Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel to Predict Value?
Hi everone,
Say you have 50 values in A column and you want to predict the 51th value based on the previous 50 values. What Excel's function you use? I know FORECAST(x,known_y's,known_x's) but I have only x values in my example! Thanks, John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel to Predict Value?
Hi John,
Sounds like you only have known-y's. You could put 1-50 in anther column as your known-x's. Note Forecast is good only for broadly linear data. Regards, Peter T "Jo" wrote in message ups.com... Hi everone, Say you have 50 values in A column and you want to predict the 51th value based on the previous 50 values. What Excel's function you use? I know FORECAST(x,known_y's,known_x's) but I have only x values in my example! Thanks, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Predict/Probability | Excel Worksheet Functions | |||
How do I predict inventorys in Excel | Excel Discussion (Misc queries) | |||
How to use excel to predict interest | Excel Discussion (Misc queries) | |||
time addition to predict finish time | Excel Worksheet Functions | |||
Formula to predict a future date | Excel Worksheet Functions |