Report the two companies you would like to work on before proceeding. After receiving the goahead. you need to find their annual return rates $($the percentage of change in stock price from the previous year$)$ first. You then calculate the following measures of the return rates of the two companies:

The average of the retums from $2013$ to $2022$

The median of the returns

The geometric mean of the returns

Q$1$ of the returns

Q$3$

IQR

Upper Bound

Lower Bound

Is there an outlier? If yes, what is it$?$

Range of the returns

Mean absolute deviation

Standard deviation and variance of the returns

Coefficient of variation

Sharpe ratio with $3\mathrm{.}5\%$ risk$-$free return assumed

Between the two companies, calculate the following measures:

$15.$ Covariance between the two companies

$16.$ Their correlation

Generate the following plots with proper labeling:

$17.$ A boxplot of the returns by the company

$18.$ A scatterplot with the returns of one company on $x$ and the return of the other company on $y$

Mark your answers clearly in the Excel spreadsheet and submit your file.

DVN UN EquityBLK UN EquityDIE UNEOIVDevon Energy CorpBlackRock IncEFnergyCO$52\mathrm{.}0461\mathrm{.}8761\mathrm{.}21206\mathrm{.}71316\mathrm{.}47357\mathrm{.}5632340\mathrm{.}5240\mathrm{.}45\mathrm{.}6741\mathrm{.}4380\mathrm{.}54513\mathrm{.}7122\mathrm{.}54392\mathrm{.}8225\mathrm{.}97502\mathrm{.}715\mathrm{.}81721\mathrm{.}5444\mathrm{.}0561\mathrm{.}51915\mathrm{.}56708\mathrm{.}63$