Use the Student_Data.xls file which consists of 200 MBA students at Whatsamattu U. The file includes variables regarding students’ age,

gender, major, GPA, Bachelors GPA, course load, English speaking status, family, weekly hours spent studying. Each of the three

assigned problems should be formatted as a one page memo. Answers to all three of the problems should be submitted via the Drop Box as

a single Word document with each of the problems clearly labeled. Be sure to include your name on the document itself!

COMPLETE PROBLEM 1: Perform a categorical data analysis on the majors of students enrolled in the MBA program. Report on your findings

(100+ words, 3 or more sentences), along with a table showing the frequency distribution and at least one chart (pie chart or bar

chart) that illustrates the points raised in your report.

COMPLETE PROBLEM 2: Compute the descriptive statistics for the MBA GPAs of the students. Then, create a frequency distribution &

histogram on the GPAs of the students. Use ranges of 2.50-2.75, 2.75-3.00, 3.00-3.25, 3.25-3.50, 3.50-3.75 and 3.75-4.00. Report on

your findings (100+ words, 3 or more sentences) along with a table covering the descriptive statistics that are important and at least

one chart that illustrates the points raised in your report.

COMPLETE PROBLEM 3: Compute the descriptive statistics for the weekly hours spent studying. Create a frequency distribution & histogram

of the hours spent studying. Use ranges of 0-2, 2-4, 4-6, 6-8, 8-10, and 10-12. Report on your findings (100+ words, 3 or more

sentences) along with a table covering the descriptive statistics that are important and at least one chart that illustrates the points