FINANCE-Select a stock and S& P 500 Index (ETF) and import

thanks for helping me with this exercice

3. Select a stock and S& P 500 Index (ETF) and import 1 year of daily stock prices into MS Excel,

a. Compute the daily return of the stock and S & P 500,

b. Compute the mean and standard deviation of the stock’s return and S & P 500,

4. Use the Data Analysis ADD-In of Excel to compute the stock’s beta coefficient. Regress the

stock’s return on the return of the S & P 500.

5. Using the regression output, determine the stock’s systematic and unsystematic risks.

Var(R) = ß^2 Var [S&P 500] + Var [e] = systematic risk and unsystematic risk