Compute the annual standard deviation of returns for all countries from 1980 – 1981 Year Month...

Compute the annual standard deviation of returns for all countries from 1980 – 1981

Year	Month	Australia	Canada	France	Germany	Italy
1980	7	-0.0026889	0.0546111	-0.0204165	0.0369633	0.1278857
1980	8	0.0407999	-0.0117627	0.0244608	-0.0230018	0.0696608
1980	9	0.060746	0.0135679	0.0113528	-0.0190223	0.1420983
1980	10	0.0585204	-0.0220067	0.0920545	-0.0205731	0.2766413
1980	11	-0.0175011	0.0490367	-0.0163204	-0.0030604	-0.0968726
1980	12	-0.030612	-0.074856	-0.0757283	-0.0210946	0.0017446
1981	1	-0.0965194	-0.0119725	-0.0590439	-0.034434	0.1904963
1981	2	-0.0241678	-0.0322855	0.0308526	-0.0096864	0.0908233
1981	3	0.0816266	0.0492637	0.0112111	0.0099601	0.0358859
1981	4	-0.0156632	-0.0168862	-0.0607607	0.0350148	0.1014527
1981	5	-0.0034859	0.0154803	-0.1894615	-0.0372021	0.0531986
1981	6	-0.0324157	-0.0358805	-0.0759704	0.0361752	-0.2164954
1981	7	-0.1098754	-0.05526	0.1138425	-0.0065494	-0.092925
1981	8	-0.0136848	-0.0340705	0.0249309	-0.0462012	0.1319221
1981	9	-0.1024419	-0.1480877	-0.0313814	-0.0480223	-0.1772388
1981	10	-0.0587205	-0.0334613	-0.0514094	-0.015371	-0.051872
1981	11	0.0683676	0.0768831	0.0250603	0.0186473	0.0455291
1981	12	-0.0010473	-0.0444019	-0.0153722	-0.0308835	-0.016512

Solutions

Expert Solution

milcah answered 9 months ago

Next > < Previous

Related Solutions

The (annual) expected return and standard deviation of returns for 2 assets are as follows:

1. The (annual) expected return and standard deviation of returns for 2 assets are as follows: Asset A Asset B E[r] 10% 20% SD[r] 30% 50% The correlation between the returns is 0.15. a. Calculate the expected returns and standard deviations of the following portfolios: (i) 80% in A, 20% in B (ii) 50% in A, 50% in B (iii) 20% in A, 80% in B b. Find the weights for a portfolio with an expected return of 25%?...

Compute the standard deviation given these four economic states, their likelihoods, and the potential returns: Economic...

Compute the standard deviation given these four economic states, their likelihoods, and the potential returns: Economic State Probability Return Fast Growth 0.35 40% Slow Growth 0.45 10% Recession 0.10 -10% Depression 0.10 -100% 39.48 percent 12.65 percent 113.69 percent 7.5 percent

For Asset A and for Asset B, compute the average annual return, variance, standard deviation, and...

For Asset A and for Asset B, compute the average annual return, variance, standard deviation, and coefficient of variation for the annual returns given below. a. Asset A: 5%, 10%, 15%, 4% b. Asset B: -6%, 20%, 2%, -5%, 10%

What is the standard deviation of the returns?

You are analyzing the returns of a mutual fund portfolio for the past 5 years. Year Return 2014 -30% 2015 -25% 2016 40% 2017 -10% 2018 15% What is the standard deviation of the returns?

The (annual) expected return and standard deviation of returns for 2 assets are as follows: Asset...

The (annual) expected return and standard deviation of returns for 2 assets are as follows: Asset A : E[r] 10% , SD[r] 30% Asset B : E[r] 20% , SD[r] 50% The correlation between the returns is 0.15 a. Calculate the expected returns and standard deviations of the following portfolios: i) 80% in A, 20% in B : 12%/27.35% ii) 50% in A, 50% in B : 15% /30.02% iii) 20% in A, 80% in B : 18%/41.33% b. Find...

You are provided below with annual return, standard deviation of returns, and tracking error to the...

You are provided below with annual return, standard deviation of returns, and tracking error to the relevant benchmark for three portfolios. Please calculate the Sharpe Ratio for the three portfolios Portfolio Return Standard Deviation Tracking Error 1 15.50% 19.00% 1.50% 2 13.25% 24.00% 7.00% 3 18.00% 23.00% 8.00% Index 14.00% 20.00% Risk-Free 5.00%

1) Calculate daily returns over the sample period. 2) Compute "mean" and "standard deviation" for the...

1) Calculate daily returns over the sample period. 2) Compute "mean" and "standard deviation" for the daily returns. 3)Calculate the 1-day VaR (99%) on a percentage basis using the calculated mean and standard deviation. Answer in EXCEL . Use data provided below Date Open High Low Close Adj Close Volume 1/2/2020 3244.67 3258.14 3235.53 3257.85 3257.85 3458250000 1/3/2020 3226.36 3246.15 3222.34 3234.85 3234.85 3461290000 1/6/2020 3217.55 3246.84 3214.64 3246.28 3246.28 3674070000 1/7/2020 3241.86 3244.91 3232.43 3237.18 3237.18 3420380000 1/8/2020 3238.59...

Task 1: Compute the respective average, standard deviation, and covariance of monthly or daily stock returns....

Task 1: Compute the respective average, standard deviation, and covariance of monthly or daily stock returns. You can pick any two companies to download stock data for (daily or monthly Covariance table will be in the form: Var(stock1, stock1) Cov(stock1, stock2) Cov(stock1, stock2) Var(stock2, stock2) Note: Use STDEV.P in Excel for the standard deviation Task 2: Using the obtained statistics fromQ1, calculate an equal weighted portfolio return and portfolio variance for the first portfolio using the below equations: Equal weighted...

answer them in typed please. 1. The (annual) expected return and standard deviation of returns for...

answer them in typed please. 1. The (annual) expected return and standard deviation of returns for 2 assets are as follows: Asset A Asset B E[r] 10% 20% SD[r] 30% 50% The correlation between the returns is 0.15. a. Calculate the expected returns and standard deviations of the following portfolios: (i) 80% in A, 20% in B (ii) 50% in A, 50% in B (iii) 20% in A, 80% in B b. Find the weights for a portfolio with an...

The standard deviation of Asset A returns is 36%, while the standard deviation of Asset M...

The standard deviation of Asset A returns is 36%, while the standard deviation of Asset M returns in 24%. The correlation between Asset A and Asset M returns is 0.4. (a) The average of Asset A and Asset M’s standard deviations is (36+24)/2 = 30%. Consider a portfolio, P, with 50% of funds in Asset A and 50% of funds in Asset M. Will the standard deviation of portfolio P’s returns be greater than, equal to, or less than 30%?...

Subjects