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 interactive

Chapter 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 sets

Chapter 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