[oggoy]

completed!

[oggoy]

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?

[the bear]

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.

[oggoy]

Is my method correct? Pls help i need to complete this by today!!!

[Brit_Miller]

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.

[oggoy]

How do you do a moving average?

[oggoy]

I used a moving average and got the answer 1145.333 for nov and 1239 for december is this correct?

[oggoy]

please help!! BumP!

[oggoy]

really in need of help guys please!

[oggoy]

help!

[the bear]

you can use this tool:

http://home.ubalt.edu/ntsbarsh/Busin.../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

[oggoy]

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.