Section #$2$ based on the Sheet$=$Data and the AdjClose variable:

Python:

Price $=$ df$[\text{'}$AdjClose$\text{'}]$

mean$\_$v $=$ np$.$mean$($Price$)$

std$\_$v $=$ np$.$std$($Price$,$ ddof$=1)$ # Use ddof$=1$ for sample standard deviation

df$\_$v $=$ len$($Price$)-1$

# Using SciPy

# $95\%$ Confidence Interval

confidence$\_$interval $=$ stats.t$.$interval$(0\mathrm{.}95,$ df$\_$v$,$ loc$=$mean$\_$v$,$ scale$=$std$\_$v $/$ np$.$sqrt$($len$($Price$)))$

print$(\text{'}$Mean $=\text{'},$ mean$\_$v$)$

print$(\text{'}$Std $=\text{'},$ std$\_$v$)$

print$(\text{'}$df $=\text{'},$ df$\_$v$)$

print$(\text{'}95\%$ CL $=\text{'},$ confidence$\_$interval$)$

$$

# One sample test with a compared mean value to $180$

stats.ttest$\_1$samp$($Price$,$ popmean$=$mean$\_$v$)$

test$\_1$samp$\_$result $=$ stats.ttest$\_1$samp$($Price$,$ popmean$=180,$ alternative$=$'two$-$sided'$)$

print$(\text{'}180$ t$-$statistic $=\text{'},$ test$\_1$samp$\_$result.statistic$)$

print$(\text{'}180$ p$-$value $=\text{'},$ test$\_1$samp$\_$result.pvalue$)$

$$

Result:

Mean $=183\mathrm{.}94099557522125$

Std $=24\mathrm{.}18073993299828$

df $=451$

$95\%$ CL $=(181\mathrm{.}70580013487844,186\mathrm{.}17619101556406)$

Two$-$Sided $180$ t$-$statistic $=3\mathrm{.}4650186659320665$

Two$-$Sided $180$ p$-$value $=0\mathrm{.}0005808961945123946$

$$

Question: This question is worth $5$ points.

Please tell me what these results are telling you based on the descriptive statistics of the Adjust Closing Price sample?$$ Remember, everything I have provided should mean something to you.$$ I want to see if you really understand these descriptive statistics for the AdjClose Price.$$ You better pay attention to the question of $$Two$-$Sided$$ test.