Purchase Solution

Forecasting Corporate Triple A Bond

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

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

Purchase this Solution


Free BrainMass Quizzes
Probability Quiz

Some questions on probability

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.