Statics ANOVA help 5 questions in excel

profilemtvert3bv
additional.xlsx
Home>Mathematics homework help>Statics ANOVA help 5 questions in excel

2 x 6

Chi-Square Test
Observed Frequencies
Column variable Calculations
Row variable C1 C2 C3 C4 C5 C6 Total fo-fe
R1 0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
R2 0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Total 0 0 0 0 0 0 0
Expected Frequencies
Column variable
Row variable C1 C2 C3 C4 C5 C6 Total (fo-fe)^2/fe
R1 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
R2 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Total ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Data
Level of Significance 0.05
Number of Rows 2
Number of Columns 6
Degrees of Freedom 5
Results
Critical Value 11.0704976935
Chi-Square Test Statistic ERROR:#DIV/0!
p-Value ERROR:#DIV/0!
ERROR:#DIV/0!
Expected frequency assumption
ERROR:#DIV/0!

PHStat User Note: Enter replacement labels for the row and column variables as well as the observed frequency counts in the table that starts in row 3. Note: The #DIV/0! error messages will disappear after you enter the observed frequency counts. (Before continuing, press the Delete key to delete this note.)

4 x 6

Chi-Square Test
Observed Frequencies
Column variable Calculations
Row variable C1 C2 C3 C4 C5 C6 Total fo-fe
R1 0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
R2 0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
R3 0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
R4 0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Total 0 0 0 0 0 0 0
Expected Frequencies
Column variable
Row variable C1 C2 C3 C4 C5 C6 Total (fo-fe)^2/fe
R1 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
R2 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
R3 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
R4 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Total ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Data
Level of Significance 0.05
Number of Rows 4
Number of Columns 6
Degrees of Freedom 15
Results
Critical Value 24.9957901397
Chi-Square Test Statistic ERROR:#DIV/0!
p-Value ERROR:#DIV/0!
ERROR:#DIV/0!
Expected frequency assumption
ERROR:#DIV/0!

PHStat User Note: Enter replacement labels for the row and column variables as well as the observed frequency counts in the table that starts in row 3. Note: The #DIV/0! error messages will disappear after you enter the observed frequency counts. (Before continuing, press the Delete key to delete this note.)

Sheet1

Sheet2

Sheet3