Theta Mathematics
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
Data
Sets
Answers
Worked
examples
Chapter 6 - Quadratic equations
59 Quadratic equation solver.xls
Chapter 10 - Factored polynomials and their graphs
97 Parabola by plotting points.xls
108 Roller-coaster.xls
Chapter 11 Hyperbolas and
circles
126 Marathon times.xls
Chapter 12 Exponential and
logarithmic graphs
141 Graph of log to base 3.xls
Chapter 13 Transformation of
graphs and modelling
145 Reading age.xls
Chapter 14 Introducing
differentiation
163 Shrinking chord.xls
Chapter 17 Calculus
applications
203 Napier-Hastings Warehouse.xls
210 Horse-paddock.xls
Chapter 20 Sample statistics
and data display
244 Mean, median and mode.xls
250 Frequency table and bar graph.xls
261 Range and interquartile range (results).xls
263 Boxplot.xls
268 Standard deviation for individual data (result).xls
273 Coffee cups.xls
Chapter 21 Sampling
processes and making inferences
288 Real estate cluster sample.xls
288 Auckland real estate prices (sample).xls
Chapter 23 Experimental
probability and simulation methods
321 Tossing a fair coin simulation.xls
324 Heads or Tails.xls
325 Day of the week simulation (20 trials).xls
326 Day of the week simulation (1000 trials).xls
326 Waiting for heads.xls
335 Predator-prey
simulation 1 (cats and mice).xls
Chapter 24 The normal
distribution
350 normdist result.xls
350 normdist differences result.xls
356 Witch of Agnesi.xls
359 norminv.xls
364 Normal simulation.xls
365 Normal simulation (histogram).xls
Chapter 25 Introducing
sequences
375 Graphing a sequence.xls
Chapter 26 Arithmetic
sequences
385 Parking building calculations.xls
Chapter 28 Growth and decay
409 Adding to the original investment.xls
Chapter 32 Practical
trigonometry
448 Croquet-hoop.xls
449 Kidney-shaped pool.xls
Chapter 33 Circular measure
456 Polygon society.xls
Chapter 34 Trigonometric
graphs and equations
478 sin graph using radians.xls
Chapter 35 Further trig
graphs and equations
492 Clyde average daily temperatures.xls
496 Picturing a solution to a trig equation (degrees).xls
SimulationsChapter
23 Experimental probability and simulation methods
321 Tossing a fair coin simulation.xls
324 Heads or Tails.xls
325 Day of the week simulation (20 trials).xls
326 Day of the week simulation (1000 trials).xls
326 Waiting for heads.xls
327 Fives and sixes (200 tosses) simulation.xls
328 Coloured cards simulation.xls
329 Boy or girl in 4-child family simulation (1000 trials)
329 Three members of a family simulation.xls
329 The gamblers simulation.xls
330 Chinese Lunar Calendar simulation (1000 trials).xls
330 Dartboard score simulation.xls
331 Overbooked car-ferry simulation.xls
332 Triangle inequality simulation
332 Right-angled, acute & obtuse triangle simulation.xls
335 Predator-prey simulation 1 (cats and mice).xls
336 Predator-prey simulation 2 (sharks and fish).xls
337 Predator-prey simulation 3 (ferrets and fantails).xls
337 Predator-prey simulation 4 (toheroa and off-road vehicles).xls
Chapter 24 The normal
distribution
364 Normal simulation.xls
365 Normal simulation (histogram).xls
366 Normal simulation answers.xls
366 Soft drink simulation (500 values).xls
366 Excess baggage simulation (400 values).xls
NCEA 2.6 Revision Exercises
367 The 12 Houses (answer).xls
Data setsChapter
20 Sample statistics and data display
245, 262,270 Christchurch Temperature data Feb 2005.xls
257 Motorcyclist data.xls
Chapter 21 Sampling
processes and making inferences
283 116 Bag Weights.xls
283 Oscar
Winners 1928 to 2004.xls
284 Olive
grove production.xls
286 Longman
Mathematics Series Statistics.xls
NCEA 2.5 Revision Exercises
291 Toyota
Corolla Prices.xls
Answers
44 Off
to the freezing works.xls
59 Quadratic equation
solver answers.xls
74 Acoustic
concert hall.xls
108 Roller-coaster
answers.xls
117 Dance
Floor Ans.xls
126 Drawing
a semi-circle.xls
131 Simple
exponential graph.xls
139 Exponential
and log graphs investigation answers
143 Different
bases for log graphs.xls
145 Reading
age answers.xls
164 Shrinking
chords answers.xls
186 Combining
trapeziums Answers.xls
203 Napier-Hastings
Warehouse Answers.xls
210 Horse-paddock
answers.xls
245, 262, 270 Christchurch
Temperature data Feb 2005 answers.xls
257 Motorcyclist
accident analysis.xls
273 Coffee
cups (answer).xls
277 Numeral
soup (answer).xls
283 School
Bag Weight Analysis.xls
283 Oscar
age analysis.xls
284 Olive
grove sampling (answers).xls
291 Toyota
Corolla Prices Analysis.xls
327 Fives
and sixes (200 tosses) simulation.xls
328 Coloured
Cards Simulation.xls
329 Boy or girl in 4-child family simulation (1000 trials)
329 Three members of a family simulation.xls
329 The gamblers simulation.xls
330 Chinese Lunar Calendar simulation (1000 trials).xls
330 Dartboard score simulation.xls
331 Overbooked car-ferry simulation.xls
332 Triangle inequality simulation
332 Right-angled, acute & obtuse triangle simulation.xls
335 Predator-prey simulation 1 (cats and mice).xls
336 Predator-prey simulation 2 (sharks and fish).xls
337 Predator-prey simulation 3 (ferrets and fantails).xls
337 Predator-prey simulation 4 (toheroa and off-road vehicles).xls
356 Witch
of Agnesi answers.xls
366 Normal
simulation answers.xls
366 Soft
drink simulation (500 values).xls
366 Excess
baggage simulation (400 values).xls
367 The
12 Houses (answer).xls
370 Identical
triplets answers.xls
375 Ex
25-04 and Ex 25-05.xls
377 Ex
25-06.xls
379 Fibonacci
sequence answers.xls
385 Parking
building calculations answers.xls
388 Holiday
savings plan.xls
388 The
51 Pearls.xls
391 Watering
down drinks answers.xls
392 Grains
of rice answers.xls
396 The
four gifting schemes.xls
405 Business
depreciation answers.xls
409 The
sharebroker's report.xls
410 Ex
28-04 answers.xls
446 Ex
32-02 Qn 3 answers.xls
448 Croquet-hoop
answers.xls
448 Penalty-spot
answers.xls
449 Kidney-shaped
pool answers.xls
456 Polygon
society answers.xls
468 Water-trough
calculations.xls
472 Trig
graphs.xls
478 simple
trig graphs using radians.xls
509 Off
to the freezing works.xls
512 Quadratic equation
solver answers.xls
514 Acoustic
concert hall.xls
523 Roller-coaster
answers.xls
527 Dance
Floor Ans.xls
529 Drawing
a semi-circle.xls
530 Simple
exponential graph.xls
532 Exponential
and log graphs investigation answers
534 Different
bases for log graphs.xls
534 Reading
age answers.xls
540 Shrinking
chords answers.xls
543 Combining
trapeziums Answers.xls
544 Napier-Hastings
Warehouse Answers.xls
545 Horse-paddock
answers.xls
551, 553, 554 Christchurch
Temperature data Feb 2005 answers.xls
553 Motorcyclist
accident analysis.xls
555 Coffee
cups (answer).xls
556 Numeral
soup (answer).xls
557 School
Bag Weight Analysis.xls
557 Oscar
age analysis.xls
557 Olive
grove sampling (answers).xls
558 Toyota
Corolla Prices Analysis.xls
561 Fives
and sixes (200 tosses) simulation.xls
561 Coloured
Cards Simulation.xls
561 Boy or girl in 4-child family simulation (1000 trials)
561 Three members of a family simulation.xls
561 The gamblers simulation.xls
561 Chinese Lunar Calendar simulation (1000 trials).xls
561 Dartboard score simulation.xls
561 Overbooked car-ferry simulation.xls
561 Triangle inequality simulation
562 Right-angled, acute & obtuse triangle simulation.xls
562 Predator-prey simulation 1 (cats and mice).xls
562 Predator-prey simulation 2 (sharks and fish).xls
562 Predator-prey simulation 3 (ferrets and fantails).xls
562 Predator-prey simulation 4 (toheroa and off-road vehicles).xls
563 Witch
of Agnesi answers.xls
564 Normal
simulation answers.xls
564 Soft
drink simulation (500 values).xls
564 Excess
baggage simulation (400 values).xls
564 The
12 Houses (answer).xls
565 Identical
triplets answers.xls
566 Ex
25-04 and Ex 25-05.xls
566 Ex
25-06.xls
566 Fibonacci
sequence answers.xls
567 Parking
building calculations answers.xls
567 Holiday
savings plan.xls
567 The
51 Pearls.xls
568 Watering
down drinks answers.xls
568 Grains
of rice answers.xls
569 The
four gifting schemes.xls
569 Business
depreciation answers.xls
570 The
sharebroker's report.xls
570 Ex
28-04 answers.xls
574 Ex
32-02 Qn 3 answers.xls
574 Croquet-hoop
answers.xls
574 Penalty-spot
answers.xls
574 Kidney-shaped
pool answers.xls
575 Polygon
society answers.xls
576 Water-trough
calculations.xls
577 Trig
graphs.xls
577 simple
trig graphs using radians.xls