Explore BrainMass

Explore BrainMass

    Time Series & Forecasting

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

    Listed below is the net sales in $ million for Home Depot, Inc. and its subsidiaries from 1993 to 2002.

    Year Code Net Sales
    1993 1 9,239
    1994 2 12,477
    1995 3 15,470
    1996 4 19,535
    1997 5 24,156
    1998 6 30,219
    1999 7 38,434
    2000 8 45,738
    2001 9 53,553
    2002 10 58,247

    C. Compute a 3-year moving average.[use MS Excel 2007, Data, Data Analysis, Moving average, showing input range by highlighting column B, enter and for interval, show output range by highlighting Column C, check Chart output box, and click ok.
    D. Show a trendline [First enlarge the chart by dragging at the right bottom corner. Right click on the chart's forecast series your produced in (c) above. Select add trendline. The default is linear. Click ok.]

    © BrainMass Inc. brainmass.com June 3, 2020, 11:03 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/time-series-forecasting-261119

    Solution Preview

    Time Series & Forecasting
    Listed below is the net sales in $ million for Home Depot, Inc. and its subsidiaries from 1993 to 2002.

    Year Code Net Sales
    1993 1 9,239
    1994 2 12,477
    1995 3 ...

    Solution Summary

    This solution answers questions regarding time series and forecasting.

    $2.19

    ADVERTISEMENT