Question

Find variance of the following stocks A,B and C: Stock A B C 1 3 19...

Find variance of the following stocks A,B and C:

Stock A B C
1 3 19 -2
2 5 17 4
3 7 15 0
4 9 13 8
5 11 11 12
6 13 9 14
8 15 7 -8
9 17 5 16
10 19 3 20

Homework Answers

Answer #1

Statement showing variance

A B C
Year x (x-X) (x-X)^2 y (y-Y) (y-Y)^2 z (z-Z) (z-Z)^2
1 3 -8 64 19 8 64 -2 -9.11 82.9921
2 5 -6 36 17 6 36 4 -3.11 9.6721
3 7 -4 16 15 4 16 0 -7.11 50.5521
4 9 -2 4 13 2 4 8 0.89 0.7921
5 11 0 0 11 0 0 12 4.89 23.9121
6 13 2 4 9 -2 4 14 6.89 47.4721
8 15 4 16 7 -4 16 -8 -15.11 228.3121
9 17 6 36 5 -6 36 16 8.89 79.0321
10 19 8 64 3 -8 64 20 12.89 166.1521
99 240 99 240 64 688.8889
(/) n 9 9 9 9 9 9
Expected return(X,Y,Z) 11.000 11.000 7.111
Variance 26.667 26.667 76.543
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
I need a breakdown to perform in excel for numbers 7,8,9. I am unsure of how...
I need a breakdown to perform in excel for numbers 7,8,9. I am unsure of how I calculate the times. heres the data set and the questions. Calculate the probability that a flight will depart early or on time. Calculate the probability that a flight will arrive late. Calculate the probability that a flight departs late or arrives early. DEP_Delay ARR_Delay -4 0 -3 -3 0 -5 -7 -1 8 3 -1 -5 3 8 11 6 -6 0 -5...
Dep Delay Arr Delay q1 -13 -9 q3 1 3 IQR 14 12 stdev 9.211846 9.660933...
Dep Delay Arr Delay q1 -13 -9 q3 1 3 IQR 14 12 stdev 9.211846 9.660933 negative 291 zero 39 positive 170 total (should be 500) 500 all data is for arrival data. please help me explain these can someone help me answer these questions and tell me how to put them in excel.thanx in advance 1.    Define a random variable (X) so that your chosen data set represents values of X. 2.    Is your chosen random variable discrete or...
Cork price: 16 10 15 10 17 11 14 13 11 14 11 16 18 16...
Cork price: 16 10 15 10 17 11 14 13 11 14 11 16 18 16 10 17 14 14 16 7 10 12 19 15 16 14 9 12 21 13 10 16 12 16 13 17 17 13 14 18 11 12 15 16 13 18 16 17 12 12 14 9 11 14 19 13 11 17 11 13 15 14 18 18 18 12 10 11 13 14 11 14 18 13 13 19 17 14...
1. The following table shows rates of return for two stocks. A B C 1 Year...
1. The following table shows rates of return for two stocks. A B C 1 Year Stock A Stock B 2 1 14% 13% 3 2 -15% -14% 4 3 -6% -9% 5 4 5% 28% 6 5 14% 8% 7 6 15% 7% a. What is the arithmetic average return for stock B? b. What is the variance for stock B? c. What is the covariance of returns? 2. The following table shows realized rates of return for two...
Cork price: 16 10 15 10 17 11 14 13 11 14 11 16 18 16...
Cork price: 16 10 15 10 17 11 14 13 11 14 11 16 18 16 10 17 14 14 16 7 10 12 19 15 16 14 9 12 21 13 10 16 12 16 13 17 17 13 14 18 11 12 15 16 13 18 16 17 12 12 14 9 11 14 19 13 11 17 11 13 15 14 18 18 18 12 10 11 13 14 11 14 18 13 13 19 17 14...
Bag Blue Orange Green Yellow Red Brown Total Number of Candies 1 7 23 9 11...
Bag Blue Orange Green Yellow Red Brown Total Number of Candies 1 7 23 9 11 4 6 60 2 16 16 4 7 9 4 56 3 14 14 3 10 5 11 57 4 13 14 7 8 8 6 56 5 18 12 7 10 5 7 59 6 12 9 11 9 8 8 57 7 15 16 6 6 6 8 57 8 15 17 8 4 6 7 57 9 12 14 10 5...
Let S = { 1 , 2 , 3 , ... , 18 , 19 ,...
Let S = { 1 , 2 , 3 , ... , 18 , 19 , 20 } S = { 1 , 2 , 3 , ... , 18 , 19 , 20 } be the universal set. Let sets A and B be subsets of S , where: Set A = { 4 , 6 , 10 , 11 , 12 , 15 , 16 , 18 , 19 , 20 } Set B = { 1 ,...
Assuming that the population standard deviation is unknown, calculate the 95% confidence interval of the population...
Assuming that the population standard deviation is unknown, calculate the 95% confidence interval of the population mean. The following is the data. Calculating Process should be shown by Excel (Formulas). What formulas in statistics are used? 7 21 23 24 18 16 2 19 11 6 3 13 17 9 5 12 13 17 4 14 15 25 12 24 22 14 14 20 15 11 26 17 21 11 4 13 16 14 13 14 25 23 9 15...
Indices   DUR   DUR (OLD) 1   6   11 2   13   14 3   11   14 4   7   10...
Indices   DUR   DUR (OLD) 1   6   11 2   13   14 3   11   14 4   7   10 5   9   9 6   7   10 7   8   11 8   5   8 9   7   6 10   7   10 11   7   13 12   3   5 13   10   13 14   3   15 15   4   12 16   9   7 17   9   8 18   10   13 19   6   10 20   8   14 21   10   14 22   8   18 23   2   10 24   4   11 25   7   16 26  ...
The following frequency table summarizes 60 data values. What is the 80th percentile of the data?...
The following frequency table summarizes 60 data values. What is the 80th percentile of the data? The table is read from left to right. 1 1 1 1 2 2 2 2 2 2 2 3 3 3 3 6 6 6 7 7 8 8 9 9 9 9 10 11 11 11 11 11 12 12 12 12 13 13 13 14 14 14 14 15 15 15 16 17 17 17 17 17 18 19 19 20...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT