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)

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,

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.