| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
project values based on other values
How can I project the values for November and December if I have values for
January - October? What is the correct formula? |
|
#2
|
|||
|
|||
|
The short answer is try using the =FORECAST() function, where the known_y's
are your values, the known_x's can just be 1, 2, .. 10 (or =MONTH() of the date) and then the points for which you want to predict a value are 11 and 12. However, this makes a huge assumption that the relationship is linear. So the first step has to be simply to plot them and see if this assumption is valid. If it is, FORECAST is perfectly OK. If they are something that is growing at a constant rate then =LOGEST() might be the function to use. Otherwise you're moving into much more complex area. HTH, David Jessop "Gabriele" wrote: How can I project the values for November and December if I have values for January - October? What is the correct formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero values in a log chart | Charts and Charting in Excel | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| Missing values in Excel Line Chart | Charts and Charting in Excel | |||
| Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
| HOW TO: Plot a Team Name on a chart based on two values | Charts and Charting in Excel | |||
Hybrid Mode
