Name: Excel Tutorial Videos, Chapter 10 | PoliSciData
Channel: Barry Edwards, JD, PhD, poliscidata.com
Description: Excel tutorial videos for Chi-Square and Analysis of Variance from A Microsoft Excel Companion to Political Analysis.

Watch & Learn: Chi-Square and Analysis of Variance

►
Calculating Lambda Using Excel i
Based on given cross-tabulation (8:48).
►
How to Calculate P-Value for an F-Statistic i
Uses Excel F.DIST function (2:26).
►
How to Perform a Chi-Square Test for Independence i
Includes making table of expected values, from Eugene O'Loughlin (8:42)..
►
How to Use CHISQ.TEST and CHISQ.INV.RT Functions i
Illustrates with a goodness of fit test (4:12).
►
Working with Chi Distribution Functions i
From Mauricio Arango (4:12).
►
Using Functions for F-Distribution and F-Test i
Shows how to calculate p-values for F-statistics (4:12).
►
How to Conduct a Chi-Square Test i
From Todd Grande (8:03)..
►
How to Conduct Analysis of Variance (ANOVA) and Graph Results i
From Amy Dykstra (9:01).
►
One-Way ANOVA with the Data Analysis ToolPak i
Nice illustration of underlying data, from Jeffrey Knutsen (4:19).
►
One-Way ANOVA (Single Factor) with Data Analysis Tools i
From Todd Grande (12:02).
►
Two-Way ANOVA with Replication using Data Analysis Tools i
From Todd Grande (12:42).

Streaming Excel Tutorial Videos for Chi-Square and Analysis of Variance