FIND DATA: By Author | Journal Archives | Sites   ANALYZE DATA: Help with R | Stata | Excel   WHAT'S NEW? US Politics | Int'l Relations | Law & Courts
FIND DATA: By Author | Journal | Sites   WHAT'S NEW? US Politics | IR | Law & Courts
A Microsoft Excel Companion to Political Analysis Video Tutorials: Making Comparisons with Excel
This page features video tutorials to help you do political analysis with Microsoft Excel. We created this page, and related pages, to supplement our Excel Companion to Political Analysis. Where possible, we leverage existing videos, but have created a number of custom tutorial videos for our textbook.
 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 & LEARN: Making Comparisons with Excel
 Excel PivotTables Made Easy Demonstrates PivotTables with sales data (DV) and addresses common problems (13:17).

 Using Count, Average and Sum in Pivot Tables Useful for creating mean comparison tables (8:16).

 Excel Pivot Tables Explained Leila Gharani uses PivotTables to summarize sales data by other variables, like sales by product (13:21).

WATCH & LEARN: Making Comparisons with Excel
 Excel PivotTables Made Easy Demonstrates PivotTables with sales data (DV) and addresses common problems (13:17).

 Using Count, Average and Sum in Pivot Tables Useful for creating mean comparison tables (8:16).

WATCH & LEARN: Making Comparisons with Excel
 Excel PivotTables Made Easy Demonstrates PivotTables with sales data (DV) and addresses common problems (13:17).