Using the Excel file with the year’s stock data, conduct descriptive analysis as follows:1. Create a scatter plot of the highest stock price against time. Write a sentence explaining the process by which you created this graph.
2. Create a scatter plot of the lowest stock price against time. Write a sentence explaining the process by which you created this graph.
3. Create a histogram of the adjusted daily closing stock price. 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.
4. Create a histogram of the stock trading 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.
5. 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.
