6.2 Assignment: Pick Additional Data Set

profileTonio12070514
Chi-Square_10by10.xlsx
Home>Mathematics homework help>Statistics homework help>6.2 Assignment: Pick Additional Data Set

COMPUTE

Chi-Square Test
Observed Frequencies
Hotel Calculations
Return? A B c3 c4 c5 c6 c7 c8 c9 c10 Total fo-fe
Yes 110 100 210 5 -5 0 0 0 0 0 0 0 0
No 90 100 190 -5 5 0 0 0 0 0 0 0 0
r3 0 0 0 0 0 0 0 0 0 0 0
r4 0 0 0 0 0 0 0 0 0 0 0
r5 0 0 0 0 0 0 0 0 0 0 0
r6 0 0 0 0 0 0 0 0 0 0 0
r7 0 0 0 0 0 0 0 0 0 0 0
r8 0 0 0 0 0 0 0 0 0 0 0
r9 0 0 0 0 0 0 0 0 0 0 0
r10 0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
Total 200 200 0 0 0 0 0 0 0 0 400
Expected Frequencies
Hotel
Return? A B c3 c4 c5 c6 c7 c8 c9 c10 Total (fo-fe)^2/fe
Yes 105.0000 105.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 210 0.2381 0.2381 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
No 95.0000 95.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 190 0.2632 0.2632 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
r3 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
r4 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
r5 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
r6 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
r7 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
r8 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
r9 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
r10 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
Total 200 200 0 0 0 0 0 0 0 0 400
Data
Level of Significance 0.05
Number of Rows 2
Number of Columns 2
Degrees of Freedom 1
Results
Critical Value 3.8415
Chi-Square Test Statistic 1.0025
p-Value 0.3167
Do not reject the null hypothesis