Reference no: EM131762157
Practice Problems: Student data
Use the Student.xls file which consists of 100 fictional graduate students at Concordia. It includes variables regarding their age, gender, major, employment status, BS GPA, MBA GPA, and weekly hours spent studying.
- PRACTICE PROBLEM 1: Using the CATEGORICAL_ANALYSIS.xls file, perform a categorical analysis on the majors of students enrolled in the MBA. Describe your findings.
- PRACTICE PROBLEM 2: Using the FREQUENCY_DISTRIBUTION.xls file, create a frequency distribution & histogram on the GPAs of the students. Use ranges of 2.50-2.75, 2.75¬3.00, 3.25-3.50, 3.50-3.75 and 3.75-4.00. Describe your findings.
- PRACTICE PROBLEM 3: Using the DESCRIPTIVE_STATISTICS.xls file, compute the descriptive statistics for the weekly hours spent studying. Describe your findings. Solutions are provided to practice problems so you can check your work.
Attachment:- Student Data.xls