• Calculate a forecast of the above demand using a 3- and 5-period moving average ...

profileguru2009
 (Not rated)
 (Not rated)
Chat
Home>Homework Answsers>Mathematics homework help>Statistics homework help

        Day Demand             1 200             2 134             3 157             4 165             5 177             6 125             7 146             8 150             9 182             10 197             11 136  Develop a spreadsheet to answer the   following questions.      12 163  • Calculate a forecast of the above   demand using a 3- and 5-period moving average.   13 157  • Graph these forecasts and the   original data using Excel. What does the graph show?   14 169  • Which of the above forecasts is   best? Why?        

    • 8 years ago
    Report issue
    The graph shows that vertical displacements (from the actual demand) are lesser for 5- period moving average than for 3- period moving average. ...
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      Thegraphshowsthatverticaldisplacementsfromtheactualdemandarelesserfor5-periodmovingaveragethanfor3-periodmovingaverage.xls