Sigma Mathematics (NCEA Edition) 

These spreadsheets are Microsoft Excel 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                Answers


Worked examples

Chapter 2 – Time series analysis

13   Crime statistics (NZ) 1990 to 2004.xls
21   Moving median (order 5).xls
22   Moving mean (wool exports NZ) Order 4.xls
24   Centred moving averages.xls
29   Monthly Arrivals from Australia Jan 1991 to Aug 2001.xls
32   Supermarket sales different trend lines.xls
41   Index numbers for Cheese exports 1984-2004.xls
44   Multiplicative time series model.xls
45   Hotel nights for tourists in New Zealand 1990-2003 (answer).xls

Chapter 10  – Simultaneous linear equations

198 Fitting a parabola to three points.xls

Chapter 13  – Scatter diagrams and the correlation coefficient
260 Metro stations (table of calculations for r).xls
261 Metro stations (correlation).xls

Chapter 14 – Regression

283 Plotting residuals.xls
283 Plotting residuals 2.xls
288 Cricket chirps vs Temperature Regression calculations.xls
293 Cricket Chirps and Temperature (Regression).xls
299 Nuclear plants answer (Cost vs Generating capacity).xls
304 Cigarette use vs Lung Cancer - 44 US states.xls
306 TV Advertising Impressions.xls

Chapter 15 – The binomial distribution

314 Binomial probability graph for n = 5 and p = 0.25.xls

Chapter 20 – Modelling and curve-fitting

409 Logging deliveries.xls
415 Weight of a guinea pig.xls


Simulations and Interactive Spreadsheets

Chapter 3 – Distribution of the total and the sample mean

56   Distribution of total when tossing five dice.xls
59   Distribution of the sample mean.xls
63   Uniform distribution simulation.xls

Chapter 4 – Confidence intervals for means  

71  95% Confidence interval simulation.xls

Chapter 6 – Basic probability  

103 Breaking the stick.xls                                                                              

Chapter 7 – Expected value

125 Paper, scissors, stone.xls
136 Run of successful penalties.xls
141 Coin tossing simulation.xls

Chapter 10 – Simultaneous linear equations

186 3 by 3 Simultaneous Equation Solver.xls

Chapter 11 – Numerical methods of solving equations

217 Bisection method.xls
221 Newton-Raphson method.xls

Chapter 14 – Regression

281 Interactive Line of Best Fit.xls

Chapter 16 – The Poisson distribution

342 Poisson probability graph.xls


Data sets


Chapter 1 – Features of time series

9     Marriage and Divorce rates 1961-2003.xls
10   Lung disease deaths (UK) 1974 to 1979.xls 
11   Lynx trappings (Canada) 1821 to 1934.xls                                      

Chapter 2 – Time series analysis

15   Crime statistics (NZ) 1880 to 2004.xls
16   Jeans sales figures ( UK ) 1980 to 1985.xls
18   Cheese exports 1984-2004.xls
19   Kiwifruit exports 1984-2004.xls
19   Electricity Generation - New Zealand 1971-2003.xls
20   Road motor vehicles per thousand population.xls
26   UK traffic fatalities - monthly.xls
30   Monthly Arrivals from Australia Jan 1991 to Aug 2001.xls
33   Quarterly electricity use.xls
34   Bun run.xls
35   Swimming pool admissions 2002 to 2006.xls
36   Wool exports (NZ) 1985 to 1991.xls
37   Australian quarterly production of electricity March 1956 - Sep 1994.xls
42   Mean estimated resident population of New Zealand 1991-2004.xls
42   Wine exports 1989-2004.xls
43   Alpha-Beta-Gamma Share prices.xls
45   Hotel nights for tourists in New Zealand 1990-2003.xls
47   Violent offences 1952 - 2000.xls
48   Hotel nights - international comparisons.xls
48   Divorce - median age of husband and wife - 1991-2004.xls
49   Manatees and powerboats.xls
49   Smoking prevalence and consumption NZ 1985-2004.xls
52   NZ Tree ring data 1256-1976.xls
52   Victoria motel data Jan 1980 - June 1995.xls
52   Monthly traffic fatalities in Ontario, Canada 1960-74.xls
52   Monthly sales in Australia of red wine from January 1980 to July 1995.xls
53   Daily sales of paperback and hardcover books over a 30 day period.xls
53   Sunspot Numbers.xls
53   Daily maximum temperatures in Melbourne 1981-90.xls
53   Southern Oscillation Index.xls
53   Melanoma in Connecticut 1936 to 1972.xls
53   Phone call charges (NY to SFO) 1915-1996.xls
53   Real daily wages in pounds in the United Kingdom from 1260 to 1994.xls
53   Purse snatchings in Hyde Park Chicago Jan 1969 to Sept 1973.xls
53   Library books issued.xls
53   Credit card statistics.xls
53   Primary energy supply.xls
53   Beer production.xls
53   NZ Population male female.xls

