The Student Room Group

Problem Solvin Help!

completed!
(edited 11 years ago)
Reply 1
I used excel and created a scatterplot graph and used the equation which was -31.024x+1216.9 and used that to solve for 11 and 12 and got 875 on november and 844 on december is this correct?
Reply 2
Or you could work with moving averages:
Plot 3 monthly moving averages... extend the trend line/curve and use your next predicted moving average to find the predicted monthly figure and so on.
Reply 3
Is my method correct? Pls help i need to complete this by today!!!
I would use a two or three quarter moving average. I wouldn't use a regression line because there doesn;t seem to be an obvious linear relationship looking at that data.
(edited 11 years ago)
Reply 5
How do you do a moving average?
Reply 6
I used a moving average and got the answer 1145.333 for nov and 1239 for december is this correct?
Reply 7
please help!! BumP!
Reply 8
really in need of help guys please!
Reply 9
help!
Reply 10
you can use this tool:

http://home.ubalt.edu/ntsbarsh/Business-stat/otherapplets/ForecaSmo.htm

with period 3 for a 3 month moving average etc.

obtain the "forecast" value and add it to the data then run again to get the second predicted value
Reply 11
can you please try and do it bear my internet does not load.
So in conclusion the last two months predicted averages are 1145.333 for November and 1239 for December.

Quick Reply

Latest