Ch 14 Homework i Saved Help Save & Exit Submit Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Return to question 4 U.S. Treasury 10-Year Bond Yields at Week's End (n = 51 weeks) Date 4-January 11- January 18-January . . . 13-December 20-December 27-December Rate 2.67 2.71 2.79 1.82 1.92 1.88 1.53 points Click here for the Excel Data File (a-1) Select an Excel line graph of the following bond yield data. Yield A Yield B Yield C 10-Yr Treasury Constant Maturity Rate 2019 10-Yr Treasury Constant Maturity Rate 2019 10-Yr Treasury Constant Maturity Rate 2019 10-Yr T 3.00 3.50 3.50 3.00 2.50 3.00 3.00 2.50 2.50 2.50 2.00 2.00 2.00 2.00 1.50 1.50 1.50 1.50 1.00 1.00 1.00 1.00 0.50 0.50 0.50 0.50 0.00 0.00 0.00 0.00 4-Jan 4- Feb 1-Mar 4-Ap 4-May 4-Jun 4-Jul 4-Aug 4-Se 4-Oct 4-Dec 4-Jan 4-Feb 4-Ap 4-May 4-Jun 4-Jul 4-Aug 4-No 4-Ma 4-Sep 4-Oct 4-Nov 4-De 4-Jan 4-Feb 4-Mar 4-Apr 4-May 4-Jun 4-Jul 4-Aug 4-Sep 4-Oct 4-No 4-Dec 4-Jan 4-Feb 4-Mar 4.4 O Yield A O Yield B O Yield CO O Yield D (a-2) Describe the pattern. Is there a consistent trend? Answer is complete and correct. The pattern observed is cyclical. The trend is consistent the form statintion of fit In.. ...d Mc Graw (b) Perform exponential smoothing with a = .20. Use both methods A and B to initialize the forecast. Record the statistics of fit. (Round the Mean squared error to 3 decimal places, percent values to 1 decimal place and Forecast to 2 decimal places.) x Answer is complete but not entirely correct. a = .20 Mean squared error 0.029 Mean absolute percent error 4.6 x % Percent positive errors 0.3 X % Forecast for period 52 .84 (c) Do the smoothing again with a = 10 and then with a = .30, recording the statistics of fit. (Round the Mean squared error to 3 decimal places and percent values to 1 decimal place.) x Answer is complete but not entirely correct. a = .10 a = .30 Mean squared error 0.062 0.020 Mean absolute percent error 6.2 x % 3.9 % % Percent positive errors 0.3 x% 0.3 x% (d) Make a one-period forecast (i.e., t= 52) using each of the three a values. How did a affect your forecasts? Answer is complete and correct. As a increases, the value of forecast increases