The Stocks tab of the Excel file Week $14$ASMT Data.xlsx contains monthly adjusted stock prices for technology company Google, Inc., and consumer

$-$

$$goods company Walmart between

the years

$2018$

$-$

$2023$

$.$

Compute the sample covariance.

$(2$

$$decimals

$)$

$.$

Interpret the sample covariance: Higher Google stock prices are associated with

Walmart stock prices.

Develop a scatter diagram with Google stock price on the horizontal axis and Walmart

stock price on the vertical axis. What appears to be the direction of relationship

between these two stock prices?

Compute the sample correlation coefficient.

$(4$

$$decimals

$)$

$.$

$)$

What does the correlation coefficient indicate about the strength and direction of the

relationship between the stock price of Google and the stock price of Walmart?

Use the data below to solve answer, you to find covariance, correlation, and a scatter plot:

Date Google Walmart

$5/31/201844\mathrm{.}4465\mathrm{.}71$

$6/30/201850\mathrm{.}7168\mathrm{.}54$

$7/31/201854\mathrm{.}6066\mathrm{.}98$

$8/31/201856\mathrm{.}0065\mathrm{.}00$

$9/30/201861\mathrm{.}4069\mathrm{.}44$

$10/31/201865\mathrm{.}3272\mathrm{.}99$

$11/30/201868\mathrm{.}6970\mathrm{.}55$

$12/31/201861\mathrm{.}2966\mathrm{.}40$

$1/31/201964\mathrm{.}4368\mathrm{.}68$

$2/28/201968\mathrm{.}5770\mathrm{.}38$

$3/31/201975\mathrm{.}3972\mathrm{.}08$

$4/30/201980\mathrm{.}8771\mathrm{.}11$

$5/31/201986\mathrm{.}4769\mathrm{.}17$

$6/30/201988\mathrm{.}9568\mathrm{.}05$

$7/31/201995\mathrm{.}3773\mathrm{.}73$

$8/31/201994\mathrm{.}2174\mathrm{.}29$

$9/30/2019100\mathrm{.}9977\mathrm{.}42$

$10/31/2019111\mathrm{.}2180\mathrm{.}84$

$11/30/2019103\mathrm{.}6681\mathrm{.}43$

$12/31/2019110\mathrm{.}0375\mathrm{.}35$

$1/31/2020120\mathrm{.}6476\mathrm{.}64$

$2/28/2020117\mathrm{.}3273\mathrm{.}77$

$3/30/2020118\mathrm{.}0071\mathrm{.}58$

$4/29/2020122\mathrm{.}8471\mathrm{.}14$

$5/30/2020118\mathrm{.}7671\mathrm{.}01$

$6/29/2020114\mathrm{.}8569\mathrm{.}61$

$7/30/2020106\mathrm{.}9164\mathrm{.}66$

$8/30/2020104\mathrm{.}9165\mathrm{.}82$

$9/29/2020113\mathrm{.}6669\mathrm{.}89$

$10/30/2020112\mathrm{.}5169\mathrm{.}09$

$11/29/2020100\mathrm{.}5473\mathrm{.}31$

$12/30/202092\mathrm{.}9875\mathrm{.}42$

$1/30/202192\mathrm{.}3574\mathrm{.}77$

$2/28/2021104\mathrm{.}6776\mathrm{.}65$

$3/31/202190\mathrm{.}0274\mathrm{.}61$

$4/30/202195\mathrm{.}9076\mathrm{.}09$

$5/31/202192\mathrm{.}3779\mathrm{.}49$

$6/30/2021100\mathrm{.}6980\mathrm{.}36$

$7/31/2021102\mathrm{.}5182\mathrm{.}62$

$8/31/2021109\mathrm{.}8284\mathrm{.}92$

$9/30/2021110\mathrm{.}3082\mathrm{.}13$

$10/31/2021107\mathrm{.}3678\mathrm{.}63$

$11/30/2021113\mathrm{.}0980\mathrm{.}17$

$12/31/2021118\mathrm{.}4983\mathrm{.}53$

$1/31/2022133\mathrm{.}7687\mathrm{.}53$

$2/28/2022140\mathrm{.}8886\mathrm{.}35$

$3/31/2022140\mathrm{.}8783\mathrm{.}93$

$4/30/2022149\mathrm{.}8085\mathrm{.}31$

$5/31/2022141\mathrm{.}8284\mathrm{.}40$

$6/30/2022146\mathrm{.}4587\mathrm{.}95$

$7/31/2022161\mathrm{.}4990\mathrm{.}06$

$8/31/2022152\mathrm{.}3688\mathrm{.}80$

$9/30/2022167\mathrm{.}1184\mathrm{.}27$

$10/31/2022169\mathrm{.}8888\mathrm{.}49$

$11/30/2022167\mathrm{.}9090\mathrm{.}35$

$12/31/2022166\mathrm{.}1184\mathrm{.}90$

$1/31/2023176\mathrm{.}7277\mathrm{.}80$

$2/28/2023167\mathrm{.}1478\mathrm{.}55$

$3/31/2023164\mathrm{.}6371\mathrm{.}68$

$4/30/2023187\mathrm{.}8674\mathrm{.}31$