Question

The Excel file Room Inspection provides data for 100 room inspections at each of 25 hotels in a major chain. Management would like the proportion of nonconforming rooms to be less than 2%. Formulate a one-sample hypothesis test for a proportion and perform the calculations using the correct formulas and Excel functions, and compare your results with the One Sample Hypothesis Test Excel template to verify them.

Sample	Rooms Inspected	Nonconforming Rooms	Fraction Nonconforming
1	100	3	0.03
2	100	1	0.01
3	100	0	0.00
4	100	0	0.00
5	100	2	0.02
6	100	5	0.05
7	100	3	0.03
8	100	6	0.06
9	100	1	0.01
10	100	4	0.04
11	100	0	0.00
12	100	2	0.02
13	100	1	0.01
14	100	3	0.03
15	100	4	0.04
16	100	1	0.01
17	100	1	0.01
18	100	2	0.02
19	100	5	0.05
20	100	2	0.02
21	100	3	0.03
22	100	4	0.04
23	100	1	0.01
24	100	0	0.00
25	100	1	0.01

Answer 1

Ho :   p =    0.02                  
H1 :   p <   0.02       (Left tail test)          
                          
Level of Significance,   α =    0.05
Sample Size,   n =    25                  
                          
Sample Proportion ,    p̂ = 0.0220                  
                          
Standard Error ,    SE = √( p(1-p)/n ) =    0.0280     

           
Z Test Statistic = ( p̂-p)/SE = (   0.0220   -   0.02   ) /   0.0280   =   0.0714
                          
  
p-Value   =   0.5285 [excel function =NORMSDIST(z)]              
Decision:   p value>α ,do not reject null hypothesis

there is not enough evidence to conlcude that proportion of nonconforming rooms is less than 2%

...............

please revert back for doubt

thumbs up if like