# 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)