Chapter 6 – Basic probability

109  NZ Census - Families (Ages of parents and children).xls

Chapter 13 – Scatter diagrams and the correlation coefficient

263   Fertility rate vs contraception use.xls
263   McDonaldsTM Nutrition Information.xls
264   Currency rates NZD vs AUD & USD.xls
265   Four sets of artificial bivariate data.xls
273   Airports vs Area vs Population.xls
274   Powerboat registrations vs Manatee fatalities (Florida 1977-2004).xls
275   World Bank Life Expectancy vs Fertility Ratios.xls
276   Poverty vs Corruption.xls  

Chapter 14 – Regression

286   Sand erosion data.xls
294   Height and arm-span for 25 adults.xls
294   Video vs DVD hires.xls
295   World Metro List (length vs stations).xls
299   Nuclear plants data (Cost vs Generating capacity).xls
301   Alcohol and tobacco spending, UK.xls
302   Wine consumption and heart disease.xls
303   Leaning Tower of Pisa.xls
304   Cigarette use vs Lung Cancer - 44 US states.xls
310   Destinations and airfares from Auckland.xls  

Chapter 16 – The Poisson distribution

343   Frequency of Tropical Cyclones 1968-1989.xls
345   Earthquakes over magnitude 7 (1995-2005).xls

Chapter 20 – Modelling and curve-fitting

419   Heartbeat Rates of Animals.xls
422   Altitude vs atmospheric pressure.xls
423   North Island population.xls
424   Obesity table (height vs weight).xls
430   Cell-phone sales over a ten-year period.xls   


Answers 

