CORRELATION DATA
( X) | ( Y) | X^2 | Y^2 | X*Y |
4 | 4 | 16 | 16 | 16 |
5 | 6 | 25 | 36 | 30 |
3 | 5 | 9 | 25 | 15 |
6 | 7 | 36 | 49 | 42 |
10 | 7 | 100 | 49 | 70 |
calculation procedure for correlation
sum of (x) = 28
sum of (y) = 29
sum of (x^2) = 186
sum of (y^2) = 175
sum of (x*y) = 173
to calculate value of r( x,y) = co-variance ( x,y ) / sd (x) * sd
(y)
co-variance ( x,y ) = [ sum (x*y - N *(sum (x/N) * (sum (y/N)
]/n-1
= 173 - [ 5 * (28/5) * (29/5) ]/5- 1
= 2.12
and now to calculate r( x,y) = 2.12/ (SQRT(1/5*173-(1/5*28)^2) ) *
( SQRT(1/5*173-(1/5*29)^2)
=2.12 / (2.4166*1.1662)
=0.7522
value of correlation is =0.7522
co-efficient of determination = r^2 = 0.5659
----------------------------------------------------------------------------------------
REGRESSION
EQUATION
X | Y | (Xi - Mean)^2 | (Yi - Mean)^2 | (Xi-Mean)*(Yi-Mean) |
4 | 4 | 2.56 | 3.24 | 2.88 |
5 | 6 | 0.36 | 0.04 | -0.12 |
3 | 5 | 6.76 | 0.64 | 2.08 |
6 | 7 | 0.16 | 1.44 | 0.48 |
10 | 7 | 19.36 | 1.44 | 5.28 |
calculation procedure for regression
mean of X = sum ( X / n ) = 5.6
mean of Y = sum ( Y / n ) = 5.8
sum ( (Xi - Mean)^2 ) = 29.2
sum ( (Yi - Mean)^2 ) = 6.8
sum ( (Xi-Mean)*(Yi-Mean) ) = 10.6
b1 = sum ( (Xi-Mean)*(Yi-Mean) ) / sum ( (Xi - Mean)^2 )
= 10.6 / 29.2
= 0.363
bo = sum ( Y / n ) - b1 * sum ( X / n )
bo = 5.8 - 0.363*5.6 = 3.767
value of regression equation is, Y = bo + b1 X
Y'=3.767+0.363* X
----------------------------------------------------------------------------------------
SCATTER DIAGRAM
HYPOTHESIS STEPS
Given that,
value of r =0.7522
number (n)=5
null, Ho: row(ρ) =0
alternate, H1: row(ρ)>0
level of significance, alpha = 0.05
from standard normal table,right tailed t alpha/2 =2.353
since our test is right-tailed
reject Ho, if to > 2.353
we use test statistic (t) = r / sqrt(1-r^2/(n-2))
to=0.7522/(sqrt( ( 1-0.7522^2 )/(5-2) )
to =1.977
|to | =1.977
critical value
the value of |t alpha| at los 0.05% is 2.353
we got |to| =1.977 & | t alpha | =2.353
make decision
hence value of |to | < | t alpha | and here we do not reject
Ho
----------------------------------------------------------------------------------------
null, Ho: row(ρ) <0
alternate, H1: row(ρ)>=0
test statistic: 1.977
critical value: 2.353
decision: do not reject Ho
correlation in the data does n't greater than zero
1. The following sample observations were randomly selected: X: 4 3 6 128 Y: 4 6...
PLEASE ANSWER ALL QUESTIONS ! 1. The following sample observations were randomly selected: X Y 10 4 5 6 6 5 4 7 3 7 What is the coefficient of correlation? Select one: a. 0.90 b. -0.46 c. -0.95 d. 0.82 2. The regression output from Excel indicates that the Significance F is 0.001. Does that mean there is a significant relationship? Select one: a. Yes, because it is small. b. Yes, because it is large. c. No, because it...
Exercise 2: The following sample observations were randomly selected. X Y 5 13 3 15 6 7 3 12 4 13 4 11 6 9 8 5 a. Insert the trendline equation. b. Determine the coefficient of correlation and the coefficient of determination.
The following sample observations were randomly selected: 1 2 3 4 5 X: 17 4 2 7 6 Y: 13 25 6 15 15 a. Determine the regression equation. (Negative answer should be indicated by a minus sign. Do not round intermediate calculations. Round the final answers to 4 decimal places.) b = a = Y' = + X b. Determine the value of Y' when X is 13. (Do not round intermediate calculations. Round the final...
The following sample observations were randomly selected. 4 4 X. 6 3 15 13 11 95 13 15 7 Determine the correlation coefficient and interpret relationship between X and Y. the Name Student ID Date Classwork of chapter21 1. A goatherd has the cost function cly)-Sy' where y is the number of tubs of goat cheese she makes per month. She faces a competitive market for goat cheese, with a price of $100 a tub. How many tubs should she...
The following sample observations were randomly selected. (Round your answers to 2 decimal places.) X: 4 5 3 6 10 Y: 10.8 12.6 8 14.4 19.6 a. The regression equation is Yˆ Y^ = + X b. When X is 7 this gives Yˆ Y^ =
Question 7 3 pts Suppose that you have 50 observations on the variables Y and X. If the sample correlation coefficient is 0.5 (r=0.5), and you want to test the null hypothesis that the true population correlation coefficient (rho) is equal to zero, then the test statistic associated with this null hypothesis is: o 5 04 O2 O 3 Question 8 3 pts Suppose you estimate a multiple regression model using OLS and the coefficient of determination is very high...
Different hotels in a certain area are randomly selected, and their ratings and prices were obtained online. Using technology, with x representing the ratings and y representing price, we find that the regression equation has a slope of 140 and y-intercept of -391. Complete parts (a) and (b) below. a. What is the equation of the regression line? Select the correct choice below and fill in the answer boxes to complete your choice. O A y= X OB x OC....
Given are five observations for two variables, r and y. 3 4 5 1 2 7 6 11 14 4 The estimated regression equation is y = 1.2 + 2.4r Compute the mean square error using the following equation (to 3 decimals). a. SSE s2=MSE n- 2 decimals). b. Compute the standard error of the estimate using the following equation (to SSE VMSE Vn-2 SE c. Compute the estimated standard deviation bi using the following equation (to 3 decimals). Sp...
The following sample observations were randomly selected. (Round intermediate calculations and final answers to 2 decimal places.) 4 6 4 &Click here for the Excel Data File a. The regression equation is y- When X is 5 this gives y =
GAGE MINDTAP 6 Homework Video eBook Given are five observations for two variables, a and y. 5 1 2 3 4 12 14 3 6 The estimated regression equation is ý= 0.8+ 2.6z - using the following equation (to 3 decimals). a. Compute the mean square error SSE = MSE= n-2 b. Compute the standard error of the estimate using the following equation (to 3 decimals). SSE s=VMSE n-2 c. Compute the estimated standard deviation b using the following equation...
> For the calculation of covariance, they divided by 5 instead of by 5-1, so 4. the answer should be 2.65
Morgan L Sat, Nov 20, 2021 10:06 AM