You are here

A Microsoft Excel® Companion to Political Analysis

A Microsoft Excel® Companion to Political Analysis

First Edition

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.

Yi Edward Yang
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.

Soyoung Kwon
Texas A & M University - Kingsville

A textbook that makes statistics in Excel very approachable and easy to understand even for non-STEM majors.

Volodymyr Gupan
University of Connecticut
Key features
  • Screenshots and walk-throughs of Microsoft Excel® give students a step-by-step template for using the software for statistics.
  • Four downloadable Excel workbooks provide real political data for analysis so students learn more about political science as well as statistics.
  • QR codes throughout link to video walk-throughs in the supplemental resources.
  • Chapters cover all major topics in data analysis, from descriptive statistics to logistic regression.
  • Chapters follow the same order and progression as The Essentials of Political Analysis to help students stay on task.
  • A final chapter describes several doable research projects, shows how to find relevant data, and lays out a framework for a well-organized research paper so students see statistics in the context of research.

For instructors

Select a Purchasing Option

ISBN: 9781071813355