460   Ex 2-01 Qn 1 Answers.xls
460   Ex 2-01 Qn 2 Answers.xls
460   Ex 2-02 Qn 1 Answers.xls
460   Ex 2-02 Qn 2 Answers.xls
460   Ex 2-02 Qn 3 Answers.xls
461   Ex 2-03 Qn 1 Answers.xls
461   Ex 2-03 Qn 2 Answers.xls
461   Ex 2-03 Qn 3 Answers.xls
461   Ex 2-03 Qn 8 Answers.xls
461   Ex 2-04 Qn 1 Answers.xls
461   Ex 2-04 Qn 2 Answers.xls
461   Ex 2-04 Qn 4 Answers.xls
462   Ex 2-04 Qn 6 Answers.xls
462   Ex 2-05 Qn 1 Answers.xls
462   Ex 2-05 Qn 2 Answers.xls
463   Ex 2-05 Qn 3 Answers.xls
463   Ex 2-06 Qn 1 Answers.xls
463   Ex 2-06 Qn 2 Answers.xls
463   Ex 2-06 Qn 3 Answers.xls
464   Ex 2-06 Qn 4 Answers.xls
464   Ex 2-06 Qn 5 Answers.xls
465   Uniform distribution simulation.xls  
469   Creating a margin of error table.xls
470   Breaking the stick.xls
472   Random secretary – letters and envelopes.xls
473   The birthday problem.xls
474   Paper, scissors, stone.xls
475   Run of successful penalties.xls
477   Stirling’s formula (answers).xls
481   The Abbot of Canterbury’s Puzzle.xls                                                      
484   NPK Investigation - Qn 3.xls
484   NPK Investigation - Qn 4.xls
486   Ex 11-02 Answers.xls
487   Ex 11-05 Answers - Bisection method.xls
488   Ex 11-07 Answers - Newton-Raphson method.xls
494   Ex 13-01 Qn 1 Answers.xls
494   Ex 13-01 Qn 3 Answers.xls
495   Ex 13-03 Qn 1 Answers.xls
495   Ex 13-03 Qn 2 Answers.xls
495   Ex 13-03 Qn 3 Answers.xls
495   Ex 13-03 Qn 4 Answers.xls
495   Ex 13-03 Qn 5 Answers.xls
495   Ex 13-03 Qn 6 Answers.xls
495   Ex 13-03 Qn 7 Answers.xls
496   Ex 13-04 Qn 9 Answers.xls
496   Ex 13-05 Qn 1 Answers.xls
497   Ex 13-05 Qn 2 Answers.xls
497   Ex 13-05 Qn 3 Answers.xls
497   Ex 13-05 Qn 4 Answers.xls
497   Ex 13-05 Qn 5 Answers.xls
498   Interactive Line of Best Fit (answers).xls
498   Ex 14-01 Qn 3 Answers.xls
499   Ex 14-01 Qn 4 Answers.xls
499   Ex 14-01 Qn 6 Answers.xls
499   Ex 14-02 Qn 1 Answers.xls
499   Ex 14-02 Qn 2 Answers.xls
499   Ex 14-02 Qn 3 Answers.xls
499   Ex 14-02 Qn 4 Answers.xls
500   Ex 14-03 Qn 2 Answers.xls
500   Ex 14-03 Qn 3 Answers.xls
501   Ex 14-03 Qn 4 Answers.xls
501   Ex 14-04 Qn 1 Answers.xls
501   Ex 14-04 Qn 2 Answers.xls
501   Ex 14-04 Qn 3 Answers.xls
501   Ex 14-04 Qn 4 Answers.xls
502   Ex 14-04 Qn 5 Answers.xls
503   Binomial probability graph for n = 20 and p = 0.6.xls
504   Pepys, Newton and the dice.xls
505   Bonus RAM graph.xls                                                                                     
506   Frequency of Tropical Cyclones 1968-1989 (Answers).xls
507   Ex 16-03 Qn 1 Answers.xls
507   Ex 16-03 Qn 2 Answers.xls
513   Ex 19-01 Qn 11 Answers.xls
513   Euler's number.xls
515   Catenary categories.xls
515   Ex 20-01 Qn 1 Answers.xls
515   Ex 20-01 Qn 2 Answers.xls
515   Ex 20-01 Qn 3 Answers.xls
516   Ex 20-01 Qn 5 Answers.xls
516   Zettabytes and Yottabytes Answers.xls
516   Ex 20-02 Qn 1 Answers.xls
516   Ex 20-02 Qn 2 Answers.xls
516   Ex 20-02 Qn 3 Answers.xls
516   Ex 20-02 Qn 4 Answers.xls
516   Ex 20-02 Qn 6 Answers.xls
517   Kleiber's law answers.xls
517   Ex 20-03 Qn 1 Answers.xls
517   Ex 20-03 Qn 2 Answers.xls
517   Ex 20-03 Qn 3 Answers.xls
517   Ex 20-03 Qn 4 Answers.xls
517   Ex 20-03 Qn 5 Answers.xls
517   Ex 20-03 Qn 6 Answers.xls
517   Ex 20-03 Qn 7 Answers.xls
518   Ex 20-03 Qn 8 Answers.xls
518   Benford's Law answers.xls
519   Ex 20-06 Qn 1 Answers.xls
520   Ex 20-07 Qn 1 Answers.xls
520   Ex 20-07 Qn 2 Answers.xls