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
Year Period Amount ...
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.