Compute the standard deviation and variance of the following monthly returns. A B C D E F
Question:
Compute the standard deviation and variance of the following monthly returns.
Transcribed Image Text:
A B C D E F G H 1 Date TSLA 23 2 Jul-10 -16.32% Mar-13 8.79% Nov-15 11.27% Jul-18 -13.07% 3 Aug-10 -2.31% Apr-13 42.49% Dec-15 4 Sep-10 4.77% May-13 81.07% Jan-16 4.23% -20.34% Sep-18 Aug-18 1.18% -12.23% 5 Oct-10 7.01% Jun-13 9.82% Feb-16 0.38% Oct-18 27.40% 6 Nov-10 61.77% Jul-13 25.07% Mar-16 19.72% Nov-18 3.90% 7 Dec-10 -24.62% Aug-13 25.86% Apr-16 4.78% Dec-18 -5.04% 8 Jan-11 -9.50% Sep-13 14.42% May-16 -7.28% Jan-19 -7.75% 9 Feb-11 -0.87% Oct-13 -17.29% Jun-16 -4.91% Feb-19 4.19% 10 Mar-11 16.16% Nov-13 -20.42% Jul-16 10.60% Mar-19 -12.51% 11 Apr-11 -0.54% Dec-13 18.19% Aug-16 -9.70% Apr-19 -14.71% 12 May-11 9.20% Jan-14 20.59% Sep-16 -3.76% May-19 -22.43% 13 Jun-11 -3.35% Feb-14 34.95% Oct-16 -3.09% Jun-19 20.68% 14 Jul-11 -3.30% Mar-14 -14.85% Nov-16 -4.21% Jul-19 8.12% 15 Aug-11 -12.18% Apr-14 -0.27% Dec-16 12.82% Aug-19 -6.62% 16 Sep-11 -1.41% May-14 -0.06% Jan-17 17.90% Sep-19 6.76% 17 Oct-11 20.42% Jun-14 15.54% Feb-17 -0.77% Oct-19 30.74% 18 Nov-11 11.47% Jul-14 -6.98% Mar-17 11.32% Nov-19 4.77% 19 Dec-11 -12.77% Aug-14 20.78% Apr-17 12.85% Dec-19 26.79% 20 Jan-12 1.79% Sep-14 -10.02% May-17 8.58% Jan-20 55.52% 21 Feb-12 14.93% Oct-14 -0.40% Jun-17 6.04% Feb-20 2.68% 22 Mar-12 11.46% Nov-14 1.17% Jul-17 -10.55% Mar-20 -21.56% 23 Apr-12 -11.04% Dec-14 -9.04% Aug-17 10.03% Apr-20 49.21% 24 May-12 -10.96% Jan-15 -8.46% Sep-17 -4.16% May-20 6.79% 25 Jun-12 6.07% Feb-15 -0.13% Oct-17 -2.81% Jun-20 29.32% 26 Jul-12 -12.37% Mar-15 -7.17% Nov-17 -6.84% Jul-20 32.50% 27 Aug-12 4.01% Apr-15 19.75% Dec-17 0.81% Aug-20 74.15% 28 Sep-12 2.66% May-15 10.95% Jan-18 13.80% Sep-20 -13.91% 29 Oct-12 -3.93% Jun-15 6.96% Feb-18 -3.18% Oct-20 -9.55% 30 Nov-12 20.23% Jul-15 -0.79% Mar-18 -22.42% Nov-20 46.27% 31 Dec-12 0.15% Aug-15 -6.42% 32 Jan-13 10.75% Sep-15 33 Feb-13 Apr-18 10.43% Dec-20 24.33% -0.26% May-18 -3.12% -7.14% Oct-15 -16.69% Jun-18 20.45%
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 0% (1 review)
Answered By
Shubhradeep Maity
I am an experienced and talented freelance writer passionate about creating high-quality content. I have over five years of experience working in the field and have collaborated with several renowned companies and clients in the SaaS industry.
At Herman LLC, an online collective of writers, I generated 1,000+ views on my content and created journal content for 100+ clients on finance topics. My efforts led to a 60% increase in customer engagement for finance clients through revamping website pages and email interaction.
Previously, at Gerhold, a data management platform using blockchain, I wrote and published over 50 articles on topics such as Business Finance, Scalability, and Financial Security. I managed four writing projects concurrently and increased the average salary per page from $4 to $7 in three months.
In my previous role at Bernier, I created content for 40+ clients within the finance industry, increasing sales by up to 40%.
I am an accomplished writer with a track record of delivering high-quality content on time and within budget. I am dedicated to helping my clients achieve their goals and providing exceptional results.
5.00+
1+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Business questions
-
Question Data Case for Chapter 11: Optimal Portfolio Choice and the Capital Asset Pricing Model Your manager was so impressed with your work analyzing the return and standard deviations of the 12...
-
Big Boy Company owns 70% of Sly Company. During year X1, Big Boy sold 1,000 units of inventory costing $10.000 to Big Boy for $15,.000, As of 12/31/X1, Big Boys inventory contained 6,000 of the units...
-
assume MAC cosmetic expand to open a mortar-brick store in Vietnam. Mainly manufacture its products in China, How MAC do supply chain and distribution to Vietnam explain with details and explanation
-
Which of the following is indeterminate at x = 1? x + 1 x-1' 2-1 x + 2 x - 1 x+3-2' x + 1 x+3-2
-
The hollow box beam shown in the figure is subjected to a bending moment M of such magnitude that the flanges yield but the webs remain linearly elastic. (a) Calculate the magnitude of the moment M...
-
Air from a line at 12 MPa, 15C, flows into a 500-L rigid tank that initially contained air at ambient conditions, 100 kPa, 15C. The process occurs rapidly and is essentially adiabatic. The valve is...
-
Spreading rate of spilled liquid. Refer to the Chemical Engineering Progress (Jan. 2005) study of the rate at which a spilled volatile liquid will spread across a surface, Exercise LO9 11.35 (p....
-
Given that z is a standard normal random variable, compute the following probabilities. a. P(z 1.0) b. P(z 1) c. P(z 1.5) d. P(2.5 z) e. P( 3 < z 0)
-
What is the reason the authors of our text book feel that the Federal Reserve issuing a digital currency is not a good idea? The Federal Reserve would then control the money supply, interest rates,...
-
Following are the monthly returns for January 2016 to December 2020 of three international stock indices: All Ordinaries of Australia, Nikkei 225 of Japan, and Euronext of Europe. a. Compute and...
-
Consider the year-to-date returns of Yum Brands, Raytheon, and Coca-Cola. If you have a portfolio made up of the weights shown below, what is your portfolio return? A 1 2 Return 3 Weight B D Yum...
-
1. As a management accountant, do you think you would have a role in evaluating use of technologies such as IoT devices? 2. Can you think how costs might be reduced by such technologies? Just-in-Time...
-
Follows is a list of outstanding invoices at 12/31/09. List is by customer. Company: Winter Invoice: 101 Date: Amount: 4/15 300.00 155 7/1 500.00 162 10/14 600.00 197 12/16 250.00 Bradley 126 6/25...
-
Question 3. The acceleration of a robot as it moves along a straight line in the horizontal x-axis is given by -kt a = e (2 cos wt +3 sin wt), k = 0, w % 0, where k and w are positive constants and...
-
(1 pt) To find the length of the curve defined by from the point (0,0) to the point (1,9), you'd have to compute where a b= and f(x)= y=5x+4x / f(x)dx
-
screen. In Exercises 21 through 32, find the instantaneous rates of change of the given functions at the indicated points. 21. f(x) = 2x + 3, c = 2 22.) f(x) = -3x+4, c = 3 23. f(x) = x - 1, c = 1...
-
Solve . f(x)= cos(x) 2+ sin(x)
-
Commuters who have more than one passenger in the car are permitted to drive in a special lane on some highways while all the other motorists have to contend with stop-and-go traffic. Does this have...
-
Show, if u(x, y) and v(x, y) are harmonic functions, that u + v must be a harmonic function but that uv need not be a harmonic function. Is e"e" a harmonic function?
-
Show that the convexity for a zero coupon bond with m payments per year is (m) n(n + -)(1+ m m
-
Abdul Canarte , a Central Bank economist, noticed that the total group purchasing basket of goods (CPI) has gone from $149,740.00 to $344,460.00 in 8 years. With monthly compounding, what is the...
-
ABC Corporation expects sales next year to be $50,000,000. Inventory and accounts receivable (combined) will increase $8,000,000 to accommodate this sales level. The company has a profit margin of 6...
Study smarter with the SolutionInn App