Question

Assume these were the inflation rates and stock market and Treasury bill returns between 1929 and 1933:

Year	Inflation	Stock Market Return	T-Bill Return
1929	.2	–11.9	5.0
1930	–5.8	–29.2	3.2
1931	–9.2	–42.3	1.6
1932	–13.3	–6.7	.7
1933	.8	59.1	.5

a. What was the real return on the stock market in each year? (Negative answers should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.)

Year	Real Return
1929	%
1930	%
1931	%
1932	%
1933	%

b. What was the arithmetic average real return? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)

            

Average real return             %

c. What was the risk premium in each year? (Negative answers should be indicated by a minus sign. Enter your answers as a percent rounded to 2 decimal places.)   

Year	Risk Premium
1929	%
1930	%
1931	%
1932	%
1933	%

d. What was the average risk premium? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)   

Average risk premium             %    

       

e. What was the standard deviation of the risk premium? (Do not make the adjustment for degrees of freedom described in footnote 18.) (Use decimals, not percents, in your calculations. Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)   

Standard deviation            

Answer 1

I HAVE CALCULATED STANDARD DEVIATION WITH MANUAL CALCULATIONS ANS ALSO WITH EXCEL. THANK YOU