Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use Excel to answer the question The Closing Stock Prices data below provides data for four stocks and the Dow Jones Industrial Average over a
Use Excel to answer the question
The Closing Stock Prices data below provides data for four stocks and the Dow Jones Industrial Average over a one-month period.
1. Construct a visual of your choice to display all four stocks prices and the DJIA for each day over the period from 9/3/2010 to 10/1/2010. Be sure each stock/index is clearly identifiable.
Closing Stock Prices | |||||
Date | IBM | INTC | CSCO | GE | DJ Industrials Index |
9/3/10 | $127.58 | $18.43 | $21.04 | $15.39 | 10447.93 |
9/7/10 | $125.95 | $18.12 | $20.58 | $15.44 | 10340.69 |
9/8/10 | $126.08 | $17.90 | $20.64 | $15.70 | 10387.01 |
9/9/10 | $126.36 | $18.00 | $20.61 | $15.91 | 10415.24 |
9/10/10 | $127.99 | $17.97 | $20.62 | $15.98 | 10462.77 |
9/13/10 | $129.61 | $18.56 | $21.26 | $16.25 | 10544.13 |
9/14/10 | $128.85 | $18.74 | $21.45 | $16.16 | 10526.49 |
9/15/10 | $129.43 | $18.72 | $21.59 | $16.34 | 10572.73 |
9/16/10 | $129.67 | $18.97 | $21.93 | $16.23 | 10594.83 |
9/17/10 | $130.19 | $18.81 | $21.86 | $16.29 | 10607.85 |
9/20/10 | $131.79 | $18.93 | $21.75 | $16.55 | 10753.62 |
9/21/10 | $131.98 | $19.14 | $21.64 | $16.52 | 10761.03 |
9/22/10 | $132.57 | $19.01 | $21.67 | $16.50 | 10739.31 |
9/23/10 | $131.67 | $18.98 | $21.53 | $16.14 | 10662.42 |
9/24/10 | $134.11 | $19.42 | $22.09 | $16.66 | 10860.26 |
9/27/10 | $134.65 | $19.24 | $22.11 | $16.43 | 10812.04 |
9/28/10 | $134.89 | $19.51 | $21.86 | $16.44 | 10858.14 |
9/29/10 | $135.48 | $19.24 | $21.87 | $16.36 | 10835.28 |
9/30/10 | $134.14 | $19.20 | $21.90 | $16.25 | 10788.05 |
10/1/10 | $135.64 | $19.32 | $21.91 | $16.36 | 10829.68 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started