Topic 3: Hypothesis testing Excel Worksheet

Directions:  Answer all questions and submit to instructor at the end of Module 2

To answer a question, please click on “Choose an item” and on the drop-down arrow and choose an answer. Here is a resulting drop-down list:

If it is not working, you can enter your answers to the table at the end of the file.

1.      There is a new drug that is used to treat leukemia. The following data represents the remission time in weeks for a random sample of 21 patients using the drug.

10	7	32	23	22	6	16
11	20	19	6	17	35	6
10	34	32	25	13	9	6

 

Let X be a random variable representing the remission time in weeks for all patients using the new drug. Assume that the distribution of x is normal. A previously used drug treatment has a mean remission time of 12.5 weeks. Does the data indicate that the mean remission time using the new drug is different from 12.5 week at a level of significance of 0.01?

 

State the null hypothesis:

A.    µ=12.5

B.     µ≠12.5

C.     µ<12.5

D.    µ>12.5

 

Answer:  Choose an item.

State the alternative hypothesis:

A.    µ=12.5

B.     µ≠12.5

C.     µ<12.5

D.    µ>12.5

 

Answer:  Choose an item.

State the level of significance:

A.    0.001

B.     0.01

C.     0.05

D.    0.10

 

Answer:  Choose an item.

State the test statistic:

A.    0.058

B.     0.552

C.     1.058

D.    2.106

Answer:  Choose an item.

Perform calculations

Then answer the following two questions:

Critical value:

A.      0.050

B.      1.960

C.      2.086

D.     2.845

Answer:  Choose an item.

P-value:

A.      p <0.001

B.      0.001 ≤ p <0.01

C.      0.01 ≤ p <0.05

D.     0.05≤ p

Answer:  Choose an item.

Statistical Conclusion

A.    Reject the null hypothesis

B.     Do not reject the null hypothesis

Answer:  Choose an item.

 

Experimental Conclusion

A.    There is sufficient evidence to conclude that the mean remission time using the new drug is different from 12.5 week at a level of significance of 0.01.

B.     There is no sufficient evidence to conclude that the mean remission time using the new drug is different from 12.5 week at a level of significance of 0.01.

Answer:  Choose an item.

 

2.      We wish to test the claim that the mean body mass index (BMI) of men is equal to the mean BMI of women.  Use the data below to test this claim.

 

Men	Women
20	29
37	28
46	20
23	28
20	42
23	45
21	19
15	45
20	16
28	32
27	38
20	45
30	41
22	34
27	28
38	21
29	42
20	21
16	30
27	28
42	30
37	43
39	40
39	16
32	44
16	15
21	16
26	20
17	41
39	16

 

 

State the Null Hypothesis

A.    μ₁ = μ₂

B.     μ₁ ≠μ₂

C.     μ₁ >μ₂

D.    μ₁ <μ₂

Where μ₁ andμ₂ are the mean body mass index for men and women, respectively.

 

Answer:  Choose an item.

 

State the alternative hypothesis:

A.    μ₁ = μ₂

B.     μ₁ ≠μ₂

C.     μ₁ >μ₂

D.    μ₁ <μ₂

Answer:  Choose an item.

State the Level of significance

State the level of significance:

A.    0.001

B.     0.01

C.     0.05

D.    0.10

 

Answer:  Choose an item.

State the test statistic (its absolute value, for example the absolute value of -1.5 is 1.5):

A.    0.058

B.     0.515

C.     1.273

D.    2.108

Answer:  Choose an item.

Perform calculations

Then answer the following two questions:

Critical value:

A.      0.050

B.      1.960

C.      2.002

D.     2.045

Answer:  Choose an item.

P-value:

A.                    p <0.001

B.      0.001 ≤ p <0.01

C.      0.01   ≤ p <0.05

D.     0.05   ≤ p

Answer:  Choose an item.

Statistical Conclusion

A.    Reject the null hypothesis

B.     Do not reject the null hypothesis

Answer:  Choose an item.

 

Experimental Conclusion

A.    There is sufficient evidence to conclude that the mean body mass index (BMI) of mean is equal to the mean BMI of women.

B.     There is no sufficient evidence to conclude that that the mean body mass index (BMI) of mean is equal to the mean BMI of women.

Answer:  Choose an item.

Grading

Please do not make any changes for the following grading table unless you have a problem with the drop-down lists (then you can enter your answers in the second column).  If you use the drop-down lists, the instructor will update your answers in the table. Thanks

 

Question	Your answer	Correct answer	Possible points	Your points
1  H0			5
H1			5
Sig. level			3
Test statistic*			12
Critical value			5
P-value			4
Stat conclusion			5
Experimental conclusion			5
2  H0			5
H1			5
Sig. level			5
Test statistic*			12
Critical value			5
P-value			4
Stat conclusion			5
Experimental conclusion			5
Total			90

*including grade for calculations

 

 

 

Attachments:

• 1507212522-week 3 excel assignment ans.docx