Explore BrainMass

# Predicting forecast based on given trend line equation

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

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.

https://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