Online Appendix
Chi-Square Probability Distribution
Table 1 provides the chi-square, or p-value, for the corresponding value of alpha and the number of degrees of freedom.
Table 1 Chi-Square Probability Distribution
Table 2 provides the critical-values for the F-distribution for the corresponding degrees of freedom of the numerator υ1 and denominator υ2 using a value of alpha equal to 0.05.
Table 2 F-Distribution
a = 0.05
Note that this is a very limited version of the F-distribution, but the table can be much larger. If you need a more comprehensive table, you can find larger versions online or in other statistics books.
Chi-Square Tests
CHISQ.DIST(x, Deg_freedom) |
The p-value for a calculated chi-square test statistic, left-tail test |
CHISQ.DIST.RT(x, Deg_freedom) |
The p-value for a calculated chi-square test statistic, right-tail test |
CHISQ.INV(Probability, Deg_freedom) |
The critical value for chi-square distribution, left-tail test |
CHISQ.INV.RT(Probability, Deg_freedom) |
The critical value for chi-square distribution, right-tail test |
CHISQ.TEST(actual_range, expected_range) |
Chi-square test of independence |
Analysis of Variance (ANOVA) (Data Analysis ToolPak)
Anova: Single Factor |
One-way ANOVA |
Anova: Two-Factor Without Replication |
Completely randomized block ANOVA |
Correlation and Regression (Data Analysis ToolPak)
CORREL(array1, array2) |
Correlation coefficient |
Regression (in the data analysis ToolPak) |
Performs linear regression |