Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started