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