5008_Ass 2 : # Draft 1 : Assessment 2 Instructions: Using Analytic Techniques to Add Meaning to Data # MBA

Running Head : USING ANALYTIC TECHNIQUES TO ADD MEANING TO DATA 2

Using Analytic Techniques to Add Meaning to Data

Using Analytic Techniques to Add Meaning to Data

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.

To create this graph, copied the data in the columns "Date" and "High" and put them in a new tab "Highest Stock Price and Time" in the same excel worksheet. I then selected the data and clicked on the "Insert" tab on the tabs bar. I chose "Insert Scatter (X, Y)" in the "Charts" group. Finally, chose "Scatter with Smooth Lines" to generate the graph. I then clicked on the "+" in the chart area to insert "Axis Title" (Sarikaya & Gleicher, 2017).

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

To create this graph, copied the data in the columns "Date" and "Low" and put them in a new tab "Lowest Stock Price and Time" in the same excel worksheet. I then selected the data and clicked on the "Insert" tab on the tabs bar. I chose "Insert Scatter (X, Y)" in the "Charts" group. Finally, chose "Scatter with Smooth Lines" to generate the graph. I then clicked on the "+" in the chart area to insert "Axis Title" (Sarikaya & Gleicher, 2017).

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

To create this graph, I copy the data in the column "Adj Close" and put them in a new tab "Adjusted Daily Stock Price" in the same worksheet. I then establish bin limit and bin count for every range. I then selected the data and clicked on the "Insert" tab on the tabs bar. Finally, I chose "Clustered Columns" in the "Charts" group to generate the graph. I then clicked on the "+" in the chart area to insert "Axis Title" (Anderson, Sweeney, Williams, Camm, & Cochran, 2020). 

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

To create this graph, I copy the data in the column "Volume" and put them in a new tab "Stock Trading Volume" in the same worksheet. I then establish bin limit and bin count for every range. I then selected the data and clicked on the "Insert" tab on the tabs bar. Finally, chose "Clustered Columns" in the "Charts" group to generate the graph. I then clicked on the "+" in the chart area to insert "Axis Title" (Anderson et al., 2020).

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

Table 1.

Descriptive Statistics for the Adjusted Daily Closing Stock Price

Column1
Mean	551.8642305
Standard Error	19.81150916
Median	469.059998
Mode	#N/A
Standard Deviation	315.1213441
Sample Variance	99301.46153
Kurtosis	0.709074562
Skewness	1.021364902
Range	1334.610016
Minimum	211.399994
Maximum	1546.01001
Sum	139621.6503
Count	253
Confidence Level (95.0%)	39.01722924

I clicked "Data" in the tabs bar and select "Data Analysis" in the "Analysis Group." In the Data Analysis wizard, I chose "Descriptive Statistics." I activated the input range control and selected the data in the "Adj Close" column. I then select a 95% confidence level for mean and click "Ok." The above table with summary statistics was generated.

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

Table 2.

Descriptive Statistics for the Stock Volume

Column1
Mean	13413402.37
Standard Error	526530.6515
Median	11698100
Mode	#N/A
Standard Deviation	8374982.707
Sample Variance	7.01403E+13
Kurtosis	5.50164049
Skewness	1.820742724
Range	58473200
Minimum	2465600
Maximum	60938800
Sum	3393590800
Count	253
Confidence Level (95.0%)	1036961.241

I clicked "Data" in the tabs bar and select "Data Analysis" in the "Analysis Group." In the Data Analysis wizard, I chose "Descriptive Statistics." I activated the input range control and selected the data in the "Stock Volume" column. I then select a 95% confidence level for mean and click "Ok." The above table with summary statistics was generated (Agabekova, 2019).

References

Agabekova, N. V. (2019). Business Statistics using Excel: electronic educational-methodical complex for undergraduates in the specialties 1-25 80 10 "Statistics and analysis".

Anderson, D. R., Sweeney, D. J., Williams, T. A., Camm, J. D., & Cochran, J. J. (2020). Essentials of modern business statistics with Microsoft Excel. Cengage Learning.

Sarikaya, A., & Gleicher, M. (2017). Scatterplots: Tasks, data, and designs. IEEE transactions on visualization and computer graphics, 24(1), 402-412.