Question: Aggregate students with the same level of computer programming knowledge (1-5; values stored in the 'ProgSkills' column). For each of the 5 groups of students

Aggregate students with the same level of computer programming knowledge (1-5; values stored in the 'ProgSkills' column). For each of the 5 groups of students (1-5), compute these two statistics: The percentage (0100) of students within the group who know the Python and/or Java programming languages, with level of knowledge on classification methods that is greater than or equal to 2. These values are stored in the 'Python', 'Java', and 'Classification' columns, respectively. This statistic is referred to as 'PJClass\%'. The standard deviation (function std) of students' level of knowledge on clustering methods. These values are stored in the 'Clustering' column. This statistic is referred to as 'StdevClust'. Output a data frame with one row for each level of computer programming knowledge (1-5), and the computed 'PJClass\%' and 'StdevClust' statistics for that group of students. 12 points for result; plus up to 12 progress points
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
