Standard Course Week 10 ANALYZING RELATIONSHIPS AMONG VARIABLES (PART 1) Cross tabulation (contingency tables) Filtering & pivot tables for temporary views Charts for contingency tables THIS WEEK'S TEXTBOOK CHAPTER Edit Students can manually mark this item complete: THIS WEEK'S TEXTBOOK CHAPTER Statistics Text Chapter 9 -- Relationships among variables URL Edit title Edit Students can manually mark this item complete: Statistics Text Chapter 9 -- Relationships among variables 9.1 Analyzing Relations Among Variables 9.2 Cross tabulations (Contingency Tables) 9.3 Filtering for Temporary Views 9.4 Charts for Contingency Tables Learning Objectives At a practical level, students should be able to Give examples of multifactorial data collection Create multi-way contingency tables in Excel using Pivot Tables Show selected subsets of data using filtering in Excel Create clustered and stacked bar charts from two-way contingency tables Create 3-D response-surface graphs from three-way tables. Edit Students can manually mark this item complete: Learning Objectives At a practical level, student... REVIEW Edit Students can manually mark this item complete: REVIEW qm213_wk11_review_questions File Edit title Edit Students can manually mark this item complete: qm213_wk11_review_questions HOMEWORK ASSIGNMENTS Edit Students can manually mark this item complete: HOMEWORK ASSIGNMENTS  qm213_homework_wk11_part_1.xlsx File Edit title Edit Students can manually mark this item complete: qm213_homework_wk11_part_1.xlsx Practice with multivariate graphs. qm213_homework_wk11_part_2.xlsx File Edit title Edit Students can manually mark this item complete: qm213_homework_wk11_part_2.xlsx Practice with PIVOT tables. qm213_homework_wk11_part_3.xlsx File Edit title Edit Students can manually mark this item complete: qm213_homework_wk11_part_3.xlsx Practice with 3-D response-surface graphs qm213_homework_wk11_part_4_graded.xlsx File Edit title Edit Students can manually mark this item complete: qm213_homework_wk11_part_4_graded.xlsx Your exam for this week's practical knowledge. Don't even THINK of doing this without doing the preliminary homework!!! HOMEWORK GRADING & UPLOADS Edit Students can manually mark this item complete: HOMEWORK GRADING & UPLOADS  hg_wk11_p4_sheet-c_answers-A Quiz Edit title Edit No groups (Click to change) Students can manually mark this item complete: hg_wk11_p4_sheet-c_answers-A Homework-grading questions for week 11 part 4 sheet c (ANSWERS A) exercises. 10 questions, 20 minutes, 1 try. If you find errors in your homework, fix them and then use the hg_wk##r quiz. Higher grade in the hg_wk##r quiz replaces lower grade in hg_wk## quiz. hg_wk11_p4_sheet-c_answers-A_r Quiz Edit title Edit No groups (Click to change) Students can manually mark this item complete: hg_wk11_p4_sheet-c_answers-A_r Replacement homework-grading questions for week 11 part 4 sheet c (ANSWERS A) exercises. 10 questions, 20 minutes, 1 try. If you find errors in your homework using the hg_wk## quiz, fix them and then use the hg_wk##r quiz. Higher grade in the hg_wk##r quiz replaces lower grade in hg_wk## quiz. hg_wk11_p4_sheet-d_answers-B Quiz Edit title Edit No groups (Click to change) Students can manually mark this item complete: hg_wk11_p4_sheet-d_answers-B Homework-grading questions for week 11 part 4 sheet d (ANSWERS B) exercises. 10 questions, 20 minutes, 1 try. If you find errors in your homework, fix them and then use the hg_wk##r quiz. Higher grade in the hg_wk##r quiz replaces lower grade in hg_wk## quiz. hg_wk11_p4_sheet-d_answers-B_r Quiz Edit title Edit No groups (Click to change) Students can manually mark this item complete: hg_wk11_p4_sheet-d_answers-B_r Replacement homework-grading questions for week 11 part 4 sheet d (ANSWERS B) exercises. . 10 questions, 20 minutes, 1 try. If you find errors in your homework using the hg_wk## quiz, fix them and then use the hg_wk##r quiz. Higher grade in the hg_wk##r quiz replaces lower grade in hg_wk## quiz. hg_wk11_p4_sheet-e_answers-C Quiz Edit title Edit No groups (Click to change) Students can manually mark this item complete: hg_wk11_p4_sheet-e_answers-C Homework-grading questions for week 11 part 4 sheet e (ANSWERS C) exercises. 10 questions, 20 minutes, 1 try. If you find errors in your homework, fix them and then use the hg_wk##r quiz. Higher grade in the hg_wk##r quiz replaces lower grade in hg_wk## quiz. hg_wk11_p4_sheet-d_answers-C_r Quiz Edit title Edit No groups (Click to change) Students can manually mark this item complete: hg_wk11_p4_sheet-d_answers-C_r Replacement homework-grading questions for week 11 part 4 sheet e (ANSWERS C) exercises. 10 questions, 20 minutes, 1 try. If you find errors in your homework using the hg_wk## quiz, fix them and then use the hg_wk##r quiz. Higher grade in the hg_wk##r quiz replaces lower grade in hg_wk## quiz. hu11 Assignment Edit title Edit No groups (Click to change) Students can manually mark this item complete: hu11 Upload your 4 completed qm213_homework_wk11 xlsx files here. Do NOT upload archive (ZIP, RAR, etc.) files because they force the prof to open them to extract the files. QUIZ Edit Students can manually mark this item complete: QUIZ  q11 Quiz Edit title Edit No groups (Click to change) Students can manually mark this item complete: q11 10 questions, 20 minutes, 1 try. q11a Quiz Edit title Edit No groups (Click to change) Students can manually mark this item complete: q11a q11r Quiz Edit title Edit No groups (Click to change) Students can manually mark this item complete: q11r 15 questions, 15 minutes, 1 try. You must complete q11 before attempting q11r. Higher grade in q11r replaces lower grade in q11. q11ra Quiz Edit title Edit No groups (Click to change) Students can manually mark this item complete: q11ra