Data+Actvity+2

=Activity 2 Comparing Non Traditional Careers for Gender and Salary=

http://data.bls.gov/PDQ/outside.jsp?survey=le

Weekly and Hourly Earning Data from the Current Population Survey (Decide if you want to record most recent data only or data over multiple years).

1. Select the Person Count in Thousands for a particular Occupation HINT: To get all 4 pieces of data consolidated on one OUTPUT screen, you can click on ADD TO YOUR SELECTION instead of GET DATA in steps 3, 7, 12, and 16. When you have all 4 queries created, you can click on GET DATA (and then Change Formatting Options to only get ANNUAL Data). You can Print the screen or actually SAVE the OUTPUT as a WEB Page in a folder on your computer for analyzing later.
 * 1) Select (men)
 * 2) Get Data
 * 3) Record the number of men who work in that field
 * 4) Close out that window (this should return you to the Data form with your SAME occupation highlighted.
 * 5) Change selection to (women)
 * 6) Get Data
 * 7) Record the number of women who work in that field
 * 8) Close out the “output window”, this should return you to the Data form with your Same occupation highlighted. (PAY attention to the occupation highlighted (it’s about to change, and you’ll need to remember it so you can rehighlight it)
 * 9) Go back to Box 1 and change the Person Count to Medium Usual Weekly Earning. (note your occupation field is back to All occupation.)
 * 10)  Go to Box 3, and find the SAME occupation you had highlighted before
 * 11)  Choose (men) in Box 4, then click on Get Data
 * 12)  Optional (I usually click on only ANNUAL data instead of All Time) then hit Retrieve Data Button
 * 13) Record the Salary (not this is a weekly salary)
 * 14) Close (x) out the output screen and your Form should be on the screen
 * 15) Change the Gender to (women) in Box 4 and repeat steps 13 – 15)

In any case, you now have the information you need to create a spreadsheet that compares the percentage of men and women in each job category and the salaries of men and women in each job category.

I challenge you to try to fill out a spreadsheet like this for 5 jobs that have more than 75% women and 5 jobs that have more than 75% men. Then sort the spreadsheet by salary from highest to lowest. (You should be careful to only compare jobs that require the same amount of education (HS, Associates, Bachelors)

Job Title Count of men Count of Women Total Men and Women % of men % of women Weekly (or annual) Salary of men Weekly (or annual) Salary of men Average Salary





formula formula formula



formula