The worksheet Sterling in the Chp 17 HW problems data workbook on Moodle shows the daily spot exchange rate in U.S. dollars per pound Sterling. a) Use simple regression with rate as the independent or Y variable and Day as the dependent or X variable to fit the data. Determine MAD, MSE and MAPE for the simple regression model. Construct a chart that has the observed data and the fit line by Day. Use the simple regression model to predict spot exchange rate for the next day, i.e., t = 43. b) Use a four time period Moving Average to fit the rate data. Determine MAD, MSE and MAPE for the Moving Average model. Construct a chart that has the observed data and the fit line by t. Use the Moving Average model to predict spot exchange rate for the next day, i.e., t = 43. c) Use exponential smoothing with a smoothing constant of 0.25 to fit the data. Determine MAD, MSE and MAPE for the exponential smoothing model. Use the model to forecast housing starts for the next year, i.e., year 23. d) Short answer. Which of the three above forecasting models (simple regression, moving average and exponential smoothing) would you use to model the data and why would you use that model. A B с D E G H J K L M N о P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH -23456N 1 Day Rate 1 1.8564 2 1.8293 3 1.814 4 1.8374 5 1.841 7 6 1.8325 8 7 1.8322 9 8 1.8358 10 9 1.816 11 10 1.7902 12 11 1.7785 13 12 1.8004 14 13 1.8055 15 14 1.7914 16 15 1.772 17 16 1.7684 18 17 1.7674 19 18 1.7857 20 19 1.7925 21 20 1.772 22 21 1.7751 23 22 1.7744 24 23 1.772 25 24 1.7907 26 25 1.7932 27 26 1.7941 28 27 1.7842 29 28 1.7723 30 29 1.7544 31 30 1.7743 32 31 1.7584 33 32 1.7572 34 33 1.7695 35 34 1.7695 36 35 1.7827 37 36 1.771 38 37 1.788 39 38 1.7908 40 39 1.8135 41 40 1.8142 42 41 1.8369 43 42 1.833 44 AC Sales Sterling Revenue Accessibility: Good to go < > Ready 47°F Cloudy Q Search Ο f ENG 11:06 PM 4/6/2024
The worksheet Sterling in the Chp 17 HW problems data workbook on Moodle shows the daily spot exchange rate in U.S. dollars per pound Sterling. a) Use simple regression with rate as the independent or Y variable and Day as the dependent or X variable to fit the data. Determine MAD, MSE and MAPE for the simple regression model. Construct a chart that has the observed data and the fit line by Day. Use the simple regression model to predict spot exchange rate for the next day, i.e., t = 43. b) Use a four time period Moving Average to fit the rate data. Determine MAD, MSE and MAPE for the Moving Average model. Construct a chart that has the observed data and the fit line by t. Use the Moving Average model to predict spot exchange rate for the next day, i.e., t = 43. c) Use exponential smoothing with a smoothing constant of 0.25 to fit the data. Determine MAD, MSE and MAPE for the exponential smoothing model. Use the model to forecast housing starts for the next year, i.e., year 23. d) Short answer. Which of the three above forecasting models (simple regression, moving average and exponential smoothing) would you use to model the data and why would you use that model. A B с D E G H J K L M N о P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH -23456N 1 Day Rate 1 1.8564 2 1.8293 3 1.814 4 1.8374 5 1.841 7 6 1.8325 8 7 1.8322 9 8 1.8358 10 9 1.816 11 10 1.7902 12 11 1.7785 13 12 1.8004 14 13 1.8055 15 14 1.7914 16 15 1.772 17 16 1.7684 18 17 1.7674 19 18 1.7857 20 19 1.7925 21 20 1.772 22 21 1.7751 23 22 1.7744 24 23 1.772 25 24 1.7907 26 25 1.7932 27 26 1.7941 28 27 1.7842 29 28 1.7723 30 29 1.7544 31 30 1.7743 32 31 1.7584 33 32 1.7572 34 33 1.7695 35 34 1.7695 36 35 1.7827 37 36 1.771 38 37 1.788 39 38 1.7908 40 39 1.8135 41 40 1.8142 42 41 1.8369 43 42 1.833 44 AC Sales Sterling Revenue Accessibility: Good to go < > Ready 47°F Cloudy Q Search Ο f ENG 11:06 PM 4/6/2024
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.FOM: Focus On Modeling: Fitting Lines To Data
Problem 10P
Related questions
Question
Transcribed Image Text:The worksheet Sterling in the Chp 17 HW problems data workbook on Moodle shows
the daily spot exchange rate in U.S. dollars per pound Sterling.
a) Use simple regression with rate as the independent or Y variable and Day as the
dependent or X variable to fit the data. Determine MAD, MSE and MAPE for the
simple regression model. Construct a chart that has the observed data and the fit
line by Day. Use the simple regression model to predict spot exchange rate for
the next day, i.e., t = 43.
b) Use a four time period Moving Average to fit the rate data. Determine MAD,
MSE and MAPE for the Moving Average model. Construct a chart that has the
observed data and the fit line by t. Use the Moving Average model to predict spot
exchange rate for the next day, i.e., t = 43.
c) Use exponential smoothing with a smoothing constant of 0.25 to fit the data.
Determine MAD, MSE and MAPE for the exponential smoothing model. Use the
model to forecast housing starts for the next year, i.e., year 23.
d) Short answer. Which of the three above forecasting models (simple regression,
moving average and exponential smoothing) would you use to model the data and
why would you use that model.
Transcribed Image Text:A
B
с
D
E
G
H
J
K
L
M
N
о
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
-23456N
1 Day
Rate
1
1.8564
2 1.8293
3
1.814
4
1.8374
5
1.841
7
6
1.8325
8
7
1.8322
9
8
1.8358
10
9
1.816
11
10
1.7902
12
11
1.7785
13
12
1.8004
14
13
1.8055
15
14 1.7914
16
15
1.772
17
16
1.7684
18
17
1.7674
19
18
1.7857
20
19
1.7925
21
20 1.772
22
21
1.7751
23
22
1.7744
24
23
1.772
25
24
1.7907
26
25
1.7932
27
26
1.7941
28
27
1.7842
29
28
1.7723
30
29
1.7544
31
30
1.7743
32
31
1.7584
33
32
1.7572
34
33
1.7695
35
34
1.7695
36
35
1.7827
37
36
1.771
38
37
1.788
39
38
1.7908
40
39
1.8135
41
40
1.8142
42
41
1.8369
43
42
1.833
44
AC
Sales
Sterling
Revenue
Accessibility: Good to go
<
>
Ready
47°F
Cloudy
Q Search
Ο
f
ENG
11:06 PM
4/6/2024
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
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
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill