Hey there Sign in to join this conversationNew here? Join for free

Problem Solvin Help!

Announcements Posted on
Study Help needs new mods! 14-04-2014
Post on TSR and win a prize! Find out more... 10-04-2014
    • Thread Starter
    • 0 followers
    Offline

    ReputationRep:
    completed!
    • Thread Starter
    • 0 followers
    Offline

    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?
    • 32 followers
    Offline

    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
    • 0 followers
    Offline

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

    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
    • 0 followers
    Offline

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

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

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

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

    ReputationRep:
    help!
    • 32 followers
    Offline

    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
    • 0 followers
    Offline

    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.

Reply

Submit reply

Register

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?

    this is what you'll be called on TSR

  2. this can't be left blank
    this email is already registered. Forgotten your password?

    never shared and never spammed

  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. By completing the slider below you agree to The Student Room's terms & conditions and site rules

  2. Slide the button to the right to create your account

    Slide to join now Processing…

    You don't slide that way? No problem.

Updated: May 11, 2012
Article updates
Reputation gems:
You get these gems as you gain rep from other members for making good contributions and giving helpful advice.