1)

Daily Dollar/Euro Exchange Rate (11 = 61 days) Day 1 2 3 ... 59 60 61 Date 11/1/19 11/4/19 11/5/19 ... 1/29/20 1/30/20 1/31/20 Rate 1.1169 1.1144 1.1070 ... 1.1004 1.1032 1.1082 Click here for the Excel Data File (a) Make an Excel line graph of the exchange rate data. Describe the pattern. The pattern observed is (b) Click on the data and choose Add Trendline > Moving Average. Describe the effect of increasing In (eg. m= 2, 4, 6, etc). As m increases the trendline describe the data as well. (c) Discuss how this moving average might help a currency speculator. Trend models much help. U.S. Usage of Renewable Energy (quad BTU), 2011 to 2018 Year Usage 2011 9.20 2012 3.35 2013 9.45 2014 9.74 2015 9.72 2016 10.37 2017 11.18 2018 11.52 I3 Click here for the Excel Data File (a) Select a line chart for usage of renewable energy in the United States. U.S. Usage of Renewable Energy, 2011-2018 US. Usage of Renewable Energy, 20112018 us. Usage of Renewable Energy, 2011-2018 2011 2012 2013 2014 201.5 2016 2017 201.8 2011 M12 2013 2014 201.5 2015 N17 2018 2011 mu an; 1014 2015 2015 2017 1015 0 Chart A 0 Chart B 0 Chart C (b) The underlying causes that might explain the trend or pattern is 0 Climate change and increasing fossil fuel prices 0 Climate change and decreasing fossil fuel prices (c) Choose a graph below which shows the linear, quadratic and exponential models. Graph A Graph B Graph C U.S. Usage of Renewable Energy, 2011-2018 U.S. Usage of Renewable Energy, 2011-2018 U.S. Usage of Renewable Energy, 201: 14 14.00 14.00 y = 0.3646x + 8.3629 y = 0.0495x2 - 0.0805x + 9.1048 y = 0.3646x + 9.3629 y = 0.0495x2 - 0.0805x + 10.105 y = 0.3646x + 7.3629 y = 0.0495x2 - ( 12 12.00 12.00 y = 8.47730.0398x y = 9.46780.0327x y = 7.48880.0395x 10 10.00 10.00 8 8.00 8.00 quad BTU quad BT quad BT 6 60 6.00 4,00 4.00 N 2.00 2.00 0.00 0.00 2011 2012 2013 2014 2015 2016 2017 2018 2011 2012 2013 2014 2015 2016 2017 2018 2011 2012 2013 2014 2015 20 O Graph A O Graph B O Graph C (d) Use each of the three fitted trend equations to make numerical forecasts for the next three years. (Round your final answers to 2 decimal places.) t Linear Exponential Quadratic 9 10 11Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling (n = 60 days) Day 1 2 3 58 59 60 Date 11/1/19 11/4/19 11/5/19 1/28/20 1/29/20 1/30/20 Rate 1.2950 1.2905 1.2070 1.2996 1.3012 1.3105 Click here for the Excel Data File (a) Make a line chart for an m-period moving average to the exchange rate data shown below with m = 2,3,4, and 5 periods. For each method, state the last MA value. (Round your answer to 4 decimal places.) (b) Is a moving average appropriate for this kind of data? Mamovingg l