125 fx A B C D E F G H Random Rock, Preferred Favorite Number of Height Number 1- Paper, or Age (years) Hand Season Siblings (inches) 20 Scissors 1 2 20 Left Fall 2 7 Rock 74 3 NR NR Summer 2 16 Paper 66 21 Right Fall 2 13 Rock 73 5 NR NR Winter 3 4 Rock 75 6 20 Right Summer 2 3 Paper 64 7 20 Left Summer 4 2 Paper 72 00 22 Right Fall 0 6 Rock 63 9 NR Right Fall 3 8 Rock 63 10 21 Right Winter 1 S Scissors 74 11 21 Right Summer 3 17 Rock 72 12 13 23 NR NR NR 2 15 Sdssors 71 20 Right Spring 2 3 Scissors 67 14 20 Right NR 3 9 Paper 73 15 NR Right Fall 1 1 Rock 69 16 NR NR NR NR NR NR NR 17 20 Right Fall NR 11 Rock 70 18 20 Right Winter 2 8 Rock 73 19 19 Right Fall 1 13 Rock 73 20 20 Right Fall 3 15 Rock 72 31 PUP Winter 1 10 Brick 75 Counting CLASS A CLASS B + Ready Accessibility: Investigate Paste A v Font Alignment % Number 125 X fx Format as Table Cell Styles A B C D E F G H 2222 20 20 Right Fall 3 15 Rock 72 21 NR Loft Winter 1 19 Rock 75 20 Right Fall 2 4 Scissors 68 23 20 Right Spring 2 3 Paper 76 24 20 Rugha Fall 2 9 Scissors 73 25 26 56 19 NR Spring 1 NP NR Paper 70 21 Aight Fall 3 8 Paper 66 27 20 Left Fall 1 13 Paper 69 28 20 Right Fall 1 3 Paper 65 29 20 Right Fall 0 13 Paper 62 30 20 Fight Fall 2 12 Scissors 64 31 20 Right Fall 2 11 Rock + 67 32 PR NR NR NR NF NR NR NR 33 19 Right Summer 1 13 Paper 69 34 20 Hight Summer 2 15 Rock 73 35 22 Right Winter 2 3 Rock 70 36 MR Right Summer 1 17 17 Sdssors 72 37 NR NR Fall 3 11 Rock 73 38 NR Right Fall NR NR NR NR 39 20 Right Winter 4 17 Rock 76 40 20 Left Summer 1 18 Paper 68 41 NA Right Summar 2 11 Sassors 72 Ready Counting CLASS A CLASS B + Accessibility 125 A fx B C D E F G 40 20 Left Summer 1 18 Paper 68 41 NR Right Summer 2 11 Scissors 72 42 300 Right Winter 4 7 Paper 71 43 20 Right Summer 2 4 Rock 75 44 20 Right Fall 1 S Scissors 2 45 19 Left Winter 3 3 Rock 73 46 20 Right Fall 2 14 Sdssors 70 47 20 Right Summer 1 3 Scissors 67 48 20 Both Summer 2 11 Sdssors 75 49 20 Right Fall 4 16 Rock 50 NR NR Summer 1 2 Rock 51 19 Right Fall 1 12 Paper 71 72 68 52 19 Right Fall 2 7 Rock 71 53 NR NR Fall 2 1 Rock 68 54 20 Right Fall 1 3 Scissors 76 55 19 Right Fall 1 13 Sdssors 68 56 21 Right Fall 2 12 Rock 69 57 20 Right Summer 3 13 Rock 66 58 20 Left Fall 3 18 Scissors 58 59 20 Right Fall 2 6 Paper 68 60 22 Right Fall 2 5 Scissors 73 61 20 Right Fall 3 3 Rock 62 69 19 Right Fall A Paner 76 Counting CLASS A CLASS B + Paste Font Cell St 125 fx A B C D E F 61 20 Right Fall 3 3 Rock 69 62 19 Right Fall 0 8 Paper 63 19 Right Spring 3 15 Rock 64 20 Right Fall 2 2 Paper GS 621 76 72 75 65 NR Left Summer 1 13 Rock 66 19 Right Fall 1 4 Scissors 67 20 Right Winter 2 19 Rock 228 71 72 64 68 20 Right Fall 0 17 Scissors 71 69 20 Right Fall 1 4 Rock 69 70 20 Right Fall 2 5 Scissors 68 71 21 Left Winter 2 4 Rock 72 19 Right Winter 1 19 Scissors 26 71 66 73 NR Right Spring 2 13 Rock 72 72 74 20 Right Summer 1 13 Rock 71 71 75 20 Right Fall 1 18 Rock 70 70 76 20 Right Fall 3 2 Scissors 77 19 Right Fall 1 7 Rock 69 14 69 71 78 19 Right Fall 0 7 Rock 66 79 19 Right Summer 2 11 Scissors 66 80 20 Right Fall 0 8 Rock 74 81 20 Right Spring 1 7 Paper 67 82 19 Left Fall 2 7 Paper 70 83 21 Both Winter 3 9 Scissors 72 Counting CLASS A CLASS B + Paste P Font Alignment Number Cell Style 125 A X fx C D E F G 82 19 LET Fall 2 T Papar 70 83 21 Both Winter 3 9 Scissors 72 84 21 Right Fall 1 3 Scissors 73 85 20 NR Spring 1 5 NR 70 86 21 Laft Fall 1 16 Rock 72 87 NA Lon Fall 2 9 Paper 69 88 20 fight Fall 2 7 Rock + 69 89 18 Right Fall 1 15 Paper 64 90 21 Right Summer 1 7 Rock 77 91 20 Right Fall 1 10 Rock 77 92 20 Right Summer 1 3 Paper 74 93 20 Right Spring 2 5 Rock 65 94 NB Right Fall 2 14 Scissors 73 95 20 Fight Summer NR NE 4 Rock 69 96 97 9B 99 100 101 102 103 ps://umsystem.instructure.com Question 2 Consider the data in the CLASS B tab in the Excel file 2500-Discussion4.xlsx . Create a PivotTable for the Favorite Season and the Rock, Paper, Scissors variables. Be sure to exclude the "NR" values in your totals. Complete the joint probability table below: (Round all decimal answers to 2 places.) Fall Spring Summer Winter Paper Rock Scissors Total .56 .08 .23 .14 Total .24 .49 .27 1 Question 3 12 p 5 pts //umsystem.instructure.com/course Question 3 5 pts Use the data from Question 2 to answer the following. NOTE: You rounded answers in Question 2, but use the original (unrounded) values from your Excel sheet when performing any calculations for this problem. When you are finished with a calculation, you can select the rounded final answer shown here. What is the probability that a student preferred Summer AND chose Scissors? [Select] What is the probability that student preferred Summer OR chose Scissors? [Select] Suppose that a student volunteered to play Rock/Paper/Scissors against Truman the Tiger, and we know that this volunteer preferred Fall. Scissors beats paper Truman will choose to play Paper. What is the probability that Truman will tie the volunteer (i.e. that they will both choose Paper)? [Select] What is the probability that Truman will beat the volunteer (i.e. the student will choose Rock)? [Select] Are the selections Winter and Scissors independent? [Select] beats scissors Rock Paper beats rock