Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Weekly returns for two assets are provided in the file xlsx. You are required to calculate the average weekly return and standard deviation of Asset

Weekly returns for two assets are provided in the file xlsx. You are required to calculate the average weekly return and standard deviation of Asset 1 over the period 23rd September 2016 till 07-Apr-2017

All data in % weekly returns
Weeks Asset 1 Asset 2
23-Sep-2016 0.538 1.246
30-Sep-2016 0.053 0.188
07-Oct-2016 -0.506 -0.649
14-Oct-2016 -0.170 -1.000
21-Oct-2016 0.332 0.417
28-Oct-2016 -0.502 -0.682
04-Nov-2016 0.234 -1.902
11-Nov-2016 -1.466 3.788
18-Nov-2016 -1.023 0.949
25-Nov-2016 -0.212 1.460
02-Dec-2016 0.069 -1.013
09-Dec-2016 -0.268 3.103
16-Dec-2016 -0.613 -0.043
23-Dec-2016 0.447 0.288
30-Dec-2016 0.652 -1.061
06-Jan-2017 0.185 1.840
13-Jan-2017 0.194 -0.049
20-Jan-2017 -0.350 -0.130
27-Jan-2017 0.037 1.061
03-Feb-2017 -0.030 0.224
10-Feb-2017 0.436 0.871
17-Feb-2017 -0.018 1.572
24-Feb-2017 0.609 0.702
03-Mar-2017 -0.844 0.653
10-Mar-2017 -0.557 -0.402
17-Mar-2017 0.504 0.368
24-Mar-2017 0.594 -1.457
31-Mar-2017 0.065 0.854
07-Apr-2017 0.168 -0.260

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

Microfinance And Its Impact On Entrepreneurial Development Sustainability And Inclusive Growth

Authors: Ramesh Chandra Das

1st Edition

1522552138, 1522552146, 9781522552130, 9781522552147

More Books

Students also viewed these Finance questions