Hey! Sign in to get help with your study questionsNew here? Join for free to post

Problem Solvin Help!

Announcements Posted on
Take our survey to be in with the chance of winning a £50 Amazon voucher or one of 5 x £10 Amazon vouchers 24-05-2016
  1. Offline

  2. Offline

    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. Offline

    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. Offline

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

    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. Offline

    How do you do a moving average?
  7. Offline

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

    please help!! BumP!
  9. Offline

    really in need of help guys please!
  10. Offline

  11. Offline

    you can use this tool:


    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. Offline

    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.


Submit reply


Thanks for posting! You just need to create an account in order to submit the post
  1. this can't be left blank
    that username has been taken, please choose another Forgotten your password?
  2. this can't be left blank
    this email is already registered. Forgotten your password?
  3. this can't be left blank

    6 characters or longer with both numbers and letters is safer

  4. this can't be left empty
    your full birthday is required
  1. Oops, you need to agree to our Ts&Cs to register
  2. Slide to join now Processing…

Updated: May 11, 2012
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.

Today on TSR

OCR Physics Breadth exam

Chat about the exam here

Are you registered to vote in the EU referendum?
Useful resources

Make your revision easier


Maths Forum posting guidelines

Not sure where to post? Read here first


How to use LaTex

Writing equations the easy way

Student revising

Study habits of A* students

Top tips from students who have already aced their exams

Study Planner

Create your own Study Planner

Never miss a deadline again

Polling station sign

Thinking about a maths degree?

Chat with other maths applicants

Can you help? Study help unanswered threads

Groups associated with this forum:

View associated groups
Study resources
Quick reply
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.