If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
trendline
I am trying to fill in the blanks here and come up with a graph and trendline
forecasting sales in $.10 increments when I have history of sales at .99, 1.49, 1.99, and 2.49. Obviously as the price goes up, unit sales come down. So how can I forecast what might be sold at all these price points. Thanks in advance. 0.99 280,242 1.09 1.19 1.29 1.39 1.49 227,988 1.59 1.69 1.79 1.89 1.99 146,740 2.09 2.19 2.29 2.39 2.49 59,814 |
#2
|
|||
|
|||
trendline
Arrange the data with the known values in A1:B4
0.99 280,242 1.49 227,988 1.99 146,740 2.49 59,814 An XY chart trendline shows that a linear fit should be OK for this data. The unknown values in A8:A19 1.09 275225 1.19 260375 1.29 245524 1.39 230673 1.59 200972 1.69 186121 1.79 171271 1.89 156420 2.09 126719 2.19 111868 2.29 97017 2.39 82167 In B8 enter =FORECAST(A8,$B$1:$B$4,$A$1:$A$4) and copy down to B16 or better =ROUND(=FORECAST(A8,$B$1:$B$4,$A$1:$A$4),0) -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "PB" wrote in message ... I am trying to fill in the blanks here and come up with a graph and trendline forecasting sales in $.10 increments when I have history of sales at .99, 1.49, 1.99, and 2.49. Obviously as the price goes up, unit sales come down. So how can I forecast what might be sold at all these price points. Thanks in advance. 0.99 280,242 1.09 1.19 1.29 1.39 1.49 227,988 1.59 1.69 1.79 1.89 1.99 146,740 2.09 2.19 2.29 2.39 2.49 59,814 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Trendline Extract | Phil Hageman | Charts and Charting | 5 | July 6th, 2005 02:27 AM |
How do I get the trendline equation from Excel to script? | Mattias | Charts and Charting | 1 | December 7th, 2004 12:21 PM |
Trendline and its referencing / linking to a cell | MikeG | Charts and Charting | 0 | February 5th, 2004 03:17 PM |
Trendline and its referencing / linking to a cell | Jerry W. Lewis | Charts and Charting | 4 | February 4th, 2004 03:13 AM |
trendline equations | kathy | Charts and Charting | 5 | October 2nd, 2003 10:12 PM |