Standard deviation and average real return computation
The following table shows the nominal returns on U. S. stocks and the rate of inflation.
a. What was the standard deviation of the market returns?
b. Calculate the average real return.
Year Nominal Return (%) Inflation (%)
2004 12.5 3.3
2005 6.4 3.4
2006 15.8 2.5
2007 5.6 4.1
2008 -37.2 0.1 Solution Preview
Formula for Real Returns= [(1+Nominal Return) /(1+ Inflation)]-1
Formula for Standard Deviation of Real Returns using Excel=’=STDEV(Cell …
This solution provides for the standard deviation and average real return computation of US stocks. A spreadsheet presentation is given for easy calculations.To continue with the answer check on topwriters4me.com/