Calculate the standard deviation for each individual stock. Expected Year Return Return 2015 10% 2016 13% 13.43%

Calculate the standard deviation for each individual stock.

Transcribed Image Text:

Expected Year Return Return 2015 10% 2016 13% 13.43% 2017 15% 13.43% Stock A Deviation Deviation^2 13.43% -3.43% 0.00117551 -0.43% 0.00001873 1.57% 0.0002469 0.00003265 0.00066122 0.00003265 12% 13.43% -1.43% 0.00020408 0.00237143 2018 14% 13.43% 2019 16% 13.43% 2020 14% 13.43% 2021 Standard deviation = 1.84% 2019 2020 2021 Stock B 9% 9% 10% Expected Return Year Return 2015 10% 11.57% 2016 11% 11.57% 2017 8% 11.57% 2018 12% 11.57% 0.43% 2019 10% 11.57% -1.57% 2020 15% 11.57% 3.43% 2021 15% 11.57% 3.43% Standard deviation = 2.44% Expected Year Return Return 2015 12% 2016 14% 2017 10% 2018 11% Stock C 10.71% 10.71% 10.71% 10.71% 10.71% 10.71% 10.71% 0.57% 2.57% 0.57% Standard deviation = 1.67 Deviation -1.57% -0.57% -3.57% Deviation 1.29% 3.29% 0.71% 0.29% -1.71% -1.71% -0.71% Deviation^2 0.00024694 0.00003265 0.00127551 0.00001837 0.00024694 0.00117551 0.00117551 0.00417143 0.00024694 0.00003265 0.00127551 0.00001837 0.00024694 0.00117551 0.00117551 0.00194286 Stock A standard deviation Stock B standard deviation Stock C standard deviation Expected Year Return Return 2015 10% 2016 13% 13.43% 2017 15% 13.43% Stock A Deviation Deviation^2 13.43% -3.43% 0.00117551 -0.43% 0.00001873 1.57% 0.0002469 0.00003265 0.00066122 0.00003265 12% 13.43% -1.43% 0.00020408 0.00237143 2018 14% 13.43% 2019 16% 13.43% 2020 14% 13.43% 2021 Standard deviation = 1.84% 2019 2020 2021 Stock B 9% 9% 10% Expected Return Year Return 2015 10% 11.57% 2016 11% 11.57% 2017 8% 11.57% 2018 12% 11.57% 0.43% 2019 10% 11.57% -1.57% 2020 15% 11.57% 3.43% 2021 15% 11.57% 3.43% Standard deviation = 2.44% Expected Year Return Return 2015 12% 2016 14% 2017 10% 2018 11% Stock C 10.71% 10.71% 10.71% 10.71% 10.71% 10.71% 10.71% 0.57% 2.57% 0.57% Standard deviation = 1.67 Deviation -1.57% -0.57% -3.57% Deviation 1.29% 3.29% 0.71% 0.29% -1.71% -1.71% -0.71% Deviation^2 0.00024694 0.00003265 0.00127551 0.00001837 0.00024694 0.00117551 0.00117551 0.00417143 0.00024694 0.00003265 0.00127551 0.00001837 0.00024694 0.00117551 0.00117551 0.00194286 Stock A standard deviation Stock B standard deviation Stock C standard deviation

Answer rating: 100% (QA)

Based on the data provided the ... View the full answer