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
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!
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
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