TABLE OF CONTENTS
SCREENCASTS: Complete list of video screencasts that show how to do the statistical tests and graphs described in this manual.
Screencast Subtopics: Alphabetized list with links to the most important subtopics included within the screencasts.
How to Install the Analysis Toolpak
(necessary for doing statistics in MS Excel)
Preface
Introduction
Section 1—Comparing the Means of Two Groups of Numbers:
Section 2—Comparing Means Among Three or More
Section 3—Looking For Relationships Between
Section 4—Comparing Counts With Expected Values:
APPENDIX I: The Language of Statistics
APPENDIX II: Hypotheses
APPENDIX III: What test is right for these data
APPENDIX IV: Using Formulas in MS Excel
APPENDIX V: Histograms
APPENDIX VI: Putting Error Bars on Graphs
APPENDIX VII: Finding and Displaying
Hidden Data on Scatterplots
APPENDIX VIII: Excel Basics for Beginners
Data Sets and other Excel Files
Glossary
References Cited
Acknowledgements
July 2005, Costa Rica: I would like to thank several colleagues, friends and family members. From the beginning, Catherine Koning, Fred Rogers, and Jacques Veilleux encouraged the idea of writing a guide to statistics for undergraduates. The enthusiasm and creative suggestions of Michael Lehner were great sources of motivation while I was writing. April, Jordan, and Isaiah were supportive of my efforts even when this manual was a source of distraction. Most importantly, I want to thank Jordan for his thorough reading and insightful comments that helped improve and clarify the text.
June 2014, Latvia:
Once again, Catherine Koning has been a source of encouragement for this project and the goal of making it available online. My friends Hadley and Guntra were kind enough to share their apartment in Latvia where many of these revisions were made. My fellow musicians (you know who you are!) have kept me relatively sane when data analysis has threatened to do otherwise. Most importantly, I thank April for her patience, support, sound advice, and tolerance of my obsessions with projects such as these.
March 2026, Ecuador: Big thanks to Jay and Kate for getting us started with an amazing experience on the coast of Ecuador where most of the 2026 revisions to this manual were made. Justin and Mariscal were (and continue to be) an inspiration for positive attitude and living one's best life. And April, a huge thanks to you for your editorial advice on wording, format, and layout and for your patience throughout the entirety of this project!
Special thanks to Franklin Pierce University for granting sabbaticals— and, here's to undergraduate research!
