Then clicking on data analysis located under DATA tab provided me options to

Then clicking on data analysis located under data tab

This preview shows page 6 - 10 out of 10 pages.

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:
Image of page 6
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
Image of page 7
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
Image of page 8
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.
Image of page 9
Image of page 10

You've reached the end of your free preview.

Want to read all 10 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture