The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete part a Click the icon to view the closing prices data. a. Use Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smooth
The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete part a Click the icon to view the closing prices data. a. Use Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smooth
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
The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete part a
Click the icon to view the closing prices data.
a. Use Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smoothing constant of 0.3.
![The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c.
E Click the icon to view the closing prices data.
a. Use Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smoothing constant of 0.3.
Complete the exponential smoothing forecast model for stock A.
(Type integers or decimals rounded to two decimal places as needed.)
Date
Forecast A
09/03/ 2010
09/07/2010
Closing Prices
09/08/ 2010
09/ 09/2010
Stock
09/ 10/2010
Exchange D
10,415.68
10,320.55
Date
A
В
D
09/ 13/2010
09/03/ 2010 128.73
18.28
21.15
15.25
09/07/ 2010 125.47
18.11
20.68
15.44
09/ 14/2010
09/08/ 2010 127.24
17.73
20.76
15.68
10,353.27
09/ 15/2010
09/ 09/ 2010 127.25
17.98
20.56
15.79
10,332.99
09/10/2010 127.46
18.05
20.43
16.05
10,474.01
09/ 16/2010
09/ 13/2010 129.93
18.58
21.36
16.12
10,635.45
09/17/2010
09/ 14/2010 127.81
18.86
21.57
16.25
10,488.78
09/ 15/2010 129.74
18.73
21.75
16.18
10,518.83
09/ 20/2010
09/ 16/2010 128.66
18.93
21.72
16.33
10.602.89
09/21/2010
09/ 17/2010 129.82
18.76
21.84
16.26
10,690.54
09/ 20/2010 131.11
18.98
21.67
16.61
10,714.17
09/21/2010 132.26
19.18
21.61
16.63
10,703.66
Print
Done
OOOOD ODOODO](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F7f5d7e33-a769-491d-918b-b3ccb8916743%2F6eede74f-102f-4984-adbc-3f8ca01d9d8e%2F9mkqw8f_processed.png&w=3840&q=75)
Transcribed Image Text:The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c.
E Click the icon to view the closing prices data.
a. Use Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smoothing constant of 0.3.
Complete the exponential smoothing forecast model for stock A.
(Type integers or decimals rounded to two decimal places as needed.)
Date
Forecast A
09/03/ 2010
09/07/2010
Closing Prices
09/08/ 2010
09/ 09/2010
Stock
09/ 10/2010
Exchange D
10,415.68
10,320.55
Date
A
В
D
09/ 13/2010
09/03/ 2010 128.73
18.28
21.15
15.25
09/07/ 2010 125.47
18.11
20.68
15.44
09/ 14/2010
09/08/ 2010 127.24
17.73
20.76
15.68
10,353.27
09/ 15/2010
09/ 09/ 2010 127.25
17.98
20.56
15.79
10,332.99
09/10/2010 127.46
18.05
20.43
16.05
10,474.01
09/ 16/2010
09/ 13/2010 129.93
18.58
21.36
16.12
10,635.45
09/17/2010
09/ 14/2010 127.81
18.86
21.57
16.25
10,488.78
09/ 15/2010 129.74
18.73
21.75
16.18
10,518.83
09/ 20/2010
09/ 16/2010 128.66
18.93
21.72
16.33
10.602.89
09/21/2010
09/ 17/2010 129.82
18.76
21.84
16.26
10,690.54
09/ 20/2010 131.11
18.98
21.67
16.61
10,714.17
09/21/2010 132.26
19.18
21.61
16.63
10,703.66
Print
Done
OOOOD ODOODO
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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 with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman