Question

Falloing the spreadsheet calculates the average return and standard deviation for both Boeing and Bank of America.

1991 Bank of America 1142 -118 505 13.7 1992 1993 138 1995 72.7 1996 53.2 321 1997 1998 1999 32.5 28.7 2000 2001 2002 61.2 40.4 13.4 30.4 45.6 18.9 2003 246 2004 25.3 37.9 2005 2006 2007 23.4 20.7 2008 -63.4 2009 2010 2011 2012 -50.1 31.8 23.6 15.2 5.2 84.2 -112 -58.1 34,6 155

Answer 1

Cupuudlu NUM P12 А E в Return 1 Year (Return-ER)^2 Year Return - ER (Return - 17.66%) Return-ER (Return-ER)^2 (Return - 21.03%) 1991 9.70% 1992 -11.80% 1993 13.70% 1994 13.80% 1995 72.70% 1996 39.40% 1997 -6.60% 1998 -32.50% 1999 28.70% 2000 61.20% 2001 -40.40% 2002 -13.40% 2003 30.40% 2004 24.90% 2005 37.90% 2006 28.40% 2007 -0.10% 2008 -50.10% 2009 31.80% 2010 23.60% 2011 15.20% 2012 5.20% 2013 84.70% 2014 -2.60% 2015 14.10% 2016 12.20% 2017 94.70% 484.80% -8.26% -29.76% -4.26% -4.16% 54.74% 21.44% -24.56% -50.46% 10.74% 43.24% -58.36% -31.36% 12.44% 6.94% 19.94% 10.44% -18.06% -68.06% 13.84% 5.64% -2.76% -12.76% 66.74% -20.56% -3.86% -5.76% 76.74% 0.68% 1991 8.86% 1992 0.18% 1993 0.17% 1994 29.96% 1995 4.60% 1996 6.03% 1997 25.46% 1998 1.15% 1999 18.70% 2000 34.06% 2001 9.83% 2002 1.55% 2003 0.48% 2004 3.98% 2005 1.09% 2006 3.26% 2007 46.32% 2008 1.92% 2009 0.32% 2010 0.08% 2011 1.63% 2012 44.54% 2013 4.23% 2014 0.15% 2015 0.33% 2016 58.89% 2017 308.449% Total 114.20% 50.50% 9.00% 7.10% 88.00% 53.20% 32.10% 3.60% - 11.70% 1.60% 45.60% 18.90% 24.60% 25.30% 3.40% 20.70% -20.00% -63.40% 9.90% - 11.20% -58.10% 109.60% 34.60% 15.50% -4.80% 39.70% 29.90% 567.80% 93.17% 29.47% -12.03% -13.93% 66.97% 32.17% 11.07% -17.43% -32.73% - 19.43% 24.57% -2.13% 3.57% 4.27% -17.63% -0.33% -41.03% -84.43% -11.13% -32.23% -79.13% 88.57% 13.57% -5.53% -25.83% 18.67% 8.87% 86.81% 8.68% 1.45% 1.94% 44.85% 10.35% 1.23% 3.04% 10.71% 3.78% 6.04% 0.05% 0.13% 0.18% 3.11% 0.00% 16.83% 71.28% 1.24% 10.39% 62.62% 78.45% 1.84% 0.31% 6.67% 3.49% 0.79% 436.229% Total

P62 А в 34 Boeing 35 36 Expected Return 37 Sum of Returns/n 484.8% / 27 17.96% 39 41 Variance (Return-ER)^2 / (n-1) 308.45% / (27 - 1) 11.86% 45 Now SD = Sqrt(Var) SORT(11.86%) 34.44% 46 47 Bank of America 49 Expected Return = Sum of Returns/n 567.8% / 27 21.03% 54 Variance 55 (Return-ER)^2 / (n-1) 436.23% / (27 - 1) 16.78% 56 57 58 Now SD = 59 sqrt(Var) SQRT(16.78%) 40.96%

If there is any doubt please ask in comments