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 mean for female pulse rates frequency table
2/13/13 3-3, #30 variance & standard deviation for female pulse rates frequency table
9/27/11 5-2, #7
3/21/12 5-2, #10
3/28/12 5-3, #28
4/13/13 5-3, #47 and 5-5, #10 (Hypergeometric and Poisson)
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 Predicting Sex of Baby
11/15/11 8-5, #25 Tests of Child Booster Seats
11/20/12 9-2, #8 & 10 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