Question

In: Finance

A portfolio generates the following returns over the past 10 years: Year Return (%) 1 14...

A portfolio generates the following returns over the past 10 years:

Year Return (%)
1 14
2 2
3 -15
4 20
5 18
6 16
7 -17
8 24
9 -10
10 -4

Calculate the test statistic to test whether the standard deviation of this portfolio's return is different from the benchmark portfolio standard deviation of 23.

The answer should be 4.075. Please use Excel and show formulas that are used. Thank you!

Solutions

Expert Solution

A B C D E F G H I J
2
3 To test the claim about standard deviation and variance, the chi-square test statistic is used.
4
5 The hypothesis will be
6 Null Hypothesis: Standard Deviation is σ0 i.e. σ = σ0
7 Alternate Hypothesis: Standard Deviation is σ0 i.e. σ ≠ σ0
8
9 The test statistic is
10 χ2= [(n-1)s2]/σ02
11
12 Where n is the sample size, s is sample standard deviation and σ0 is the target standard deviation.
13
14 Given the following data:
15
16 Year Return (%)
17 1 14
18 2 2
19 3 -15
20 4 20
21 5 18
22 6 16
23 7 -17
24 8 24
25 9 -10
26 10 -4
27
28 Sample Standard Deviation (s) 15.4761465 =STDEV.S(D17:D26)
29 n 10
30 σ0 23
31
32 The test statistic is
33 χ2= [(n-1)s2]/σ02
34 or
35 χ2= 4.075 =(D29-1)*((D28/D30)^2)
36
37 Hence test statistic is 4.075
38

Related Solutions

A portfolio generates the following returns over the past 10 years: Year Return (%) 1 -7...
A portfolio generates the following returns over the past 10 years: Year Return (%) 1 -7 2 -15 3 20 4 21 5 9 6 -6 7 15 8 23 9 2 10 -5 Calculate the test statistic to test whether the standard deviation of this portfolio's return is different from the benchmark portfolio standard deviation of 22. Enter answer accurate to 3 decimal places. Bonus thinking question: can you reject the hypothesis that the two standard deviations are equal?...
You are analyzing the returns of a mutual fund portfolio for the past 5 years. Year...
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% Question 7: Use Excel to compute the VaR at the 1% level (you can write the Excel formula as your work).
You are analyzing the returns of a mutual fund portfolio for the past 5 years. Year...
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% Question 6: What is the standard deviation of the returns?   29.28% Question 7:  Use Excel to compute the VaR at the 1% level (you can write the Excel formula as your work). Answer Question 7 plz
Over the past five years, a stock produced returns of 14%, 22%, -16%, 4%, and 11%....
Over the past five years, a stock produced returns of 14%, 22%, -16%, 4%, and 11%. If the returns are normally distributed, what is the probability that an investor in this stock will NOT lose more than 7.4% nor earn more than 21.4% in any one given year? (Hint: Find average return and standard deviation first.)
Your investment portfolio has the following annual returns over the last three years. Year 1: -13%...
Your investment portfolio has the following annual returns over the last three years. Year 1: -13% Year 2: 6% Year 3: 19% The arithmetic average of these returns is:  % The time-weighted annualized return (i.e. geometric average) of these returns is:  % Please enter your answer with TWO decimal points.
Over the past four years, a stock produced returns of 14 percent, 22 percent, 6 percent,...
Over the past four years, a stock produced returns of 14 percent, 22 percent, 6 percent, and -19 percent. What is the approximate probability that an investor in this stock will not lose more than 30 percent nor earn more than 41 percent in any one given year? How would you calculate this in excel?
The S&P 500 and Nohr Corp had the following returns over the past five years Year   ...
The S&P 500 and Nohr Corp had the following returns over the past five years Year        S&P 500               Nohr .12                     .23 .01                     -.05 .18                     .20 .09                     .12 .10                     .20 a. What was the mean AND standard deviation of returns (population version) for Nohr for the 5 years? b. What was the beta of Nohr relative to the S&P 500?                   c. What was the geometric mean return for Nohr for the 5 years?
. Over the past five years, a stock produced returns of 10 percent, 18 percent, 2...
. Over the past five years, a stock produced returns of 10 percent, 18 percent, 2 percent, -9 percent, and 4 percent. a) What is the geometric return? b) What is the arithmetic return? c) What is the variance of the above returns? d) What is the sample standard deviation?
Consider the following returns for two investments, A and B, over the past four years: Investment...
Consider the following returns for two investments, A and B, over the past four years: Investment 1: 9% 10% -7% 15% Investment 2: 7% 9% -16% 14% b-1. Calculate the standard deviation for each investment. (Round your answers to 2 decimal places.) Investment 1: Investment 2: c-1. Given a risk-free rate of 1.2%, calculate the Sharpe ratio for each investment. (Round your answers to 2 decimal places.) Investment 1: Investment 2:
Find the geometric average return for the following 4 years of returns: +18%, +12, (14), +...
Find the geometric average return for the following 4 years of returns: +18%, +12, (14), + 3 1A. If taxable income is $ 158,000.00 calculate the AVERAGE tax using the following: 0-50K = 20 % >50-100K = 25 % >100- 135K = 30 % >135k = 40 %
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT