The Student News Service at Clear Mountain State University (CMSU) has decided to gather data about the undergraduate students that attend CMSU. CMSU creates and distributes a survey of 14 questions and receives responses from 62 undergraduates (stored in the Survey.csvfile).

Part I

• 2.1. For this data, construct the following contingency tables (Keep Gender as row variable)
• 2.1.1. Gender and Major
• 2.1.2. Gender and Grad Intention
• 2.1.3. Gender and Employment
• 2.1.4. Gender and Computer

• 2.2. Assume that the sample is a representative of the population of CMSU. Based on the data, answer the following questions:
• 2.2.1. What is the probability that a randomly selected CMSU student will be male?
• What is the probability that a randomly selected CMSU student will be female?
• 2.2.2. Find the conditional probability of different majors among the male students in CMSU.
• Find the conditional probability of different majors among the female students of CMSU.
• 2.2.3. Find the conditional probability of intent to graduate, given that the student is a male.
• Find the conditional probability of intent to graduate, given that the student is a female.
• 2.2.4. Find the conditional probability of employment status for the male students as well as for the female students.
• 2.2.5. Find the conditional probability of laptop preference among the male students as well as among the female students.

• 2.3. Based on the above probabilities, do you think that the column variable in each case is independent of Gender?
• Justify your comment in each case.

Part II

• 2.4. Note that there are three numerical (continuous) variables in the data set, Salary, Spending and Text Messages. For each of them comment whether they follow a normal distribution.
• send note summarizing your conclusions.
• [Recall that symmetric histogram does not necessarily mean that the underlying distribution is symmetric]

Please send me answer in python commands

