The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c. 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

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter4: Analyzing And Charting Financial Data
Section4.2: Charts, Sparklines, And Data Bars
Problem 3QC
icon
Related questions
Question
The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c.
 
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
 
 
 
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
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
 
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Public key encryption
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage