Excel spreadsheets for Brief Notes on Statistics
Michael Wood (michael.wood@port.ac.uk)
Data spreadsheets
Data workbook (also includes normal
distribution calculator)
Drink data (data on the amount a sample of students
drank and smoked)
Data on a random sample of people from the
Isle of Fastmoney
Data on share prices and returns
Spreadsheets for implementing
statistical methods
Least squares method for regression with
one independent variable (This spreadsheet uses the Excel Solver to find
the best fit line.)
Resampling
method to test the null hypothesis of no difference between two means (This
spreadsheet does the randomization test.)
These go a bit beyond the
notes …
Least squares methods for regression with
several independent variables
Bootstrap resampling
method for confidence intervals
Bootstrap method for confidence intervals for regression slopes