Dr. Karl Ware is a Professor of Business Law at DeVry/ Keller University and has

Question

Dr. Karl Ware is a Professor of Business Law at DeVry/ Keller University and has recruited "30" Florida Residents and Prelaw Students from "3" Florida Historically Black Colleges and Universities (HBCUs) to get GPA, Veteran Status, Major, Demographic Data (such as Ethnic Background, Sex, Fluent Languages, and Law Specialty Interest: Forensics, Criminal, Family, etc. He currently has the data saved in a Microsoft Excel workbook with data from each HBCU on a separate worksheet.

Part 1: Given the Professor's needs, summarize how he can consolidate this data to output average GPA, minimum, and maximum GPA

Part 2: Partition the diversity of females, males, Fluent Languages, and Veterans

Part 3: Display the ethnicity groups in the context of law specialty to promote diversity and inclusion in column charts.

Explanation / Answer

Dr. Karl Ware, a professor of business Lawc at DeVry/Kellar University.

Excel Sheet details can be used as special sheet for viewing all the necessary data.

The excel sheet contains details like

The above details are useful to have a complete idea on the recruited students. This can help the professor to set the GPA of students.He can filter the conditions and know the Maximum GPA, minimum GPA and Average GPA.

The partiton set the columns into females males fluent languages and veterans.

The professor can also know the law speciality interests and add up to GPA

1A) The Data in the Excel sheet helps to

Name or Resident Area Veteran Status Major Demographic Data Florida residents 1-30 Ethnic background Sex    Fluent languages Law Speciality interests Prelaw students Ethnic Background Sex Fluent Languages Law Speciality Interests G.P.A

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.