Question: using excel formulas if possible A B D E 1 Date Stock A Return Stock B return 2 2/1/02 3.63% 12.71% 3 3/1/02 -2.86% 4.99%

using excel formulas if possible
using excel formulas if possible A B D E 1 Date Stock

A B D E 1 Date Stock A Return Stock B return 2 2/1/02 3.63% 12.71% 3 3/1/02 -2.86% 4.99% 4 4/1/02 -15.64% -7.56% 5 5/1/02 -1.30% -4.00% 6 6/1/02 -6.71% 5.49% 7 7/1/02 10.84% -7.72% 8 8/1/02 -6.37% -10.31% 9 9/1/02 -18.24% -7.92% 10 10/1/02 2.43% -12.84% 11 11/1/02 7.41% 15.07% 12 12/1/02 - 10.21% -3.11% 13 14 Use the information from the above table to calculate the 15 Average return 16 Variance 17 Standard Deviation 18 Covariance 19 20 21 A B D E 1 Date Stock A Return Stock B return 2 2/1/02 3.63% 12.71% 3 3/1/02 -2.86% 4.99% 4 4/1/02 -15.64% -7.56% 5 5/1/02 -1.30% -4.00% 6 6/1/02 -6.71% 5.49% 7 7/1/02 10.84% -7.72% 8 8/1/02 -6.37% -10.31% 9 9/1/02 -18.24% -7.92% 10 10/1/02 2.43% -12.84% 11 11/1/02 7.41% 15.07% 12 12/1/02 - 10.21% -3.11% 13 14 Use the information from the above table to calculate the 15 Average return 16 Variance 17 Standard Deviation 18 Covariance 19 20 21

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!