DColin
asked on
Trend line.
Hi Experts,
Please look at the attached Excel file.
It represents sale success rate (1 = sale and 0 = no sale) plotted against budget allocation over or under spend. How can I plot a trend line to show the correlation of amount spent to sales success. Common sense tells me that there is never a zero or definite chance of success so the answer is going to be non linear. Sales.xlsx
Please look at the attached Excel file.
It represents sale success rate (1 = sale and 0 = no sale) plotted against budget allocation over or under spend. How can I plot a trend line to show the correlation of amount spent to sales success. Common sense tells me that there is never a zero or definite chance of success so the answer is going to be non linear. Sales.xlsx
ASKER
aburr:
The first column represents the the amount over or under budget spent to get the sale. Each sale is allocated a budget of 20,000 if exactly 20,000 is spent perusing a sale then 0 will appear in the first column. If 18,000 was spent then -2 if 23,000 was spent then +3. If you look at the bottom of this column you will see the negative spend amounts.
The first column represents the the amount over or under budget spent to get the sale. Each sale is allocated a budget of 20,000 if exactly 20,000 is spent perusing a sale then 0 will appear in the first column. If 18,000 was spent then -2 if 23,000 was spent then +3. If you look at the bottom of this column you will see the negative spend amounts.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just exactly what does the first column represent. To me over or under leads me to expect a + or -.