# Predicting forecast based on given trend line equation

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 ad1c9bdddfhttps://brainmass.com/statistics/regression-analysis/predicting-forecast-based-on-given-trend-line-equation-120414

#### 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.

$2.19