Home |
Search |
Today's Posts |
#1
|
|||
|
|||
statistical functions
I have a monthly data:Feb-04-Feb-05
Feb-04 2,156 ..... Dec-04 3,844 Jan-05 3,964 Feb-05 4,001 I need to make a forecast for Jun-05,Jul-05,Aug-05 Which of statistical functions would be better to apply on this data? Thank you |
#2
|
|||
|
|||
If it is a simple linear or growth projection you may not need any of them.
You might first review Help on the use of EditFillSeries. HTH |:) "agenda9533" wrote: I have a monthly data:Feb-04-Feb-05 Feb-04 2,156 .... Dec-04 3,844 Jan-05 3,964 Feb-05 4,001 I need to make a forecast for Jun-05,Jul-05,Aug-05 Which of statistical functions would be better to apply on this data? Thank you |
#3
|
|||
|
|||
agenda9533 -
First, look at the data. That is, create a simple line chart. Identify whether there is trend and seasonality. Use your judgment. Finally, use an appropriate model to extrapolate into the future. - Mike www.mikemiddleton.com "agenda9533" wrote in message ... I have a monthly data:Feb-04-Feb-05 Feb-04 2,156 .... Dec-04 3,844 Jan-05 3,964 Feb-05 4,001 I need to make a forecast for Jun-05,Jul-05,Aug-05 Which of statistical functions would be better to apply on this data? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pick certain rows from database to use statistical functions on th | Excel Worksheet Functions | |||
PivotTable canned functions | Excel Discussion (Misc queries) | |||
Statistical functions | Excel Worksheet Functions | |||
How can I print out a list of statistical functions in Excel (I d. | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |