Home |  1.1  | 1.2 | 2.1 | 2.2 | 2.3 | 3.1 | 3.2 | 4.1 | 5.1
Data Visualization Exercises
   Home > Exercise 3.1    
 

Exercise 3.1

Cumulative Average GPA By Gender and Ethnicity.

Male Female
Asian 3.91 3.94
Black 3.70 3.77
Hispanic 3.69 3.56
White 3.86 3.89
Other 3.72 3.75

Complete the following:
  1. Construct a bar graph using Excel to visualize this information.
  2. What gender and ethnicity earned the highest cumulative GPA?
  3. What gender and ethnicity earned the lowest cumulative GPA?
  4. What is the average GPA for Females?
  5. What is the average GPA for Males?
  6. What is the average GPA for those classified as Black?
Upon completion of this exercise, please show your results to your teacher for approval.
 
<< Previous Next >>