using MS Excel (online version, revised 2014)

Departments of Biology &

Environmental Science

Franklin Pierce University

How to Install the Analysis Toolpak

(necessary for doing statistics in MS Excel)

Preface

Introduction

TOPICS:

location and spread of data

pattern, dependent and independent variables

categorical vs. continuous variables

random chance

p-values

location and spread of data

pattern, dependent and independent variables

categorical vs. continuous variables

random chance

p-values

Chapter 1 – Comparing the Means of Two Groups of Numbers:

Scatterplots and the t-Test

.

TOPICS:

Entering & Describing Data

Interpreting a t-Test Scatterplot

Interpreting t-Test Output

TOOLS:

Making a t-Test Scatterplot

Formatting Your Scatterplot

Doing a t-Test

.

TOPICS:

Entering & Describing Data

Interpreting a t-Test Scatterplot

Interpreting t-Test Output

TOOLS:

Making a t-Test Scatterplot

Formatting Your Scatterplot

Doing a t-Test

Chapter 2 – Comparing Means Among Three or More

Groups of Numbers: Analysis of Variance

TOPICS:

Why Anova Rather than a t-Test?

Interpreting Anova Output

TOOLS:

Adding Mean Values to a Scatterplot

Doing an Anova and Formatting Your Output

TOPICS:

Why Anova Rather than a t-Test?

Interpreting Anova Output

TOOLS:

Adding Mean Values to a Scatterplot

Doing an Anova and Formatting Your Output

Chapter 3 – Looking For Relationships Between

Dependent and Independent Variables:

Scatterplots and Regression Analysis

TOPICS:

Independent and Dependent Variables

Interpreting a Regression Analysis Scatterplot

Interpreting Regression Analysis Output

TOOLS:

Making a Regression Analysis Scatterplot

Doing a Regression Analysis

Scatterplots and Regression Analysis

TOPICS:

Independent and Dependent Variables

Interpreting a Regression Analysis Scatterplot

Interpreting Regression Analysis Output

TOOLS:

Making a Regression Analysis Scatterplot

Doing a Regression Analysis

Chapter 4 – Comparing Counts With Expected Values:

Chi-Square Test

TOPICS:

Count; Value; Frequency; Relative Abundance

Contingency Tables

Expected Frequencies based on Reference Data or Theory

TOOLS:

Calculating Expected Values for Cells in Contingency Tables

Making a Bar Graph

Using a Table and Calculator to Determine Chi-Square

Calculating Expected Values from Expected Frequencies

Setting Up Spreadsheets to Calculate Chi-Square Values

TOPICS:

Count; Value; Frequency; Relative Abundance

Contingency Tables

Expected Frequencies based on Reference Data or Theory

TOOLS:

Calculating Expected Values for Cells in Contingency Tables

Making a Bar Graph

Using a Table and Calculator to Determine Chi-Square

Calculating Expected Values from Expected Frequencies

Setting Up Spreadsheets to Calculate Chi-Square 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

Mountain Lion Data

Butterfly Data

Fish Diversity Data

Crayfish Data

Tree Data

Fish Diversity Data (hidden data points)

Summary Statistics Calculator

Chi-Square Calculator for Contingency Tables

Chi-Square Calculator for Reference Data or Theory

Butterfly Data

Fish Diversity Data

Crayfish Data

Tree Data

Fish Diversity Data (hidden data points)

Summary Statistics Calculator

Chi-Square Calculator for Contingency Tables

Chi-Square Calculator for Reference Data or Theory

Glossary

References Cited

©2017 EcologyAndEvolution.Org, All rights reserved.