# Question: a Make an Excel line graph of the following bond

(a) Make an Excel line graph of the following bond yield data. Describe the pattern. Is there a consistent trend?

(b) Use exponential smoothing (MegaStat, MINITAB, or Excel) with α = .20. Use both methods A and B to initialize the forecast (the default in both MegaStat and MINITAB).

(c) Record the statistics of t. (MegaStat uses MSE and MSD; MINITAB uses MSD and MAPE. With Excel you will have to calculate these by creating cell formulas.)

(d) Do the smoothing again with α = .10 and then with α = .30, recording the statistics of t.

(e) Compare the statistics of t for the three values of α.

(f) Make a one-period forecast (i.e., t = 53) using each of the three values. How did affect your forecasts?

(b) Use exponential smoothing (MegaStat, MINITAB, or Excel) with α = .20. Use both methods A and B to initialize the forecast (the default in both MegaStat and MINITAB).

(c) Record the statistics of t. (MegaStat uses MSE and MSD; MINITAB uses MSD and MAPE. With Excel you will have to calculate these by creating cell formulas.)

(d) Do the smoothing again with α = .10 and then with α = .30, recording the statistics of t.

(e) Compare the statistics of t for the three values of α.

(f) Make a one-period forecast (i.e., t = 53) using each of the three values. How did affect your forecasts?

**View Solution:**## Answer to relevant Questions

(a) Use MegaStat or MINITAB to deseasonalize the quarterly data on PepsiCo's revenues and t a trend. Interpret the results. (b) Use MegaStat or MINITAB to perform a regression using seasonal binaries. Interpret the results. ...Excel was asked to generate 50 Poisson random numbers with mean λ = 5. (a) Calculate the sample mean. How close is it to the desired value? (b) Calculate the expected frequencies assuming a Poisson distribution with λ = ...Employees of Axolotl Corporation were sampled at random from pay records and asked to complete an anonymous job satisfaction survey, yielding the tabulation shown. Research Employees question: At α = .05, is job ...High levels of cockpit noise in an aircraft can damage the hearing of pilots who are exposed to this hazard for many hours. A Boeing 727 co-pilot collected 61 noise observations using a handheld sound meter. Noise level is ...Prof. Green's multiple-choice exam had 50 questions with the distribution of correct answers shown below. Research question: At α = .05, can you reject the hypothesis that Green's exam answers came from a uniform ...Post your question