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
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
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
European Politics
Teaching & Learning
Political Behavior
International Relations
Comparative Politics
Descriptive Statistics with Excel
Suggest a Link
Printer-Friendly List
Teach Political Analysis
Try our updated classic:
The Essentials of Political Analysis, 6th Ed.
From
CQ Press/Sage
.
Get instructor copy
Student resources
,
sample syllabi
,
lecture videos
with SPSS, Stata, Excel & R
Companions
Watch & Learn
NORM.DIST and Related Functions
Todd Grande explains how to use these functions in Excel (9:52)
More
Excel Tutorials
|
Ch. 8
Review Terminology
Advanced Methodology
Latin Am. Politics
Voting & Elections
Asian Politics
American Politics
Law, Courts & Justice
African Politics
More Excel Tips & Tutorials:
☑ Getting Started
|
Using Excel for Data Analysis
|
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
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
Watch and Learn
Watch and Learn
Excel Tutorials
|
Ch. 2
How to Make a Map Chart
Demonstrates using Florida zip codes (4:33).
Excel Tutorials
|
Ch. 2
How to Use PivotTables to Summarize Data
Nice introduction and demonstration (17:39).
Excel Tutorials
|
Ch. 2
How to Show % of Total in PivotTable
Helps create percentages column in frequency distribution table (4:30).
Excel Tutorials
|
Ch. 2
Descriptive Statistics with Excel's Data Analysis ToolPak
By Matt Macarty (4:24)
Excel Tutorials
|
Ch. 2
How to Use Descriptive Statistics Tool
Demonstrates with data on heights (2:37).
Excel Tutorials
|
Ch. 2
Rank and Percentile Tools in Data Analysis ToolPak
How to use additional tools to describe data (1:57).
Excel Tutorials
|
Ch. 2
Pivot Table Tutorial
By Kevin Stratvert (13:35)
Excel Tutorials
|
Ch. 2
Make a Histogram Using Data Analysis ToolPak's Histogram Tool
By Vickie Dominguez (5:40)
Excel Tutorials
|
Ch. 2
Learn Chart & Graph Basics for Quick Start
From Leila Gharani (14:09)
Excel Tutorials
|
Ch. 2
Sorting and Filtering Data
Starting from blank worksheet, from Organic Chemistry Tutor (13:28)
Excel Tutorials
|
Ch. 2
Making a Simple Bar Graph
Scott Stevens creates the graph from scratch (5:13)
Excel Tutorials
|
Ch. 2
How to Create a Column Chart
Good emphasis on design principles (3:40)
Excel Tutorials
|
Ch. 2
Sorting Worksheet Data
Demonstrates basics of sorting (4:30)
Excel Tutorials
|
Ch. 2
How to Make a Map Chart
Demonstrates using Florida zip codes (4:33).
Excel Tutorials
|
Ch. 2
How to Use PivotTables to Summarize Data
Nice introduction and demonstration (17:39).
Excel Tutorials
|
Ch. 2
How to Show % of Total in PivotTable
Helps create percentages column in frequency distribution table (4:30).
Excel Tutorials
|
Ch. 2
Descriptive Statistics with Excel's Data Analysis ToolPak
By Matt Macarty (4:24)
Excel Tutorials
|
Ch. 2
How to Use Descriptive Statistics Tool
Demonstrates with data on heights (2:37).
Excel Tutorials
|
Ch. 2
Rank and Percentile Tools in Data Analysis ToolPak
How to use additional tools to describe data (1:57).
Excel Tutorials
|
Ch. 2
Pivot Table Tutorial
By Kevin Stratvert (13:35)
Excel Tutorials
|
Ch. 2
Make a Histogram Using Data Analysis ToolPak's Histogram Tool
By Vickie Dominguez (5:40)
Excel Tutorials
|
Ch. 2
Learn Chart & Graph Basics for Quick Start
From Leila Gharani (14:09)
Excel Tutorials
|
Ch. 2
Sorting and Filtering Data
Starting from blank worksheet, from Organic Chemistry Tutor (13:28)
Excel Tutorials
|
Ch. 2
Making a Simple Bar Graph
Scott Stevens creates the graph from scratch (5:13)
Excel Tutorials
|
Ch. 2
How to Create a Column Chart
Good emphasis on design principles (3:40)
Excel Tutorials
|
Ch. 2
Sorting Worksheet Data
Demonstrates basics of sorting (4:30)
NORM.DIST and Related Functions
Try our updated classic: The Essentials of Political Analysis, 6th Ed. From 
