Question

In: Statistics and Probability

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? (use the CHISQ.INV() spreadsheet function to find the rejection points for your desired test probability)

Solutions

Expert Solution

Solution:

Here, we have to use Chi square test for the population standard deviation.

The null and alternative hypotheses are given as below:

Null hypothesis: H0: σ = 22

Alternative hypothesis: Ha: σ ≠ 22

We assume level of significance as 5% or α = 0.05.

This is a two tailed test.

The test statistic formula is given as below:

Chi square = (n – 1)*S^2 / σ^2

We are given

n = 10

S = 13.7036

σ = 22

Chi square = (10 – 1)* 13.7036^2 / 22^2

Chi square = 9*13.7036^2 / 22^2

Chi square =3.491938

Test statistic = 3.492

Degrees of freedom = n – 1 = 10 – 1 = 9

α = 0.05

Lower critical value = 2.7004

Upper critical value = 19.0228

[By using excel commands =CHIINV(1- α/2, df) and =CHIINV(α/2, df)]

Test statistic value is lies between above critical values, so we do not reject the null hypothesis.

We cannot reject the hypothesis that the two standard deviations are equal.

There is sufficient evidence that the population standard deviation for the portfolio returns is 22.


Related Solutions

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!
1a. You’ve observed the following returns on Boca Inc’s stock over the past five years: 7...
1a. You’ve observed the following returns on Boca Inc’s stock over the past five years: 7 percent, ?13 percent, 21 percent, 34 percent, and 15 percent. What was the arithmetic average return on Crash-n-Burn’s stock over this five-year period? What was the variance of Crash-n-Burn’s returns over this period? The standard deviation? 1b. A stock has had the following year-end prices and dividends: Year Price Dividend 1 $51.50 - 2 59.32 $0.65 3 64.13 0.70 4 57.86 0.77 5 65.19...
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
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.
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?
You've observed the following returns on Crash-n-Burn Computer's stock over the past five years: 7 percent,...
You've observed the following returns on Crash-n-Burn Computer's stock over the past five years: 7 percent, -15 percent, 19 percent, 37 percent, and 18 percent. Suppose the average inflation rate over this period was 3.81 percent and the average T-bill rate over the period was 4.62 percent. What was the average real risk premium over this time period? (Enter your answer as a percentage, omit the "%" sign in your response, and round your answer to 2 decimal places. For...
. 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:
a. A financial asset generates returns of $10,000 at the end of each year for ten years. The required rate of return if 7% per year. How much must you pay to buy this asset?
Exercice 4: a. A financial asset generates returns of $10,000 at the end of each year for ten years. The required rate of return if 7% per year. How much must you pay to buy this asset? b. A stock pays a constant dividend of $10, starting at the beginning of year 6 (t=6). What is the present value today of the perpetuity if the required rate of return is 20%?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT