Instructions:
Select a publicly traded business or stock that plays in only one industry in which you have interest. Download the raw data on the company’s stock history.
Follow these steps to locate and download stock history from Yahoo! Finance:
•Go to Yahoo Finance: https://finance.yahoo.com/
•Search for and find the stock information of your chosen company. Remember do not use a company that plays in multiple industries.
•Once you pull up the general data on the company, review the screen links throughout until you find the link for Historical Data. Click on the Historical Data link. Then select the following settings above the table:
oSelect Time Period of one year.
oSelect “Historical Prices.”
oSelect Frequency as “Daily.”
oClick Apply.
oClick Download Data. Go to the bottom of your screen or your Downloads folder to open the Excel file you just downloaded. Open the Excel file. Check to be sure that you have enough lines to show the whole year. If not, reset the settings at the top of the Historical Data chart and try again.
oOnce you are sure that you have a year’s worth of data, save the Excel file.
Using the Excel file with the year’s stock data, conduct descriiptive analysis as follows:
1. Create a scatter plot of the highest stock price (in the column labeled “High”) against time. Write several sentences explaining the process/steps by which you created this graph.
2. Create a scatter plot of the lowest stock price (in the column labeled “Low”) against time. Write several sentences explaining the process/steps by which you created this graph.
3. Create a histogram of the adjusted daily closing stock price (in the column labeled “Adj Close”). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write several sentences explaining the process/steps by which you created this graph.
4. Create a histogram of the stock trading volume (in the column labeled “Volume”). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write several sentences explaining the process/steps by which you created each graph.
5. Complete the following for each of the four graphs:
o Make sure the x and y axis have appropriate labels—“Stock Price in USD” or “Date D/M/Y” for example.
o Change the title of the graph to communicated what the graph is communicating.
o Add options—color, trendlines, legend, other?
6. Calculate the mean, median, mode, and standard deviation of the adjusted daily closing stock price.
7. Put answers of calculations in table format for easy review.
8. Write several sentences explaining the process by which you calculated these statistics.
9. Calculate the mean, median, mode, and standard deviation of the stock volume. Put in table format for easy review. Write a sentence explaining the process by which you calculated these statistics.
10. Prepare a 5-8 page report that you would present to your supervisor, including the following:
o An APA-formatted title page.
o A 1-2 page introduction describing the background of your chosen company and its practical extensive business context. You should use at least four sources of information on the company, industries the company participates in, history, mission, platforms, products, competitive advantage, and competitors by industry.
o A section labeled Graphical Representations of Data, in which you include the four graphs you created above and short descriiptions of the process you used to create each graph.
o A section labeled Descriiptive Statistics, in which you include the statistics you calculated above and explanation of the procedures you followed to calculate the statistics.
o A summary of what the data suggests. No opinion please. See textbook information on how to interpret data. Please remain unbiased in your summary. You may use additional resources (and cite) to help you interpret the data. For example: What does Standard Deviation say about stock volatility?
Requirements:
• Length: 5-8 pages, double-spaced. Include a title page and the graphical representations of the data selected.
• Written communication: Written communication should be free of errors that detract from the overall message.
• Your paper should be APA-formatted with in-text citations and a corresponding references page. Remember to cite the sources of your financial data. Include at least four sources of information for your page and reflect on reference page.
Walkthrough:
You may view the following media piece to help you understand concepts addressed in this assessment:
• Using Analytic Techniques to Add Meaning to Data Walkthrough: https://media.capella.edu/coursemedia/mba5008element19233/wrapper.asp