The data comes from the paper "Sex Bias in Graduate Admissions: Data from Berkeley" by Bickel, Hammel, and O'Connell. The data in the file genderbiasberkeley.csv contains the following columns....

Extracted text: The data comes from the paper "Sex Bias in Graduate Admissions: Data from Berkeley" by Bickel, Hammel, and O'Connell. The data in the file genderbiasberkeley.csv contains the following columns. department-the department letter code (letters A through F) gender-the gender of the student applying to the school, where 1 = male and 2 = female admitted-an indicator showing whether the student was accepted or denied to the program, where 1 = admitted and 2 = denied count-the number of students admitted or denied O Tech Guide You will need to use the TI Tech Guide. A Lab Questions Describe the structure of the data. Is it different than data you have examined before? Specifically, there are 24 rows in this data set, but the set provides information about 4,526 observations (the sum of the "count" column). Describe what each row represents. Each of the six departments (A-F) have four rows of data in this set corresponding to each of the following. 1st row ---Select--- who were Select--- V. 2nd row --Select- V who were -Select--- V 3rd row ---Select--- VV who were -Select-- V 4th row ---Select--- Vwho were ---Select--- Of the 4,526 applicants in this data set, 1,755 were admitted for an overall admission rate of approximately 39%. The admission rate for men was 45%, while the admission rate for women was 30%. Complete the following table. Gender Number Admitted Number Rejected Male Female Indicate how your numbers are consistent with these given admission rates for men and women. (Round your answers to four decimal places.) admission rate for men admission rate for women Use these data to conduct a test of independence between gender and admission. Use a significance level of 0.05. State the null and alternative hypotheses. O H.: Gender and whether or not an applicant is admitted are not dependent. H,: Gender and whether or not an applicant is admitted are dependent. O Ho: Gender and whether or not an applicant is admitted are dependent. H: Gender and whether or not an applicant is admitted are not dependent. O H: Gender and whether or not an applicant is admitted are independent. H,: Gender and whether or not an applicant is admitted are not independent. O Ho: Gender and whether or not an applicant is admitted are not independent. H: Gender and whether or not an applicant is admitted are independent. State the statistic, degrees of freedom, and the P-value. (Round your answer for x to two decimal places and your P-value to three decimal places.) = df = P-value = Interpret the result with respect to gender bias in admissions. O There is sufficient evidence at a significance level of 0.05 to conclude that there is gender bias in admissions. O There is insufficient evidence at a significance level of 0.05 to conclude that there is gender bias in admissions. Now, let's reconsider this data by investigating whether there is a relationship between gender and department by conducting a test of independence between gender and department, ignoring admittance. Use a significance level of 0.05. State the null and alternative hypotheses. O H: Gender and department are dependent. H,: Gender and department are not dependent. O Ho: Gender and department are not dependent. H: Gender and department are dependent. O H: Gender and department are independent. H,: Gender and department are not independent. O Ho: Gender and department are not independent. H,: Gender and department are independent.