Excel Tips & Tutorials:
Chi-Square and Analysis of Variance
Suggest a LinkAlphabetize PagePrinter-Friendly List
More Excel Tips & Tutorials: ☑ Getting Started | Using Excel for Data Analysis | Descriptive Statistics | Creating & Transforming Variables | Making Comparisons | Graphing Relationships & Describing Patterns | Random Assignment & Sampling | Making Controlled Comparisons | Foundations of Inference | Hypothesis Tests with One & Two Samples | Correlation & Bivariate Regression | Multiple Regression | Analyzing Residuals | Logistic Regression | Doing Your Own Analysis | ∞ Advanced Political Analysis
More Excel Tips & Tutorials:
Watch and Learn
Watch and Learn
Watch and Learn
Watch and Learn
How to Conduct a Chi-Square Test
thumbnail preview
From Todd Grande (8:03).data
dataExcel Tutorials | Ch. 10link info
How to Calculate P-Value for an F-Statistic
thumbnail preview
Uses Excel F.DIST function (2:26)data
dataExcel Tutorials | Ch. 10link info
One-Way ANOVA with the Data Analysis ToolPak
thumbnail preview
Nice illustration of underlying data, from Jeffrey Knutsen (4:19)data
dataExcel Tutorials | Ch. 10link info
How to Use CHISQ.TEST and CHISQ.INV.RT Functions
thumbnail preview
Illustrates with a goodness of fit test (4:12)data
dataExcel Tutorials | Ch. 10link info
How to Conduct a Chi-Square Test
thumbnail preview
From Todd Grande (8:03).data
dataExcel Tutorials | Ch. 10link info
How to Calculate P-Value for an F-Statistic
thumbnail preview
Uses Excel F.DIST function (2:26)data
dataExcel Tutorials | Ch. 10link info
Additional References
Additional References
Calculating Lambda Using Excel
Based on given cross-tabulation (8:48)data
dataExcel Tutorials | Ch. 10link info
Multiple Applications of ANOVA
Real Statistics Using Excel provides detailed instructions for implementing different types of ANOVA with Excel.data
dataExcel Tutorials | Ch. 10link info
Chi-Square and F Distributions
Excellent references for Chi-Square Test and ANOVA featuring Excel.data
dataExcel Tutorials | Ch. 10link info
Calculating Lambda Using Excel
Based on given cross-tabulation (8:48)data
dataExcel Tutorials | Ch. 10link info
Multiple Applications of ANOVA
Real Statistics Using Excel provides detailed instructions for implementing different types of ANOVA with Excel.data
dataExcel Tutorials | Ch. 10link info


Latin Am. Politics
Voting & Elections
Asian Politics
American Politics
Migration & Citizenship
African Politics
Teaching & Learning
European Politics
Political Behavior
Law, Courts & Justice
International Relations
Comparative Politics
Latin Am. Politics
Voting & Elections
Asian Politics
American Politics
Political Behavior
Law, Courts & Justice
International Relations
Comparative Politics