Standard deviation of adjusted daily closing stock price

Assignment Help Business Management

Reference no: EM133085041

Select a business of which you are a part or in which you have interest and download the raw data on the company's stock history. Any business that has practical meaning for you is appropriate for this assessment on Yahoo FinanceUsing the Excel file with the year's stock data, conduct descriptive analysis as follows:

Create a scatterplot of the highest stock price (in the column labeled "High") against time. Write a sentence explaining the process by which you created this graph.

Create a scatterplot of the lowest stock price (in the column labeled "Low") against time. Write a sentence explaining the process by which you created this graph.

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 a sentence explaining the process by which you created this graph.

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 a sentence explaining the process by which you created this graph.

Calculate the mean, median, mode, and standard deviation of the adjusted daily closing stock price. Write a sentence explaining the process by which you calculated these statistics.

Calculate the mean, median, mode, and standard deviation of the stock volume. Write a sentence explaining the process by which you calculated these statistics.

Reference no: EM133085041

Questions Cloud

How much is the combined balance of the BDO accounts : The closing rate for the year was $1 = P54 and the average rate was $1 = P40. How much is the combined balance of the BDO accounts (in peso)

What is the future of tqm : Q#1. Does an organization's complete supply chain influence both the need for and implementation of TQM? Is an organization's overall supply chain important to

Describe four methods of sampling : Describe four methods of sampling and provide examples of each. How could each of these methods be useful in some area of business?

What are the pros and cons of csr : What is Corporate Social Responsibility? Where does Corporate Social Responsibility fit in? CSR vs grants: What is the difference between granting organizations

Standard deviation of adjusted daily closing stock price : Calculate the mean, median, mode, and standard deviation of the adjusted daily closing stock price.

Federal and provincial governments in canada : Over the last twenty years, while federal and provincial governments in Canada have been investing heavily in research and development, manufactured product hav

Lululemon athletica-primed for growth case : Read the Lululemon Athletica: Primed for Growth case attached in below and answer the following ing question

What is the recoverable amount of the building : The entity holds its buildings at re-valued depreciated cost: Revalued Cost 250,000. What is the recoverable amount of the building

Describe three tricks you learned that food companies : From the Marketplace video describe three tricks you learned that food companies use to make their products appear healthier than they really are?

User Account

All Pages