k 6 - Practice: Wk 6 Exercises [due Day 5] i Saved 2 Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date Rate Date Rate Date Rate 1-Apr-04 1. 8664 13-Apr-04 1. 8260 23-Apr -04 1.7674 2-Apr-04 1.8393 14-Apr-04 1.7702 26-Apr -04 1. 7857 points 5-Apr-04 1. 8140 15 -Apr -04 1.7785 27-Apr -04 1.7925 6-Apr - 04 1.8474 16-Apr-04 1. 8104 28-Apr-04 1.7720 Skipped 7-Apr-04 1.8410 19-Apr-04 1.8955 29-Apr -04 1. 7856 8-Apr-04 1.8425 20-Apr-04 1.7916 30-Apr- 04 1. 7844 9-Apr-04 1.8322 21-Apr-04 1.7620 3-May -04 1. 7720 12-Apr-04 1. 8458 22-Apr-04 1.7684 4-May -04 1. 7607 5-May-04 1.7732 13-May -04 1. 7554 21-May - 04 1. 7880 Book 6-May -04 1. 7841 14-May -04 1. 7592 24-May-04 1. 7908 7-May-04 1.7942 17-May -04 1. 7595 25-May-04 1. 8635 10-May -04 1.7823 18-May-04 1.7795 26-May -04 1.8342 11-May - 04 1. 7644 19-May -04 1.7827 27-May-04 1. 8769 References 12-May -04 1.7743 20-May-04 1. 7610 28-May - 04 1.8530 Click here for the Excel Data File (b) Perform simple exponential smoothing (using Excel's Data Analysis or other software such as Minitab) using a = .05, 10. 20, and 50. The degree of smoothing |(Click to select) v | dramatically as a is Increased. (c) Which value of a do you prefer? (Round your answers to 2 decimal places.) C = (d) is exponential smoothing appropriate for this kind of data? (Click to select) v