Compute the standard deviation and variance of the following monthly returns. Note: Round your Standard Deviation...

Transcribed Image Text:

Compute the standard deviation and variance of the following monthly returns. Note: Round your "Standard Deviation" answer to 2 decimal places and "Variance" answer to 6 decimal places. 2 4 5 6 7 8 9 10 11 12 13 14 15 16 17 19 20 21 22 23 24 A Date: July-10 August-10 September-10 October-10 November-10 December-10 January-11. February-11 25 26 27 26 29 30 31 32 33 March-11 April-111 May-11 June-111 July-11 August-11 September-11 October-11 November-11 December-11 January 12 February 12 March-12 April-12 May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 January 13 February-11 B TSLA -34.328 March-13 -2.678 April-131 4.41% May-13 6.65% June-13 61.41% July-13 -24.98% August-13 -9.868 -1.238 15.80% -.90% 8.84% -3.714 -3.66% March-14 April-141 D E P TSLA TSLA Date 8.438 November-15 10.91% December-15 3.87% January-16 -20.70% 42.13% 80.71% 9.468 February-16 24.71% March-16 25.50% April-16. September-13 14.06% May-16 October-13 -17.65% June-16 -5.279 November-13 -20.78% July-16 10.24% December-131 17.838 August-16. -10.06% January 14 20.238 September-16 -4.12 February 14 34.59% October 16 -3.459 -15.218 November-16 -4.578 -0.638 December 16 12.46% 17.54% -0.129 January 17 15.18% -7.34% 20.429 February-17 -1.13% March-17 April-17 May-17 June-17 July-17 August-17. September-17 -4.528 October 17 -8.82% -0.49% -3.17% -7.538 November-17 -7.201 19.398 December-17 45% 10.59% January 18 13.44% -12.54% -1.77% 20.06% 11.11. C Date May-14 June-14 July-14 August-14 September-14-10.38% -0.76% .81% -13.13% 1.43% 14.57% October-14 11.10% November 14 -11.40% December-14 -9.40% -11.32% January 15 5.71% February 15 -12.738 March-15 April-15 3.65% 2.30% May-15 -4.29% June-15 March-18 6.60% February 18 19.87% July-15 -1.158 21% August-15 -6.78% 10.39% September-15 -0.62% May-18 -7.50% October 15 -17.05% April-18 June-18 G Date July-18 August-18 September-18-12.598 0.02% 19.36% 4.42% -7.64% January 19 October-18 November-18 December-18 -5.40% -8.114 3.83% 8 TSLA -13.43% .82% February-19 March-19 April-19 May-19 June-19 July-19 August-19 September-19 October 19 10.96% November-19 12.498 December-19 8.220 January-20 5.68 -10.919 March-20 9.679 February-20 April-201 May-20 June-20 July-20 August-20 27.04% 3.548 -12.87% -15.07% -22.79% 20.326 7.76% -6.988 6.40% 30.38% 4.41% 26.438 55.164 2.326 -21.924 40.85% 6.438 28.968 32.148 73.799 September-20-14.278 -3.548 October-20 -9.919 -22.70% November-20 45.918 10.07% December-20 23.976 -3.488 20.098 ts 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 March-11 April-11 May-11 June-11 July-11 August-11 September-11 October-11 November-11 December-11 January-12 February-12 March-12 April-12 May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12. January 13 February-13 15.80% November-13 -20.78% 17.83% -.90% December-13 8.848 January 14 20.23% -3.718 February-14 34.59% -3.66% -15.218 -12.54% -0.638 -1.778 May-14 -0.42% 20.06% June-14 15.188 July-14 -7.34% August-14 20.428 Standard Deviation Variance i 11.118 -13.138. March-14 April-14 1.43% 14.578 October-14 November-14 11.10 -11.40% December-14. -9.408 -11.32% January-151 -.829 5.71% February15 -12.738 March-15 -0.49% -7.538 April-15 19.398 3.65% 2.30% May-15 10.59% 6.60% -4.298 June-15 19.87% -1.158 -6.78% .210 10.39% -7.50% October-15 -17.05 September-15 -0.62% 0.987612 Answer is complete but not entirely correct. 16.94% July-15 August-15 March-17 April-17 September-14-10.38% May-17 June-17 July-17 August-17 March-19 April-19 May-19 October-16 -3.458 June-19 November-16. -4.57% July-19 December-16 12.468 January-17 17.548 February-17 -1.138 10.968 12.498 8.22% 5.68% -10.918 -0.768 .818 10.24% -10.06% September-16 -4.12% July-16 August-16 9.678 September-17 -4.52% October-17 -3.178 November-17 -7.20% December-17 January-18 February 18 March-18 April-18 May-18 June-18) -3.48% 20.098 January-20 February-20 August-19 September-19 October-19 November-19 December-19 26.4. 55.16 2.32 March-20 April-201 -12. -15. -22. May-20 June-20 July-20 August-20 20.2 7.7 -6.9 6.4 30.3 4.4 -21.92 48.85 6.43 28.96 32.145 73.791 .45% 13.448 September-20-14.278 -3.548 October-20 -9.918 -22.78% November-20 45.918 10.07% December-20 23.978 O 1 2 23 24 25 26 127 128 Average return 129 Standard deviation 130 Coefficient of variation 131 132 133 134 135 136 137 138 139 140 101 19-Oct 19-Nov 19-Dec 20-Jan 20-Feb 0.3038 0.0441 0.2643 0.5516 0.0232 20-Mar-0.2192 20-Apr 20-May 20-Jun 20-Jul 20-Aug 20-Sep -0.1427 20-Nov 20-Dec 0.4885 0.0643 0.2896 0.3214 0.7379 20-Oct-0.0991 0.4591 0.2397 0.1715 0.16937542 0.99 Compute the standard deviation and variance of the following monthly returns. Note: Round your "Standard Deviation" answer to 2 decimal places and "Variance" answer to 6 decimal places. 2 4 5 6 7 8 9 10 11 12 13 14 15 16 17 19 20 21 22 23 24 A Date: July-10 August-10 September-10 October-10 November-10 December-10 January-11. February-11 25 26 27 26 29 30 31 32 33 March-11 April-111 May-11 June-111 July-11 August-11 September-11 October-11 November-11 December-11 January 12 February 12 March-12 April-12 May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 January 13 February-11 B TSLA -34.328 March-13 -2.678 April-131 4.41% May-13 6.65% June-13 61.41% July-13 -24.98% August-13 -9.868 -1.238 15.80% -.90% 8.84% -3.714 -3.66% March-14 April-141 D E P TSLA TSLA Date 8.438 November-15 10.91% December-15 3.87% January-16 -20.70% 42.13% 80.71% 9.468 February-16 24.71% March-16 25.50% April-16. September-13 14.06% May-16 October-13 -17.65% June-16 -5.279 November-13 -20.78% July-16 10.24% December-131 17.838 August-16. -10.06% January 14 20.238 September-16 -4.12 February 14 34.59% October 16 -3.459 -15.218 November-16 -4.578 -0.638 December 16 12.46% 17.54% -0.129 January 17 15.18% -7.34% 20.429 February-17 -1.13% March-17 April-17 May-17 June-17 July-17 August-17. September-17 -4.528 October 17 -8.82% -0.49% -3.17% -7.538 November-17 -7.201 19.398 December-17 45% 10.59% January 18 13.44% -12.54% -1.77% 20.06% 11.11. C Date May-14 June-14 July-14 August-14 September-14-10.38% -0.76% .81% -13.13% 1.43% 14.57% October-14 11.10% November 14 -11.40% December-14 -9.40% -11.32% January 15 5.71% February 15 -12.738 March-15 April-15 3.65% 2.30% May-15 -4.29% June-15 March-18 6.60% February 18 19.87% July-15 -1.158 21% August-15 -6.78% 10.39% September-15 -0.62% May-18 -7.50% October 15 -17.05% April-18 June-18 G Date July-18 August-18 September-18-12.598 0.02% 19.36% 4.42% -7.64% January 19 October-18 November-18 December-18 -5.40% -8.114 3.83% 8 TSLA -13.43% .82% February-19 March-19 April-19 May-19 June-19 July-19 August-19 September-19 October 19 10.96% November-19 12.498 December-19 8.220 January-20 5.68 -10.919 March-20 9.679 February-20 April-201 May-20 June-20 July-20 August-20 27.04% 3.548 -12.87% -15.07% -22.79% 20.326 7.76% -6.988 6.40% 30.38% 4.41% 26.438 55.164 2.326 -21.924 40.85% 6.438 28.968 32.148 73.799 September-20-14.278 -3.548 October-20 -9.919 -22.70% November-20 45.918 10.07% December-20 23.976 -3.488 20.098 ts 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 March-11 April-11 May-11 June-11 July-11 August-11 September-11 October-11 November-11 December-11 January-12 February-12 March-12 April-12 May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12. January 13 February-13 15.80% November-13 -20.78% 17.83% -.90% December-13 8.848 January 14 20.23% -3.718 February-14 34.59% -3.66% -15.218 -12.54% -0.638 -1.778 May-14 -0.42% 20.06% June-14 15.188 July-14 -7.34% August-14 20.428 Standard Deviation Variance i 11.118 -13.138. March-14 April-14 1.43% 14.578 October-14 November-14 11.10 -11.40% December-14. -9.408 -11.32% January-151 -.829 5.71% February15 -12.738 March-15 -0.49% -7.538 April-15 19.398 3.65% 2.30% May-15 10.59% 6.60% -4.298 June-15 19.87% -1.158 -6.78% .210 10.39% -7.50% October-15 -17.05 September-15 -0.62% 0.987612 Answer is complete but not entirely correct. 16.94% July-15 August-15 March-17 April-17 September-14-10.38% May-17 June-17 July-17 August-17 March-19 April-19 May-19 October-16 -3.458 June-19 November-16. -4.57% July-19 December-16 12.468 January-17 17.548 February-17 -1.138 10.968 12.498 8.22% 5.68% -10.918 -0.768 .818 10.24% -10.06% September-16 -4.12% July-16 August-16 9.678 September-17 -4.52% October-17 -3.178 November-17 -7.20% December-17 January-18 February 18 March-18 April-18 May-18 June-18) -3.48% 20.098 January-20 February-20 August-19 September-19 October-19 November-19 December-19 26.4. 55.16 2.32 March-20 April-201 -12. -15. -22. May-20 June-20 July-20 August-20 20.2 7.7 -6.9 6.4 30.3 4.4 -21.92 48.85 6.43 28.96 32.145 73.791 .45% 13.448 September-20-14.278 -3.548 October-20 -9.918 -22.78% November-20 45.918 10.07% December-20 23.978 O 1 2 23 24 25 26 127 128 Average return 129 Standard deviation 130 Coefficient of variation 131 132 133 134 135 136 137 138 139 140 101 19-Oct 19-Nov 19-Dec 20-Jan 20-Feb 0.3038 0.0441 0.2643 0.5516 0.0232 20-Mar-0.2192 20-Apr 20-May 20-Jun 20-Jul 20-Aug 20-Sep -0.1427 20-Nov 20-Dec 0.4885 0.0643 0.2896 0.3214 0.7379 20-Oct-0.0991 0.4591 0.2397 0.1715 0.16937542 0.99

Answer rating: 100% (QA)

The standard deviation and variance of the Tesla monthly returns data you provided are Standard devi... View the full answer