Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The data set contains one row for every person who filled the survey. We use person and student interchangeably. Job : 0 for those students
The data set contains one row for every person who filled the survey. We use person and student interchangeably.
- Job: 0 for those students without a job, 0.5 for those students with a part-time job, and 1 for those students with a full-time job
- Program: program of enrollment
- C-Regression: indicates whether the student knows (1) or doesn't know (0) a certain programming language or topic
- Classification: indicates the level of knowledge (1-5) on classification
- Clustering: indicates the level of knowledge (1-5) on clustering
- Bach_0to1: 1 if time elapsed from graduation is less than a year; 0 otherwise
- Bach_1to3: 1 if time elapsed from graduation is between one and three years; 0 otherwise
- Bach_3to5: 1 if time elapsed from graduation is between three and five years; 0 otherwise
- Bach_5Plus: 1 if time elapsed from graduation is more than five years; 0 otherwise
Question 1
- Find out the ratio of people that know at least one among Python and Java and their Classification knowledge has to be at least 2.
- Compute the standard deviation of the Clustering knowledge (function std), for people with ProgSkills of 3
Question 2
For the MBA program, how many people have a Programming Skill knowledge of less than 4?
Question 3
Return the rows of those people who know the most Languages
Question 4
Let us define the "data science experience" of a given person as the person's largest score among Regression, Classification, and Clustering. Compute the average data science experience among all MBA students.
| BachTime | Program | ProgSkills | C | CPP | CS | Java | Python | JS | R | SQL | SAS | Excel | Tableau | Regression | Classification | Clustering | Job | Languages | Expert |
| longer than 1 year ago but less than 3 years ago | MSIS | 4 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 4 | 4 | 0 | 6 | 1 |
| over 5 years ago | MSIS | 3 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 2 | 2 | 0.5 | 4 | 0 |
| longer than 3 years ago but less than 5 years ago | MSIS | 3 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 3 | 3 | 0 | 3 | 0 |
| over 5 years ago | MSIS | 3 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 2 | 3 | 0 | 5 | 0 |
| longer than 3 years ago but less than 5 years ago | MSIS | 3 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 4 | 0 |
| longer than 1 year ago but less than 3 years ago | Supply Chain Mgmt & Analytics | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 |
| longer than 1 year ago but less than 3 years ago | MSIS | 3 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 2 | 2 | 0 | 4 | 0 |
| < 1 year ago | MSIS | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 2 | 2 | 0 | 3 | 0 |
| over 5 years ago | MBA | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 0 | 0 |
| over 5 years ago | MSIS | 3 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 2 | 1 | 0.5 | 4 | 0 |
| over 5 years ago | MBA | 4 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 2 | 2 | 0.5 | 5 | 0 |
| over 5 years ago | MBA | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 |
| over 5 years ago | MSIS | 4 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0.5 | 5 | 0 |
| < 1 year ago | Supply Chain Mgmt & Analytics | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 3 | 1 | 0 | 3 | 0 |
| over 5 years ago | MBA | 5 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 2 | 2 | 1 | 5 | 0 |
| over 5 years ago | MBA | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 |
| over 5 years ago | Faculty! | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 5 | 5 | 1 | 3 | 1 |
| over 5 years ago | MBA | 4 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 4 | 4 | 1 | 0 | |||
| longer than 1 year ago but less than 3 years ago | MBA | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 2 | 2 | 0.5 | 1 | 0 |
| longer than 3 years ago but less than 5 years ago | MSIS | 5 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 4 | 0 |
| longer than 1 year ago but less than 3 years ago | MSIS | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 3 | 2 | 0.5 | 2 | 0 |
| over 5 years ago | MSIS | 2 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 5 | 0 |
| longer than 3 years ago but less than 5 years ago | MBA | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 2 | 0 | 1 | 0 |
| longer than 3 years ago but less than 5 years ago | MSIS | 3 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 2 | 2 | 0.5 | 6 | 0 |
| longer than 3 years ago but less than 5 years ago | MBA | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 2 | 2 | 0 | 2 | 0 |
| over 5 years ago | MSIS | 3 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 2 | 1 | 0 | 0 | ||
| longer than 3 years ago but less than 5 years ago | MSIS | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 2 | 3 | 0 | 1 | 0 |
| over 5 years ago | MSIS | 3 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 2 | 2 | 0.5 | 4 | 0 |
| over 5 years ago | MSIS | 3 | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 0.5 | 0 | |||
| longer than 1 year ago but less than 3 years ago | MSIS | 3 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 3 | 0 |
| longer than 1 year ago but less than 3 years ago | MSIS | 3 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 0.5 | 4 | 0 |
| over 5 years ago | Business Man | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 2 | 3 | 1 | 0 | ||
| over 5 years ago | MBA | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 1 | 4 | 4 | 0 | 3 | 1 |
| longer than 3 years ago but less than 5 years ago | MSIS | 3 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 3 | 3 | 0 | 3 | 0 |
| over 5 years ago | MSIS | 4 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 2 | 0 | 6 | 0 |
| over 5 years ago | Master of Finance | 4 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 5 | 0 |
| over 5 years ago | MBA | 3 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 3 | 3 | 1 | 5 | 0 |
| longer than 1 year ago but less than 3 years ago | MSIS | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 |
| over 5 years ago | MBA | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 3 | 0 |
| longer than 3 years ago but less than 5 years ago | MSIS | 3 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 3 | 3 | 0 | 3 | 0 |
| longer than 1 year ago but less than 3 years ago | MSIS | 3 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 3 | 3 | 1 | 6 | 0 |
| longer than 3 years ago but less than 5 years ago | MSIS | 2 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 2 | 1 | 0 | 3 | 0 |
| longer than 1 year ago but less than 3 years ago | MSIS | 4 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 2 | 1 | 0 | 4 | 0 |
| longer than 1 year ago but less than 3 years ago | MSIS | 3 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 5 | 0 |
| over 5 years ago | MSIS | 3 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 5 | 0 |
| longer than 1 year ago but less than 3 years ago | MSIS | 3 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 2 | 2 | 1 | 7 | 0 |
| longer than 1 year ago but less than 3 years ago | MSIS | 4 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 2 | 2 | 0 | 7 | 0 |
| longer than 1 year ago but less than 3 years ago | MSIS | 4 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 2 | 2 | 0 | 5 | 0 |
| longer than 3 years ago but less than 5 years ago | MSIS | 4 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 0.5 | 5 | 0 |
| over 5 years ago | MBA | 3 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 2 | 1 | 1 | 4 | 0 |
| longer than 1 year ago but less than 3 years ago | MBA | 3 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | 3 | 0.5 | 6 | 0 |
| longer than 3 years ago but less than 5 years ago | MSIS | 3 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 3 | 3 | 0 | 3 | 0 |
| longer than 3 years ago but less than 5 years ago | MSIS | 4 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 2 | 2 | 0 | 5 | 0 |
| longer than 3 years ago but less than 5 years ago | MSIS | 3 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 2 | 2 | 0.5 | 5 | 0 |
| longer than 3 years ago but less than 5 years ago | MSIS | 2 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 5 | 0 |
| over 5 years ago | MSIS | 3 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 0.5 | 3 | 0 |
| over 5 years ago | MBA | 2 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | 0 |
| over 5 years ago | MSIS | 4 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | ||
| over 5 years ago | MSIS | 3 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0.5 | 3 | 0 |
| longer than 3 years ago but less than 5 years ago | MSIS | 3 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 2 | 0 | 3 | 0 |
| over 5 years ago | MBA | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 7 | 0 |
Step by Step Solution
★★★★★
3.37 Rating (153 Votes )
There are 3 Steps involved in it
Step: 1
Lets address each question one by one Question 1 Find out the ratio of people that know at least one ...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Essentials Of Statistics
Authors: Mario F Triola
6th Edition
0134687159, 9780134687155
