Mean Median Mode and Standard Deviation Adjusted Daily Closing Stock Price Mean

Mean median mode and standard deviation adjusted

This preview shows page 5 - 7 out of 8 pages.

Mean, Median, Mode, and Standard DeviationAdjusted Daily Closing Stock PriceMean8.8582Median8.7373Mode10.05Standard Deviation0.792This statistic represents the adjusted daily closing stock prices. The mean is the average daily stock price. The median in the daily stock prices that fell right in the middle of the highest and the lowest daily stock price and the mode is the daily stock price that occurred the most. Because the mean is higher than the median it implies that average stock price is on the higher that the mid range of the adjusted daily closing stock prices. Stock Volume Mean43,079,356Median40,183,200Mode#N/AStandard Deviation16,392,385This statistic represents the Stock volume. The mean is the average stock volume. The median in the stock volume that fell right in the middle of the highest and the lowest stock volume and the mode is the stock volume that occurred the most. Because the mean is higher than the median it implies that average stock volume is on the higher that the mid range of the stock volume.
Background image
APPLYING ANALYTIC TECHNIQUES TO BUSINESS 6Descriptive StatisticsTo create the “High” graph, I pulled the stock history over the last year, filtered out the unneeded columns and selected the “high” price column as the “y” axis and the dates as the “x” axis and created a scatterplot in Microsoft Excel. To create the “Low” graph, I pulled the stock history over the last year, filtered out the unneeded columns and selected the “low” price column as the “y” axis and the dates as the “x” axis and created a scatterplot in Microsoft Excel. To create the “Adj Close” graph, I pulled the stock history over the last year, filtered out the unneeded columns and selected the “Adj Close” price column as the “y” axis and the dates as the“x” axis and created a scatterplot in Microsoft Excel. To create the “Volume” graph, I pulled the stock history over the last year, filtered out the unneeded columns and selected the “Volume” price column as the “y” axis and the dates as the “x” axis and created a scatterplot in Microsoft Excel. I was able to calculate the Adjusted Daily Closing Stock Price statistics by selecting the data in the “Adj Close” column and use the Microsoft Excel function (=AVERAGE()) to calculate the mean, used the Microsoft Excel function (=MEDIAN()) to calculate the median, used the Microsoft Excel function “MODE” (=MODE()) to calculate the mode and used the Microsoft Excel function for
Background image
Image of page 7

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture