Question

In: Statistics and Probability

Using the table below, calculate the variance of X, variance of Y, standard deviation of X,...

  1. Using the table below, calculate the variance of X, variance of Y, standard deviation of X, standard deviation of Y,   the covariance between X and Y, the correlation coefficient between X and Y, and find the regression line assuming X is the independent variable (find the slope and the intercept). Show your work

Fill in the Blanks:

X

Y

X-Xbar

Y-Ybar

(X-Xbar)^2

(Y-Ybar)^2

(X-Xbar)*(Y-Ybar)

5

3

9

6

12

15

17

20

21

23

Sum

Calculate the following and show your work.

Xbar:

Ybar:

Variance of X:

Variance of Y:

Standard Deviation of X:

Standard Deviation of Y:   

Covariance between X and Y:

Correlation Coefficient between X and Y:

The Slope of the Regression Line:

The Y Intercept of the Regression Line:   

Regression Line:  

Solutions

Expert Solution

Here in this Question we need to compute the given Statistic based on given sample.

We need to compute the covariance, which is computed by first computing cross products of the sample data.

The independent variable is X, and the dependent variable is Y. In order to compute the regression coefficients, the following table needs to be used:

X Y X*Y X2 Y2
5 3 15 25 9
9 6 54 81 36
12 15 180 144 225
17 20 340 289 400
21 23 483 441 529
Sum = 64 67 1072 980 1199

Based on the above table, the following is calculated:

1) The sample mean Xbar = 12.8.

2) The sample mean Ybar = 13.4.

3) The Slope of the Regression Line: 1.3333

The Y Intercept of the Regression Line: -3.6667

Regression Line: Yhat = -3.6667 + 1.3333 X.

4) The covariance bet x and y is calculated as below,

The covariance bet x and y is 53.6.

5) The correlation coefficient bt x and y is calculated as below,

The correlation coefficient is 0.974. which is strong positive correlation.

6)the sample Standerd deviation and variance is computed as below,

7) The Variance of x is 40.2.

8) The sample Standerd deviation of X is 6.34.

9) The Variance of Y is 75.3

10) the sample standerd deviation is 8.68.

All above Calculation is done using Statistical software.

Hope it helps.

Thank you.


Related Solutions

Using the following returns, calculate the expected returns, the variance, standard deviations and coefficient of variation for X and Y.
Using the following returns, calculate the expected returns, the variance, standard deviations and coefficient of variation for X and Y.ProbRxRy0.3512.29.650.30-20.356.512.5Show All in Excel.
Given the data set below, calculate the range, mean, variance, and standard deviation
Given the data set below, calculate the range, mean, variance, and standard deviation. 19,  33,  8,  29,  18,  5, 10, 14,  25 Range = Mean = Variance = Standard deviation =
a) Calculate the mean, variance, and standard deviation for each of the binomial distributions below. i)...
a) Calculate the mean, variance, and standard deviation for each of the binomial distributions below. i) ?~?(1000,0.05) ii) ?~?(800,0.25) b) Team Victory’s winning rate is 20% whenever it plays a match. If the team Victory played 10 matches, what is the probability: i) It will win exactly one match. ii) It will win at most two matches. c) On average, Ali scores a goal per match. What is the probability that Ali will score: i) No goals in the next...
Given the data set below, calculate the standard deviation standard deviation using the defining formula standard...
Given the data set below, calculate the standard deviation standard deviation using the defining formula standard deviation using the computing formula 8,41,24,19,15,12,47,12,33
This data is from a sample. Calculate the mean, standard deviation, and variance. x 38.3 35.2...
This data is from a sample. Calculate the mean, standard deviation, and variance. x 38.3 35.2 26.7 49.9 44.6 14.2 16.4 34 14.4 Please show the following answers to 2 decimal places. Sample Mean = Sample Standard Deviation = Sample Variance = Ooops - now you discover that the data was actually from a population! So now you must give the population standard deviation. Population Standard Deviation =
Using the below returns, what is the average return, the variance, and the standard deviation 1.38%...
Using the below returns, what is the average return, the variance, and the standard deviation 1.38% 11.77% :21.61% -4.23% 31.22%
(TCO 2) Given the data below, calculate the expected return, variance, and standard deviation of the...
(TCO 2) Given the data below, calculate the expected return, variance, and standard deviation of the following company. In a recessionary economy, which is expected to occur with a 30% probability, the expected returns would be -5%. In an expanding economy with an expected probability of occurrence of 20%, the expected return would be 10%. In a normal economy, expected to occur 50% of the time, the expected return would be 5%.
x 3.5 1.4 27.3 9.2 11.6 14.1 Calculate the standard deviation and variance of the sample...
x 3.5 1.4 27.3 9.2 11.6 14.1 Calculate the standard deviation and variance of the sample data shown, to two decimal places x 3.5 1.4 27.3 9.2 11.6 14.1 Standard deviation: Variance:
Using Minitab, calculate the mean, standard deviation, variance, and median of the following four data sets....
Using Minitab, calculate the mean, standard deviation, variance, and median of the following four data sets. Comment on the results. A B C D 100 50 50 75 100 75 100 75 100 100 100 75 100 125 100 100 100 150 150 175
1. Using the data below, calculate the standard deviation.             ri          Pi          &nbs
1. Using the data below, calculate the standard deviation.             ri          Pi                      1%       .25             4%       .45             7%       .30 1.98% 2.22% 3.27% 2.01% none of these 2. The standard deviation of stock i’s return is 4.3%, the standard deviation of the market return is 3.9% and the correlation of the market return and stock i’s return is .35; calculate the Beta. 1.3214 1.1148 .3859 .6947 none of these 3. A stock's beta equals 1.2, the risk-free rate of return is 1.5% and the market risk premium...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT