In: Finance
I have figured out the risk premium and average risk premium for the question below. I'm having trouble figuring out what the standard deviation of the risk premium is. 2006 18.67 7.50 2007 9.01 7.16 2008 −39.83 2.80 2009 30.90 0.80 2010 20.56 0.92 The average risk premium is 4.03% but can't figure out how to calculate standard deviation of the risk premium.
Yes, an excel function will do.
Thank you.