Explore BrainMass

Explore BrainMass

    Predicting forecast based on given trend line equation

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

    The following time series data represent the yearly amounts spent on advertising (in millions of dollars) by a large toy company:
    23.3, 21.7, 22.7, 25.5, 22.7, 25.9

    This series of data begins in year 1997(i.e., time period t=1 corresponds to 1997). Using regression analysis, a linear trend line of the form Tt=21.77 + 0.53t was fit to the data. Using this information, generate a forecast for the total yearly amount of money that will be spent on advertising in 2006.

    © BrainMass Inc. brainmass.com June 3, 2020, 8:00 pm ad1c9bdddf

    Solution Preview

    Year Period Amount ...

    Solution Summary

    This solution is comprised of a detailed step-by-step calculation and analysis of the given problem related to a time series analysis in EXCEL and provides students with a clear perspective of the underlying concept.