NAVIGATION ☰
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
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
R Demos & Resources
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:
Making Comparisons
Suggest a Link
Alphabetize Page
PrinterFriendly List
Watch and Learn
Watch and Learn
Watch and Learn
Watch and Learn
Using SUM, COUNT and AVERAGE in PivotTables
Skills needed to make create mean comparison tables (9:51).
Excel Tutorials

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

Chapter 4
How to Make CrossTabulation
Uses PivotTable to make crosstable with car data (12:02).
Excel Tutorials

Chapter 4
Calculating Means and Standard Deviations in PivotTable
Useful for creating mean comparison tables (7:34).
Excel Tutorials

Chapter 4
Excel PivotTables Made Easy
Demonstrates PivotTables with sales data (DV) and addresses common problems (13:17).
Excel Tutorials

Chapter 4
Cross Tabulation With Frequencies and Percentages
Shows how to calculate values and format PivotTable (15:12).
Excel Tutorials

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

Chapter 4
Map Chart Tutorial
With helpful tips on mapping at different levels (15:15).
Excel Tutorials

Chapter 4
How to Group, Ungroup, and Remove PivotTable Rows
Useful for making comparisons with intervallevel independent variable (3:23).
Excel Tutorials

Chapter 4
Using SUM, COUNT and AVERAGE in PivotTables
Skills needed to make create mean comparison tables (9:51).
Excel Tutorials

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

Chapter 4
How to Make CrossTabulation
Uses PivotTable to make crosstable with car data (12:02).
Excel Tutorials

Chapter 4
Calculating Means and Standard Deviations in PivotTable
Useful for creating mean comparison tables (7:34).
Excel Tutorials

Chapter 4
Excel PivotTables Made Easy
Demonstrates PivotTables with sales data (DV) and addresses common problems (13:17).
Excel Tutorials

Chapter 4
Cross Tabulation With Frequencies and Percentages
Shows how to calculate values and format PivotTable (15:12).
Excel Tutorials

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

Chapter 4
Map Chart Tutorial
With helpful tips on mapping at different levels (15:15).
Excel Tutorials

Chapter 4
How to Group, Ungroup, and Remove PivotTable Rows
Useful for making comparisons with intervallevel independent variable (3:23).
Excel Tutorials

Chapter 4
Using SUM, COUNT and AVERAGE in PivotTables
Skills needed to make create mean comparison tables (9:51).
Excel Tutorials

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

Chapter 4
How to Make CrossTabulation
Uses PivotTable to make crosstable with car data (12:02).
Excel Tutorials

Chapter 4
Calculating Means and Standard Deviations in PivotTable
Useful for creating mean comparison tables (7:34).
Excel Tutorials

Chapter 4
Excel PivotTables Made Easy
Demonstrates PivotTables with sales data (DV) and addresses common problems (13:17).
Excel Tutorials

Chapter 4
Cross Tabulation With Frequencies and Percentages
Shows how to calculate values and format PivotTable (15:12).
Excel Tutorials

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

Chapter 4
Map Chart Tutorial
With helpful tips on mapping at different levels (15:15).
Excel Tutorials

Chapter 4
How to Group, Ungroup, and Remove PivotTable Rows
Useful for making comparisons with intervallevel independent variable (3:23).
Excel Tutorials

Chapter 4
Using SUM, COUNT and AVERAGE in PivotTables
Skills needed to make create mean comparison tables (9:51).
Excel Tutorials

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

Chapter 4
How to Make CrossTabulation
Uses PivotTable to make crosstable with car data (12:02).
Excel Tutorials

Chapter 4
Calculating Means and Standard Deviations in PivotTable
Useful for creating mean comparison tables (7:34).
Excel Tutorials

Chapter 4
Excel PivotTables Made Easy
Demonstrates PivotTables with sales data (DV) and addresses common problems (13:17).
Excel Tutorials

Chapter 4
Cross Tabulation With Frequencies and Percentages
Shows how to calculate values and format PivotTable (15:12).
Excel Tutorials

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

Chapter 4
Map Chart Tutorial
With helpful tips on mapping at different levels (15:15).
Excel Tutorials

Chapter 4
How to Group, Ungroup, and Remove PivotTable Rows
Useful for making comparisons with intervallevel independent variable (3:23).
Excel Tutorials

Chapter 4
Over 18,000 Members!