Beta Mathematics 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 

196   Drawing parabolas
424   Pie graphs
443   Using a spreadsheet to calculate the mean, median and mode
463   PPDAC multivariate data set

 

Simulations/Interactive

491   Scratch Kiwi Simulation (Have I won a prize yet?)       

Data sets

428  NZ Regional Council Population 2006.xls (Ex 30.01 #9)
428  Passenger Arrivals at
Auckland Airport by country.xls (Ex 30.01 #10)
429  Digital cameras - weight vs price.xls (Ex 30.01 #12)
436  New car registrations 1987-2006.xls
440  Distances from
Auckland Airport.xls
443 
Building consent fees.xls
445  Diving scores.xls
450  Credit card Fees.xls
452 
Weekly rental prices in Auckland.xls
460  Age profile of major vehicle types at year end 2006.xls
463  Multivariate dataset.xls
470  Dog and cat food - yearly costs.xls
471  Mobile phones.xls
472  Sugar consumption in drinks (monthly).xls

 

Answers 

15    How do spreadsheets handle integers
62    Depreciation (car values answer)
65    The house market
112  Child dose for medicines (Ex 7.06 #1)
112  Fahrenheit/Celsius conversions  (Ex 7.06 #2)
112  The humerus (Ex 7.06 #3)
124  Skid marks
197  Exercise 13.11
428  NZ Regional Council Population 2006.xls Answers (Ex 30.01 #9)
428  Passenger Arrivals at
Auckland Airport by country.xls Answers (Ex 30.01 #10)
429  Digital cameras - weight vs price.xls (Ex 30.01 #12) Answers
436  New car registrations 1987-2006.xls (Ex 30.03 #3) Answers
437  Cinema ticket sales (Ex 30.03 #4) Answers
440  Distances from Auckland Airport (Answers)
443  Building consent fees Answers.xls
445  Diving scores Answers.xls
450  Creditcard Fees Answers.xls
452  Weekly rental prices in Auckland Answers.xls
460  The old dunga Answers.xls
468  Local street car speed investigation.xls
472  Sugar consumption in drinks (monthly) Answers.xls
504
  Depreciation (car values answer)
504  The house market
509  Child dose for medicines (Ex 7.06 #1)
509  Fahrenheit/Celsius conversions  (Ex 7.06 #2)
509  The humerus (Ex 7.06 #3)
511  Skid marks
525  Exercise 13.11
559  NZ Regional Council Population 2006.xls Answers (Ex 30.01 #9)
559  Passenger Arrivals at
Auckland Airport by country.xls Answers (Ex 30.01 #10)
561  Digital cameras - weight vs price.xls (Ex 30.01 #12) Answers
562  New car registrations 1987-2006.xls (Ex 30.03 #3) Answers
563  Distances from Auckland Airport (Answers)
563
  Cinema ticket sales (Ex 30.03 #4) Answers
563  Building consent fees Answers.xls
563  Diving scores Answers.xls
564  Creditcard Fees Answers.xls
565  Weekly rental prices in Auckland Answers.xls
567  The old dunga Answers.xls
568  Local street car speed investigation.xls
570  Sugar consumption in drinks (monthly) Answers.xls