Part 1 The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c. Part 1 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 B. (Type integers or decimals rounded to two decimal places as needed.) Date Forecast B 09/03/2010 09/07/2010 09/08/2010 09/09/2010 09/10/2010 09/13/2010 09/14/2010 09/15/2010 09/16/2010 09/17/2010 09/20/2010 09/21/2010 Date A B C D Stock Exchange 09/03/2010 128.82 18.38 21.22 15.37 10,462.55 09/07/2010 124.78 18.27 20.54 15.54 10,262.84 09/08/2010 126.03 17.86 20.68 15.77 10,351.68 09/09/2010 125.91 17.98 20.43 15.99 10,319.13 09/10/2010 126.87 17.87 20.56 15.84 10,421.86 09/13/2010 128.66 18.47 21.45 16.23 10,502.87 09/14/2010 128.53 18.59 21.56 16.32 10,463.49 09/15/2010 128.92 18.64 21.75 16.43 10,654.59 09/16/2010 128.71 19.14 21.91 16.37 10,531.53 09/17/2010 129.71 18.69 21.65 16.17 10,709.94 09/20/2010 131.65 18.79 21.67 16.41 10,800.02 09/21/2010 132.27 19.02 21.62 16.63 10,680.45
Part 1 The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c. Part 1 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 B. (Type integers or decimals rounded to two decimal places as needed.) Date Forecast B 09/03/2010 09/07/2010 09/08/2010 09/09/2010 09/10/2010 09/13/2010 09/14/2010 09/15/2010 09/16/2010 09/17/2010 09/20/2010 09/21/2010 Date A B C D Stock Exchange 09/03/2010 128.82 18.38 21.22 15.37 10,462.55 09/07/2010 124.78 18.27 20.54 15.54 10,262.84 09/08/2010 126.03 17.86 20.68 15.77 10,351.68 09/09/2010 125.91 17.98 20.43 15.99 10,319.13 09/10/2010 126.87 17.87 20.56 15.84 10,421.86 09/13/2010 128.66 18.47 21.45 16.23 10,502.87 09/14/2010 128.53 18.59 21.56 16.32 10,463.49 09/15/2010 128.92 18.64 21.75 16.43 10,654.59 09/16/2010 128.71 19.14 21.91 16.37 10,531.53 09/17/2010 129.71 18.69 21.65 16.17 10,709.94 09/20/2010 131.65 18.79 21.67 16.41 10,800.02 09/21/2010 132.27 19.02 21.62 16.63 10,680.45
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.7: Exponential Smoothing Models
Problem 25P: The file P13_25.xlsx contains the quarterly numbers of applications for home mortgage loans at a...
Related questions
Question
Part 1
The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c.
Part 1
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 B.
(Type integers or decimals rounded to two decimal places as needed.)
Date
|
Forecast B
|
---|---|
09/03/2010
|
|
09/07/2010
|
|
09/08/2010
|
|
09/09/2010
|
|
09/10/2010
|
|
09/13/2010
|
|
09/14/2010
|
|
09/15/2010
|
|
09/16/2010
|
|
09/17/2010
|
|
09/20/2010
|
|
09/21/2010
|
Date A B C D Stock Exchange
09/03/2010 128.82 18.38 21.22 15.37 10,462.55
09/07/2010 124.78 18.27 20.54 15.54 10,262.84
09/08/2010 126.03 17.86 20.68 15.77 10,351.68
09/09/2010 125.91 17.98 20.43 15.99 10,319.13
09/10/2010 126.87 17.87 20.56 15.84 10,421.86
09/13/2010 128.66 18.47 21.45 16.23 10,502.87
09/14/2010 128.53 18.59 21.56 16.32 10,463.49
09/15/2010 128.92 18.64 21.75 16.43 10,654.59
09/16/2010 128.71 19.14 21.91 16.37 10,531.53
09/17/2010 129.71 18.69 21.65 16.17 10,709.94
09/20/2010 131.65 18.79 21.67 16.41 10,800.02
09/21/2010 132.27 19.02 21.62 16.63 10,680.45
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 2 steps with 3 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing