Resolved Question
How to calculate a quarterly moving average ?
2001 Q1 630
Q2 567
Q3 552
Q4 678
please for help
i have to do that for tommorowz
thanks x
Q2 567
Q3 552
Q4 678
please for help
i have to do that for tommorowz
thanks x
Best Answer - Chosen by Asker
Is there more to the question? Normally I would expect to see more than one year's worth of data to be able to do a 4 point quarterly average.Is there more data.
If not, you can average the figures given (630+567+552+678)/4 = 606.75 but that's not a moving average.
To give a 2 point moving average within the given data, you would use:
(630+567)/2 = 598.5
(567+552)/2 = 559.5
(552+678)/2 = 615
But that's not really what the question asked for.
Probably not much help, but best i can do with the info,
If not, you can average the figures given (630+567+552+678)/4 = 606.75 but that's not a moving average.
To give a 2 point moving average within the given data, you would use:
(630+567)/2 = 598.5
(567+552)/2 = 559.5
(552+678)/2 = 615
But that's not really what the question asked for.
Probably not much help, but best i can do with the info,
There are currently no comments for this question.
Other Answers (1)
- for that suggestion is
http://biznuss.net/index.html
i hope it will be beneficial for you
keep using answers.yahoo.comSource(s):
No comments:
Post a Comment