MENU ☰
Home Page
Find Data by Subfield ►
African Politics
American Politics
Asian Politics
Comparative Politics
European Politics
International Relations
Latin American Politics
Law Courts & Justice
Methodology
Migration & Citizenship
Political Behavior
Teaching & Learning
Voting & Elections
Find Data by Source ►
Topical Collections
By Author
Journal Archives
Teach Data Analysis ►
Teaching Resources
Teaching Assistant
Live R Demos
Sample Syllabi
Lecture Videos
Excel Tutorials ►
☑ Getting Started with Excel
1: Excel for Data Analysis
2: Descriptive Statistics
3: Transforming Variables
4: Making Comparisons
5: Graphing Relationships
6: Random Assignment & Sampling
7: Controlled Comparisons
8: Foundations of Inference
9: Hypothesis Tests with One or Two Samples
10: Chi-Square & ANOVA
11: Correlation & Bivariate Regression
12: Multiple Regression
13: Regression Residuals
14: Logistic Regression
15: Doing Your Own Analysis
∞ Advanced Topics
R Demos & Resources ►
☑ Getting Started with R
1: Using R for Data Analysis
2: Descriptive Statistics
3: Transforming Variables
4: Making Comparisons
5: Graphing Relationships
6: Random Assignment & Sampling
7: Controlled Comparisons
8: Foundations of Inference
9: Hypothesis Tests with One or Two Samples
10: Chi-Square & ANOVA
11: Correlation & Bivariate Regression
12: Multiple Regression
13: Regression Residuals
14: Logistic Regression
15: Doing Your Own Analysis
∞ Advanced Topics
Stata Tutorials ►
☑ Getting Started
Using Stata 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
Chi-Square & ANOVA
Correlation & Bivariate Regression
Multiple Regression
Analyzing Residuals
Logistic Regression
Doing Your Own Analysis
∞ Advanced Political Analysis
Analyze Data ►
Grade Level of Text
Surname Census Info
Calculate Federal Judge Ideal Points
Crosstabs with Circuit Court Data
Election Simulation
Share Findings ►
Blogs
Peer-Reviewed Journals
Podcasts
Join Facebook Group
Legal Research
It's Better with Music
About ►
This Web Site
Barry C. Edwards
Chi-Square and Analysis of Variance
Suggest a Link
Printer-Friendly List
Political Analysis Books
Textbooks
The Essentials of Political Analysis, 6th Edition
With Companions for
SPSS
,
Stata
,
Excel
, and
R
Watch & Learn
NORM.DIST and Related Functions
Todd Grande explains how to use these functions in Excel (9:52)
Comparative Politics
Voting & Elections
European Politics
Latin Am. Politics
American Politics
Teaching & Learning
Teaching Assistant
African Politics
Asian Politics
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:
Select Page ...
Getting Started with Excel
Data Analysis with Excel
Descriptive Statistics
Creating and Transforming Variables
Making Comparisons
Graphing Relationships and Describing Patterns
Random Assignment and Sampling
Making Controlled Comparisons
Foundations of Statistical Inference
Hypothesis Tests with One and Two Samples
Chi-Square and Analysis of Variance
Correlation and Bivariate Regression
Multiple Regression
Analyzing Regression Residuals
Logistic Regression
Doing Your Own Political Analysis
Advanced Political Analysis with Excel
Watch and Learn
Watch and Learn
Excel Tutorials
|
Ch. 10
Two-Way ANOVA with Replication using Data Analysis Tools
From Todd Grande (12:42)
Excel Tutorials
|
Ch. 10
How to Conduct a Chi-Square Test
From Todd Grande (8:03).
Excel Tutorials
|
Ch. 10
How to Use CHISQ.TEST and CHISQ.INV.RT Functions
Illustrates with a goodness of fit test (4:12)
Excel Tutorials
|
Ch. 10
How to Calculate P-Value for an F-Statistic
Uses Excel F.DIST function (2:26)
Excel Tutorials
|
Ch. 10
How to Conduct Analysis of Variance (ANOVA) and Graph Results
From Amy Dykstra (9:01)
Excel Tutorials
|
Ch. 10
One-Way ANOVA (Single Factor) with Data Analysis Tools
From Todd Grande (12:02)
Excel Tutorials
|
Ch. 10
Working with Chi Distribution Functions
From Mauricio Arango (4:12)
Excel Tutorials
|
Ch. 10
Using Functions for F-Distribution and F-Test
Shows how to calculate p-values for F-statistics (4:12)
Excel Tutorials
|
Ch. 10
One-Way ANOVA with the Data Analysis ToolPak
Nice illustration of underlying data, from Jeffrey Knutsen (4:19)
Excel Tutorials
|
Ch. 10
How to Perform a Two-Way ANOVA without Replication
From Stephanie Glen (3:08)
Excel Tutorials
|
Ch. 10
How to Perform a Chi-Square Test for Independence
Includes making table of expected values, from Eugene O'Loughlin (8:42).
Excel Tutorials
|
Ch. 10
Two-Way ANOVA with Replication using Data Analysis Tools
From Todd Grande (12:42)
Excel Tutorials
|
Ch. 10
How to Conduct a Chi-Square Test
From Todd Grande (8:03).
Excel Tutorials
|
Ch. 10
How to Use CHISQ.TEST and CHISQ.INV.RT Functions
Illustrates with a goodness of fit test (4:12)
Excel Tutorials
|
Ch. 10
How to Calculate P-Value for an F-Statistic
Uses Excel F.DIST function (2:26)
Excel Tutorials
|
Ch. 10
How to Conduct Analysis of Variance (ANOVA) and Graph Results
From Amy Dykstra (9:01)
Excel Tutorials
|
Ch. 10
One-Way ANOVA (Single Factor) with Data Analysis Tools
From Todd Grande (12:02)
Excel Tutorials
|
Ch. 10
Working with Chi Distribution Functions
From Mauricio Arango (4:12)
Excel Tutorials
|
Ch. 10
Using Functions for F-Distribution and F-Test
Shows how to calculate p-values for F-statistics (4:12)
Excel Tutorials
|
Ch. 10
One-Way ANOVA with the Data Analysis ToolPak
Nice illustration of underlying data, from Jeffrey Knutsen (4:19)
Excel Tutorials
|
Ch. 10
How to Perform a Two-Way ANOVA without Replication
From Stephanie Glen (3:08)
Excel Tutorials
|
Ch. 10
How to Perform a Chi-Square Test for Independence
Includes making table of expected values, from Eugene O'Loughlin (8:42).
Additional References
Additional References
Excel Tutorials
|
Ch. 10
Multiple Applications of ANOVA
Real Statistics Using Excel provides detailed instructions for implementing different types of ANOVA with Excel.
Excel Tutorials
|
Ch. 10
Chi-Square and F Distributions
Excellent references for Chi-Square Test and ANOVA featuring Excel.
Excel Tutorials
|
Ch. 10
Calculating Lambda Using Excel
Based on given cross-tabulation (8:48)
Excel Tutorials
|
Ch. 10
Multiple Applications of ANOVA
Real Statistics Using Excel provides detailed instructions for implementing different types of ANOVA with Excel.
Excel Tutorials
|
Ch. 10
Chi-Square and F Distributions
Excellent references for Chi-Square Test and ANOVA featuring Excel.
Excel Tutorials
|
Ch. 10
Calculating Lambda Using Excel
Based on given cross-tabulation (8:48)