Q2 DATA: YOU ARE PRESENTED WITH FOUR (4) STOCKS AND THEIR RETURNS FOR FIVE CONDITIONS. QUESTION 1: USING THE COVARAINCE AND CORRELATION COEFFICIENT SHOW YOUR PREFERED TWO- ASSET COMBINATION.

NAME: STUDENT NUMBER: MODE OF STUDY: INSTURCTIONS: READ CAREFULLY. ALL CALCULATIONS MUST BE DONE IN EXCEL USING EXCEL APPROPRIATE Q2 DATA: YOU ARE PRESENTED WITH FOUR (4) STOCKS AND THEIR RETURNS FOR FIVE CONDITIONS. QUESTION 1: USING THE COVARAINCE AND CORRELATION COEFFICIENT SHOW YOUR PREFERED TWO-AS FORMULAS SET COMBINATION. Probability of Occurrence bte of Return Distributie E F G H 0.1 0.1 0.06 0.14 0.04 0.2 0.1 0.08 0.12 0.06 0.4 0.1 0.1 0.1 0.08 0.2 0.1 0.12 0.08 0.15 0.1 0.1 0.14 0.06 0.22 Probability of Occurrence bte of Return Distributie E F G H 0.1 0.1 0.06 0.14 0.04 0.2 0.1 0.08 0.12 0.06 0.4 0.1 0.1 0.1 0.08 0.2 0.1 0.12 0.08 0.15 0.1 0.1 0.14 0.06 0.22 Probability of Occurrence bte of Return Distributie E F G H 0.1 0.1 0.06 0.14 0.04 0.2 0.1 0.08 0.12 0.06 0.4 0.1 0.1 0.1 0.08 0.2 0.1 0.12 0.08 0.15 0.1 0.1 0.14 0.06 0.22 NAME: STUDENT NUMBER: MODE OF STUDY: INSTURCTIONS: READ CAREFULLY. ALL CALCULATIONS MUST BE DONE IN EXCEL USING EXCEL APPROPRIATE Q2 DATA: YOU ARE PRESENTED WITH FOUR (4) STOCKS AND THEIR RETURNS FOR FIVE CONDITIONS. QUESTION 1: USING THE COVARAINCE AND CORRELATION COEFFICIENT SHOW YOUR PREFERED TWO-AS FORMULAS SET COMBINATION. Probability of Occurrence bte of Return Distributie E F G H 0.1 0.1 0.06 0.14 0.04 0.2 0.1 0.08 0.12 0.06 0.4 0.1 0.1 0.1 0.08 0.2 0.1 0.12 0.08 0.15 0.1 0.1 0.14 0.06 0.22 Probability of Occurrence bte of Return Distributie E F G H 0.1 0.1 0.06 0.14 0.04 0.2 0.1 0.08 0.12 0.06 0.4 0.1 0.1 0.1 0.08 0.2 0.1 0.12 0.08 0.15 0.1 0.1 0.14 0.06 0.22 Probability of Occurrence bte of Return Distributie E F G H 0.1 0.1 0.06 0.14 0.04 0.2 0.1 0.08 0.12 0.06 0.4 0.1 0.1 0.1 0.08 0.2 0.1 0.12 0.08 0.15 0.1 0.1 0.14 0.06 0.22