Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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
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...
See similar textbooks
icon
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
SEE MORE TEXTBOOKS