NAVIGATION ☰
Home Page
Find Data by Source ►
Topical Collections
By Author
Journal Archives
Ask Facebook Group
Find Data by Subfield ►
African Politics
American Politics
Comparative Politics
European Politics
International Relations
Law Courts & Justice
Public Opinion Surveys
Voting & Elections
Ask Facebook Group
Teach Data Analysis ►
Teaching Resources
Teaching Assistant
Live R Demos
Sample Syllabi
Excel Tutorials ►
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: Sampling Distributions
9: Hypothesis Tests with One or Two Samples
10: ChiSquare & ANOVA
11: Correlation & Bivariate Regression
12: Multiple Regression
13: Regression Residuals
14: Logistic Regression
15: Doing Your Own Analysis
Analyze Data ►
Grade Level of Text
Surname Census Info
Calculate Federal Judge Ideal Points
Crosstabs with Circuit Court Data
Election Simulation
Share Findings ►
Political Science Blogs
Political Science Journals
Political Science Podcasts
Political Theory Journals
Public Administration Journals
Public Policy Journals
Legal Research
It's Better with Music
About ►
This Web Site
Barry C. Edwards
Excel Tips & Tutorials:
ChiSquare and Analysis of Variance
Suggest a Link
Alphabetize Page
PrinterFriendly List
Find data. Produce results. Tell the world.
Watch and Learn
Watch and Learn
Watch and Learn
Watch and Learn
How to Calculate PValue for an FStatistic
Uses Excel F.DIST function (2:26)
Excel Tutorials

Chapter 10
How to Use CHISQ.TEST and CHISQ.INV.RT Functions
Illustrates with a goodness of fit test (4:12)
Excel Tutorials

Chapter 10
OneWay ANOVA with the Data Analysis ToolPak
Nice illustration of underlying data, from Jeffrey Knutsen (4:19)
Excel Tutorials

Chapter 10
Working with Chi Distribution Functions
From Mauricio Arango (4:12)
Excel Tutorials

Chapter 10
OneWay ANOVA (Single Factor) with Data Analysis Tools
From Todd Grande (12:02)
Excel Tutorials

Chapter 10
TukeyKramer Post Hoc Test after OneWay ANOVA
From Todd Grande (15:35)
Excel Tutorials

Chapter 10
Using Functions for FDistribution and FTest
Shows how to calculate pvalues for Fstatistics (4:12)
Excel Tutorials

Chapter 10
How to Perform a ChiSquare Test for Independence
Includes making table of expected values, from Eugene O'Loughlin (8:42).
Excel Tutorials

Chapter 10
How to Conduct Analysis of Variance (ANOVA) and Graph Results
From Amy Dykstra (9:01)
Excel Tutorials

Chapter 10
How to Perform a TwoWay ANOVA without Replication
From Stephanie Glen (3:08)
Excel Tutorials

Chapter 10
TwoWay ANOVA with Replication using Data Analysis Tools
From Todd Grande (12:42)
Excel Tutorials

Chapter 10
OneWay ANOVA with PostHoc tTests
From James Clark (14:25)
Excel Tutorials

Chapter 10
How to Conduct a ChiSquare Test
From Todd Grande (8:03).
Excel Tutorials

Chapter 10
How to Calculate PValue for an FStatistic
Uses Excel F.DIST function (2:26)
Excel Tutorials

Chapter 10
How to Use CHISQ.TEST and CHISQ.INV.RT Functions
Illustrates with a goodness of fit test (4:12)
Excel Tutorials

Chapter 10
OneWay ANOVA with the Data Analysis ToolPak
Nice illustration of underlying data, from Jeffrey Knutsen (4:19)
Excel Tutorials

Chapter 10
Working with Chi Distribution Functions
From Mauricio Arango (4:12)
Excel Tutorials

Chapter 10
OneWay ANOVA (Single Factor) with Data Analysis Tools
From Todd Grande (12:02)
Excel Tutorials

Chapter 10
TukeyKramer Post Hoc Test after OneWay ANOVA
From Todd Grande (15:35)
Excel Tutorials

Chapter 10
Using Functions for FDistribution and FTest
Shows how to calculate pvalues for Fstatistics (4:12)
Excel Tutorials

Chapter 10
How to Perform a ChiSquare Test for Independence
Includes making table of expected values, from Eugene O'Loughlin (8:42).
Excel Tutorials

Chapter 10
How to Conduct Analysis of Variance (ANOVA) and Graph Results
From Amy Dykstra (9:01)
Excel Tutorials

Chapter 10
How to Perform a TwoWay ANOVA without Replication
From Stephanie Glen (3:08)
Excel Tutorials

Chapter 10
TwoWay ANOVA with Replication using Data Analysis Tools
From Todd Grande (12:42)
Excel Tutorials

Chapter 10
OneWay ANOVA with PostHoc tTests
From James Clark (14:25)
Excel Tutorials

Chapter 10
How to Conduct a ChiSquare Test
From Todd Grande (8:03).
Excel Tutorials

