the Correlation analysis tool in Data Analysis found in the Data tab on the

The correlation analysis tool in data analysis found

This preview shows page 29 - 38 out of 175 pages.

the Correlation analysis tool in Data Analysis found in the Data tab on the Ribbon. Place the results in cel n? ency of sex. redict an itl value for each of the observations from the headed PR (for predicted). sion analysis predicting cptw for the variables icpy to tr. ts. Note LINEST is an ARRAY function.
Image of page 29
e predicted value of itl (PR). Place in the box below. luding R 2 . cted values is the Multiple Correlation, R, when the Predicted values is the linear combination of two or m by calculating the correlation between itl and PR. Then, square the correlation. You should get the same v
Image of page 30
Image of page 31
ll W5.
Image of page 32
more value for
Image of page 33
Image of page 34
RandomNum Gender Race Female Black/African American Female White Female White 1 Using Pivot Tables create Gender by Race cr 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 The data columns B & C constitute the popu job in a large company. The data were collec Opportunity) reporting purposes. Is the association between Gender and Rac of the statistical calculators located on the w Assume that you did not have access to the but had to select a random sample on whic statistic. Assign a random number to the ob lowest random numbers for your sample. C on this sample.
Image of page 35
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 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 Female White Female Black/African American Male Black/African American Female White Female White Female White Female White Female White Female White Female White
Image of page 36
Female Black/African American Male White Male White Female White Male White Female White Male White Female White Female White Female White Female White Female Black/African American Female White Male White Male White Female White Male White Female White Female White Female White Female White Female White Male White
Image of page 37
Image of page 38

You've reached the end of your free preview.

Want to read all 175 pages?

  • Fall '15
  • Threesome

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture