Excel for Statistics
How to Organize Data
This booklet is a handbook on statistical software, not on statistical theory and methodology as such.
The focus is on how to create input for Excel s statistical functions and data analyses when using raw data. The need for organizing data applies to survey data in particular. Also,a presentation of basic Excel targeted at statistics is included.
Prior experience with Excel is not presupposed. In conclusion, output by Excel s statistical functions and data analyses is briefly interpreted.
NB: For en mere udførlig indholdsfortegnelse, vælg 'Kig i bogen' herover.
Basic Excel for Statistics 7
Descriptive Statistics: Looking at the Data 29
Significance Tests about Means 37
Significance Tests about Proportions 63
Testing Categorical Variables for Independence (÷2-test) .
Computing expected Frequencies 69
Correlation Analysis 73
Regression Analysis with Two Variables 75
Multiple Regression Analysis with a Categorical Variable 89
Functions and Data Analyses applied . Excel 2010/2007 97
The text presupposes a basic knowledge of quantitative statistics. It can be used in a statistics course as a companion to Excel statistical software. Students writing a thesis can use the text as a handbook when applying Excel as readily available statistical software.