Chapter 10
How to Calculate PValue for an FStatistic
Uses Excel F.DIST function (2:26)
Excel Tutorials

Chapter 10
How to Use CHISQ.TEST and CHISQ.INV.RT Functions
Illustrates with a goodness of fit test (4:12)
Excel Tutorials

Chapter 10
OneWay ANOVA with the Data Analysis ToolPak
Nice illustration of underlying data, from Jeffrey Knutsen (4:19)
Excel Tutorials

Chapter 10
Working with Chi Distribution Functions
From Mauricio Arango (4:12)
Excel Tutorials

Chapter 10
OneWay ANOVA (Single Factor) with Data Analysis Tools
From Todd Grande (12:02)
Excel Tutorials

Chapter 10
TukeyKramer Post Hoc Test after OneWay ANOVA
From Todd Grande (15:35)
Excel Tutorials

Chapter 10
Using Functions for FDistribution and FTest
Shows how to calculate pvalues for Fstatistics (4:12)
Excel Tutorials

Chapter 10
How to Perform a ChiSquare Test for Independence
Includes making table of expected values, from Eugene O'Loughlin (8:42).
Excel Tutorials

Chapter 10
How to Conduct Analysis of Variance (ANOVA) and Graph Results
From Amy Dykstra (9:01)
Excel Tutorials

Chapter 10
How to Perform a TwoWay ANOVA without Replication
From Stephanie Glen (3:08)
Excel Tutorials

Chapter 10
TwoWay ANOVA with Replication using Data Analysis Tools
From Todd Grande (12:42)
Excel Tutorials

Chapter 10
OneWay ANOVA with PostHoc tTests
From James Clark (14:25)
Excel Tutorials

Chapter 10
How to Conduct a ChiSquare Test
From Todd Grande (8:03).
Excel Tutorials

Chapter 10
How to Calculate PValue for an FStatistic
Uses Excel F.DIST function (2:26)
Excel Tutorials

Chapter 10
How to Use CHISQ.TEST and CHISQ.INV.RT Functions
Illustrates with a goodness of fit test (4:12)
Excel Tutorials

Chapter 10
OneWay ANOVA with the Data Analysis ToolPak
Nice illustration of underlying data, from Jeffrey Knutsen (4:19)
Excel Tutorials

Chapter 10
Working with Chi Distribution Functions
From Mauricio Arango (4:12)
Excel Tutorials

Chapter 10
OneWay ANOVA (Single Factor) with Data Analysis Tools
From Todd Grande (12:02)
Excel Tutorials

Chapter 10
TukeyKramer Post Hoc Test after OneWay ANOVA
From Todd Grande (15:35)
Excel Tutorials

Chapter 10
Using Functions for FDistribution and FTest
Shows how to calculate pvalues for Fstatistics (4:12)
Excel Tutorials

Chapter 10
How to Perform a ChiSquare Test for Independence
Includes making table of expected values, from Eugene O'Loughlin (8:42).
Excel Tutorials

Chapter 10
How to Conduct Analysis of Variance (ANOVA) and Graph Results
From Amy Dykstra (9:01)
Excel Tutorials

Chapter 10
How to Perform a TwoWay ANOVA without Replication
From Stephanie Glen (3:08)
Excel Tutorials

Chapter 10
TwoWay ANOVA with Replication using Data Analysis Tools
From Todd Grande (12:42)
Excel Tutorials

Chapter 10
OneWay ANOVA with PostHoc tTests
From James Clark (14:25)
Excel Tutorials

Chapter 10
How to Conduct a ChiSquare Test
From Todd Grande (8:03).
Excel Tutorials

Chapter 10
Additional References
Additional References
Additional References
Additional References
Multiple Applications of ANOVA
Real Statistics Using Excel provides detailed instructions for implementing different types of ANOVA with Excel.
Excel Tutorials

Chapter 10
ChiSquare and F Distributions
Excellent references for ChiSquare Test and ANOVA featuring Excel.
Excel Tutorials

Chapter 10
Multiple Applications of ANOVA
Real Statistics Using Excel provides detailed instructions for implementing different types of ANOVA with Excel.
Excel Tutorials

Chapter 10
ChiSquare and F Distributions
Excellent references for ChiSquare Test and ANOVA featuring Excel.
Excel Tutorials

Chapter 10
Multiple Applications of ANOVA
Real Statistics Using Excel provides detailed instructions for implementing different types of ANOVA with Excel.
Excel Tutorials

Chapter 10
ChiSquare and F Distributions
Excellent references for ChiSquare Test and ANOVA featuring Excel.
Excel Tutorials

Chapter 10
Multiple Applications of ANOVA
Real Statistics Using Excel provides detailed instructions for implementing different types of ANOVA with Excel.
Excel Tutorials

Chapter 10
ChiSquare and F Distributions
Excellent references for ChiSquare Test and ANOVA featuring Excel.
Excel Tutorials

Chapter 10
Over 18,000 Members!