$2)$ Use Yahoo Finance to download one year$$s worth of weekly prices for the

following two stocks: NVIDIA $($ticker: NVDA$)$ and Advanced Micro Devices

Inc. $($ticker: AMD$).$ Be careful to sort the data depending on how you want the

data to be displayed. Use the dates: $5/12/2023$ through $5/12/2024.$ This will

result in prices over the period: $5/8/23-5/6/24.$

Based on the adjusted closing prices, calculate each stock$$s: weekly mean return

$($continuously compounded$),$ and weekly standard deviation $($for a sample$).$ Then

annualize the return and standard deviation.

Next, calculate the weekly covariance and annualize it$.$ Also solve for the

correlation between the two stocks.

What return $($for each of the two stocks$)$ is the cutoff for which $15\%$ of the returns

lie above it$?($HINT: I$$m looking for you to use the PERCENTILE function$).$

$3)$ Use the LINEST function to describe the relationship between these two stocks.

Treat NVDA as the Y variable and AMD as the X variable.

a$)$ If AMD stock rises by $6\%,$ what can we expect NVDA$$s stock return to

be$?$

b$)$ How reliable do you think this result is$,$ and why?