The mean of the daily traded stock volume was 3079152306 This figure shows that

The mean of the daily traded stock volume was

This preview shows page 8 - 11 out of 11 pages.

daily adjusted closing stock price has increased among the duration of the last year. The mean of the daily traded stock volume was 30791523.06. This figure shows that the daily traded stock volume has increased among the duration of the last year. The mean of the Capella University provided insight for using excel to determine the mean of a data set. “The mean can be calculated in Excel 2016 by selecting the Formulas tab on the home page and then selecting the More Functions option in the drop-down menu. Next, select the Statistical bar and select Average from the list. In the Functions Argument page for the average, fill the Number 1 option by selecting the data set for adjacent closing stock price found in column 6 and then select OK; this leads to the generation of the mean” (Thompson, 2019)
Image of page 8
9 Applying Analytic Techniques to Business Median is a statistical measure used to determine the central or midpoint of a value set. Capella University provided insight on how to determine the median in Excel “The median can be calculated in Excel 2016 by selecting the Formulas tab; select the More Functions option, select the Statistical bar, and choose Median from the list. In the Functions Argument page for the median, select the data set for adjacent closing stock price and then select OK, which will generate the median” (Thompson, 2019). The median of the adjusted daily closing stock price is 195.877899. The median for the adjusted daily closing stock price is higher than the mean, this in turn shows a steadily increasing relationship for the daily prices. The median of the daily traded stock volume is 27528300. The median for the daily traded stock volume is lower than the mean of this dataset, this means that there has been significant increases in the daily traded stock volume. Mode is the figure that occurs most often. When calculating mode in Excel , highlight the data you want to use, select the Formulas tab, select the More Functions option, select the Statistical bar, and select MODE SNGL, then enter the cell numbers as noted above. The mode for the adjusted daily closing stock price is 172.176.The mode for of the daily traded stock volume is 36529700. Standard deviation is a measure of the dispersion or separation of values from the mean. In excel, first select the Formulas tab, select the More Functions option, select the Statistical bar, and select the Standard Deviation Sample (STDEV.S) option. Then, in the Functions Argument page, select the data set for adjacent closing stock price as the Number 1 option and select OK to generate the standard deviation. The standard deviation of the adjusted daily closing stock price is 24.89745547. Considering the mean of the adjusted daily closing stock price is 193.2205379,
Image of page 9
10 Applying Analytic Techniques to Business the volatility is 7.7%. The standard deviation suggests Apple Inc. hosts a moderate risk when purchasing stock. The standard deviation of the daily traded stock volume is 12709433.63. The volatility of the daily traded stock volume is 2.2%, this low volatility represents a very consistent growth in daily traded stock volume.
Image of page 10
Image of page 11

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture