For this problem you need to make a pivot table and then determine the following

Question

For this problem you need to make a pivot table and then determine the following probabilities: P(female), P(red hair given female), P(red hair given male), P(red hair), p(over 200 lbs given male), p(over 200 pounds given male and has white hair). Create your pivot table in sheet2 and answer the questions in sheet2, then upload the file to BBLearn as instructed. 0-male     1-female 0-blond, 1-brown, 2-black, 3-red, 4-white, 5-none subject gender height weight hair color 1 0 85.82 144.56 5 2 1 72.23 138.99 3 3 1 84.37 140.8 1 4 0 70.74 195.26 2 5 0 61.9 186.29 5 6 0 88.67 237.23 3 7 0 62.14 178.31 2 8 0 83.62 158.93 2 9 0 88.32 168.77 5 10 1 81.81 156.64 3 11 0 68.05 200.13 2 12 0 81.9 195.37 5 13 0 76.54 204.36 5 14 0 90.69 183.94 2 15 0 65.8 194.59 5 16 1 68.22 223.95 4 17 1 57.26 222.85 1 18 1 57.76 166.26 2 19 1 61.72 188.48 0 20 0 55.37 253.83 3 21 1 63.59 167.93 4 22 1 65.95 184.29 1 23 1 63.39 205.38 1 24 0 58.89 138.95 1 25 0 61.52 211.07 5 26 0 69.66 180.04 1 27 0 64.83 201.27 0 28 0 79.33 159.98 1 29 1 74.47 150.01 0 30 0 89.55 145.73 0 31 1 84.71 161.72 4 32 0 86.52 133.32 3 33 0 61.9 209.88 5 34 1 61.44 216.99 3 35 1 55.01 164.42 1 36 1 62.21 160.22 2 37 0 68.67 247.57 5 38 1 84.57 171.72 1 39 0 63.71 150.74 2 40 1 89.57 203.8 1 41 0 56.62 168.63 4 42 1 81.82 198.8 3 43 0 74.55 160.44 3 44 1 81.69 135.29 5 45 1 73.56 197.46 5 46 1 84.33 132.78 3 47 0 88.17 189.27 1 48 0 60.43 125.95 4 49 1 70.51 130.12 1 50 1 70.66 139.18 0 51 1 55.65 196.9 0 52 1 82.17 141.11 5 53 0 74.89 126.18 0 54 1 70.28 183.54 1 55 1 85.46 173.45 4 56 1 75.42 192.24 4 57 0 62.94 198.6 2 58 1 83.32 174.32 4 59 0 61.28 152.5 4 60 1 57.74 171.97 2 61 1 60.43 188.68 1 62 0 69.4 181.26 0 63 1 66.91 193.6 0 64 0 87.15 185.97 0 65 0 64.63 166.05 3 66 1 58.33 132.26 1 67 1 61.49 184.72 5 68 0 69.23 134.96 2 69 0 87.36 195.53 0 70 1 79.82 197.53 5 71 0 61.71 192.27 4 72 0 85.97 170.89 4 73 1 61.24 177.63 2 74 1 62.12 148.47 3 75 1 66.62 179.15 0 76 1 58.91 187.38 4 77 1 87.42 249.12 1 78 1 79.98 114.05 0 79 1 70.98 157.43 2 80 0 82.92 139.86 3 81 0 61.31 159.25 4 82 0 61.01 196.56 3 83 0 81.19 161.81 1 84 0 55.18 144.17 5 85 0 76.42 122.91 4 86 1 84.15 135.62 0 87 1 76.93 174.67 5 88 1 80.43 209.87 4 89 0 82.79 176.22 5 90 1 85.38 171.45 5 91 1 69.56 119.77 1 92 1 55.49 172.99 0 93 1 70.92 93.98 5 94 0 59.53 161.18 5 95 1 67.04 126.99 3 96 1 90.92 102.29 4 97 1 55.92 193.54 1 98 0 88.2 170.18 2 99 0 78.93 119.1 5 100 0 90.13 130.86 4 101 1 56.2 147.04 0 102 0 71.19 165.56 1 103 1 67.85 149.35 1 104 1 62.82 197.42 5 105 0 89.35 162.42 1 For this problem you need to make a pivot table and then determine the following probabilities: P(female), P(red hair given female), P(red hair given male), P(red hair), p(over 200 lbs given male), p(over 200 pounds given male and has white hair). Create your pivot table in sheet2 and answer the questions in sheet2, then upload the file to BBLearn as instructed. 0-male     1-female 0-blond, 1-brown, 2-black, 3-red, 4-white, 5-none subject gender height weight hair color 1 0 85.82 144.56 5 2 1 72.23 138.99 3 3 1 84.37 140.8 1 4 0 70.74 195.26 2 5 0 61.9 186.29 5 6 0 88.67 237.23 3 7 0 62.14 178.31 2 8 0 83.62 158.93 2 9 0 88.32 168.77 5 10 1 81.81 156.64 3 11 0 68.05 200.13 2 12 0 81.9 195.37 5 13 0 76.54 204.36 5 14 0 90.69 183.94 2 15 0 65.8 194.59 5 16 1 68.22 223.95 4 17 1 57.26 222.85 1 18 1 57.76 166.26 2 19 1 61.72 188.48 0 20 0 55.37 253.83 3 21 1 63.59 167.93 4 22 1 65.95 184.29 1 23 1 63.39 205.38 1 24 0 58.89 138.95 1 25 0 61.52 211.07 5 26 0 69.66 180.04 1 27 0 64.83 201.27 0 28 0 79.33 159.98 1 29 1 74.47 150.01 0 30 0 89.55 145.73 0 31 1 84.71 161.72 4 32 0 86.52 133.32 3 33 0 61.9 209.88 5 34 1 61.44 216.99 3 35 1 55.01 164.42 1 36 1 62.21 160.22 2 37 0 68.67 247.57 5 38 1 84.57 171.72 1 39 0 63.71 150.74 2 40 1 89.57 203.8 1 41 0 56.62 168.63 4 42 1 81.82 198.8 3 43 0 74.55 160.44 3 44 1 81.69 135.29 5 45 1 73.56 197.46 5 46 1 84.33 132.78 3 47 0 88.17 189.27 1 48 0 60.43 125.95 4 49 1 70.51 130.12 1 50 1 70.66 139.18 0 51 1 55.65 196.9 0 52 1 82.17 141.11 5 53 0 74.89 126.18 0 54 1 70.28 183.54 1 55 1 85.46 173.45 4 56 1 75.42 192.24 4 57 0 62.94 198.6 2 58 1 83.32 174.32 4 59 0 61.28 152.5 4 60 1 57.74 171.97 2 61 1 60.43 188.68 1 62 0 69.4 181.26 0 63 1 66.91 193.6 0 64 0 87.15 185.97 0 65 0 64.63 166.05 3 66 1 58.33 132.26 1 67 1 61.49 184.72 5 68 0 69.23 134.96 2 69 0 87.36 195.53 0 70 1 79.82 197.53 5 71 0 61.71 192.27 4 72 0 85.97 170.89 4 73 1 61.24 177.63 2 74 1 62.12 148.47 3 75 1 66.62 179.15 0 76 1 58.91 187.38 4 77 1 87.42 249.12 1 78 1 79.98 114.05 0 79 1 70.98 157.43 2 80 0 82.92 139.86 3 81 0 61.31 159.25 4 82 0 61.01 196.56 3 83 0 81.19 161.81 1 84 0 55.18 144.17 5 85 0 76.42 122.91 4 86 1 84.15 135.62 0 87 1 76.93 174.67 5 88 1 80.43 209.87 4 89 0 82.79 176.22 5 90 1 85.38 171.45 5 91 1 69.56 119.77 1 92 1 55.49 172.99 0 93 1 70.92 93.98 5 94 0 59.53 161.18 5 95 1 67.04 126.99 3 96 1 90.92 102.29 4 97 1 55.92 193.54 1 98 0 88.2 170.18 2 99 0 78.93 119.1 5 100 0 90.13 130.86 4 101 1 56.2 147.04 0 102 0 71.19 165.56 1 103 1 67.85 149.35 1 104 1 62.82 197.42 5 105 0 89.35 162.42 1

Explanation / Answer

Please refer to the excel attached at below link:

https://drive.google.com/file/d/0B474U2tWxyGvckhiTWFMV2tCdzQ/view?usp=sharing

There are 3 sheets in the attached excel:

1) Data - This sheet contains the data given in the table. Also, an additional column has been added for Weight Over 200 pounds

2) Pivot - This sheet has the pivot table for the data

3) Solutions - This sheet copies the contents of the pivot table and does the required calculations for the questions asked.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.