Create a pivottable which shows average yearly earnings

Assignment Help Business Management

Reference no: EM133509138

Problem

Label tables and worksheets as needed:

A. Create a new PivotTable showing Average Usual Hours Worked by Gender (with Gender as the Row variable).

You should get a table that looks like this:

Average of Usual Hours Worked
Sex	Total
Female	40.63
Male	43.26
Grand Total	42.19

B. Create a new PivotTable showing Average Usual Hours Worked for each state by Gender (with Gender as the Row variable). Chart the resulting data.

C. Create a PivotTable which shows Average Yearly Earnings with Education in the Rows and Gender in the Columns. Chart the resulting data.

D. Based on the data can we conclude that having a higher level of education (more years) will result in higher wages?

E. Based on the data provided: Which state has the higher wages for females?

Reference no: EM133509138

Questions Cloud

How would implement these strategies in professional life : How would you implement these strategies in your professional life? What steps do you need to take?

How does the celebrity align to the target market : How does this celebrity align to the target market? Which media channels would you use to reach the target market with this celebrity endorser?

How can you identify trends in themarket place : How can you identify trends in themarketplace, from what sources might this research information come and how can this information impact onthe establishment

How does this particular place make you feel : Describe a place that you feel part pf and that is a part of you, how is this place special what are some experiences you have had in this place?

Create a pivottable which shows average yearly earnings : BUS 5250- Create a PivotTable which shows Average Yearly Earnings with Education in the Rows and Gender in the Columns. Chart the resulting data.

How can preventive services-alcohol misuse screening : Alcohol Misuse Screening, bladder cancer screening, and HPV Vaccines in Children Ages 7 to 18 impact positive social change.

What concepts did you plan to talk about : Which movie have you chosen for your paper? What concepts did you plan to talk about? What was the most inspiring thing you learned from your paper

Describe the minnesota studies in detail : What strategies would be applied when dealing with difficult group members? Examine the relevance of each strategy. Consider This:On the surface, it helps

What are some examples of hypotheses of human behavior : What are some examples of hypotheses of human behavior?

User Account

All Pages