Software for Making Sense of Statistics
Michael Wood (michael.wood@port.ac.uk or mickofemsworth@gmail.com)
accquest.xls, accdin.txt, accsoc.txt
These files are designed to help with some of the exercises and examples in the text.
jobs.xls (Jenny's jobs in Section 5.3)
sharesan.xls (some of the analysis of the data in shares.xls)
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). Improved version which will do the job of
this spreadsheet and the five below: http://woodm.myweb.port.ac.uk/SL/resample.xlsx
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). Improved version which will do multiple regression too: http://woodm.myweb.port.ac.uk/SL/predictor.xlsx
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.
May not work with recent versions of Excel.
This is an old DOS
program that runs from the command prompt and does not need Windows. It saves its results in a file called
RESAMPLE.OUT in the same folder as the program. Unfortunately it won't work on
modern, 64 bit versions of Windows without a Dos emulator.
resample.exe (resampling, bootstrapping or the two bucket model)
resample.htm (notes
on resample.exe)
There are some videos which may be helpful here.