Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions