Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have been provided with the yearly equity return for USA, Australia, Canada and Japan Table 2.1: Annual Returns Year USA Australia Canada Japan 2017

You have been provided with the yearly equity return for USA, Australia, Canada and Japan

Table 2.1: Annual Returns

Year

USA

Australia

Canada

Japan

2017

0.04

0.03

0.03

0.04

2018

0.06

0.05

0.09

-0.02

2019

-0.03

-0.02

-0.05

0.07

2020

0.01

0.02

0.02

-0.02

2021

0.04

0.05

0.08

0.02

2022

-0.05

-0.03

-0.06

0.06

Using the data provided in Table 2.1, you are required to answer the following:

(i) Produce the Variance-covariance matrix for the four markets. The variance-covariance matrix is expected to be generated using Microsoft Excel.

(ii) Using the variance covariance matrix presented in Part a (i) above, identify the variance of returns for each market and highlight them in bold.

(iii) Generate the correlation coefficient figures for the pairs of markets.

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

Process To Profits Strategic Planning For A Growing Business

Authors: William Lasher

1st Edition

0324223870, 9780324223873

More Books

Students also viewed these Finance questions

Question

What are some of the hiring standards to avoid?

Answered: 1 week ago

Question

What are some metrics for evaluating recruitment and selection?

Answered: 1 week ago