Making Sense of Statistics: a Non-mathematical Approach
Michael Wood (michael.wood@port.ac.uk)
Data and program files
·
accquest.xls, accdin.txt, accsoc.txt
·
iofm.xls
Spreadsheet data/analysis files
These files are designed to help with some of the exercises and examples in the text.
These are workbooks designed to carry
out particular methods. They are all Excel 2000 files so you will need this on
your computer to run them. Note that cells used for inputting data and formulae
are green.
resample.xls (resampling, bootstrapping or the two
bucket model)
resamplenrh.xls (approximate randomisation test)
diffofmeanstest.xls (approximate
randomisation test of the difference of the means of two groups of exam marks.
This worksheet is not mentioned in the book. The previous worksheet will do
this test too, but it is less convenient.)
diffofmeanstestnd.xls
(approximate randomisation test of the difference of the means of two groups of
measurements. Just like the previous one, but without the data.)
diffofmeansconfidence.xls (for
producing a confidence interval for the difference of two means. Not mentioned
in the book.)
resamplenrh-drinkfm.xls
(approximate randomisation test of the hypothesis that males and females
drink the same amount. Needs the add-in, nms.xla to work.)
pred1var.xls, (regression with one independent
variable)
predmvar.xls, (multiple regression)
nms.xla (Excel
add-in with functions
To install, download, then, in Excel, click on Tools - Add-ins, and Browse to
find the downloaded file. Use the Function Wizard (fx on the toolbar or the
Insert menu) to find the extra functions and a brief description of what they
do. They should be listed under Statistical functions.
This program does not require any special software to run it. Simply double
click on it after downloading it. It saves its results in a file called
RESAMPLE.OUT in the same folder as the program.
resample.exe (resampling, bootstrapping or the two
bucket model)
resample.htm (notes on resample.exe)