Forecasting Corporate Triple A Bond
Not what you're looking for?
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
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Probability Quiz
Some questions on probability
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.