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