8f09f0cc09f4d27c10c4d94b745d9b0db2a29b19 ID Gender Age Class 1 Female 20 Junior 2 Male 23 Senior 3 Male 21 Junior 4 Male 21 Junior 5 Male 23 Senior 6 Female 22 Senior 7 Female 21 Junior 8 Female 22 Senior 9 Female 20 Junior 10 Female 21 Senior 11 Female 23 Senior 12 Male 21 Senior 13 Male 22 Senior 14 Male 22 Senior 15 Male 21 Senior 16 Male 24 Senior 17 Female 19 Junior 18 Male 21 Junior 19 Male 19 Junior 20 Female 20 Junior 21 Female 22 Junior 22 Male 18 Sophomore 23 Female 22 Senior 24 Male 22 Senior 25 Female 20 Junior 26 Male 24 Senior 27 Male 20 Junior 28 Female 20 Junior 29 Male 22 Senior 30 Male 20 Sophomore 31 Male 20 Junior 32 Male 20 Junior 33 Male 20 Junior 34 Male 22 Senior 35 Female 19 Junior 36 Female 26 Junior 37 Male 21 Senior 38 Female 21 Sophomore 39 Male 24 Junior 40 Male 19 Sophomore 41 Male 22 Junior 42 Female 20 Junior 43 Female 22 Senior 44 Female 21 Senior 45 Female 21 Senior 46 Female 21 Senior 47 Female 20 Junior 48 Male 19 Sophomore 49 Female 21 Senior 50 Female 21 Senior 51 Female 21 Junior 52 Male 21 Senior Major Other Management Other CIS Other Economics/Finance Other Other Management Economics/Finance Economics/Finance Undecided International Business International Business Management Management CIS Economics/Finance Economics/Finance Management Retailing/Marketing Accounting Retailing/Marketing Undecided Economics/Finance Management Economics/Finance International Business Retailing/Marketing Retailing/Marketing Accounting Other Accounting Retailing/Marketing Retailing/Marketing Accounting Management Accounting Economics/Finance Retailing/Marketing Accounting Retailing/Marketing Retailing/Marketing Retailing/Marketing International Business Management Retailing/Marketing Undecided Economics/Finance Economics/Finance Management Management Grad Intention GPA Employment Salary Yes 2.9 Full-Time 50 Yes 3.6 Part-Time 25 Yes 2.5 Part-Time 45 Yes 2.5 Full-Time 40 Undecided 2.8 Unemployed 40 Undecided 2.3 Unemployed 78 Undecided 3 Part-Time 50 Undecided 3.1 Full-Time 80 Yes 3.6 Unemployed 30 Undecided 3.3 Part-Time 37.5 Yes 2.8 Full-Time 50 No 3.5 Full-Time 37 Undecided 3.4 Part-Time 40 Undecided 3.1 Part-Time 40 Yes 3.2 Part-Time 54 Undecided 3.4 Part-Time 45 Undecided 3.7 Part-Time 55 Undecided 3.1 Part-Time 55 Yes 3.5 Part-Time 52 Undecided 3.2 Unemployed 60 Undecided 3.2 Part-Time 55 Undecided 3 Unemployed 60 Undecided 3 Part-Time 55 Yes 2.6 Full-Time 45 Yes 3 Part-Time 55 Yes 3.3 Full-Time 60 Yes 3.1 Full-Time 65 Yes 2.9 Part-Time 50 Yes 3.3 Part-Time 55 Undecided 3.1 Part-Time 45 Undecided 3.4 Part-Time 55 Yes 2.9 Part-Time 47 Yes 3.6 Part-Time 35 Yes 2.6 Full-Time 40 Undecided 3.4 Part-Time 40 Yes 3.3 Part-Time 60 Yes 3.1 Part-Time 40 Yes 2.5 Part-Time 60 Yes 2.8 Part-Time 50 Yes 2.5 Unemployed 50 Yes 3.2 Full-Time 60 No 3.3 Part-Time 30 Undecided 3.5 Unemployed 40 No 3.9 Part-Time 30 No 3 Part-Time 30 Undecided 3.8 Part-Time 60 Yes 3.5 Unemployed 60 Undecided 2.5 Part-Time 80 Yes 3.2 Part-Time 47.5 Undecided 3 Part-Time 45 No 3.5 Unemployed 35 No 3 Part-Time 50 Page 1 8f09f0cc09f4d27c10c4d94b745d9b0db2a29b19 53 Female 54 Male 55 Male 56 Female 57 Female 58 Female 59 Female 60 Female 61 Female 62 Female 21 Senior 21 Junior 21 Senior 21 Senior 21 Senior 21 Senior 20 Junior 20 Sophomore 23 Senior 23 Senior Retailing/Marketing Retailing/Marketing Other Retailing/Marketing International Business International Business CIS CIS Accounting Economics/Finance Undecided No Yes No Yes No No No Yes No Page 2 3.7 Part-Time 3.4 Part-Time 3.4 Part-Time 3.1 Part-Time 3.4 Part-Time 2.4 Part-Time 2.9 Part-Time 2.5 Part-Time 3.5 Part-Time 3.2 Part-Time 40 40 50 50 42 40 40 55 30 70 8f09f0cc09f4d27c10c4d94b745d9b0db2a29b19 Social Networking Satisfaction Spending Computer Text Messages 1 3 350 Laptop 200 1 4 360 Laptop 50 2 4 600 Laptop 200 4 6 600 Laptop 250 2 4 500 Laptop 100 3 2 700 Laptop 30 1 3 500 Laptop 50 1 2 200 Tablet 300 0 4 500 Laptop 400 1 4 200 Laptop 100 2 5 400 Laptop 200 2 3 500 Laptop 100 2 3 400 Desktop 45 1 3 400 Laptop 150 3 4 600 Laptop 400 4 4 500 Laptop 175 1 4 450 Laptop 150 2 3 600 Laptop 300 2 5 500 Laptop 300 2 6 300 Laptop 350 1 3 690 Laptop 50 1 4 600 Laptop 500 0 4 300 Laptop 35 1 5 400 Laptop 600 1 3 600 Laptop 300 0 1 300 Laptop 40 1 5 375 Laptop 300 3 1 900 Laptop 100 1 6 1100 Laptop 60 1 4 400 Laptop 140 2 3 500 Laptop 750 3 1 300 Laptop 300 1 4 200 Laptop 70 1 4 1400 Laptop 800 1 5 500 Laptop 300 1 4 450 Desktop 300 1 4 500 Laptop 100 2 3 500 Laptop 600 1 6 600 Laptop 50 2 5 300 Laptop 100 1 4 680 Desktop 200 1 4 600 Laptop 350 2 5 300 Laptop 50 1 5 100 Laptop 900 2 5 650 Desktop 500 1 4 650 Laptop 150 1 3 350 Laptop 200 2 4 500 Laptop 150 2 4 220 Laptop 105 1 3 520 Laptop 105 2 4 600 Tablet 100 1 4 500 Laptop 200 Page 3 8f09f0cc09f4d27c10c4d94b745d9b0db2a29b19 3 1 1 1 1 1 2 1 2 2 4 5 4 1 1 3 4 4 3 3 300 Laptop 500 Laptop 250 Desktop 300 Laptop 200 Laptop 1000 Laptop 350 Laptop 500 Laptop 490 Laptop 250 Laptop Page 4 700 300 700 300 100 10 250 500 50 0