C8 X V A C D E F G H I J K L M N O P Sample Size 50 Given Sample Variance 0.006 Given W N Hypothesized Variance 0.004 Given Alpha Level 0.05 Given 6 Degrees of Freedom #N/A 7 Test Statistic #N/A Hint: we know the population variance. Which distribution is used with a known population variance? p - value #N/A Hint: what is the tail of our test? 9 10 11 12 13 14 15 16 17 18A8 X V 20 A C D E F G H I J K L M N O P Oberved Values Red Green Blue Yellow Total 25 18 23 14 80 5 Expected Values 6 7 Red Green Blue Yellow Red Green Blue Yellow 8 20 20 20 20 #N/A #N/A #N/A #N/A g 10 11 chi-square statistic: #N/A 12 13 p - value 0.295734 =CHISQ.DIST.RT(3.7,3) 14 15 16 17 18F11 X V =(30-40/F125) A B C D E F G H K L 1 Hotel 1 Hotel 2 Hotel 1 Hotel 2 Formula calculations; do not delete or modify. IN 39 37 Sample Size 30 =COUNTA(A2:A31) =COUNTA(B2,B31) 40 52 Sample Mean 40 29.5 =AVERAGE(A2,A31) |=AVERAGE(B2,B31) 4 35 40 35 37 Population Standard Deviation 5 7 Given 6 35 44 7 38 29 Standard Error 1 =STDEV(A2,A31)/SORT(COUNT(B2,B31)) 46 35 9 32 39 Confidence Coefficient 0.95 Given 10 23 10 Level of Significance (Alpha) #NAME? =dat 11 43 49 #DIV/O! =(30-40/F125) 12 29 50 Margin of Error #N/A 13 32 35 14 41 22 Point Estimate of the Difference #N/A 15 44 17 Upper limit #N/A 16 48 32 Lower limit #N/A 17 41 41 18 56 36 19 44 34 20 25 40 27 25 Hotels Q3 - Q6 Perfume Q9 - Q12 Sweaters Q15 - Q19 + 1\f