BUSINESS STATISTICS

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 threeassigned problems should be formatted as a one page memo. Answers to all three of the problems should be submitted via the Drop Box asa 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 barchart) 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 onyour findings (100+ words, 3 or more sentences) along with a table covering the descriptive statistics that are important and at leastone 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 & histogramof 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 moresentences) along with a table covering the descriptive statistics that are important and at least one chart that illustrates the pointsraised in your report.