A Microsoft Excel (R) Companion to Political Analysis

Philip H. Pollock III is a professor of political science at the University of Central Florida. He has taught courses in research methods at the undergraduate and graduate levels for more than thirty years. His main research interests are American public opinion, voting behavior, techniques of quantitative analysis, and the scholarship of teaching and learning. His recent research has been on the effectiveness of Internet-based instruction. Pollock's research has appeared in the American Journal of Political Science, Social Science Quarterly, and the British Journal of Political Science. Recent scholarly publications include articles in Political Research Quarterly, the Journal of Political Science Education, and PS: Political Science and Politics. Barry C. Edwards is a lecturer in the Department of Political Science at the University of Central Florida. He received his B.A. from Stanford University, a J.D. from New York University, and a Ph.D. from the University of Georgia. His teaching and research interests include American politics, public law, and research methods. He founded the Political Science Data Group and created the PoliSciData.com web site. His research has been published in American Politics Research, Congress & the Presidency, Election Law Journal, Emory Law Journal, Georgia Bar Journal, Harvard Negotiation Law Review, Journal of Politics, NYU Journal of Legislation and Public Policy, Political Research Quarterly, Presidential Studies Quarterly, Public Management Review, and State Politics and Policy Quarterly.

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 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 A textbook that makes statistics in Excel very approachable and easy to understand even for non-STEM majors. -- Volodymyr Gupan