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

QUESTION

thanks for helping me with this exercice3. 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 thestock’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

ANSWER:

REQUEST HELP FROM A TUTOR