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
Get step-by-step solutions from verified subject matter experts
