ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 Gender 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Employ Unemployed Full Time Part Time Full Time Full Time Unemployed Full Time Full Time Part Time Full Time Part Time Full Time Full Time Full Time Part Time Full Time Full Time Part Time Full Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Part Time Unemployed Part Time Full Time Full Time Unemployed Full Time Full Time Part Time Part Time Full Time Unemployed Full Time Part Time Full Time Full Time Full Time Unemployed Full Time Full Time Part Time Full Time Full Time Full Time Full Time Age 39 55 43 56 38 54 30 37 38 42 52 35 37 53 51 40 33 53 43 35 57 32 59 48 34 53 35 38 37 46 44 31 51 47 56 42 44 54 51 42 45 55 47 43 57 36 58 46 53 59 49 MBA_GPA 2.82 3.49 3.28 3.25 3.26 2.87 3.16 3.4 2.84 3.72 3.22 3.44 3.65 3.02 3.03 3.8 3.23 3.26 3.53 3.75 3.15 3.66 3.36 3.79 2.85 3.74 3.23 3.52 3.32 2.89 2.83 2.93 3.71 3.47 3.52 2.83 3.64 2.96 3.59 3.33 3.38 3.44 3.31 3.03 3.26 3.04 2.98 2.8 3.75 3.64 3.65 BS GPA 3.05 3.45 3.5 3.55 3.3 3.05 3.35 3.35 3.05 3.7 3.5 3.55 3.9 3.3 3.25 3.8 3.5 3.5 3.75 3.9 3.2 3.75 3.45 3.85 3.05 3.9 3.25 3.7 3.45 3.1 3.05 3.1 3.8 3.75 3.65 3.05 3.55 3.1 3.8 3.55 3.6 3.35 3.45 3.25 3.4 3.25 3.1 3.05 3.75 3.65 3.8 Hrs_Studying 3 7 7 7 6 4 6 6 3 7 7 7 8 6 6 8 7 7 8 8 6 8 7 8 3 8 6 7 7 4 3 5 8 8 7 3 7 4 8 7 7 6 7 6 7 6 5 2 8 7 8 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 Finance Finance Finance Finance Finance Finance Finance Finance Finance Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership No Major Leadership No Major Full Time Full Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Part Time Full Time Part Time Full Time Part Time Full Time Full Time Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Full Time Full Time Full Time Full Time Full Time Full Time Part Time Full Time Full Time Full Time Full Time Full Time Part Time Full Time Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Part Time 34 46 46 33 56 39 51 55 38 33 34 31 37 46 31 47 54 52 43 44 34 59 45 30 32 32 40 48 51 30 31 35 33 35 31 38 46 45 59 58 46 35 53 31 50 38 50 48 53 53 30 32 3.18 3.44 3.06 3.51 3.33 2.81 3.64 3.05 2.85 3.56 2.92 3.35 3.46 3.59 3.11 3.65 3.17 2.97 3.77 3.21 3.17 3.65 2.94 3.53 3.65 3.61 3.7 2.91 3.09 3.77 3.79 3.59 3.38 3.57 2.97 3.44 3.64 3.48 2.99 3.73 2.91 3.78 3.4 3.13 3.14 3.24 3.56 3.16 3.53 3.01 3.3 3.62 3.3 3.4 3.15 3.75 3.4 3.05 3.8 3.4 3.05 3.6 3.1 3.5 3.35 3.75 3.2 3.7 3.5 3.1 3.9 3.2 3.15 3.65 3.1 3.7 3.6 3.7 3.9 3.1 3.25 3.95 3.8 3.6 3.5 3.5 3.1 3.65 3.55 3.4 3.1 3.8 3.05 3.95 3.4 3.15 3.25 3.3 3.5 3.25 3.55 3.15 3.35 3.6 6 7 6 8 7 2 8 7 3 7 5 7 6 8 6 8 7 5 8 6 6 7 5 8 7 8 8 5 6 9 8 7 7 7 5 7 7 7 5 8 4 9 7 6 6 6 7 6 7 6 6 7 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Leadership Leadership No Major Leadership No Major No Major Leadership No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Marketing Marketing Marketing Marketing Marketing Full Time Full Time Full Time Full Time Part Time Full Time Full Time Part Time Full Time Full Time Unemployed Full Time Full Time Part Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Unemployed Part Time Full Time Part Time Full Time Unemployed Part Time Full Time Full Time Full Time Full Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Part Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Part Time Full Time Unemployed Full Time Part Time 42 56 46 49 32 36 42 37 31 31 42 39 47 28 28 52 35 38 44 38 52 53 53 31 47 51 37 46 48 54 48 36 39 28 45 31 47 35 52 52 55 52 46 31 33 45 50 33 37 33 46 55 3.21 3.39 3.65 3.47 3.44 3.88 3.83 3.53 3.22 3.56 3.2 3.17 3.41 3.56 3.34 3.44 3.76 3.55 3.88 3.31 3.09 3.82 3.01 3.66 3.64 3.59 3.49 3.13 3.83 3.04 3.91 3.56 3.96 3.46 3.22 3.27 3.43 3.85 3.89 3.37 3.32 3.54 3.8 3.74 3.17 3.27 3.32 3.56 3.95 3.56 3.79 3.93 3.4 3.4 3.8 3.7 3.6 3.95 3.95 3.6 3.3 3.8 3.25 3.3 3.6 3.7 3.6 3.6 3.8 3.45 3.9 3.45 3.15 4 3.2 3.85 3.7 3.65 3.55 3.2 3.9 3.15 4 3.7 4 3.4 3.15 3.2 3.45 3.95 3.9 3.45 3.3 3.55 3.9 3.85 3.45 3.55 3.3 3.45 4 3.75 3.75 4 7 7 8 8 7 9 9 7 6 8 6 6 7 8 7 7 8 7 8 7 6 9 6 8 8 7 7 6 8 6 10 8 9 7 6 6 7 9 8 7 6 7 8 8 7 7 6 7 9 8 8 9 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Full Time Full Time Part Time Unemployed Part Time Full Time Full Time Full Time Part Time Full Time Full Time Part Time Full Time Full Time Unemployed Part Time Full Time Full Time Part Time Full Time Full Time Part Time Full Time Unemployed Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Full Time Full Time Unemployed Full Time Full Time Full Time Unemployed Full Time Unemployed Part Time Full Time Full Time Part Time Full Time 30 51 35 40 29 52 27 51 56 35 46 39 31 52 32 32 44 43 38 54 27 38 45 48 43 34 54 36 45 28 37 27 31 45 48 50 32 33 49 27 28 36 35 47 33 3.79 3.71 3.05 3.22 3.85 3.82 3.23 3.56 3.53 3.62 3.8 3.47 3.64 3.03 3.17 3.22 3.92 3.82 3.26 3.8 3.2 3.46 3.67 3.06 3.66 3.96 3.75 3.83 3.22 3.36 3.21 3.02 3.99 3.07 3.65 3.67 3.06 3.98 3.93 3.41 3.43 3.7 3.76 3.9 3.23 3.85 3.85 3.35 3.2 3.95 3.95 3.95 3.65 3.65 4 3.95 3.35 3.65 3.15 3.25 3.2 4 3.95 3.55 3.85 3.2 3.35 3.75 3.4 3.85 4 3.85 3.85 3.2 3.35 3.25 3.15 4 3.15 3.65 3.85 3.35 3.7 4 3.3 3.5 3.65 3.75 3.9 3.3 8 8 6 6 9 9 9 7 7 9 9 6 7 5 6 6 10 9 7 8 6 6 8 7 8 10 8 8 6 6 6 5 10 6 7 8 6 8 10 6 7 7 8 8 6 Works FT 1 1 0 1 0 1 1 0 0 1 1 1 0 0 1 1 1 1 0 1 0 1 0 0 0 1 0 1 1 0 1 1 1 1 1 0 1 0 1 1 0 1 0 0 1 0 0 0 1 1 1 Variable descriptions Gender = 0 (female), 1 (male) Major = student's major Age = age of student in years MBA_GPA = overall GPA in the MBA program BS_GPA = overall GPA in the BS program Hrs_Studying = average hours studied per week Works FT = 0 (No), 1 (Yes) 0 1 1 0 1 0 1 0 1 1 0 1 1 1 0 1 0 1 1 1 0 0 0 1 1 1 1 1 0 1 1 1 1 1 0 1 1 1 1 0 0 1 0 0 1 0 1 0 1 0 1 0 0 1 1 1 0 1 1 1 0 1 1 1 1 1 0 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 0 0 1 1 1 1 1 1 1 1 1 1 1 0 1 1 0 1 0 1 0 1 (1) Perform a categorical analysis on the majors of students enrolled in the MBA. Describe your findings. Among the people involved 25% majored in finance. Leadership hand the highest percentage of 35%, 12.5% majored in marketing and finally 25% did not major in any subject. Pie Chart of Major 50, 25.0% 55, 27.5% Category Finance Leadership Marketing No Major 25, 12.5% 70, 35.0% Chart of Major 70 60 Count 50 40 30 20 10 0 Finance Leadership Marketing No Major Major From the pie chart above, it can be observed that leadership hand the highest frequency followed by finance. Marketing hand the lowest frequency. (2) Create a frequency distribution & histogram on the GPAs of the students. Use ranges of 2.50-2.75, 2.753.00, 3.00-3.25, 3.25-3.50, 3.50-3.75 and 3.75-4.00. Describe your findings. classes 2.5-2.75 2.75-3.0 3-3.25 3.25-3.5 3.5-3.75 3.75-4.0 4.0 and more Freque ncy 0 0 0 50 50 50 50 Histogram 60 50 40 30 Frequency 20 10 0 Frequency classes The Gpas are skewed to the right with overall gpa in BS program being equal among three classes. That is 3.25-3.5, 3.5-3.75, 3.75-4.0, 4.0 and more. The first 3 classes hand the no individual within tis classes. That is their frequency is equal to zero. (3) Compute the descriptive statistics for the weekly hours spent studying. Describe your findings. Hrs_Studying Mean 6.895 0.1028 Standard Error 24 Median 7 Mode 7 Standard 1.4541 Deviation 48 Sample 2.1145 Variance 48 1.3565 Kurtosis 21 0.7167 Skewness 9 Range 8 Minimum 2 Maximum Sum Count 10 1379 200 The mode for the weekly hours spent studying is 7. The average weekly hours spent studying is 6.895 with a standard deviation of 1.454. The student who take maximum weekly hours studying take 10 hours and the least one take 2 hours. The Total weekly hours spent studying by all students is 1379 hours Frequency classes Frequency 2.5 0 2.75 0 3 0 3.25 50 3.5 50 3.75 50 4 50 Histogram 60 50 40 30 20 10 0 Frequency 2.5 2.75 3 3.25 3.5 3.75 classes 4 Frequency Hrs_Studying Mean 6.895 Standard E 0.102824 Median 7 Mode 7 Standard D 1.454148 Sample Var 2.114548 Kurtosis 1.356521 Skewness -0.716792 Range 8 Minimum 2 Maximum 10 Sum 1379 Count 200 ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Gender 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Employ Unemployed Full Time Part Time Full Time Full Time Unemployed Full Time Full Time Part Time Full Time Part Time Full Time Full Time Full Time Part Time Full Time Full Time Part Time Full Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Part Time Unemployed Part Time Full Time Full Time Unemployed Full Time Full Time Part Time Part Time Full Time Unemployed Full Time Part Time Full Time Full Time Full Time Unemployed Full Time Full Time Part Time Age 39 55 43 56 38 54 30 37 38 42 52 35 37 53 51 40 33 53 43 35 57 32 59 48 34 53 35 38 37 46 44 31 51 47 56 42 44 54 51 42 45 55 47 43 57 36 58 MBA_GPA 2.82 3.49 3.28 3.25 3.26 2.87 3.16 3.4 2.84 3.72 3.22 3.44 3.65 3.02 3.03 3.8 3.23 3.26 3.53 3.75 3.15 3.66 3.36 3.79 2.85 3.74 3.23 3.52 3.32 2.89 2.83 2.93 3.71 3.47 3.52 2.83 3.64 2.96 3.59 3.33 3.38 3.44 3.31 3.03 3.26 3.04 2.98 BS GPA 3.05 3.45 3.5 3.55 3.3 3.05 3.35 3.35 3.05 3.7 3.5 3.55 3.9 3.3 3.25 3.8 3.5 3.5 3.75 3.9 3.2 3.75 3.45 3.85 3.05 3.9 3.25 3.7 3.45 3.1 3.05 3.1 3.8 3.75 3.65 3.05 3.55 3.1 3.8 3.55 3.6 3.35 3.45 3.25 3.4 3.25 3.1 Hrs_Studying 3 7 7 7 6 4 6 6 3 7 7 7 8 6 6 8 7 7 8 8 6 8 7 8 3 8 6 7 7 4 3 5 8 8 7 3 7 4 8 7 7 6 7 6 7 6 5 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Full Time Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Part Time Full Time Part Time Full Time Part Time Full Time Full Time Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Full Time Full Time Full Time Full Time Full Time Full Time Part Time Full Time Full Time Full Time Full Time Full Time Part Time Full Time 46 53 59 49 34 46 46 33 56 39 51 55 38 33 34 31 37 46 31 47 54 52 43 44 34 59 45 30 32 32 40 48 51 30 31 35 33 35 31 38 46 45 59 58 46 35 53 31 2.8 3.75 3.64 3.65 3.18 3.44 3.06 3.51 3.33 2.81 3.64 3.05 2.85 3.56 2.92 3.35 3.46 3.59 3.11 3.65 3.17 2.97 3.77 3.21 3.17 3.65 2.94 3.53 3.65 3.61 3.7 2.91 3.09 3.77 3.79 3.59 3.38 3.57 2.97 3.44 3.64 3.48 2.99 3.73 2.91 3.78 3.4 3.13 3.05 3.75 3.65 3.8 3.3 3.4 3.15 3.75 3.4 3.05 3.8 3.4 3.05 3.6 3.1 3.5 3.35 3.75 3.2 3.7 3.5 3.1 3.9 3.2 3.15 3.65 3.1 3.7 3.6 3.7 3.9 3.1 3.25 3.95 3.8 3.6 3.5 3.5 3.1 3.65 3.55 3.4 3.1 3.8 3.05 3.95 3.4 3.15 2 8 7 8 6 7 6 8 7 2 8 7 3 7 5 7 6 8 6 8 7 5 8 6 6 7 5 8 7 8 8 5 6 9 8 7 7 7 5 7 7 7 5 8 4 9 7 6 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Leadership Leadership Leadership Leadership Leadership No Major Leadership No Major Leadership Leadership No Major Leadership No Major No Major Leadership No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Part Time Full Time Full Time Full Time Full Time Part Time Full Time Full Time Part Time Full Time Full Time Unemployed Full Time Full Time Part Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Unemployed Part Time Full Time Part Time Full Time Unemployed Part Time Full Time Full Time Full Time Full Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Part Time 50 38 50 48 53 53 30 32 42 56 46 49 32 36 42 37 31 31 42 39 47 28 28 52 35 38 44 38 52 53 53 31 47 51 37 46 48 54 48 36 39 28 45 31 47 35 52 52 3.14 3.24 3.56 3.16 3.53 3.01 3.3 3.62 3.21 3.39 3.65 3.47 3.44 3.88 3.83 3.53 3.22 3.56 3.2 3.17 3.41 3.56 3.34 3.44 3.76 3.55 3.88 3.31 3.09 3.82 3.01 3.66 3.64 3.59 3.49 3.13 3.83 3.04 3.91 3.56 3.96 3.46 3.22 3.27 3.43 3.85 3.89 3.37 3.25 3.3 3.5 3.25 3.55 3.15 3.35 3.6 3.4 3.4 3.8 3.7 3.6 3.95 3.95 3.6 3.3 3.8 3.25 3.3 3.6 3.7 3.6 3.6 3.8 3.45 3.9 3.45 3.15 4 3.2 3.85 3.7 3.65 3.55 3.2 3.9 3.15 4 3.7 4 3.4 3.15 3.2 3.45 3.95 3.9 3.45 6 6 7 6 7 6 6 7 7 7 8 8 7 9 9 7 6 8 6 6 7 8 7 7 8 7 8 7 6 9 6 8 8 7 7 6 8 6 10 8 9 7 6 6 7 9 8 7 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Finance Finance Finance Finance Finance Finance Finance Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Part Time Full Time Unemployed Full Time Part Time Full Time Full Time Part Time Unemployed Part Time Full Time Full Time Full Time Part Time Full Time Full Time Part Time Full Time Full Time Unemployed Part Time Full Time Full Time Part Time Full Time Full Time Part Time Full Time Unemployed Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Full Time Full Time Unemployed Full Time Full Time 55 52 46 31 33 45 50 33 37 33 46 55 30 51 35 40 29 52 27 51 56 35 46 39 31 52 32 32 44 43 38 54 27 38 45 48 43 34 54 36 45 28 37 27 31 45 48 50 3.32 3.54 3.8 3.74 3.17 3.27 3.32 3.56 3.95 3.56 3.79 3.93 3.79 3.71 3.05 3.22 3.85 3.82 3.23 3.56 3.53 3.62 3.8 3.47 3.64 3.03 3.17 3.22 3.92 3.82 3.26 3.8 3.2 3.46 3.67 3.06 3.66 3.96 3.75 3.83 3.22 3.36 3.21 3.02 3.99 3.07 3.65 3.67 3.3 3.55 3.9 3.85 3.45 3.55 3.3 3.45 4 3.75 3.75 4 3.85 3.85 3.35 3.2 3.95 3.95 3.95 3.65 3.65 4 3.95 3.35 3.65 3.15 3.25 3.2 4 3.95 3.55 3.85 3.2 3.35 3.75 3.4 3.85 4 3.85 3.85 3.2 3.35 3.25 3.15 4 3.15 3.65 3.85 6 7 8 8 7 7 6 7 9 8 8 9 8 8 6 6 9 9 9 7 7 9 9 6 7 5 6 6 10 9 7 8 6 6 8 7 8 10 8 8 6 6 6 5 10 6 7 8 192 193 194 195 196 197 198 199 200 0 0 0 0 0 0 0 0 0 Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Full Time Unemployed Full Time Unemployed Part Time Full Time Full Time Part Time Full Time 32 33 49 27 28 36 35 47 33 3.06 3.98 3.93 3.41 3.43 3.7 3.76 3.9 3.23 3.35 3.7 4 3.3 3.5 3.65 3.75 3.9 3.3 6 8 10 6 7 7 8 8 6 Works FT 1 1 0 1 0 1 1 0 0 1 1 1 0 0 1 1 1 1 0 1 0 1 0 0 0 1 0 1 1 0 1 1 1 1 1 0 1 0 1 1 0 1 0 0 1 0 0 Variable descriptions Gender = 0 (female), 1 (male) Major = student's major Age = age of student in years MBA_GPA = overall GPA in the MBA program BS_GPA = overall GPA in the BS program Hrs_Studying = average hours studied per week Works FT = 0 (No), 1 (Yes) 0 1 1 1 0 1 1 0 1 0 1 0 1 1 0 1 1 1 0 1 0 1 1 1 0 0 0 1 1 1 1 1 0 1 1 1 1 1 0 1 1 1 1 0 0 1 0 0 1 0 1 0 1 0 1 0 0 1 1 1 0 1 1 1 0 1 1 1 1 1 0 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 0 0 1 1 1 1 1 1 1 1 1 1 1 0 1 1 0 1 0 1 0 1 (1) Perform a categorical analysis on the majors of students enrolled in the MBA. Describe your findings. Among the people involved 25% majored in finance. Leadership hand the highest percentage of 35%, 12.5% majored in marketing and finally 25% did not major in any subject. Pie Chart of Major 50, 25.0% 55, 27.5% Category Finance Leadership Marketing No Major 25, 12.5% 70, 35.0% Chart of Major 70 60 Count 50 40 30 20 10 0 Finance Leadership Marketing No Major Major From the pie chart above, it can be observed that leadership hand the highest frequency followed by finance. Marketing hand the lowest frequency. (2) Create a frequency distribution & histogram on the GPAs of the students. Use ranges of 2.50-2.75, 2.753.00, 3.00-3.25, 3.25-3.50, 3.50-3.75 and 3.75-4.00. Describe your findings. classes 2.5-2.75 2.75-3.0 3-3.25 3.25-3.5 3.5-3.75 3.75-4.0 4.0 and more Freque ncy 0 0 0 50 50 50 50 Histogram 60 50 40 30 Frequency 20 10 0 Frequency classes The Gpas are skewed to the right with overall gpa in BS program being equal among three classes. That is 3.25-3.5, 3.5-3.75, 3.75-4.0, 4.0 and more. The first 3 classes hand the no individual within tis classes. That is their frequency is equal to zero. (3) Compute the descriptive statistics for the weekly hours spent studying. Describe your findings. Hrs_Studying Mean 6.895 0.1028 Standard Error 24 Median 7 Mode 7 Standard 1.4541 Deviation 48 Sample 2.1145 Variance 48 1.3565 Kurtosis 21 0.7167 Skewness 9 Range 8 Minimum 2 Maximum Sum Count 10 1379 200 The mode for the weekly hours spent studying is 7. The average weekly hours spent studying is 6.895 with a standard deviation of 1.454. The student who take maximum weekly hours studying take 10 hours and the least one take 2 hours. The Total weekly hours spent studying by all students is 1379 hours Frequency classes Frequency 2.5 0 2.75 0 3 0 3.25 50 3.5 50 3.75 50 4 50 Histogram 60 50 40 30 20 10 0 Frequency 2.5 2.75 3 3.25 3.5 3.75 classes 4 Frequency Hrs_Studying Mean 6.895 Standard E 0.102824 Median 7 Mode 7 Standard D 1.454148 Sample Var 2.114548 Kurtosis 1.356521 Skewness -0.716792 Range 8 Minimum 2 Maximum 10 Sum 1379 Count 200 ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Gender 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Employ Unemployed Full Time Part Time Full Time Full Time Unemployed Full Time Full Time Part Time Full Time Part Time Full Time Full Time Full Time Part Time Full Time Full Time Part Time Full Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Part Time Unemployed Part Time Full Time Full Time Unemployed Full Time Full Time Part Time Part Time Full Time Unemployed Full Time Part Time Full Time Full Time Full Time Unemployed Full Time Full Time Part Time Age 39 55 43 56 38 54 30 37 38 42 52 35 37 53 51 40 33 53 43 35 57 32 59 48 34 53 35 38 37 46 44 31 51 47 56 42 44 54 51 42 45 55 47 43 57 36 58 MBA_GPA 2.82 3.49 3.28 3.25 3.26 2.87 3.16 3.4 2.84 3.72 3.22 3.44 3.65 3.02 3.03 3.8 3.23 3.26 3.53 3.75 3.15 3.66 3.36 3.79 2.85 3.74 3.23 3.52 3.32 2.89 2.83 2.93 3.71 3.47 3.52 2.83 3.64 2.96 3.59 3.33 3.38 3.44 3.31 3.03 3.26 3.04 2.98 BS GPA 3.05 3.45 3.5 3.55 3.3 3.05 3.35 3.35 3.05 3.7 3.5 3.55 3.9 3.3 3.25 3.8 3.5 3.5 3.75 3.9 3.2 3.75 3.45 3.85 3.05 3.9 3.25 3.7 3.45 3.1 3.05 3.1 3.8 3.75 3.65 3.05 3.55 3.1 3.8 3.55 3.6 3.35 3.45 3.25 3.4 3.25 3.1 Hrs_Studying 3 7 7 7 6 4 6 6 3 7 7 7 8 6 6 8 7 7 8 8 6 8 7 8 3 8 6 7 7 4 3 5 8 8 7 3 7 4 8 7 7 6 7 6 7 6 5 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Full Time Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Part Time Full Time Part Time Full Time Part Time Full Time Full Time Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Full Time Full Time Full Time Full Time Full Time Full Time Part Time Full Time Full Time Full Time Full Time Full Time Part Time Full Time 46 53 59 49 34 46 46 33 56 39 51 55 38 33 34 31 37 46 31 47 54 52 43 44 34 59 45 30 32 32 40 48 51 30 31 35 33 35 31 38 46 45 59 58 46 35 53 31 2.8 3.75 3.64 3.65 3.18 3.44 3.06 3.51 3.33 2.81 3.64 3.05 2.85 3.56 2.92 3.35 3.46 3.59 3.11 3.65 3.17 2.97 3.77 3.21 3.17 3.65 2.94 3.53 3.65 3.61 3.7 2.91 3.09 3.77 3.79 3.59 3.38 3.57 2.97 3.44 3.64 3.48 2.99 3.73 2.91 3.78 3.4 3.13 3.05 3.75 3.65 3.8 3.3 3.4 3.15 3.75 3.4 3.05 3.8 3.4 3.05 3.6 3.1 3.5 3.35 3.75 3.2 3.7 3.5 3.1 3.9 3.2 3.15 3.65 3.1 3.7 3.6 3.7 3.9 3.1 3.25 3.95 3.8 3.6 3.5 3.5 3.1 3.65 3.55 3.4 3.1 3.8 3.05 3.95 3.4 3.15 2 8 7 8 6 7 6 8 7 2 8 7 3 7 5 7 6 8 6 8 7 5 8 6 6 7 5 8 7 8 8 5 6 9 8 7 7 7 5 7 7 7 5 8 4 9 7 6 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Leadership Leadership Leadership Leadership Leadership No Major Leadership No Major Leadership Leadership No Major Leadership No Major No Major Leadership No Major No Major No Major No Major No Major No Major No Major No Major No Major No Major Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Finance Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Part Time Full Time Full Time Full Time Full Time Part Time Full Time Full Time Part Time Full Time Full Time Unemployed Full Time Full Time Part Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Unemployed Part Time Full Time Part Time Full Time Unemployed Part Time Full Time Full Time Full Time Full Time Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Part Time 50 38 50 48 53 53 30 32 42 56 46 49 32 36 42 37 31 31 42 39 47 28 28 52 35 38 44 38 52 53 53 31 47 51 37 46 48 54 48 36 39 28 45 31 47 35 52 52 3.14 3.24 3.56 3.16 3.53 3.01 3.3 3.62 3.21 3.39 3.65 3.47 3.44 3.88 3.83 3.53 3.22 3.56 3.2 3.17 3.41 3.56 3.34 3.44 3.76 3.55 3.88 3.31 3.09 3.82 3.01 3.66 3.64 3.59 3.49 3.13 3.83 3.04 3.91 3.56 3.96 3.46 3.22 3.27 3.43 3.85 3.89 3.37 3.25 3.3 3.5 3.25 3.55 3.15 3.35 3.6 3.4 3.4 3.8 3.7 3.6 3.95 3.95 3.6 3.3 3.8 3.25 3.3 3.6 3.7 3.6 3.6 3.8 3.45 3.9 3.45 3.15 4 3.2 3.85 3.7 3.65 3.55 3.2 3.9 3.15 4 3.7 4 3.4 3.15 3.2 3.45 3.95 3.9 3.45 6 6 7 6 7 6 6 7 7 7 8 8 7 9 9 7 6 8 6 6 7 8 7 7 8 7 8 7 6 9 6 8 8 7 7 6 8 6 10 8 9 7 6 6 7 9 8 7 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Finance Finance Finance Finance Finance Finance Finance Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Unemployed Full Time Part Time Full Time Full Time Part Time Full Time Part Time Full Time Unemployed Full Time Part Time Full Time Full Time Part Time Unemployed Part Time Full Time Full Time Full Time Part Time Full Time Full Time Part Time Full Time Full Time Unemployed Part Time Full Time Full Time Part Time Full Time Full Time Part Time Full Time Unemployed Full Time Full Time Full Time Full Time Full Time Unemployed Full Time Full Time Full Time Unemployed Full Time Full Time 55 52 46 31 33 45 50 33 37 33 46 55 30 51 35 40 29 52 27 51 56 35 46 39 31 52 32 32 44 43 38 54 27 38 45 48 43 34 54 36 45 28 37 27 31 45 48 50 3.32 3.54 3.8 3.74 3.17 3.27 3.32 3.56 3.95 3.56 3.79 3.93 3.79 3.71 3.05 3.22 3.85 3.82 3.23 3.56 3.53 3.62 3.8 3.47 3.64 3.03 3.17 3.22 3.92 3.82 3.26 3.8 3.2 3.46 3.67 3.06 3.66 3.96 3.75 3.83 3.22 3.36 3.21 3.02 3.99 3.07 3.65 3.67 3.3 3.55 3.9 3.85 3.45 3.55 3.3 3.45 4 3.75 3.75 4 3.85 3.85 3.35 3.2 3.95 3.95 3.95 3.65 3.65 4 3.95 3.35 3.65 3.15 3.25 3.2 4 3.95 3.55 3.85 3.2 3.35 3.75 3.4 3.85 4 3.85 3.85 3.2 3.35 3.25 3.15 4 3.15 3.65 3.85 6 7 8 8 7 7 6 7 9 8 8 9 8 8 6 6 9 9 9 7 7 9 9 6 7 5 6 6 10 9 7 8 6 6 8 7 8 10 8 8 6 6 6 5 10 6 7 8 192 193 194 195 196 197 198 199 200 0 0 0 0 0 0 0 0 0 Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Leadership Full Time Unemployed Full Time Unemployed Part Time Full Time Full Time Part Time Full Time 32 33 49 27 28 36 35 47 33 3.06 3.98 3.93 3.41 3.43 3.7 3.76 3.9 3.23 3.35 3.7 4 3.3 3.5 3.65 3.75 3.9 3.3 6 8 10 6 7 7 8 8 6 Works FT 1 1 0 1 0 1 1 0 0 1 1 1 0 0 1 1 1 1 0 1 0 1 0 0 0 1 0 1 1 0 1 1 1 1 1 0 1 0 1 1 0 1 0 0 1 0 0 Variable descriptions Gender = 0 (female), 1 (male) Major = student's major Age = age of student in years MBA_GPA = overall GPA in the MBA program BS_GPA = overall GPA in the BS program Hrs_Studying = average hours studied per week Works FT = 0 (No), 1 (Yes) 0 1 1 1 0 1 1 0 1 0 1 0 1 1 0 1 1 1 0 1 0 1 1 1 0 0 0 1 1 1 1 1 0 1 1 1 1 1 0 1 1 1 1 0 0 1 0 0 1 0 1 0 1 0 1 0 0 1 1 1 0 1 1 1 0 1 1 1 1 1 0 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 0 0 1 1 1 1 1 1 1 1 1 1 1 0 1 1 0 1 0 1 0 1