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 and interactive
Data
Sets
Answers
Worked
examples
Chapter 3 - Polynomials and
their graphs
36
Parabola
by plotting points.xls
Chapter 4 - Functions - domain
and range
56 Absolute
value graph.xls
Chapter 5 - Other mathematical
functions and their graphs
75 Marathon
times.xls
78 Exponential
graph.xls
88 Graph
of log to base 3.xls
Chapter 7 - Trigonometric
graphs
105 Graph
of sin(x) in degrees.xls
108 sin
graph using radians.xls
128 Picturing
a solution to a trig equation (degrees).xls
Chapter 26 - The normal
distribution
399 Standard
deviation for individual data (result).xls
420 normdist
result.xls
420 normdist
differences result.xls
431
norminv.xls
Chapter 27 - Simulation
methods
451 Normal
simulation (histogram).xls
Simulations
and interactiveChapter
7 - Trigonometric graphs
124
Clyde
average daily temperatures.xls
Chapter 27 - Simulation
methods
439 Heads
or Tails.xls
440 Day
of the week simulation (20 trials).xls
440 Day
of the week simulation (1000 trials).xls
441 Waiting
for heads.xls
441 Fives
and sixes (200 tosses) simulation.xls
442
Coloured cards simulation.xls
444 World
Series simulation.xls
445 Boy
or girl in 4-child family simulation (1000 trials).xls
445 Three
members of a family simulation (1000 trials).xls
445 The
gamblers simulation (1000 trials).xls
446 Chinese
Lunar Calendar simulation (1000 trials).xls
447 Zodiac
simulation (1000 trials).xls
447 Gemini
simulation (1000 trials).xls
447 Dartboard
score simulation.xls
448 Overbooked
car-ferry simulation.xls
448 Triangle
inequality simulation.xls
449 Right-angled,
acute & obtuse triangle simulation.xls
451 Normal
simulation (histogram).xls
452 Normal
simulation (Answers).xls
452 Soft
drink simulation (500 values).xls
452 Excess
baggage simulation (400 values).xls
456 Predator-prey
simulation 1 (cats and mice).xls
456 Predator-prey
simulation 2 (sharks and fish).xls
457 Predator-prey
simulation 3 (ferrets and fantails).xls
457 Predator-prey
simulation 4 (toheroa and off-road vehicles).xls
Data setsChapter
25 Further probability
388
Regions
of NZ (for drowning statistics).xls
Chapter 26 - The normal distribution
401
Christchurch
temperature data.xls
404 Coffee
cups.xls
Answers
48
Roller-coaster
(Answers).xls
59 Reading
age (Answers).xls
70 Dance
floor (Answers).xls
79 Ex
5-05 #5ab (Answers).xls
81 Ex
5-07 #4 (Answers).xls
85 Exponential
and log graph investigation (Answers).xls
90 Different
bases for log graphs (Answers).xls
112 Simple
trig graphs using radians (Answers).xls
124 Clyde
average daily temperatures.xls
141 Ex
8-05 Qn 1 (Answers).xls
141 Ex
8-05 Qn 2 (Answers).xls
157 tan
graph with angles in degrees.xls
182 Croquet-hoop
(Answers).xls
182 Penalty-spot
(Answers).xls
190 Polygon
society (Answers).xls
205 Water-trough
calculations.xls
251 Play
and rewind (Answers).xls
265 Quadratic
equation solver (Answers).xls
270 Tartaglia
and Cardano cubic equation solver (Answers).xls
298 Shrinking
chord (Answers).xls
331 Combining
trapeziums (Answers).xls
351 Napier-Hastings
warehouse (Answers).xls
358 Horse-paddock
(Answers).xls
401 Christchurch
temperature data (Answers).xls
404 Coffee
cups (Answers).xls
426 Witch
of Agnesi (Answers).xls
441 Fives
and sixes (200 tosses) simulation.xls
442 Coloured
cards simulation.xls
445 Boy
or girl in 4-child family simulation (1000 trials).xls
445 Three
members of a family simulation (1000 trials).xls
445 The
gamblers simulation (1000 trials).xls
446 Chinese
Lunar Calendar simulation (1000 trials).xls
447 Zodiac
simulation (1000 trials).xls
447 Gemini
simulation (1000 trials).xls
447 Dartboard
score simulation.xls
448 Overbooked
car-ferry simulation.xls
448 Triangle
inequality simulation.xls
449 Right-angled,
acute & obtuse triangle simulation.xls
452 Normal
simulation (Answers).xls
452 Soft
drink simulation (500 values).xls
452 Excess
baggage simulation (400 values).xls
456 Predator-prey
simulation 1 (cats and mice).xls
456 Predator-prey
simulation 2 (sharks and fish).xls
457 Predator-prey
simulation 4 (toheroa and off-road vehicles).xls
481 Acoustic
concert hall (Answers).xls
493 Roller-coaster
(Answers).xls
495 Reading
age (Answers).xls
500 Dance
floor (Answers).xls
501 Ex
5-05 #5ab (Answers).xls
501 Ex
5-07 #4 (Answers).xls
503 Exponential
and log graph investigation (Answers).xls
504 Different
bases for log graphs (Answers).xls
512 Simple
trig graphs using radians (Answers).xls
514 Clyde
average daily temperatures.xls
518 Ex
8-05 Qn 1 (Answers).xls
518 Ex
8-05 Qn 2 (Answers).xls
521 tan
graph with angles in degrees.xls
524 Croquet-hoop
(Answers).xls
524 Penalty-spot
(Answers).xls
525 Polygon
society (Answers).xls
526 Water-trough
calculations.xls
535 Play
and rewind (Answers).xls
538 Quadratic
equation solver (Answers).xls
538 Tartaglia
and Cardano cubic equation solver (Answers).xls
543 Shrinking
chord (Answers).xls
549 Combining
trapeziums (Answers).xls
551 Napier-Hastings
warehouse (Answers).xls
552 Horse-paddock
(Answers).xls
557 Christchurch
temperature data (Answers).xls
557 Coffee
cups (Answers).xls
558 Witch
of Agnesi (Answers).xls
559 Fives
and sixes (200 tosses) simulation.xls
559 Coloured
cards simulation.xls
560 Boy
or girl in 4-child family simulation (1000 trials).xls
560 Three
members of a family simulation (1000 trials).xls
560 The
gamblers simulation (1000 trials).xls
560 Chinese
Lunar Calendar simulation (1000 trials).xls
560 Zodiac
simulation (1000 trials).xls
560 Gemini
simulation (1000 trials).xls
560 Dartboard
score simulation.xls
560 Overbooked
car-ferry simulation.xls
560 Triangle
inequality simulation.xls
560 Right-angled,
acute & obtuse triangle simulation.xls
561 Normal
simulation (Answers).xls
561 Soft
drink simulation (500 values).xls
561 Excess
baggage simulation (400 values).xls
561 Predator-prey
simulation 1 (cats and mice).xls
561 Predator-prey
simulation 2 (sharks and fish).xls
561 Predator-prey
simulation 4 (toheroa and off-road vehicles).xls
565 Acoustic
concert hall (Answers).xls