Predicting a Number From a Time Series
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.
|