Question: Use the spreadsheet to calculate the average return and standard deviation for Boeing and Bank of America. According to your calculations, which of these stocks

Use the spreadsheet to calculate the average return and standard deviation for Boeing and Bank of America. According to your calculations, which of these stocks is riskier? Which has the higher return?

Year Boeing Bank of America
1991 9.7 114.2
1992 -11.8 50.5
1993 13.7 9
1994 13.8 7.1
1995 72.7 88
1996 39.4 53.2
1997 -6.6 32.1
1998 -32.5 3.6
1999 28.7 -11.7
2000 61.2 1.6
2001 -40.4 45.6
2002 -13.4 18.9
2003 30.4 24.6
2004 24.9 25.3
2005 37.9 3.4
2006 28.4 20.7
2007 -0.1 -20
2008 -50.1 -63.4
2009 31.8 9.9
2010 23.6 -11.2
2011 15.2 -58.1
2012 5.2 109.6
2013 84.7 34.6
2014 -2.6 15.5
2015 14.1 -4.8
2016 12.2 39.7
2017 94.7 29.9
Average
Standard Deviation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!