Results 1 to 4 of 4

Math Help - Calculations?

  1. #1
    Junior Member
    Joined
    Oct 2007
    Posts
    48

    Question Calculations?

    The following table shows the number of items of certain product imported into the United Kingdom is given below in thousands of units for the Years
    1955-64.


    Years 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964
    Consumption 170 210 188 98 83 131 205 182 90 92
    of Cotton
    (Thousands of bales).

    Calculate
    i) 5-years moving total
    ii) 5-years moving average.
    All calculations should be in Excel.

    Thanks
    Follow Math Help Forum on Facebook and Google+

  2. #2
    GAMMA Mathematics
    colby2152's Avatar
    Joined
    Nov 2007
    From
    Alexandria, VA
    Posts
    1,172
    Awards
    1
    Quote Originally Posted by cu4mail View Post
    The following table shows the number of items of certain product imported into the United Kingdom is given below in thousands of units for the Years
    1955-64.


    Years 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964
    Consumption 170 210 188 98 83 131 205 182 90 92
    of Cotton
    (Thousands of bales).

    Calculate
    i) 5-years moving total
    ii) 5-years moving average.
    All calculations should be in Excel.

    Thanks
    Excel automatically compiles these results for you by graphing it. However, please note that a simple moving average (SMA) is the unweighted mean of the previous n data points. Therefore, you calculate the mean of the last five years of data for each point. Likewise, you sum the values of the last five years for the moving total.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by colby2152 View Post
    Excel automatically compiles these results for you by graphing it. However, please note that a simple moving average (SMA) is the unweighted mean of the previous n data points. Therefore, you calculate the mean of the last five years of data for each point. Likewise, you sum the values of the last five years for the moving total.
    I would have put the five year moving avaerage for year n tobe:

    (x_{n-2}+x_{n-1}+x_n+x_{n+1}+x_{n+2})/5

    that is I would always prefer the central moving average.

    (of course Excel just gives the rolling MA)

    RonL
    Follow Math Help Forum on Facebook and Google+

  4. #4
    GAMMA Mathematics
    colby2152's Avatar
    Joined
    Nov 2007
    From
    Alexandria, VA
    Posts
    1,172
    Awards
    1
    Quote Originally Posted by CaptainBlack View Post
    I would have put the five year moving avaerage for year n tobe:

    (x_{n-2}+x_{n-1}+x_n+x_{n+1}+x_{n+2})/5

    RonL
    It depends where it is centered around. Simple moving averages look at past data, because that data is given and known. You cannot use unknown values in the future for a moving average.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. pipe calculations
    Posted in the Math Topics Forum
    Replies: 1
    Last Post: October 27th 2010, 11:35 PM
  2. calculations
    Posted in the Algebra Forum
    Replies: 1
    Last Post: January 4th 2010, 01:41 PM
  3. Angle calculations
    Posted in the Trigonometry Forum
    Replies: 6
    Last Post: November 30th 2009, 11:30 PM
  4. LOG and EXP Calculations
    Posted in the Algebra Forum
    Replies: 1
    Last Post: October 14th 2009, 12:39 PM
  5. Check my calculations ^_^
    Posted in the Calculus Forum
    Replies: 5
    Last Post: July 2nd 2006, 05:24 PM

Search Tags


/mathhelpforum @mathhelpforum