Using the website recommended in the explanatory video, find the closing prices for the last twenty (20)
No answer yet for this question.
Ask a Tutor
Question:
- Using the website recommended in the explanatory video, find the closing prices for the last twenty (20) trading sessions for the following stocks:
- APPLE - (APPL)
- McDonalds Corporation - (MCD)
- Walmart- (WMT)
- The Coca Cola Company (KO)
- Goldman Sachs - (GS)
- Merck & Company- (MRK)
- Search for closing prices for the last twenty (20) trading sessions for the Dow Jones Industrials Index (DJI).
- Within the "Beta Calculator" spreadsheet located in Blackboard do the following:
- Perform Copy/Paste from each of the 20 sessions of the activity for each of the six (6) actions.
- Make Copy/Paste from each of the 20 Dow Jones Industrials (DJI) sessions.
- The Beta factor will be calculated automatically. Perform the same exercise for the five (5) actions presented.
- The data presented in the Excel sheet will feed a graph that will serve as a tool for data analysis.
- Interpret what the beta of each action tells us.
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/05/663af9d577a4b_077663af9d54af36.jpg)
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/05/663af9d624e56_077663af9d5e3b09.jpg)
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/05/663af9d6baad5_078663af9d689d94.jpg)
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/05/663af9d747387_079663af9d71bb1a.jpg)
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/05/663af9d7b7600_079663af9d7816c4.jpg)
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/05/663af9d84bd58_080663af9d80a48f.jpg)
Related Book For
Statistics For Business Decision Making And Analysis
ISBN: 9780321890269
2nd Edition
Authors: Robert Stine, Dean Foster
Posted Date: