IWU Observed Frequencies Excel Spreadsheet
Chi-Square TestIs success independent of the type of treatment?
Observed Frequencies
Total
Total
0
0
Expected Frequencies
0
0
0
#DIV/0!
0
#DIV/0!
Total
#DIV/0!
Data
Level of Significance
Number of Rows
Number of Columns
Degrees of Freedom
0
0
1
Results
Critical Value
#NUM!
Chi-Square Test Statistic
0.0000
p -Value
1.0000
Do not reject the null hypothesis
0
0
#DIV/0!
#DIV/0!
#DIV/0!
0
0
0
Total
#DIV/0!
#DIV/0!
#DIV/0!
Data for you to use as input is in the picture to the right:
Entering values correctly into table: (10 points)
Access this helpful video: Video
DO NOT touch the non-blue areas of the tables.
Entering correct alpha value (2 points)
0.01
Insert final judgment and interpretation here:
( 8 points)
Chi-Square Test
Is exam score independent of race?
Observed Frequencies
Total
Total
0
0
Expected Frequencies
0
0
0
#DIV/0!
0
#DIV/0!
Total
#DIV/0!
Data
Level of Significance
Number of Rows
Number of Columns
Degrees of Freedom
0
0
1
Results
Critical Value
#NUM!
Chi-Square Test Statistic
0.0000
p -Value
1.0000
Do not reject the null hypothesis
0
0
#DIV/0!
#DIV/0!
#DIV/0!
0
0
0
Total
#DIV/0!
#DIV/0!
#DIV/0!
Data for you to use as input is in the picture to the right:
Entering values correctly into table: (10 points)
Access this helpful video: Video
DO NOT touch the non-blue areas of the tables.
Entering correct alpha value (2 points)
0.01
Insert final judgment and interpretation here:
( 8 points)
Chi-Square Test
Is the nurse a serial killer?
Observed Frequencies
Total
Total
0
0
0
0
0
Expected Frequencies
0
0
0
0
Total
0
#DIV/0!
#DIV/0!
#DIV/0!
0
#DIV/0!
#DIV/0!
#DIV/0!
Data
Level of Significance
Number of Rows
Number of Columns
Degrees of Freedom
0
0
1
Results
Critical Value
#NUM!
Chi-Square Test Statistic
0.0000
p -Value
1.0000
Do not reject the null hypothesis
Total
#DIV/0!
#DIV/0!
#DIV/0!
Data for you to use as input is in the picture to the right:
Entering values correctly into table: (10 points)
Access this helpful video: Video
DO NOT touch the non-blue areas of the tables.
Entering correct alpha value (2 points)
0.01
Insert final judgment and interpretation here:
( 8 points)