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
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
use excel to solve this probelm please. I don't need long written statement to solve this. I posted this question last night and the answer I got was dissapointed!
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.
Step by step
Solved in 2 steps
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman