Use a pivot table in Excel to find the average amount of donated money for males and females (ignoring the mood level). Include a screenshot of the pivot-table set up and a screenshot of the resulting averages. Include a sentence with your conclusion: which gender, on average, is more generous?

 

Transcribed Image Text:

3 1 4 1 50 61 1 sex 20 A mood 22223 B C money 1 10 15 20 11 14 7 1 80 13 17 13 90 3 14 100 3 13 1 1 1 1 12 0 13 1 40 23 2 12 4 22 15 1 2 14. 16 1 1 9 17 0 3 15 18 1 3 25 19 1 1 17 20 0 2 10 21 1 1 9 22 1 1 19 23 0 24 1 m m 3 15 25 1 26 0 27 1 2 28 1 1 29 0 30 1 3 32 3 m m 25 22 12 16 5 15 12 31 0 1 8 B2 1 2 15 33 1 34 0 35 1 36 1 27 1131 12 17 25 21 3 1 4 1 50 61 1 sex 20 A mood 22223 B C money 1 10 15 20 11 14 7 1 80 13 17 13 90 3 14 100 3 13 1 1 1 1 12 0 13 1 40 23 2 12 4 22 15 1 2 14. 16 1 1 9 17 0 3 15 18 1 3 25 19 1 1 17 20 0 2 10 21 1 1 9 22 1 1 19 23 0 24 1 m m 3 15 25 1 26 0 27 1 2 28 1 1 29 0 30 1 3 32 3 m m 25 22 12 16 5 15 12 31 0 1 8 B2 1 2 15 33 1 34 0 35 1 36 1 27 1131 12 17 25 21