Gamma Fundamentals spreadsheets

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

Worked examples                Simulations/Interactive                Data Sets                Answers


Worked examples
 

279   Wrist size and gender analysis.xls
285   Minimum air temperatures vs latitude.xls
294   Foot length and handspan analysis.xls
326   Population Growth 1951 - 2006.xls



Simulations/Interactive

374   Die rolling simulation (does the expected value appear).xls
375   Car hire simulation.xls
375   Counterfeit ticket simulation.xls
376   Paper,scissors, rock.xls


Data sets

262  Gamma Mathematics Data Set.xls
274  Weekly supermarket bills.xls
275 
Petrol stations fills - P and Q.xls
275  Toheroa lengths - Oreti and Ninety Mile Beach.xls
283  April sunshine hours and rainfall totals.xls
289  Price and percentage of air in ice-cream.xls
289  Dishwasher prices and water use data.xls
290  Height vs arm span.xls
290  Water and power consumption at a hotel.xls
291  Accommodation prices in Christchurch & Queenstown.xls
291  Digital cameras - price and weight.xls

296
  Cyclone data 2007-2009.xls
320  Fat content and price data for ice-cream.xls
324  Public transport in Wellington.xls
327  Arrivals from Australia Jan 2004 to Dec 2009.xls
329  International Tourist Arrivals by Country 1991-2009.xls
329  Monthly electricity bills.xls


Answers
 

16    Rounding (Answers).xls
48    GST1 (Answers).xls
49    GST2 (Answers).xls
151  Water tank (Answers).xls
274  Weekly supermarket bills - A and B (Answers).xls
296  Cyclone data 2007-2009 (Answers).xls
315  Population of North and South Islands June 2009 (Answers).xls
328  Arrivals from Australia Jan 2004 to Dec 2009 (Answers).xls
379  Rounding (Answers).xls
383  GST1 (Answers).xls
383  GST2 (Answers).xls
400  Water tank (Answers).xls

420  Weekly supermarket bills - A and B (Answers).xls
425  Cyclone data 2007-2009 (Answers).xls
427  Population of North and South Islands June 2009 (Answers).xls
430  Arrivals from Australia Jan 2004 to Dec 2009 (Answers).xls