Exercises done In Excel by Professor Gramlich for Triola 9th 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 Grades In Class Example (with 6 classes)
Test Grades In Class Example (with 4 classes)
Test Grades In Class Example Standard Deviation
Test Grades Example Boxplot (on DDXL)
2-2 Continine Relative Frequency Table
2-3 #11
2-4 #2
2-4 #4
2-4, 2-5 #2
DDXL boxplot for 2-4, 2-5 #2
2-6 #32 & #32
2-7 #3
2-7 #4
2-7 #5
2-7 #5 boxplot using DDXL
6-4, #17
6-4, #18 using syntax commands
6-4, #18 using summary statistics
6-4, #18 using DDXL
7-5 #25
7-5 #26 using syntax commands &summary stats
7-5 #26 using DDXL
7-5 #28 data
7-5 #28 using DDXL
7-5 #30
8-2 #12 data
8-2 #12 using DDXL
8-2 #17
8-2 #17 (Hypothesis Test on DDXL)
8-3 #7 & 8
8-4 #8
8-4 #8 (Hypothesis Test on DDXL)
8-4 #8 (Confidence Interval on DDXL)
9-2 Example on P. 500 (using descriptive statistics command under data analysis)
9-2 Example on P. 500 (using fx commands)
9-2 #18
11-2 #8
Practice Test 4 #12