Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.
A | B | C | D | E | F | G | H | |
---|---|---|---|---|---|---|---|---|
1 | Date | TSLA | Date | TSLA | Date | TSLA | Date | TSLA |
2 | July-10 | 25.32% | March-13 | 8.61% | November-15 | 11.09% | July-18 | 13.25% |
3 | August-10 | 2.49% | April-13 | 42.31% | December-15 | 4.05% | August-18 | 1.00% |
4 | September-10 | 4.59% | May-13 | 80.89% | January-16 | 20.52% | September-18 | 12.41% |
5 | October-10 | 6.83% | June-13 | 9.64% | February-16 | 0.20% | October-18 | 27.22% |
6 | November-10 | 61.59% | July-13 | 24.89% | March-16 | 19.54% | November-18 | 3.72% |
7 | December-10 | 24.80% | August-13 | 25.68% | April-16 | 4.60% | December-18 | 5.22% |
8 | January-11 | 9.68% | September-13 | 14.24% | May-16 | 7.46% | January-19 | 7.93% |
9 | February-11 | 1.05% | October-13 | 17.47% | June-16 | 5.09% | February-19 | 4.01% |
10 | March-11 | 15.98% | November-13 | 20.60% | July-16 | 10.42% | March-19 | 12.69% |
11 | April-11 | .72% | December-13 | 18.01% | August-16 | 9.88% | April-19 | 14.89% |
12 | May-11 | 9.02% | January14 | 20.41% | September-16 | 3.94% | May-19 | 22.61% |
13 | June-11 | 3.53% | February-14 | 34.77% | October-16 | 3.27% | June-19 | 20.50% |
14 | July-11 | 3.48% | March-14 | 15.03% | November-16 | 4.39% | July-19 | 7.94% |
15 | August-11 | 12.36% | April-14 | 0.45% | December-16 | 12.64% | August-19 | 6.80% |
16 | September-11 | 1.59% | May-14 | 0.24% | January-17 | 17.72% | September-19 | 6.58% |
17 | October-11 | 20.24% | June-14 | 15.36% | February-17 | 0.95% | October-19 | 30.56% |
18 | November-11 | 11.29% | July-14 | 7.16% | March-17 | 11.14% | November-19 | 4.59% |
19 | December-11 | 12.95% | August-14 | 20.60% | April-17 | 12.67% | December-19 | 26.61% |
20 | January-12 | 1.61% | September-14 | 10.20% | May-17 | 8.40% | January-20 | 55.34% |
21 | February-12 | 14.75% | October-14 | 0.58% | June-17 | 5.86% | February-20 | 2.50% |
22 | March-12 | 11.28% | November-14 | .99% | July-17 | 10.73% | March-20 | 21.74% |
23 | April-12 | 11.22% | December-14 | 9.22% | August-17 | 9.85% | April-20 | 49.03% |
24 | May-12 | 11.14% | January-15 | 8.64% | September-17 | 4.34% | May-20 | 6.61% |
25 | June-12 | 5.89% | February15 | 0.31% | October-17 | 2.99% | June-20 | 29.14% |
26 | July-12 | 12.55% | March-15 | 7.35% | November-17 | 7.02% | July-20 | 32.32% |
27 | August-12 | 3.83% | April-15 | 19.57% | December-17 | .63% | August-20 | 73.97% |
28 | September-12 | 2.48% | May-15 | 10.77% | January-18 | 13.62% | September-20 | 14.09% |
29 | October-12 | 4.11% | June-15 | 6.78% | February18 | 3.36% | October-20 | 9.73% |
30 | November-12 | 20.05% | July-15 | 0.97% | March-18 | 22.60% | November-20 | 46.09% |
31 | December-12 | .03% | August-15 | 6.60% | April-18 | 10.25% | December-20 | 24.15% |
32 | January-13 | 10.57% | September-15 | 0.44% | May-18 | 3.30% | ||
33 | February-13 | 7.32% | October-15 | 16.87% | June-18 | 20.27% |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started