Please assist

ezto.mheducation.com Ads Manager f (2) Settings & Privacy | F.. Home Gradebook M Question 1 - Wk 6 - Pract. Homework Help - Q&A fr.. Wk 6 - Practice: Wk 6 Exercises [due Day 5] i Saved Help Save & Exit Submit Check my work Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date Rate Date Rate Date Rate 1-Apr-04 1. 8564 13-Apr-04 1. 8160 23-Apr-04 1. 7674 2-Apr-04 1. 8293 14-Apr-04 1. 7902 26-Apr-04 1. 7857 2 5-Apr-04 1. 8140 15-Apr-04 1. 7785 27-Apr-04 1. 7925 points 6-Apr-04 1. 8374 16-Apr-04 1. 8004 28-Apr-04 1. 7720 7-Apr-04 1. 8410 19-Apr-04 1. 8055 29-Apr-04 1. 7751 Skipped 8-Apr-04 1. 8325 20-Apr-04 1. 7914 30-Apr-04 1. 7744 9-Apr-04 1. 8322 21-Apr-04 1. 7720 3-May-04 1. 7720 12-Apr-04 1. 8358 22-Apr-04 1. 7684 4-May-04 1. 7907 5-May-04 1. 7932 13-May-04 1. 7584 21-May-04 1. 7880 6-May-04 1. 7941 14-May-04 1. 7572 24-May-04 1. 7908 Book 7-May-04 1. 7842 17-May-04 1. 7695 25-May-04 1. 8135 10-May-04 1. 7723 18-May-04 1. 7695 26-May-04 1. 8142 11-May-04 1. 7544 19-May-04 1. 7827 27-May-04 1. 8369 12-May-04 1. 7743 20-May-04 1. 7710 28-May-04 1. 8330 References 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) : dramatically as a is increased. (c) Which value of a do you prefer? (Round your answers to 2 decimal places.) (d) Is exponential smoothing appropriate for this kind of data? (Click to select) Mc Graw Hill ezto.mheducation.com Ads Manager f (2) Settings & Privacy | F. Home Gradebook M Question 2 - Wk 6 - Prac.. Homework Help - Q&A fr.. Wk 6 - Practice: Wk 6 Exercises [due Day 5] i Saved Help Save & Exit Submit Check my work 2 Daily Spot Exchange Rate, U. S. Dollars per Pound Sterling Date Rate Date Rate Date Rate 1-Apr-04 1. 8564 13-Apr-04 1. 8160 23-Apr-04 1. 7674 2-Apr-04 1. 8293 14-Apr-04 1. 7902 26-Apr-04 1. 7857 2 5-Apr-04 1. 8140 15-Apr-04 1. 7785 27-Apr-04 1. 7925 points 6-Apr-04 1. 8374 16-Apr-04 1. 8004 28-Apr-04 1. 7720 7-Apr-04 1. 8410 19-Apr-04 1. 8055 29-Apr-04 1. 7751 Skipped 8-Apr-04 1. 8325 20-Apr-04 1. 7914 30-Apr-04 1. 7744 9-Apr-04 1. 8322 21-Apr-04 1. 7720 3-May-04 1. 7720 12-Apr-04 1. 8358 22-Apr-04 1. 7684 4-May-04 1. 7907 5-May-04 1. 7932 13-May-04 1. 7584 21-May-04 1. 7880 6-May-04 1. 7941 14-May-04 1. 7572 24-May-04 1. 7908 Book 7-May-04 1. 7842 17-May-04 1. 7695 25-May-04 1. 8135 10-May-04 1. 7723 18-May-04 1. 7695 26-May-04 1. 8142 11-May-04 1. 7544 19-May-04 1. 7827 27-May-04 1. 8369 12-May-04 1. 7743 20-May-04 1. 7710 28-May-04 1.8330 References Click here for the Excel Data File (a) Make a line chart and fit an m-period moving average to the exchange rate data shown above with m = 2, 3, 4, and 5 periods. For each method, state the last MA value. (Round your answers to 4 decimal places.) m-period Next period forecast 2 UI A W I (b) Which value of m do you prefer? The preferred m value is (Click to select) :) . This value of m Using this allows one to forecast the weekly or monthly trends (Click to select) : overreacting to daily fluctuations. (c) Is a moving average appropriate for this kind of data? (Click to select) + , a moving average is (Click to select) ; Mc Graw Hill ezto.mheducation.com Ads Manager f (2) Settings & Privacy | F.. Home Gradebook M Question 3 - Wk 6 - Prac... Homework Help - Q&A fr.. Wk 6 - Practice: Wk 6 Exercises [due Day 5] i Saved Help Save & Exit Submit Check my work 3 For each of the following fitted trends, make a prediction for period t = 17: (a) yt = 2,286e . /ot (Do not round the intermediate calculations. Round your final answer to 1 decimal place.) 2 points Skipped (b) yt = 1,149 + 12.78t (Do not round the intermediate calculations. Round your final answer to 1 decimal place.) Book References (c) yt = 501+ 18.2t- 71t (A negative value should be indicated by a minus sign. Do not round the intermediate calculations. Round your final answer to 1 decimal place.) Mc Graw Hill ezto.mheducation.com Ads Manager f (2) Settings & Privacy | F. Home Gradebook M Question 5 - Wk 6 - Prac.. Homework Help - Q&A fr.. Wk 6 - Practice: Wk 6 Exercises [due Day 5] i Saved Help Save & Exit Submit Check my work 5 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 2 5-Apr-04 1. 8140 15-Apr-04 1. 7785 27-Apr-04 1. 7925 points 6-Apr-04 1. 8474 16-Apr-04 1. 8104 28-Apr-04 1. 7720 7-Apr-04 1. 8410 19-Apr-04 1. 8155 29-Apr-04 1. 7856 1. 7844 Skipped 8-Apr-04 1. 8425 20-Apr-04 1. 7816 30-Apr-04 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 6-May-04 1. 7841 14-May-04 1. 7692 24-May-04 1. 7908 7-May-04 1. 7942 17-May-04 1. 7595 25-May-04 1. 8535 Book 10-May-04 1. 7623 18-May-04 1. 7795 26-May-04 1. 8342 11-May-04 1. 7644 19-May-04 1. 7727 27-May-04 1. 8769 12-May-04 1. 7743 20-May-04 1. 7610 28-May-04 1. 8730 References Click here for the Excel Data File (a) Make a line chart and fit an m-period moving average to the exchange rate data shown above with m = 2, 3, 4, and 5 periods. For each method, state the last MA value. (Round your answers to 4 decimal places.) m-period Next period forecast UI A W N (b) Which value of m do you prefer? The preferred m value is (Click to select) ) . This value of m Using this allows one to forecast the weekly or monthly trends (Click to select) * ) overreacting to daily fluctuations. (c) Is a moving average appropriate for this kind of data? (Click to select) + , a moving average is (Click to select) Mc Graw HiT