Written and posted by Dr. Rhine Singleton
Departments of Biology &
Environmental Science
Franklin Pierce University
Acknowledgements
July, 2005: 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:
Once again, Catherine Koning has been a source of encouragement for this project and 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.
TABLE OF CONTENTS
How to Install the Analysis Toolpak
(necessary for doing statistics in MS Excel)
Preface
Introduction
Chapter 1—Comparing the Means of Two Groups of Numbers:
Chapter 2—Comparing Means Among Three or More
Chapter 3—Looking For Relationships Between
Chapter 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 (coming soon): Pairwise Comparisons in Anova
Data Sets and other Excel Files
Glossary
References Cited