Question: Expected Return, Standard Deviation Calculate the average rate of returns and standard deviation of the Coca-Cola stock price and the Dow Jones Index, based on

Expected Return, Standard Deviation

Calculate the average rate of returns and standard deviation of the Coca-Cola stock price and the Dow Jones Index, based on the data below.

DATA

Part Solution

DATA

Part Solution

(Current return/Previous return)-1

(Current return/Previous return)-1

Month

Coca Cola Stock Prices

Returns

Dow Jones Index Prices

Returns

Jan-20

58.40

28256.03

Feb-20

53.49

-0.08

25409.36

-0.10

Mar-20

44.25

-0.17

21917.16

-0.14

Apr-20

45.89

0.04

24345.72

0.11

May-20

46.68

0.02

25383.11

0.04

Jun-20

44.68

-0.04

25812.88

0.02

Jul-20

47.24

0.06

26428.32

0.02

Aug-20

49.53

0.05

28430.05

0.08

Sep-20

49.37

0.00

27781.7

-0.02

Oct-20

48.06

-0.03

26501.6

-0.05

Nov-20

51.60

0.07

29638.64

0.12

Dec-20

54.44

0.06

30606.48

0.03

PLEASE USE EXCEL TO ANSWER THIS QUESTION AND SHOW YOUR FULL WORK.

THANK YOU

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!