Share
Explore BrainMass

Forecasting Corporate Triple A Bond

Corporate Triple A Bond interest rates for 12 consecutive months are...
a. Develop three- and four-month averages for this time series. Which moving average provides the better forecasts? Explain.
b. What is the moving average forecast for the next month?
The following data represent 15 quarters of manufacturing capacity utilization (in percentages)...
a. Compute three- and four-quarter moving averages for this time series. Which moving average provides the better forecast for the fourth quarter of 2003?
b. Use smoothing constants of a=0.4 and a=0.5 to develop forecasts for the fourth quarter of 2003. Which smoothing constant provides the better forecast?
c. Based on the analysis in parts (a) and (b), which method-moving averages or exponential smoothing-provides the better forecast? Explain.

TV ratings provided by Nielsen Media Research show the percentage of TV-owning households tuned into a particular program. The following data show the rating for the top-rated TV show of each season, from 1987-1988 to 2000-2001 ( The New York Times Almanac 2002)...
a. Graph this time series. Does a linear trend appear?
b. Develop a linear trend equation for this time series.
c. Use the trend equation to estimate the rating for the 2001-2002 season.

Hudson Marine has been an authorized dealer for C&D marine radios for the past seven years. The number of radios sold each year is shown ...
a. Graph this time series. Does a linear trend appear?
b. Develop the equation for the linear trend component for the time series.
c. Use the linear trend developed in part (b) to prepare a forecast for sales in year 8.
Please help in excel format.

Attachments

Solution Summary

A Complete, Neat and Step-by-step Solution is provided in the attached file.

$2.19