Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Early Transcendentals

Authors: James Stewart

8th edition

1285741552, 9781305482463 , 978-1285741550

More Books

Students also viewed these Mathematics questions

Question

Did I overlook any information that would be helpful in the future?

Answered: 1 week ago