Explore BrainMass

Standard deviation and average real return computation

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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

© BrainMass Inc. brainmass.com March 21, 2019, 9:41 pm ad1c9bdddf

Solution Preview


Formula for Real Returns= [(1+Nominal Return) /(1+ Inflation)]-1

Formula for Standard Deviation of Real Returns using Excel='=STDEV(Cell ...

Solution Summary

This solution provides for the standard deviation and average real return computation of US stocks. A spreadsheet presentation is given for easy calculations.