Please help with 2,3,4, 5

ezto.mheducation.com Content Start Page f Facebook M Question 10 - Wk 6 - Practice: Wk 6 Exer... Course Hero Wk 6 - Practice: Wk 6 Exercises [due Day 5] i Saved Help Save & Exit Submit Check my work 10 Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date Rate Date Rate Date Rate 1-Apr-04 1. 8584 13-Apr-04 1. 7860 23-Apr-04 1. 7874 2-Apr-04 1. 8363 14-Apr-04 1. 7752 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. 8255 29-Apr-04 1. 7656 8-Apr-04 1. 8525 20-Apr-04 1. 7816 30-Apr-04 1. 7744 9-Apr-04 1. 8422 21-Apr-04 1. 7620 3-May-04 1. 7720 12-Apr-04 1. 8558 22-Apr-04 1. 7794 4-May-04 1. 7507 eBook 5-May-04 1. 7732 13-May-04 1. 7754 21-May-04 1. 7880 6-May-04 1. 7641 14-May-04 1. 7692 24-May-04 1. 7808 7-May-04 1. 7942 17-May-04 1. 7595 25-May-04 1. 7535 10-May-04 1. 7693 18-May-04 1. 7695 26-May-04 1. 8542 11-May-04 1. 7644 19-May-04 1. 7727 27-May-04 1. 7769 References 12-May-04 1. 7743 20-May-04 1. 7610 28-May-04 1. 7730 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 UN (b) Which value of m do you prefer? The preferred m value is (5 . This value of m Using this allows one to forecast the weekly or monthly trends without overreacting to daily fluctuations (c) Is a moving average appropriate for this kind of data? Mc Graw Hill