Question
For this exercise, open the data file called Hw2_Dataset1.xlsx. This file contains two main tabs. The first tab in the file contains the data. The
For this exercise, open the data file called Hw2_Dataset1.xlsx. This file contains two main tabs. The first tab in the file contains the data. The second tab contains a description of the variables in the data set. 1. Plot a Column or Bar Chart for math and write scores in one figure. 2. Plot a Histogram of math scores for the students. 3. What is the mean, min, max, sum, and count of math scores for students across this set which their math score is above of 310? 4. Highlight the grade of students which their math score is above of 310 (Hint: using conditional filtering). 5. Calculate the mean, sum, count, min, and max of math scores for Female students
on- 567856665886876678836587956397 133334421433444232314434414223 th-91183212 315 17185 3 1 31 2 2 27481 153141 193 3217 2232 26 22 2 2 hoc 121-333-22-322311213331222332- Bd 1211121122-222211211211222212- 4 2 12345 6789 0123456789 01 4 2222 22233 on- 567856665886876678836587956397 133334421433444232314434414223 th-91183212 315 17185 3 1 31 2 2 27481 153141 193 3217 2232 26 22 2 2 hoc 121-333-22-322311213331222332- Bd 1211121122-222211211211222212- 4 2 12345 6789 0123456789 01 4 2222 22233
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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