Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Gender And Finance

Authors: Ylva Baeckström

1st Edition

103205557X, 978-1032055572

More Books

Students also viewed these Finance questions

Question

7. Prove Theorem 5.2.5.

Answered: 1 week ago

Question

Conduct a needs assessment. page 269

Answered: 1 week ago