Exercises done In Excel by Dr. Gramlich for Triola 10th 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)
3-2, #12
3-2 & 3-3, #25
3-2 & 3-3, #5
3-3, #5
3-3, #9
Mean & Std Dev for Ages of Actresses Example
Body Temperature Data using Data Analysis
Body Temperature Data using DDXL
3-5, #12
3-5, #12 (histogram on DDXL)
3-5, #12 (boxplot on DDXL)
4-7, #6, 8, 10, 15, 27
5-2, #10
5-3, #26, 29, 33
5-5, #10
chapter 6 commands to selected exercises
7-2, #29
7-2, #29 (on DDXL)
7-2, #36 Cloning Data
7-2, #36 Cloning Data (on DDXL)
7-4, #21 Lead in Air Data
7-4, #21 Lead in Air (on DDXL)
7-4, #24 Bumblebee Bat confidence Interval
7-4, #24 Bumblebee Bat (on DDXL)
7-4, #25 Emissions
8-3, #8 Telephone Users % HT Data
8-3, #8 Telephone Users % HT (on DDXL)
8-3, #16 Nicotine Patches Data
8-3, #16 (on DDXL)
8-3, #20 Smoking Data
8-3, #20 (on DDXL)
8-5, #19 Birth Weights
8-5, #22 Effectiveness of Diet
8-5, #24 Conductor Life Span
8-5, #25 Lead in Air
8-5, #26 Cereal Sugar Mean HT Data
8-5, #26 Cereal Sugar Mean HT (on DDXL)
8-5, #27 Bumblebee Bat Mean HT
8-5, #27 Bumblebee Bat Mean HT (on DDXL)
9-2, #13
9-2, #19
9-2, #26
Using DDXL in Excel 2007 for 9-2 Proportion
9-2, #26 (HT on DDXL)
9-2, #26 (CI on DDXL)
9-3, #9 Echinacea treatment
9-3, #19
9-3, #26
9-3, #26 (HT on DDXL)
9-3, #26 (CI on DDXL)
9-4, #12
9-4, #12 (HT on DDXL)
9-4, #12 (CI on DDXL)
9-4, #19
10-2 & 10-3, Example from text
10-2 & 3, #19 (10-4 #15)
10-2, 10-3 #14 Impressions & Albums sold correlation
10-2, 10-3, #15; 10-4, #14 & #18a
10-2, 10-3 #22 (also used for 10-4)
10-2, #22 (HT on DDXL)
10-3 #22 (Regression on DDXL)
10-2, #31a on DDXL
10-3, #31a on DDXL
10-3, #31b on DDXL
10-4, #15
10-5, #13c
10-5, #13c on DDXL
11-2, #10
11-2, #18
11-3, #6
11-3, "Influence of Gender" Example