Then clicking on data analysis located under data tab

increment of 100. Then, clicking on “data analysis” (located under DATA tab) provided me with
options to choose from and Histogram was one of them. Selecting histogram popped up a prompt
box where I was able to enter input range and bin range. The chart was created in excel based on
the data enter and again I was able to make changes such as axis titles and size.
4) Amazon’s Stock Trading Volume Histogram:

USING ANALYTIC TECHNIQUES TO ADD MEANING TO DATA 7
881300 3328966.67 5776633.34 8224300.01 10671966.6813119633.3515567300.02
0
20
40
60
80
100
120
140
Amazon's Stock Trading Volume Histogram
Frequency
Ranges of Stock Trading Volume
Frequency

USING ANALYTIC TECHNIQUES TO ADD MEANING TO DATA 8
Process: To determine bin range, highest value ($ 15567300) and lowest value ($881300) were
determined with the formulas =Max and = Min from Column G (Volume). The bin range was
determined to be $ 2,447,666.67 [(Highest Value - Lowest Value) / 6] and a separate column was
created to enter the data. Then, clicking on “data analysis” (located under DATA tab) provided
me with options to choose from and Histogram was one of them. Selecting histogram popped up
a prompt box where I was able to enter input range and bin range. The chart was created in excel
based on the data enter and again I was able to make changes such as axis titles and size.
Descriptive Statistics
Mean, Median, Mode, and Standard Deviation for Amazon’s Adjusted Daily Closing Stock
Prices
1) Mean = $1879.70: To calculate Mean, I selected an empty cell in the excel sheet and
inserted formula for Average for Cells F2 through F253 (Formula tab → Autosum pop
down menu → Average) and hit enter to generate the answer.
2) Median = $ 1854.28 : To calculate Median, I selected an empty cell in the excel sheet and
inserted formula for Median for Cells F2 through F253 (Formula tab → Autosum pop
down menu → More Options → Median → Number 1(entered the cells range F2:F253))
and hit enter to generate the answer.
3) Mode = $ 1855.32 : To calculate Mode, I selected an empty cell in the excel sheet and
inserted formula for Mode for Cells F2 through F253 (Formula tab → Autosum pop
down menu → More Options → MODE:SNGL → Number 1(entered the cells range
F2:F253)) and hit enter to generate the answer.
4) Standard Deviation = $
141.98 : To calculate
Standard Deviation, I selected an empty cell
in the excel sheet and inserted formula for Standard Deviation for Cells F2 through F253

USING ANALYTIC TECHNIQUES TO ADD MEANING TO DATA 9
(Formula tab → Autosum pop down menu → More Options → STDEV.S → Number
1(entered the cells range F2:F253)) and hit enter to generate the answer.