Exercises done In Excel by Dr. Gramlich for Triola 12th edition
()
NOTE: DDXL (.dsk) files must be opened through the DDXL "add-in" software.
It is best to view excel syntax commands by saving files to disk and then opening in excel.
Test Scores In Class Example (unsorted data)
Test Scores In Class Example (sorted data into ordered array)
Test Scores Frequency Distribution
Test Scores Example Boxplot (on DDXL)
9/30/14 5-2, #7 Genetic Disorder Probability Distribution for # of children who inherit X-linked
11/12/19 7-2, #10 Mercury in Sushi Population Mean Confidence Interval
10/21/14 7-3, #21 Lead in Medicine Population Mean Confidence Interval
10/28/14 (updated 4/12/19) 8-3, #14 Gender Selection YSORT Conceiving Boy z Hypothesis Test
11/8/11 8-3, #19 Cell Phones and Cancer z Hypothesis Test
4/12/19 8-4 #21 Lead in Medicine Population Mean Hypothesis t-Test
11/19/19 8-4 #22 Brain Volume Population Mean Hypothesis t-Test
11/4/14 9-2, #11 Echinacea Effectiviness for Rhinovirus Treatment vs Placebo Proportion z-test
11/11/14 9-3 #10 t-test for Difference in Men & Women's Temperatures
11/4/14 9-4, #15 Is Friday 13th Unlucky? t-test matched pairs
11/4/14 10-2, 10-3 #23 Blood Pressure Measurements Correlation & Regression (also used for 10-4 instruction)