Question in R

id name major gender grade course

1 101 Bill CIS M 92 CIS240

2 102 Mary CIS F 88 CIS240

3 103 Sue Marketing F 82 MKT115

4 104 Tom Finance M 78 DBA120

5 105 Alex CIS M 96 CIS240

6 106 Sam Marketing M 67 MKT115

7 107 Jane Finance F 95 DBA120

Please write down R codes to create a subset and name it student_excellent from data frame student. All of students inside the student_excellent exam grades must be greater than 90. You also need to write down R codes to display the number of female students inside student_excellent (10 points)

Your output should look like the following.

id name major gender grade course

1 101 Bill CIS M 92 CIS240

5 105 Alex CIS M 96 CIS240

7 107 Jane Finance F 95 DBA120

[1] 1