Company of Choice: Apple Inc. $($AAPL$)$

Yahoo Finance is the data source.

Past Three Months' Historical Stock Prices:

Date of the USD Closing Price

$2023-07-01145\mathrm{.}86$

$2023-07-02147\mathrm{.}33$

$149\mathrm{.}152023-07-03......$

$2023-09-28154\mathrm{.}12$

$2023-09-29155\mathrm{.}30$

$($Note: For the previous three months, include all dates and matching closing prices.$)$

Task $2$: Calculating the Mean for Statistical Analysis:

The following formula is used to get the stock prices' mean, or average:

Mean is the total of all closing prices.

The quantity of closing costs

Number of closing prices $=$ Mean

total of all closing costs

Assuming there are thirty closing prices and that the total of all closing prices over the last three months is $$4500\mathrm{.}00$:

$30=150\mathrm{.}00$; Mean $=4500\mathrm{.}00$

Average: $304500\mathrm{.}00=150\mathrm{.}00$

Calculating the Median:

Sort the stock prices upward to determine the center value, which is the median. The median, when the number of observations is even, is the mean of the two middle values.

Presuming the closing prices are arranged as follows:

$[145\mathrm{.}86,147\mathrm{.}33,149\mathrm{.}15,$ et cetera, $154\mathrm{.}12,155\mathrm{.}30]$

$[147\mathrm{.}33,149\mathrm{.}15,154\mathrm{.}12,155\mathrm{.}30,145\mathrm{.}86]$

The average of the $15$th and $16$th values, if there are $30$ prices, is the median.

Calculating the Standard Deviation

The stock price dispersion from the mean is measured by the standard deviation.

Standard Deviation $=($Width $$ Mean$)/2$

Standard Deviation is equal to N $($X i $$Mean$)2.$

Considering $$200\mathrm{.}00$ as the total of the squared deviations from the mean:

Deviation Standard $=200\mathrm{.}00302\mathrm{.}58$

Deviation Standard $=30200\mathrm{.}00$

$2\mathrm{.}58$

Compute Range:

The range is the difference in stock prices from highest to lowest.

Assuming that $$145\mathrm{.}86$ is the lowest price and $$155\mathrm{.}30$ is the highest:

$155\mathrm{.}30-145\mathrm{.}86=9\mathrm{.}44$ is the range.

Calculating Variance: Range $=155\mathrm{.}30-145\mathrm{.}86=9\mathrm{.}44$

The standard deviation squared equals variance.

Variance equals $($Standard Deviation $)/2=2\mathrm{.}5826\mathrm{.}66$

Standard Deviation $-$: Variance $=2\mathrm{.}58$

$2.6\mathrm{.}66$

Synopsis

Average Cost: $$150\mathrm{.}00$

The value between the fifteenth and sixteenth sorted prices is the median price.

Deviation from the mean: $$2\mathrm{.}58$

$$9\mathrm{.}44$ in the range

Variance: $$6\mathrm{.}66$

make this file in excel format