using excel formulas compute the standard deviation for monthly returns for the sp aapl and pg c

Name: using excel formulas compute the standard deviation for monthly returns for the sp aapl and pg compute also the correlation coefficients of monthly returns between sp and aapl and sp and pg 94191
Uploaded: 2023-06-14T22:09:23-08:00
Duration: 4 min 55 s
Channel: Sri K
Description: using excel formulas compute the standard deviation for monthly returns for the sp aapl and pg compute also the correlation coefficients of monthly returns between sp and aapl and sp and pg 94191

Question

Sri K · Accepted Answer

Step 1: Gather the monthly returns data for S&P, AAPL, and PG.

Question

Using Excel formulas, compute the standard deviation for monthly returns for the S&P, AAPL, and PG. Compute also the correlation coefficients of monthly returns between S&P and AAPL, and S&P and PG. Consider all the available monthly returns to compute the statistics.

Please give Ace some feedback