Perform simple exponential smoothing (using Excel’s Data Analysis or other software such as Minitab) using α = .05, .10, .20, and .50. Which value of α do you prefer? U.S. / U.K. Foreign Exchange Rate, U.S. Dollars to One British Pound (n = 60 days) Date Rate 1-Nov 1.2950 4-Nov 1.2906 5-Nov 1.2870 6-Nov 1.2872 7-Nov 1.2829 8-Nov 1.2790 12-Nov 1.2855 13-Nov 1.2840 14-Nov 1.2879 15-Nov 1.2901 18-Nov 1.2965 19-Nov 1.2926 20-Nov 1.2918 21-Nov 1.2915 22-Nov 1.2829 25-Nov 1.2885 26-Nov 1.2850 27-Nov 1.2881 29-Nov 1.2939 2-Dec 1.2936 3-Dec 1.3002 4-Dec 1.3095 5-Dec 1.3165 6-Dec 1.3127 9-Dec 1.3157 10-Dec 1.3178 11-Dec 1.3176 12-Dec 1.3133 13-Dec 1.3349 16-Dec 1.3330 17-Dec 1.3116 18-Dec 1.3078 19-Dec 1.3034 20-Dec 1.3036 23-Dec 1.2917 24-Dec 1.2955 26-Dec 1.3007 27-Dec 1.3090 30-Dec 1.3140 31-Dec 1.3269 2-Jan 1.3128 3-Jan 1.3091 6-Jan 1.3163 7-Jan 1.3127 8-Jan 1.3110 9-Jan 1.3069 10-Jan 1.3060 13-Jan 1.2983 14-Jan 1.3018 15-Jan 1.3030 16-Jan 1.3076 17-Jan 1.3029 21-Jan 1.3047 22-Jan 1.3136 23-Jan 1.3104 24-Jan 1.3071 27-Jan 1.3054 28-Jan 1.2996 29-Jan 1.3012 30-Jan 1.3106
Perform simple exponential smoothing (using Excel’s Data Analysis or other software such as Minitab) using α = .05, .10, .20, and .50. Which value of α do you prefer? U.S. / U.K. Foreign Exchange Rate, U.S. Dollars to One British Pound (n = 60 days) Date Rate 1-Nov 1.2950 4-Nov 1.2906 5-Nov 1.2870 6-Nov 1.2872 7-Nov 1.2829 8-Nov 1.2790 12-Nov 1.2855 13-Nov 1.2840 14-Nov 1.2879 15-Nov 1.2901 18-Nov 1.2965 19-Nov 1.2926 20-Nov 1.2918 21-Nov 1.2915 22-Nov 1.2829 25-Nov 1.2885 26-Nov 1.2850 27-Nov 1.2881 29-Nov 1.2939 2-Dec 1.2936 3-Dec 1.3002 4-Dec 1.3095 5-Dec 1.3165 6-Dec 1.3127 9-Dec 1.3157 10-Dec 1.3178 11-Dec 1.3176 12-Dec 1.3133 13-Dec 1.3349 16-Dec 1.3330 17-Dec 1.3116 18-Dec 1.3078 19-Dec 1.3034 20-Dec 1.3036 23-Dec 1.2917 24-Dec 1.2955 26-Dec 1.3007 27-Dec 1.3090 30-Dec 1.3140 31-Dec 1.3269 2-Jan 1.3128 3-Jan 1.3091 6-Jan 1.3163 7-Jan 1.3127 8-Jan 1.3110 9-Jan 1.3069 10-Jan 1.3060 13-Jan 1.2983 14-Jan 1.3018 15-Jan 1.3030 16-Jan 1.3076 17-Jan 1.3029 21-Jan 1.3047 22-Jan 1.3136 23-Jan 1.3104 24-Jan 1.3071 27-Jan 1.3054 28-Jan 1.2996 29-Jan 1.3012 30-Jan 1.3106
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
Perform simple exponential smoothing (using Excel’s Data Analysis or other software such as Minitab) using α = .05, .10, .20, and .50.
Which value of α do you prefer?
U.S. / U.K. Foreign Exchange Rate, U.S. Dollars to One British Pound (n = 60 days) | |||||||||
Date | Rate | ||||||||
1-Nov | 1.2950 | ||||||||
4-Nov | 1.2906 | ||||||||
5-Nov | 1.2870 | ||||||||
6-Nov | 1.2872 | ||||||||
7-Nov | 1.2829 | ||||||||
8-Nov | 1.2790 | ||||||||
12-Nov | 1.2855 | ||||||||
13-Nov | 1.2840 | ||||||||
14-Nov | 1.2879 | ||||||||
15-Nov | 1.2901 | ||||||||
18-Nov | 1.2965 | ||||||||
19-Nov | 1.2926 | ||||||||
20-Nov | 1.2918 | ||||||||
21-Nov | 1.2915 | ||||||||
22-Nov | 1.2829 | ||||||||
25-Nov | 1.2885 | ||||||||
26-Nov | 1.2850 | ||||||||
27-Nov | 1.2881 | ||||||||
29-Nov | 1.2939 | ||||||||
2-Dec | 1.2936 | ||||||||
3-Dec | 1.3002 | ||||||||
4-Dec | 1.3095 | ||||||||
5-Dec | 1.3165 | ||||||||
6-Dec | 1.3127 | ||||||||
9-Dec | 1.3157 | ||||||||
10-Dec | 1.3178 | ||||||||
11-Dec | 1.3176 | ||||||||
12-Dec | 1.3133 | ||||||||
13-Dec | 1.3349 | ||||||||
16-Dec | 1.3330 | ||||||||
17-Dec | 1.3116 | ||||||||
18-Dec | 1.3078 | ||||||||
19-Dec | 1.3034 | ||||||||
20-Dec | 1.3036 | ||||||||
23-Dec | 1.2917 | ||||||||
24-Dec | 1.2955 | ||||||||
26-Dec | 1.3007 | ||||||||
27-Dec | 1.3090 | ||||||||
30-Dec | 1.3140 | ||||||||
31-Dec | 1.3269 | ||||||||
2-Jan | 1.3128 | ||||||||
3-Jan | 1.3091 | ||||||||
6-Jan | 1.3163 | ||||||||
7-Jan | 1.3127 | ||||||||
8-Jan | 1.3110 | ||||||||
9-Jan | 1.3069 | ||||||||
10-Jan | 1.3060 | ||||||||
13-Jan | 1.2983 | ||||||||
14-Jan | 1.3018 | ||||||||
15-Jan | 1.3030 | ||||||||
16-Jan | 1.3076 | ||||||||
17-Jan | 1.3029 | ||||||||
21-Jan | 1.3047 | ||||||||
22-Jan | 1.3136 | ||||||||
23-Jan | 1.3104 | ||||||||
24-Jan | 1.3071 | ||||||||
27-Jan | 1.3054 | ||||||||
28-Jan | 1.2996 | ||||||||
29-Jan | 1.3012 | ||||||||
30-Jan | 1.3106 | ||||||||
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 6 steps with 1 images
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