Question
For #1-3: Researchers wanted to test whether people's mood (1=bad, 2=neutral, 3=good in the MOOD variable) affected their generosity (measured in donated dollars - the
For #1-3:Researchers wanted to test whether people's mood (1=bad, 2=neutral, 3=good in the MOOD variable) affected their generosity (measured in donated dollars - the MONEY variable) differently in males and females (0=males, 1=females in the SEX variable). The collected data are presented in the datasetHW_Dataset1(imaginary data).
#1. 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?
#2. Use a pivot table in Excel to find the average amount of donated money for each mood level (ignoring the gender). Include a screenshot of the pivot-table set up and a screenshot of the resulting averages. Include a sentence with your conclusion: what is the change in people's generosity with an increase in their mood?
#3. Use a pivot table in Excel to find the average amount of donated money per each level of mood, separately for males and females. Include a screenshot of the pivot-table set up and a screenshot of the resulting averages.