Explore BrainMass

Explore BrainMass

    Time Series Analysis of US Online Advertising Spending

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

    Make an Excel graph of the data on U.S. online advertising spending. (b) Discuss the underlying causes that might explain the trend or pattern. (c) Use Excel, MegaStat, or MINITAB to fit three trends (linear, quadratic, exponential) to the time-series. (d) Which trend model do you think is best to make forecasts for the next 3 years? Why? (e) Use each of the three fitted trend equations to make a numerical forecast for 2007. How similar are the three models' forecasts?

    U.S. Online Advertising, 2000-2006 (billions)
    Year Spending
    2000 8.1
    2001 7.1
    2002 6.0
    2003 6.3
    2004 6.8
    2005 7.2
    2006 8.1

    © BrainMass Inc. brainmass.com June 3, 2020, 9:16 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/time-series-analysis-excel-174325

    Attachments

    Solution Summary

    This solution provides calculations and graphs in Excel for regression analysis.

    $2.19

    ADVERTISEMENT