Question

In: Statistics and Probability

Conduct hypothesis test to verify if there is a significant relationship between X and Y using the t test approach

9 16
8 21
6 18
5 14
8 15
6 13
9 20
5 19
7 17

Using the table above answer the following questions: Please show all your work.
1. Conduct hypothesis test to verify if there is a significant relationship between X
and Y using the t test approach
b. Calculate confidence interval for B 1
2. Perform hypothesis test to verify if there is a significant relationship between X
and Y using the F test approach.

Solutions

Expert Solution

??? It is given which one is x or y. However, I am considering the first column as x and the second one as y

The test is performed in MS Excel and the following steps are used-

Regression in excel

I performed the analysis using basic commands in MS Excel and I am giving the steps to be followed-

1. Select the Data tab and choose the Data Analysis in the top right-hand corner

2. In the Data Analysis menu choose Regression and click OK

3. In the ‘Input Range’ box, select all the data in the columns you created, including the variable names

4. Check the ‘Labels in First Row’ box

5. In the ‘Output Range’ box, enter a cell range where Excel will place the output and click OK

6. If the p-value were less than 0.05, you would reject the null hypothesis that says the means of all categories are equal. If the p-value were greater than 0.05, then you would fail to reject the null.

Now the following results are obtained -

1. The above table shows that the p-value is not as significant as it grater than 0.05 (at 5%) using the t-test. There is no significant relationship between X and Y

2. The confidence interval for b1

The blue shaded number represent the confidence interval for b1

3. Using the F-test to asses the significance of the relationship.

Since the p-value (Significance F) is too high so at 5% we do not have enough evidence to conclude that the given linear relationship between x and y is significant.


Related Solutions

Test the hypothesis using the​ P-value approach. Be sure to verify the requirements of the test....
Test the hypothesis using the​ P-value approach. Be sure to verify the requirements of the test. Upper H 0H0​: p equals=0.7 versus Upper H1​: pgreater than>0.7 nequals=200 xequals=145 alpha equals=0.01
Test the hypothesis using the​ P-value approach. Be sure to verify the requirements of the test....
Test the hypothesis using the​ P-value approach. Be sure to verify the requirements of the test. Upper H 0​: p = 0.3 versus Upper H 1​: p > 0.3 n = 200​; x = 80​; a = 0.05
Test the hypothesis using the? P-value approach. Be sure to verify the requirements of the test....
Test the hypothesis using the? P-value approach. Be sure to verify the requirements of the test. Upper H 0?: pequals0.6 versus Upper H 1?: pgreater than0.6 nequals125?; xequals80?, alphaequals0.1 Is np 0 left parenthesis 1 minus p 0 right parenthesisgreater than or equals?10? Yes No Use technology to find the? P-value. ?P-valueequals nothing ?(Round to three decimal places as? needed.) ? Do not reject Reject the null? hypothesis, because the? P-value is ? less greater than alpha.
Test the hypothesis using the P-value approach. Be sure to verify the requirements of the test....
Test the hypothesis using the P-value approach. Be sure to verify the requirements of the test. Ho:p=0.74 versus H1:p(not equal) to 0.74 N= 500, x= 360, a= 0.05 Is npo (1-po)_>10? A. No, because np0(1-p0)=? B. Yes, because np0(1-p0)=?. Now Find P (with carrot on top)=? Find the test statistic z0=? Find the P-value=? State the conclusion of the hypothesis test.
Test the hypothesis using the​ P-value approach. Be sure to verify the requirements of the test....
Test the hypothesis using the​ P-value approach. Be sure to verify the requirements of the test. H0: p=0.47 versus H1: p<0.47 n=150, x= 66, a=0.05 a) Is np0 (1-p0)> 10? b) What is the p-value? c) Should the hypothesis be rejected?
Test the hypothesis using the​ P-value approach. Be sure to verify the requirements of the test....
Test the hypothesis using the​ P-value approach. Be sure to verify the requirements of the test. Upper H 0H0​: pequals=0.60.6 versus Upper H 1H1​: pgreater than>0.60.6 nequals=125125​; xequals=8080​; alphaαequals=0.010.01 Click here to view page 1 of the table. LOADING...    Click here to view page 2 of the table. LOADING... Calculate the test​ statistic, z 0z0. z 0z0equals=nothing
Test the hypothesis using the​ P-value approach. Be sure to verify the requirements of the test....
Test the hypothesis using the​ P-value approach. Be sure to verify the requirements of the test. H0: p=0.91 versus H1: p≠0.9
Test the hypothesis using the​ P-value approach. Be sure to verify the requirements of the test....
Test the hypothesis using the​ P-value approach. Be sure to verify the requirements of the test. H0: p=0.55 versus H1: p<0.55 n=150, x=72, α=0.01 Is np01−p0≥10​? No Yes
Test the hypothesis using the​ P-value approach. Be sure to verify the requirements of the test....
Test the hypothesis using the​ P-value approach. Be sure to verify the requirements of the test. Upper H 0 : p equals 0.58 versus Upper H 1 : p less than 0.58H0: p=0.58 versus H1: p<0.58 n equals 150 comma x equals 81 comma alpha equals 0.01n=150, x=81, α=0.01 Is np 0 left parenthesis 1 minus p 0 right parenthesis greater than or equals 10np01−p0≥10​? No Yes
est the hypothesis using the​ P-value approach. Be sure to verify the requirements of the test....
est the hypothesis using the​ P-value approach. Be sure to verify the requirements of the test. Upper H 0 H0​: p equals = 0.6 versus Upper H 1 H1​: p greater than > 0.6 n equals = 250 ​; x equals = 165 ​, alpha α equals = 0.01 Is np 0 left parenthesis 1 minus p 0 right parenthesis np01−p0 greater than or equals ≥​10? Yes Your answer is correct. No Use technology to find the​ P-value. ​P-value equals...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT