Theta Dimensions 

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

3          Parabola by plotting points.xls
23        Absolute value graph.xls
42        Marathon times.xls
45        Exponential graph.xls
55        Graph of log to base 3.xls
72        Graph of sin(x) in degrees.xls
75        sin graph using radians.xls
95        Picturing a solution to a trig equation (degrees).xls
115      Generating sequences (1).xls
115      Generating sequences (2).xls
115      Generating sequences (3).xls
115      Generating sequences (4).xls
116      Generating sequences (5).xls
117      Recursive sequences (1).xls
117      Recursive sequences (2).xls
156      Adding to the original investment.xls

333      Cholesterol lowering medicine.xls
407
      Standard deviation for individual data (result).xls
428      normdist result.xls
428      normdist differences result.xls
439      norminv.xls
459      Normal simulation (histogram).xls

Simulations and interactive

91        Clyde average daily temperatures.xls
447      Heads or Tails.xls
448      Day of the week simulation (20 trials).xls
448      Day of the week simulation (1000 trials).xls
449      Waiting for heads.xls
449      Fives and sixes (200 tosses) simulation.xls
450      Coloured cards simulation.xls
451      World Series simulation.xls
452      Boy or girl in 4-child family simulation (1000 trials).xls
453      Three members of a family simulation (1000 trials).xls
453      The gamblers simulation (1000 trials).xls
453      Chinese Lunar Calendar simulation (1000 trials).xls
454      Zodiac simulation (1000 trials).xls
455      Gemini simulation (1000 trials).xls
455      Dartboard score simulation.xls
456      Overbooked car-ferry simulation.xls
456      Triangle inequality simulation.xls
457      Right-angled, acute & obtuse triangle simulation.xls
459      Normal simulation (histogram).xls
460      Normal simulation (Answers).xls
460      Soft drink simulation (500 values).xls
460      Excess baggage simulation (400 values).xls
464      Predator-prey simulation 1 (cats and mice).xls
464      Predator-prey simulation 2 (sharks and fish).xls
465      Predator-prey simulation 3 (ferrets and fantails).xls
465      Predator-prey simulation 4 (toheroa and off-road vehicles).xls



Data sets

304      116 Bag Weights.xls
305      Oscar Winners 1928 to 2010.xls
306      Olive grove production.xls
308      Pearson Mathematics Series Statistics.xls
315      Diesel fills (sample of 60).xls
315      Sample of size 40 from SURF dataset.xls
315      Toheroa lengths (sample of 500).xls
319      Water use - Auckland and Wellington.xls
321      Milk tanker deliveries - September and October.xls
325      CensusAtSchool Reaction times by gender.xls
325      CensusAtSchool Memory speed by age.xls
325      CensusAtSchool Sleeping time by mode of transport to school.xls
325      SURF dataset.xls
325      Toyota Corolla Prices.xls
335      Exercise and Pulse.xls
335      Peak Flow Rates.xls
336      Sugary Snack Intake.xls
337      Weight loss products.xls
341      Tumour reduction.xls
341      Dissolving Chocolate.xls
344      Wine choices.xls
345      Hockey Shots.xls
396      Regions of NZ (for drowning statistics).xls
409      Christchurch temperature data.xls
412      Coffee cups.xls


Answers 

15        Roller-coaster (Answers).xls
27        Reading age (Answers).xls
37        Dance floor (Answers).xls
46        Ex 3-05 #5ab (Answers).xls 
48        Ex 3-07 #4 (Answers).xls  
52        Exponential and log graph investigation (Answers).xls
57        Different bases for log graphs (Answers).xls
79        Simple trig graphs using radians (Answers).xls
91        Clyde average daily temperatures.xls
108      Ex 6-05 Qn 1 (Answers).xls  
108      Ex 6-05 Qn 2 (Answers).xls  
111      Identical triplets (Answers).xls
116      Ex 7-04 and Ex 7-05 (Answers).xls
117      Ex 7-06 (Answers).xls
119      Fibonacci sequence (Answers).xls
128      Parking building calculations (Answers).xls
131      Holiday savings plan (Answers).xls
132      The 51 Pearls (Answers).xls
135      Watering down drinks (Answers).xls
136      Grains of rice (Answers).xls
140      The four gifting schemes (Answers).xls
150      Business depreciation (Answers).xls
155      The sharebroker's report (Answers).xls
157      Ex 10-04 (Answers).xls
158      KiwiSaver (Answers).xls
174      tan graph with angles in degrees.xls
199      Croquet-hoop (Answers).xls
199      Penalty-spot (Answers).xls
207      Polygon society (Answers).xls
222      Water-trough calculations.xls
304      School Bag Weight Analysis (Answers).xls
305      Oscar age analysis (Answers).xls
307      Olive grove sampling (Answers).xls
318      Ex 19-02 Qn 1 (Data sets P and Q) (Answers).xls
319      Ex 19-02 Qn 2 (Haemoglobin data) (Answers).xls
319      Ex 19-02 Qn 3 (Auckland vs Wellington water use) (Answers).xls
321      Ex 19-02 Qn 6 (Milk tanker deliveries - Sep and Oct) (Answers).xls
325      Ex 19-03 Qn 1 (Hourly wage rate - males vs females) (Answers).xls
326      Ex 19-03 Qn 2 (Weekly wage - degree vs vocational) (Answers).xls
326      Ex 19-03 Qn 3 (Toyota Corolla prices) (Answers).xls
327      Ex 19-03 Qn 4 (Reaction times - boys vs girls) (Answers).xls
327      Ex 19-03 Qn 5 (Memory speed times - Year 9 vs Year 12) (Answers).xls
327      Ex 19-03 Qn 6 (Sleeping time - girls vs boys) (Answers).xls
327      Ex 19-03 Qn 7 (Sleeping time - walking vs other) (Answers).xls
348      Random walk.xls

409      Christchurch temperature data (Answers).xls
412      Coffee cups (Answers).xls
434      Witch of Agnesi (Answers).xls
449      Fives and sixes (200 tosses) simulation.xls
450      Coloured cards simulation.xls
453      Boy or girl in 4-child family simulation (1000 trials).xls
453      Three members of a family simulation (1000 trials).xls
453      The gamblers simulation (1000 trials).xls
453      Chinese Lunar Calendar simulation (1000 trials).xls
454      Zodiac simulation (1000 trials).xls
455      Gemini simulation (1000 trials).xls
455      Dartboard score simulation.xls
456      Overbooked car-ferry simulation.xls
456      Triangle inequality simulation.xls
457      Right-angled, acute & obtuse triangle simulation.xls
460      Normal simulation (Answers).xls
460      Soft drink simulation (500 values).xls
460      Excess baggage simulation (400 values).xls
464      Predator-prey simulation 1 (cats and mice).xls
464      Predator-prey simulation 2 (sharks and fish).xls
465      Predator-prey simulation 4 (toheroa and off-road vehicles).xls
472      Roller-coaster (Answers).xls
474      Reading age (Answers).xls
479      Dance floor (Answers).xls
480      Ex 3-05 #5ab (Answers).xls
480      Ex 3-07 #4 (Answers).xls
482      Exponential and log graph investigation (Answers).xls
483      Different bases for log graphs (Answers).xls
491      Simple trig graphs using radians (Answers).xls
493      Clyde average daily temperatures.xls
497      Ex 6-05 Qn 1 (Answers).xls
497      Ex 6-05 Qn 2 (Answers).xls
498      Identical triplets (Answers).xls
499      Ex 7-04 and Ex 7-05 (Answers).xls
499      Ex 7-06 (Answers).xls
499      Fibonacci sequence (Answers).xls
500      Parking building calculations (Answers).xls
501      Holiday savings plan (Answers).xls
501      The 51 Pearls (Answers).xls
501      Watering down drinks (Answers).xls
501      Grains of rice (Answers).xls
502      The four gifting schemes (Answers).xls
503      Business depreciation (Answers).xls
503      The sharebroker's report (Answers).xls
503      Ex 10-04 (Answers).xls
503      KiwiSaver (Answers).xls
506      tan graph with angles in degrees.xls
509      Croquet-hoop (Answers).xls
509      Penalty-spot (Answers).xls
510      Polygon society (Answers).xls
511      Water-trough calculations.xls
523      School Bag Weight Analysis (Answers).xls
523      Oscar age analysis (Answers).xls
524      Olive grove sampling (Answers).xls
525      Ex 19-02 Qn 1 (Data sets P and Q) (Answers).xls
525      Ex 19-02 Qn 2 (Haemoglobin data) (Answers).xls
526      Ex 19-02 Qn 3 (Auckland vs Wellington water use) (Answers).xls
527      Ex 19-02 Qn 6 (Milk tanker deliveries - Sep and Oct) (Answers).xls
528      Ex 19-03 Qn 1 (Hourly wage rate - males vs females) (Answers).xls
529      Ex 19-03 Qn 2 (Weekly wage - degree vs vocational) (Answers).xls
530      Ex 19-03 Qn 3 (Toyota Corolla prices) (Answers).xls
531      Ex 19-03 Qn 4 (Reaction times - boys vs girls) (Answers).xls
532      Ex 19-03 Qn 5 (Memory speed times - Year 9 vs Year 12) (Answers).xls
533      Ex 19-03 Qn 6 (Sleeping time - girls vs boys) (Answers).xls
534      Ex 19-03 Qn 7 (Sleeping time - walking vs other) (Answers).xls
536      Random walk.xls

545      Christchurch temperature data (Answers).xls
545      Coffee cups (Answers).xls
546      Witch of Agnesi (Answers).xls
547      Fives and sixes (200 tosses) simulation.xls
547      Coloured cards simulation.xls
548      Boy or girl in 4-child family simulation (1000 trials).xls
548      Three members of a family simulation (1000 trials).xls
548      The gamblers simulation (1000 trials).xls
548      Chinese Lunar Calendar simulation (1000 trials).xls
548      Zodiac simulation (1000 trials).xls
548      Gemini simulation (1000 trials).xls
548      Dartboard score simulation.xls
548      Overbooked car-ferry simulation.xls
548      Triangle inequality simulation.xls
548      Right-angled, acute & obtuse triangle simulation.xls
549      Normal simulation (Answers).xls
549      Soft drink simulation (500 values).xls
549      Excess baggage simulation (400 values).xls
549      Predator-prey simulation 1 (cats and mice).xls
549      Predator-prey simulation 2 (sharks and fish).xls
549      Predator-prey simulation 4 (toheroa and off-road vehicles).xls