The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c.

College Algebra
1st Edition
ISBN:9781938168383
Author:Jay Abramson
Publisher:Jay Abramson
Chapter6: Exponential And Logarithmic Functions
Section6.1: Exponential Functions
Problem 3SE: The Oxford Dictionary defines the word nominal asa value that is “stated or expressed but...
icon
Related questions
Question
100%
The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c.
 
LOADING...
Click the icon to view the closing prices data.
 
 
 

Question content area bottom

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 A.
​(Type integers or decimals rounded to two decimal places as​ needed.)
Date
Forecast A
09/03/2010
 
09/07/2010
enter your response here
 
09/08/2010
enter your response here
 
09/09/2010
enter your response here
 
09/10/2010
enter your response here
 
09/13/2010
enter your response here
 
09/14/2010
enter your response here
 
09/15/2010
enter your response here
 
09/16/2010
enter your response here
 
09/17/2010
enter your response here
 
09/20/2010
enter your response here
 
09/21/2010
enter your response here
 

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 1 images

Blurred answer
Similar questions
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781337278461
Author:
Ron Larson
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781337282291
Author:
Ron Larson
Publisher:
Cengage Learning