Explore BrainMass
Share

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
https://brainmass.com/business/options/standard-deviation-and-average-real-return-computation-387052

Solution Preview

Answers:

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.

$2.19