Exercises done In Excel by Dr. Gramlich for Triola 11th edition
()
NOTE: DDXL (.dsk) files must be opened through the DDXL "add-in" software.
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)
2/1/12 3-2 #30
9/27/11 5-2, #7
3/21/12 5-2, #10
3/28/12 5-3, #28
11/1/11 7-4, #25 Lead in Air Data
11/1/11 7-4, #25 Lead in Air (on DDXL)
11/8/11 8-3, #15 Cell Phones and Cancer
11/8/11 8-3, #16 Cell Predicting Sex of Baby
11/15/11 8-5, #25 Cell Tests of Child Booster Seats
11/22/11 9-2, #8 Drug Clinical Trial
11/29/11 9-3, #9 & 10 Effectiveness of Humidity in Treating Croup
11/29/11 9-4, #9 & 10 BMI During Freshman Year
12/6/11 10-2, 10-3 #15 Blood Pressure Measurements (also used for 10-4 instruction)
10-5, #5-8 King Size Cigarettes Multiple Regression on Excel
11-2, #8 Flat Tire
11-2, #21 Leading Digits Benford's Law
11-3, #14 Treatment and Flu
11-3, "Influence of Gender" Example