You are Here: Home >< Maths

# Problem Solvin Help! Watch

1. completed!
2. 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?
3. 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.
4. Is my method correct? Pls help i need to complete this by today!!!
5. 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.
6. How do you do a moving average?
7. I used a moving average and got the answer 1145.333 for nov and 1239 for december is this correct?
9. really in need of help guys please!
10. help!
11. 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
12. 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.

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: May 11, 2012
Today on TSR

### Best unis for graduate salaries

Half of the top 10 aren't even RG...

### My alarm went off in an exam!

Discussions on TSR

• Latest
• ## See more of what you like on The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

• Poll
Useful resources

### Maths Forum posting guidelines

Not sure where to post? Read the updated guidelines here

### How to use LaTex

Writing equations the easy way

### Study habits of A* students

Top tips from students who have already aced their exams

## Groups associated with this forum:

View associated groups
Discussions on TSR

• Latest
• ## See more of what you like on The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

• The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE