Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,574
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Entering a number on any sheet one time only paulrm906 Excel Discussion (Misc queries) 4 April 2nd 06 06:16 AM
How do I change a number in one cell to change a series of cells? lance559 Excel Discussion (Misc queries) 2 January 13th 06 08:56 PM
Time series mohitmahajan Excel Discussion (Misc queries) 8 December 14th 05 07:10 AM
auto insert invoice number that increases by one each time opened Michael HPSC Excel Worksheet Functions 3 November 29th 05 08:10 AM
Time as number Howard Excel Discussion (Misc queries) 4 June 23rd 05 09:12 PM


All times are GMT +1. The time now is 09:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"