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
icon
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman