Share
A Microsoft Excel® Companion to Political Analysis
First Edition
- Philip H. Pollock III - University of Central Florida, USA
- Barry C. Edwards - University of Central Florida, USA
January 2022 | 432 pages | CQ Press
The trusted series of workbooks by Philip H. Pollock III and Barry C. Edwards continues with A Microsoft Excel®Companion to Political Analysis. In this new guide, students dive headfirst into actual political data working with the ubiquitous Excel software. Students learn by doing with new guided examples, annotated screenshots, step-by-step instructions, and exercises that reflect current scholarly debates in varied subfields of political science, including American politics, comparative politics, law and courts, and international relations. Chapters cover all major topics in political data analysis, from descriptive statistics through logistic regression, all with worked examples and exercises in Excel. No matter their professional goals, students can gain a leg up for their future careers by developing a working knowledge of statistics using Excel. By encouraging students to build on their existing familiarity with the Excel program, instructors can flatten the statistics learning curve and take some of the intimidation out of the learning process. Gain lost time usually spent troubleshooting software to provide students with a smooth transition into political analysis.
Chapter 1 Using Excel for Data Analysis
Chapter 2 Descriptive Statistics
Chapter 3 Transforming Variables
Chapter 4 Making Comparisons
Chapter 5 Graphing Relationships and Describing Patterns
Chapter 6 Random Assignment and Sampling
Chapter 7 Making Controlled Comparisons
Chapter 8 Working with Sampling Distributions
Chapter 9 Hypothesis Tests with One or Two Samples
Chapter 10 Chi-Square Test and Analysis of Variance
Chapter 11 Correlation and Bivariate Regression
Chapter 12 Multiple Regression Analysis
Chapter 13 Analyzing Regression Residuals
Chapter 14 Logistic Regression
Chapter 15 Doing Your Own Political Analysis
This text is a welcoming addition to the political analysis companions series by Pollock and colleagues. Its lucid writing style, hands-on
pedagogical approach, and ample carefully curated examples and exercises will be appreciated by research methods instructors
and students alike. It really teaches the students how to conduct empirical political analysis using Microsoft Excel.
James Madison University
Pollock's book is very intuitive, straightforward, and clear. By using this textbook, students should be able to deepen their learning with more hands-on practices.
Texas A & M University - Kingsville
A textbook that makes statistics in Excel very approachable and easy to understand even for non-STEM majors.
University of Connecticut
