50 243 380 450 150 367 269 375 320 175 333 2 267 300 267 275 367 350 300 233

50 243 380 450 150 367 269 375 320 175 333 2 267 300

This preview shows page 7 - 11 out of 44 pages.

1.50 2.43 3.80 4.50 1.50 3.67 2.69 3.75 3.20 1.75 3.33 2 2.67 3.00 2.67 2.75 3.67 3.50 3.00 2.33 2.00 3.14 4.80 2.00 4.00 2.33 2.56 2.75 2.80 2.00 3.81 2 4.09 4.00 3.50 5.00 3.67 4.25 2.67 3.08 2.00 3.29 4.60 3.50 2.50 2.67 3.06 2.50 4.00 2.75 4.19 2 2.92 4.00 3.50 4.25 3.00 4.25 3.00 3.08 3.00 2.86 4.60 4.50 3.00 2.67 3.50 3.75 3.70 2.50 3.82 2 3.64 2.50 3.50 3.50 4.00 3.00 2.78 3.08 4.00 3.14 4.00 4.50 2.00 2.33 3.00 2.75 3.89 5.00 4.34 2 4.17 4.00 3.50 2.75 4.67 4.00 2.78 2.92 4.00 3.71 4.60 4.50 3.00 3.00 3.33 3.00 3.80 5.00 5.09 sex Gender: 1=Male; 2=Female org The Organization ini Information indi Direction inf Feedback prwe Work Environment preq Equipment & Supplies prwd Work Disorganization prwc Working Conditions prwco Working Conditions Outcome icad Advancement icim Impact icimo Impact Outcome icpa Pay Administration icpy Pay & Benefits su Immediate Supervisor tr Training cptw Compelling Place to Work itl Intention to Leave
Image of page 7
Place the results in cell W5. combination of two or more u should get the same value for
Image of page 8
RandomNum Gender Race Female Black/African American Female White Female White 1 Using Pivot Tables create Gender by Race crosstabulation of the data in Columns B & C. Female Black/African American Place the table in cell F7. Female Black/African American Female White Male White Female Black/African American Male White Female White Male White Female Black/African American Male Black/African American Male White Female White Female White Female White Female White Male White Male White Female White Male White Female White Female White Female Black/African American Female White Male White Female White 2 Female White Male White Female White Female White Female White Chi Square Female White p-level Female White Statistically significant? Male White Female Black/African American Male White Male Black/African American Female White 3 Female White Female Black/African American Female White Female White Male White Male White Chi Square Female White p-level Female White Statistically significant? Female White Fisher's Exact Probability Female White Female White Female Black/African American Female White Male Black/African American Female White Female White Male White Female White 4 Define the Yule-Simpson effect and show an example of it. Female White Female White Female White Female White Female White Male White Male White Female White Female White Male White Female White Male White Female Black/African American Female White Female White Female White Male White Female White Female White Male White Female White Female White Female White Female White Female White Male White The data columns B & C constitute the population of individuals in a retail clerk job in a large company. The data were collected for EEO (Equal Employment Opportunity) reporting purposes. Is the association between Gender and Race statistically significant? Use one of the statistical calculators located on the web to make this determination. Assume that you did not have access to the population of data in Column A, but had to select a random sample on which to calculate your assocation statistic. Assign a random number to the observations, then select the 30 lowest random numbers for your sample. Calculate the association statistics on this sample.
Image of page 9
Female White Female Black/African American Male Black/African American
Image of page 10
Image of page 11

You've reached the end of your free preview.

Want to read all 44 pages?

  • Fall '15
  • Threesome

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes