Question: fID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
\fID 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 52 53 54 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 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 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 Full Time Full Time Unemployed 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 34 46 46 MBA_GPA BS GPA Hrs_Studying 2.82 3.05 3 3.49 3.45 7 3.28 3.5 7 3.25 3.55 7 3.26 3.3 6 2.87 3.05 4 3.16 3.35 6 3.4 3.35 6 2.84 3.05 3 3.72 3.7 7 3.22 3.5 7 3.44 3.55 7 3.65 3.9 8 3.02 3.3 6 3.03 3.25 6 3.8 3.8 8 3.23 3.5 7 3.26 3.5 7 3.53 3.75 8 3.75 3.9 8 3.15 3.2 6 3.66 3.75 8 3.36 3.45 7 3.79 3.85 8 2.85 3.05 3 3.74 3.9 8 3.23 3.25 6 3.52 3.7 7 3.32 3.45 7 2.89 3.1 4 2.83 3.05 3 2.93 3.1 5 3.71 3.8 8 3.47 3.75 8 3.52 3.65 7 2.83 3.05 3 3.64 3.55 7 2.96 3.1 4 3.59 3.8 8 3.33 3.55 7 3.38 3.6 7 3.44 3.35 6 3.31 3.45 7 3.03 3.25 6 3.26 3.4 7 3.04 3.25 6 2.98 3.1 5 2.8 3.05 2 3.75 3.75 8 3.64 3.65 7 3.65 3.8 8 3.18 3.3 6 3.44 3.4 7 3.06 3.15 6 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 104 105 106 107 108 109 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 0 0 0 0 0 0 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 Leadership Leadership No Major Leadership No Major No Major 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 Full Time Full Time Full Time Full Time Part Time Full Time 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 42 56 46 49 32 36 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.21 3.39 3.65 3.47 3.44 3.88 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 3.4 3.4 3.8 3.7 3.6 3.95 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 7 7 8 8 7 9 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 156 157 158 159 160 161 162 163 164 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 0 0 0 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 Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing Marketing 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 Full Time Full Time Part Time Unemployed Part Time Full Time Full Time Full Time Part Time 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 30 51 35 40 29 52 27 51 56 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.79 3.71 3.05 3.22 3.85 3.82 3.23 3.56 3.53 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 3.85 3.85 3.35 3.2 3.95 3.95 3.95 3.65 3.65 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 8 8 6 6 9 9 9 7 7 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 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 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 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.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 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 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 0 1 0 1 1 0 1 1 0 1 0 1 1 1 0 1 1 0 1 0 1 0 1 1 0 1 0 0 0 1 1 0 1 1 0 0 1 0 1 0 1 1 1 0 1 1 0 1 1 1 1 1 1 0 Variable descriptions Gender = 0 (male), 1 (female) 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) 1 0 1 1 0 1 1 1 1 1 1 0 1 0 1 0 1 0 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 0 1 1 1 1 1 0 1 1 1 1 1 1 0 1 0 1 1 1 1 0 1 1 0 1 1 0 1 1 0 0 1 0 1 1 0 1 0 0 1 0 1 0 0 1 1 1 1 0 1 0 1 1 0 1 0 0 1 0 1 1 0 1 0 1 0 1 0 1 1 0 0 0 1 1 1 0 1 1 0 1 1 0 0 1 1 0 1 1 0 1 0 1 1 1 1 1 0 1 1 1 0 1 1 1 0 1 0 0 1 1 0 1 Data Multiple Regression Y 1 X1 Sl.No. Salary Ones Age 1 41711 1 30 2 27739 1 26 3 67977 1 42 4 32950 1 38 5 72899 1 43 6 30096 1 32 7 42513 1 32 8 48630 1 38 9 51450 1 37 10 46319 1 36 11 74425 1 47 12 62426 1 41 13 29495 1 30 14 58297 1 43 15 40470 1 44 16 77395 1 50 17 41410 1 37 18 47300 1 30 19 26074 1 23 20 26451 1 24 21 25367 1 21 22 25820 1 22 23 32008 1 37 24 27996 1 28 25 45999 1 42 26 48924 1 33 27 46986 1 37 28 79550 1 50 29 72464 1 45 30 39932 1 33 X2 Exper 0 1 3 6 4 4 2 5 7 5 4 1 3 13 13 7 15 0 2 3 0 1 5 2 19 0 5 0 0 12 X3 Gender 1 1 0 1 1 1 1 1 0 1 0 0 1 1 0 1 0 1 0 1 1 1 0 0 0 1 1 0 1 1 X4 X5 X6 Page 9 X7 X8 X9 X10 Data 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 55869 52045 26208 30344 58054 68133 31529 35565 35986 24539 25623 44956 31298 28141 29926 60136 26527 56140 43992 28429 54800 37474 29631 55784 31497 54429 31795 94541 36716 62361 69750 44314 49405 76986 31995 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 41 39 23 33 42 51 35 39 40 21 21 41 34 28 31 46 25 41 34 29 54 41 31 40 35 40 36 55 21 47 52 39 42 48 36 9 8 0 4 11 14 5 7 8 0 0 18 4 2 3 10 4 10 3 2 20 10 3 9 5 8 5 9 0 11 15 17 14 6 5 1 1 0 1 0 0 1 1 0 1 0 1 1 1 0 1 1 1 0 1 0 0 1 1 1 1 1 0 1 1 0 0 1 0 1 Page 10 Data 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 31301 39850 59644 49073 37128 66708 38666 44690 47955 31002 42204 80456 49042 77154 25019 64741 46047 52175 30621 49357 27514 27987 25738 64756 41077 37118 51759 97431 85594 85457 32589 28643 51987 33803 43186 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 35 42 44 39 28 49 29 35 32 34 31 54 36 45 21 40 40 49 33 40 26 27 22 48 36 41 38 57 53 52 37 30 45 39 38 5 11 15 7 6 13 7 4 0 4 1 10 7 5 0 0 0 18 4 7 5 1 0 12 14 9 8 10 8 6 6 3 16 6 16 0 1 0 0 1 1 1 1 0 1 0 0 1 0 0 0 1 1 0 1 0 1 1 1 1 1 1 0 1 0 0 0 1 1 0 Page 11 Data Page 12 Data Page 13 Data ??2007 DrJimMirabella.com Page 14 Data Page 15 Data Page 16 Data Page 17 Data Page 18 Data Page 19 Data Page 20 A B C D 1 2 3 4 5 6 7 8 9 10 11 Multiple Regression Results 12 ANOVA Table 13 14 15 16 17 18 19 20 21 22 b s(b) t p-value E 0 1 2 3 Intercept Age Exper Gender -23898 2098.15 -1092.5 -1364.3 16835.4 478.215 795.604 6771.24 -1.41952 4.38747 -1.3732 -0.2015 0.1590 0.0000 0.1729 0.8408 VIF 1.6523 1.6036 F G H I J K L 4 5 6 7 8 9 10 1.0399 Source SS Regn. 2E+010 Error 1E+011 df 3 96 FCritical p-value MS F 8E+009 7.74615 2.69939 0.0001 1E+009 Total 3E+010 99 3E+008 R2 0.7934 s 32530 Adjusted R2 -2.3798 Prediction Interval Given X 1 Age 30 Exper Gender 0 1 23 24 25 26 1-a 95% (1-a) P.I. for Y for given X 37682.1 + or - 65552 1-a 95% (1-a) P.I. for E[Y | X] 37682 + or - 11294 M A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 B C D E F G H I J K L 2 Exper 3 Gender 4 5 6 7 8 9 10 1.0000 -0.0867 1.0000 0.3205 -0.2101 Correlation matrix Correlation 1 Coefficients Age 1 Age 1.0000 2 Exper 0.6127 3 Gender -0.1919 4 5 6 7 8 9 10 Y Salary 0.8525
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
