Third Attempt at this question. (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   1.8604 1.8604 Incorrect   3   1.93849 1.93849 Incorrect   4   2.01048 2.01048 Incorrect   5   2.07638 2.07638 Incorrect     This question was asked previously and i was given the wrong answers.  1.82440, 1.82803,1.83495,1.83300 are all incorrect.   Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling                           t Date Rate               1 1-Apr-04 1.8564               2 2-Apr-04 1.8293               3 5-Apr-04 1.8140               4 6-Apr-04 1.8374               5 7-Apr-04 1.8410               6 8-Apr-04 1.8325               7 9-Apr-04 1.8322               8 12-Apr-04 1.8358               9 13-Apr-04 1.8160               10 14-Apr-04 1.7902               11 15-Apr-04 1.7785               12 16-Apr-04 1.8004               13 19-Apr-04 1.8055               14 20-Apr-04 1.7914     15 21-Apr-04 1.7720     16 22-Apr-04 1.7684     17 23-Apr-04 1.7674               18 26-Apr-04 1.7857               19 27-Apr-04 1.7925               20 28-Apr-04 1.7720               21 29-Apr-04 1.7751               22 30-Apr-04 1.7744               23 3-May-04 1.7720               24 4-May-04 1.7907               25 5-May-04 1.7932               26 6-May-04 1.7941               27 7-May-04 1.7842               28 10-May-04 1.7723               29 11-May-04 1.7544               30 12-May-04 1.7743               31 13-May-04 1.7584               32 14-May-04 1.7572               33 17-May-04 1.7695               34 18-May-04 1.7695               35 19-May-04 1.7827               36 20-May-04 1.7710               37 21-May-04 1.7880               38 24-May-04 1.7908               39 25-May-04 1.8135               40 26-May-04 1.8142               41 27-May-04 1.8369               42 28-May-04 1.8330

Algebra and Trigonometry (MindTap Course List)
4th Edition
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:James Stewart, Lothar Redlin, Saleem Watson
Chapter1: Equations And Graphs
Section1.2: Graphs Of Equations In Two Variables; Circles
Problem 111E
icon
Related questions
Question

Third Attempt at this question.

(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

 

1.8604 1.8604 Incorrect

 

3

 

1.93849 1.93849 Incorrect

 

4

 

2.01048 2.01048 Incorrect

 

5

 

2.07638 2.07638 Incorrect

 

 

This question was asked previously and i was given the wrong answers. 

1.82440, 1.82803,1.83495,1.83300 are all incorrect.

  Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling    
                   
  t Date Rate            
  1 1-Apr-04 1.8564            
  2 2-Apr-04 1.8293            
  3 5-Apr-04 1.8140            
  4 6-Apr-04 1.8374            
  5 7-Apr-04 1.8410            
  6 8-Apr-04 1.8325            
  7 9-Apr-04 1.8322            
  8 12-Apr-04 1.8358            
  9 13-Apr-04 1.8160            
  10 14-Apr-04 1.7902            
  11 15-Apr-04 1.7785            
  12 16-Apr-04 1.8004            
  13 19-Apr-04 1.8055  
 
     
 
  14 20-Apr-04 1.7914  
  15 21-Apr-04 1.7720  
  16 22-Apr-04 1.7684  
  17 23-Apr-04 1.7674            
  18 26-Apr-04 1.7857            
  19 27-Apr-04 1.7925            
  20 28-Apr-04 1.7720            
  21 29-Apr-04 1.7751            
  22 30-Apr-04 1.7744            
  23 3-May-04 1.7720            
  24 4-May-04 1.7907            
  25 5-May-04 1.7932            
  26 6-May-04 1.7941            
  27 7-May-04 1.7842            
  28 10-May-04 1.7723            
  29 11-May-04 1.7544            
  30 12-May-04 1.7743            
  31 13-May-04 1.7584            
  32 14-May-04 1.7572            
  33 17-May-04 1.7695            
  34 18-May-04 1.7695            
  35 19-May-04 1.7827            
  36 20-May-04 1.7710            
  37 21-May-04 1.7880            
  38 24-May-04 1.7908            
  39 25-May-04 1.8135            
  40 26-May-04 1.8142            
  41 27-May-04 1.8369            
  42 28-May-04 1.8330            
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 10 steps with 6 images

Blurred answer
Knowledge Booster
Time Series Analyses, Forecasting Methods, and Indices
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Algebra and Trigonometry (MindTap Course List)
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
College Algebra
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax