# Predicting forecast based on given trend line equation

Not what you're looking for? Search our solutions OR ask your own Custom question.

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 November 30, 2021, 1:41 am 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.49