Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

hi im wondering if i could have some help finding the equations to the average return, variance, standard deviation, and the covariance. i have attached

image text in transcribed

hi im wondering if i could have some help finding the equations to the average return, variance, standard deviation, and the covariance. i have attached the excel sheet

image text in transcribed
A14 X V fx Use the information from the above table to calculate the average reutrns, variances, standard deviations, and covariance for Stock A and Stock B A B C D E F G H K M N O Q 1 Date Stock A Return Stock B return 2 2/1/02 3.63% 12.71% 3/1/02 2.86% 4.99% 4/1/02 -15.64% 7.56% 5 5/1/02 1.30% 4.00% 6 6/1/02 6.71% 5.49% 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

Mergers, Acquisitions and Other Restructuring Activities

Authors: Donald DePamphilis

8th edition

9780128024539, 128013907, 978-0128013908

More Books

Students also viewed these Finance questions

Question

What are the skills of management ?

Answered: 1 week ago