MWU Library: Residency Research Manual: Data Entry & Statistics

Data Entry, Coding of Data and Overview of Statistical Analyses

This section contains information about data collection, data coding and entry, and statistical analyses. Information is provided for data entry and analyses in Excel and SPSS.

Additional Resources:

Additional SPSS training can be found by clicking on the Central Michigan University's SPSS online training pages at:

SPSS Training Workshop
This online workshop is based on SPSS 18.0.

Additional online help for using Excel for statistical analyses and a discussion regarding the limitations of Excel for statistical analyses can be found in the document "Excel for Statistics".

Acknowledgement:

Parts of this chapter were adapted from the web version of: McDonald, J.H. 2009. Handbook of Biological Statistics (2nd ed.). Sparky House Publishing, Baltimore, Maryland.

Data Entry, Coding of Data, and Overview of Statistical Analyses

Handbook of Biological Statistics

Coding/Statistical Analyses
Data Entry
Example Data Coding SPSS
Data Transformations
ANOVA Data
t-test data

Excel for Statistics

DESCRIPTIVE STATISTICS USING EXCEL AND STATA (Excel 2003 and Stata 10.0+)
Descriptive Statistics Using Microsoft Excel
Use the Analysis ToolPak to perform complex data analysis
Using Excel for Statistical Data Analysis - Caveats