Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling (n = 60 days) Day 1 3 Date 2 11/4/19 1.2906 11/1/19 60 1/30/20
Posted: Wed May 04, 2022 11:50 am
Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling (n = 60 days) Day 1 3 Date 2 11/4/19 1.2906 11/1/19 60 1/30/20 58 1/28/20 1.2996 11/5/19 59 1/29/20 1.3012 Rate 1.2950 1.2870 1.3106 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 dramatically as a is increased. (c) Which value of a do you prefer? (Round your answers to 2 decimal places.) a = (d) Is exponential smoothing appropriate for this kind of data? Yes No