Using Analytic Techniques to Add Meaning to Data

You are an analyst for the Wells Fargo company. The supervisor has asked you to create graphical representations from raw stock data for a company-wide meeting at the end of the quarter.

Your Role:
Your task is to analyze the stock history of the company and create a scatterplot and a histogram. Then you will calculate mean, median, mode, and standard deviation of the adjusted daily closing stock price and the stock volume.

It is your responsibility to turn that data into meaningful information using descriptive statistics.

Download data on a company’s stock history. From this data,
-create scatterplots
-histograms
Calculate the mean, median, mode, and standard deviation of some data points. Write a 3-page report including the graphs and descriptive statistics you have created.

apply those skills by downloading a practical dataset and creating graphical representations of that data. The work you do in this assignment will lay the foundation for future assessments in which you analyze and interpret those graphical representations.

Select the Time Period of one year for WELLS FARGO.
Select “Historical Prices.”
Select Frequency as “Daily.”
Click Apply.
Click on “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. A whole year of WELLS FARGO data needs to be shown. Then save the Excel file.
Using the Excel file with the year’s stock data for WELLS FARGO, 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.

Sample Solution

ACED ESSAYS