Explore BrainMass

Explore BrainMass

    Plotting Data

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Please see attachment for data.

    a.) Plot the data in the attachment on a graph. Do you observe any trend, cycles, or random variations?
    b.) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average. Plot your forecast on the same graph as the original data.
    c.) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average with weights of .1, .3, and .6, using .6 for the most recent year. Plot this forecast on the same graph.
    d.) As you compare forecasts with the original data, which seems to give the better results?

    © BrainMass Inc. brainmass.com June 4, 2020, 4:56 am ad1c9bdddf
    https://brainmass.com/business/business-management/plotting-data-589018

    Attachments

    Solution Summary

    The solution involves plotting data and comparing various data sets in Excel. Brief explanations are provided for all parts.

    $2.19

    ADVERTISEMENT