Sigma Statistics 

These spreadsheets are Microsoft Excel 2010 worksheets.  Each spreadsheet can either be opened and run, or saved to any location on your computer or network.

Spreadsheets

Worked examples                Simulations and Interactive Spreadsheets                Data Sets                


Worked examples

15        Reported offences (NZ) 1990 to 2010.xlsx
26        Hotel nights for tourists in New Zealand 1990-2007.xlsx
36       
Centred moving averages.xlsx
43       
Visitors from Australia Sep 1998 to Dec 2011.xlsx
57        Jack and Jill's electricity charges (piecewise model).xlsx
65        Mathematical and scientific literacy by country.xlsx
106      Cricket chirps vs temperature regression calculations.xlsx
114      Nuclear plants data (cost vs generating capacity).xlsx
120      Cigarette use vs lung cancer – 44 US states.xlsx
171      Distribution shape.xlsx
179      Kereru.xlsx
182      Bootstrap Comparisons.xlsx
184      Resamples - two groups of six.xlsx
210      Randomisation example (Toothpaste).xlsx


Simulations and Interactive Spreadsheets

97        Interactive line of best fit.xlsx
149      Sampling variability simulation.xlsx
520     
Rostered days off.xlsx
523      Different birth months (1000 trials).xlsx
528      Poisson values simulator.xlsx
528      Binomial values simulator.xlsx
529      Normal values simulator.xlsx
546      Distribution of the sample mean.xlsx


Data sets

11        Marriage and divorce rates 1961-2010.xlsx
12        Lung disease deaths (UK) 1974 to 1979.xlsx
13        Lynx trappings (Canada) 1821 to 1934.xlsx
15        Reported offences (NZ) 1990 to 2010.xlsx
21        Crime statistics (NZ) 1880 to 2010.xlsx
22        Jeans sales figures (UK) 1980 to 1985.xlsx
22        Alcohol available for consumption 1994-2011.xlsx
26        Hotel nights for tourists in New Zealand 1990-2007.xlsx
29        Kiwifruit exports 1984-2010.xlsx
30        School rolls by gender (2000-2011).xlsx
31        Electricity generation - New Zealand 1971-2010.xlsx
31        Hotel nights - international comparisons.xlsx
32        Road motor vehicles per thousand population.xlsx
37
        Cellphone infringements 2009-2011.xlsx
37        UK traffic fatalities - monthly.xlsx
39        Divorce - median age of husband and wife - 1991-2010.xlsx
43        Visitors from Australia Sep 1998 to Dec 2011.xlsx
46        Quarterly electricity use.xlsx
47        Bun run.xlsx
47        Swimming pool admissions 2008 to 2012.xlsx
49        Australian quarterly production of electricity March 1956-Sep 1994.xlsx
54        Mean estimated resident population of New Zealand 1991-2010.xlsx
54
        Crustacean exports 1989-2011.xlsx
55        Alpha-Beta-Gamma share prices.xlsx
57        Jack and Jill's electricity charges (data).xlsx

58       
Train boardings in Auckland 1986-2011.xlsx
59        Violent offences 1952-2005.xlsx
60        Annual car registrations (1926-2009).xlsx
61        Sunspot data (annual) 1700-2009.xlsx
65        Mathematical and scientific literacy by country.xlsx
79        LC flight movements and population - Europe.xlsx  
80        McDonalds nutrition information.xlsx
80        Currency rates NZD vs AUD & USD.xlsx
82        Four sets of artificial bivariate data.xlsx
90        Airports vs area vs population.xlsx
91        Powerboat registrations vs manatee fatalities (Florida 1977-2004).xlsx
92        Poverty vs corruption.xlsx
101     
Sand erosion data.xlsx
109      Height and arm-span for 25 adults.xlsx
109      Video vs DVD hires.xlsx
110      World metro list (length vs stations).xlsx
114      Nuclear plants data (cost vs generating capacity).xlsx
116      Alcohol and tobacco spending, UK.xlsx
117      Gestation and lifespan of selected animals.xlsx
118      Wine consumption and heart disease.xlsx
119      Leaning Tower of Pisa.xlsx
120      Cigarette use vs lung cancer – 44 US states.xlsx
123      Destinations and airfares from Auckland.xlsx
141      Statistical graph data (for Ex 6.03).xlsx
145      Data for statistical analysis (for Ex 6.04).xlsx
151      Sample of 15 for bootstrapping.xlsx
156      Blowhole - time intervals between eruptions.xlsx
157      Cholesterol readings.xlsx
157      Moa egg lengths.xlsx
166      Cat heart rates.xlsx
166      Geranium fertiliser.xlsx
166      Coffee drinking weekly - teachers and police.xlsx
166      Tech jobs.xlsx
168      Firewood volumes.xlsx
168      Labour force - female participation rate.xlsx
169      Termite survival.xlsx
172      Distribution Comparison Exercise.xlsx
176      Helium football distances.xlsx
176      Hearing Test - number of words heard clearly.xlsx
177      Euroweight.xlsx
177      Annual earnings - Years 9 and 10.xlsx
177      Text Messages.xlsx
177      American Colleges.xlsx
179      Kereru.xlsx
185      Comparison with Bootstrap Example.xlsx
185      Juggling.xlsx
185      Ex 8-03 Qn2 (for iNZight).xlsx
185      Calories.xlsx
185      Ex 8-03 Qn3 (for iNZight).xlsx
185      Hotdogs.xlsx
186      Ex 8-03 Qn4a (for iNZight).xlsx
186      Ex 8-03 Qn4b (for iNZight).xlsx
186      Ex 8-03 Qn4c (for iNZight).xlsx
186      Sleepless.xlsx
186      Ex 8-03 Qn 5 (for iNZight).xlsx
192      South Island rivers.xlsx
196      Top Gear.xlsx
196      Crowe.xlsx
196     
2011 Schools Data.xlsx
214      Balloons.xlsx
214      Many Medians.xlsx
215      Windsurfing.xlsx
215      Shoes.xlsx
219      Jogging.xlsx
220      Fuel usage.xlsx
220      Rubber Band.xlsx
220      Leaf cuttings.xlsx
221      Candle.xlsx
223      Paper Clips.xlsx
227      Saucepans.xlsx
227      Mould.xlsx
358     
NZ Census - families (ages of parents and children).xlsx
481      Frequency of tropical cyclones 1968-1989.xlsx
483      Earthquakes over magnitude 7 (1995-2005).xlsx



Additional time series data sets

Beer production.xlsx
Credit card statistics.xlsx
Daily maximum temperatures in Melbourne 1981-90.xlsx
Daily sales of paperback and hardcover books over a 30 day period.xlsx
Library books issued.xlsx
Melanoma in Connecticut 1936 to 1972.xlsx
Monthly sales in Australia of red wine from January 1980 to July 1995.xlsx
Monthly traffic fatalities in Ontario, Canada 1960-74.xlsx
NZ population male female.xlsx
NZ tree ring data 1256-1976.xlsx
Phone call charges (NY to SFO) 1915 to 1996.xlsx
Primary energy supply.xlsx
Purse snatchings in Hyde Park Chicago Jan 1969 to Sept 1973.xlsx
Real daily wages in pounds in the United Kingdom from 1260 to 1994.xlsx
Southern oscillation index.xlsx
Victoria motel data Jan 1980-June 1995.xlsx