Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Excel predicts th enext value is .0658.
How did I do this? Select the range and on the bottom right hand corner of the range outline, you can click and drag to extend the series. Whether Excel's prediction is accurate, I haven't a clue. As for predicting standard deviation, well that would be a function of the next value in the series, right? Dave -- Brevity is the soul of wit. "carl" wrote: I have a time series like this: .85% 5.42% 7.90% 8.28% 3.83% 3.47% 6.03% 4.19% 6.71% 8.74% 6.03% 7.71% 8.75% 7.01% 2.87% 5.23% 4.89% 6.33% 6.50% 6.22% Is there a a good way to predict what the next number is the time series will be and what the standard deviation is ? Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Entering a number on any sheet one time only | Excel Discussion (Misc queries) | |||
How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
Time series | Excel Discussion (Misc queries) | |||
auto insert invoice number that increases by one each time opened | Excel Worksheet Functions | |||
Time as number | Excel Discussion (Misc queries) |