Hey there! Sign in to join this conversationNew here? Join for free
    • Thread Starter
    Offline

    0
    ReputationRep:
    completed!
    • Thread Starter
    Offline

    0
    ReputationRep:
    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?
    Offline

    20
    ReputationRep:
    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.
    • Thread Starter
    Offline

    0
    ReputationRep:
    Is my method correct? Pls help i need to complete this by today!!!
    Offline

    13
    ReputationRep:
    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.
    • Thread Starter
    Offline

    0
    ReputationRep:
    How do you do a moving average?
    • Thread Starter
    Offline

    0
    ReputationRep:
    I used a moving average and got the answer 1145.333 for nov and 1239 for december is this correct?
    • Thread Starter
    Offline

    0
    ReputationRep:
    please help!! BumP!
    • Thread Starter
    Offline

    0
    ReputationRep:
    really in need of help guys please!
    • Thread Starter
    Offline

    0
    ReputationRep:
    help!
    Offline

    20
    ReputationRep:
    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
    • Thread Starter
    Offline

    0
    ReputationRep:
    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.
 
 
 
  • 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
    Has a teacher ever helped you cheat?
    Useful resources

    Make your revision easier

    Maths

    Maths Forum posting guidelines

    Not sure where to post? Read the updated guidelines here

    Equations

    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
  • 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

    Write a reply...
    Reply
    Hide
    Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.