stat help

strength
case-study-calculations.xlsx
Home>Mathematics homework help>Statistics homework help>stat help

westmore(2)

ID MBAGPA GMAT UGPA UGRAT AGE International UG_MAJ = 1 UG_MAJ = 2 UG_MAJ = 3 Regression Admit ADMIT DON'T ADMIT
4001 3.20 540 2.97 3 25 0 1 0 0 3.382202 3.685
4002 2.96 540 2.53 4 23 0 1 0 0 3.147967 3.907
4003 3.98 510 3.73 4 25 0 0 0 0 3.325121 3.774
4004 3.29 570 2.91 3 23 0 1 0 0 3.321815 4
4005 3.03 640 2.64 5 23 0 1 0 0 3.607943 3.764
4006 2.86 540 2.72 4 25 0 1 0 0 3.19056 3.965
4007 2.85 470 2.60 3 25 0 1 0 0 3.0888 3.317
4008 3.39 670 3.23 4 25 0 1 0 0 3.828398 3.42
4009 3.42 560 2.99 3 23 0 0 0 1 3.310993 3.964
4010 3.89 540 2.81 3 24 0 0 0 1 3.148522 3.288
4011 2.90 570 2.81 3 24 0 0 1 0 3.436522 3.666
4012 3.84 700 3.97 3 25 0 1 0 0 3.948195 3.745
4013 3.28 640 3.22 5 23 0 1 0 0 3.602283 3.69
4014 3.26 610 2.58 4 22 0 1 0 0 3.306786 3.72
4015 3.28 640 2.46 4 22 0 0 1 0 3.369357 3.341
4016 3.01 510 2.95 3 23 1 1 0 0 3.08885 3.331
4017 3.63 650 3.54 5 23 0 0 1 0 3.838643 2.829
4018 3.09 560 3.05 5 24 0 1 0 0 3.45915 3.629
4019 3.28 480 2.72 3 23 0 0 0 1 3.01056 3.258
4020 3.84 690 2.59 4 22 0 0 1 0 3.610455 3.093
4021 3.71 540 3.28 3 28 0 0 0 1 3.314771 3.226
4022 3.16 540 3.08 3 24 0 1 0 0 3.269948 3.297
4023 3.12 510 2.73 4 27 1 1 0 0 3.03979 3.155
4024 3.98 580 3.28 3 23 0 0 0 1 3.569548 3.46
4025 3.70 700 2.94 5 23 0 0 1 0 3.656397 2.939
4026 2.83 480 2.92 1 22 0 1 0 0 2.992829 3.319
4027 3.59 580 3.17 4 26 0 0 0 1 3.546356 3.902
4028 3.12 570 2.71 3 27 0 1 0 0 3.215999 3.541
4029 3.94 550 2.86 3 24 1 0 0 1 3.387449 3.046
4030 3.41 580 2.39 4 23 0 0 0 1 3.17397 3.248
4031 3.28 610 2.72 3 22 0 0 1 0 3.33756 3.08
4032 3.53 600 2.51 5 24 0 0 0 1 3.457615 3.199
4033 3.30 650 3.09 5 26 0 1 0 0 3.738293 3.446
4034 2.81 430 2.45 2 32 0 1 0 0 2.799681 3.368
4035 3.30 570 3.25 4 22 1 0 0 1 3.398304 2.827
4036 3.14 570 2.44 2 22 1 0 1 0 3.217228 3.091
4037 3.48 670 2.83 5 23 0 1 0 0 3.604421 3.221
4038 2.88 490 2.24 3 26 0 1 0 0 3.067405 2.996
4039 2.94 680 3.08 5 24 0 0 1 0 3.82584 2.989
4040 3.38 660 3.11 4 26 1 0 1 0 3.637753 3.17
4041 3.06 470 2.24 3 22 0 0 0 1 3.007851 3.181
4042 3.27 680 3.09 4 24 0 1 0 0 3.828739 3.037
4043 3.12 540 3.38 3 25 0 1 0 0 3.273848 3.111
4044 3.66 670 3.96 5 22 0 1 0 0 3.857972 3.358
4045 3.37 650 2.70 5 24 0 1 0 0 3.651769 3.276
4046 3.99 680 3.42 4 23 0 0 0 1 3.76666 3.418
4047 3.98 540 3.27 2 23 0 0 0 1 3.249764 2.585
4048 3.64 650 2.38 5 24 0 0 1 0 3.579517 3.172
4049 2.61 570 2.36 4 23 0 0 1 0 3.334834 2.876
4050 2.93 460 2.84 2 28 0 1 0 0 3.112766 3.266
4051 2.82 520 2.53 4 24 0 0 1 0 3.224082 3.248
4052 3.78 500 2.49 3 23 0 0 0 1 3.15427 3.366
4053 2.79 510 2.43 3 24 0 1 0 0 3.036782 3.003
4054 3.42 630 3.00 4 25 0 1 0 0 3.523669 2.703
4055 3.68 610 3.14 2 22 0 1 0 0 3.628328 2.903
4056 3.28 570 3.09 4 22 1 1 0 0 3.496955 2.999
4057 2.59 500 2.92 3 22 0 1 0 0 3.251052 3.097
4058 2.85 480 2.44 3 27 0 0 1 0 3.082897 3.748
4059 3.50 670 3.69 5 25 0 1 0 0 3.79687 3.136
4060 3.20 590 3.00 3 24 0 1 0 0 3.402554 3.116
4061 2.60 460 2.56 3 26 0 1 0 0 2.914434 3.112
4062 3.28 620 2.90 4 24 0 1 0 0 3.470031 3.228
4063 3.98 750 3.69 5 23 1 0 0 1 4.170755 3.13
4064 3.20 580 3.14 3 23 0 1 0 0 3.403328 2.641
4065 2.74 490 2.68 3 22 0 1 0 0 3.030525 2.897
4066 2.79 540 2.78 3 24 0 1 0 0 3.339163 3.22
4067 2.74 450 2.33 2 27 1 1 0 0 2.770367 2.491
4068 2.95 510 2.24 3 23 0 0 1 0 2.993966 2.466
4069 3.21 580 2.98 4 23 0 1 0 0 3.503094 3.727
4070 2.72 460 2.41 2 33 1 1 0 0 3.017322 2.91
4071 3.23 550 2.73 4 22 1 1 0 0 3.35779 2.505
4072 2.87 540 2.85 4 23 0 0 1 0 3.354104 2.884
4073 3.50 630 3.37 4 23 0 1 0 0 3.740064 3.277
4074 3.80 500 2.45 5 32 0 0 0 1 3.144458 3.268
4075 3.98 590 3.18 3 22 0 0 0 1 3.578363 2.991
4076 3.92 600 3.20 3 26 0 0 0 1 3.477377 3.572
4077 3.21 540 2.46 4 24 0 0 0 1 3.267134 2.799
4078 2.93 430 2.38 1 24 0 0 0 1 2.784963 2.806
4079 3.27 600 2.94 3 24 0 1 0 0 3.418951 2.937
4080 3.50 540 2.86 5 23 0 0 0 1 3.356334 3.624
4081 2.89 520 2.55 2 24 0 1 0 0 3.091981 3.136
4082 3.53 690 3.16 4 23 0 0 1 0 3.737565 3
4083 2.62 460 2.56 2 24 0 0 0 1 2.913765 2.998
4084 3.04 570 2.60 4 22 0 1 0 0 3.190577 2.709
4085 3.98 660 2.83 4 22 0 0 0 1 3.511867 2.977
4086 3.39 600 2.82 4 24 0 1 0 0 3.393083 2.821
4087 3.79 670 2.49 5 23 0 0 1 0 3.529493 2.808
4088 3.36 600 3.46 3 23 1 0 0 1 3.67058 2.863
4089 3.55 600 3.04 4 24 0 0 0 1 3.378251 3.068
4090 3.17 520 2.58 1 23 0 1 0 0 3.099563 2.92
4091 2.87 560 2.30 3 22 0 1 0 0 3.156231 2.65
4092 3.14 630 2.71 2 23 0 0 1 0 3.395107 2.379
4093 3.52 670 3.26 3 23 0 1 0 0 3.700534 2.875
4094 2.86 560 2.81 2 25 0 0 1 0 3.405407 2.39
4095 3.93 520 3.75 5 24 0 0 0 1 3.359804 2.582
4096 2.91 500 2.70 4 22 0 0 0 1 3.002877 2.459
5001 2.71 520 2.69 3 23 0 1 0 0 3.124539 2.978
5002 3.52 550 3.08 3 28 0 1 0 0 3.237617 2.853
5003 3.03 600 2.81 3 26 0 1 0 0 3.390184 3.085
5004 2.87 570 3.02 3 22 0 1 0 0 3.481345 2.858 Constant 1.0992783406
5005 2.96 520 2.57 4 22 0 1 0 0 3.096887 2.656 GMAT 0.0026807797
5006 3.02 610 2.98 4 24 0 0 1 0 3.592871 2.814 UGPA 0.2231495899
5007 3.45 680 3.72 3 22 0 0 1 0 3.83356 3.015 UG_MAJ = 1 -0.1347837991
5008 3.98 500 2.55 3 25 1 0 0 1 2.96965 2.753 UG_MAJ = 2 -0.197720117
5009 2.92 500 3.16 3 27 0 0 0 1 3.167788 2.869
5010 3.52 740 3.29 4 23 0 0 1 0 3.917224 2.999
5011 2.51 570 2.39 4 23 0 0 1 0 3.205855 2.853
5012 3.98 570 3.10 3 23 0 0 0 1 3.301631 2.72
5013 3.27 480 2.60 3 23 1 0 0 1 2.983131 3.376
5014 3.98 570 3.27 3 24 1 0 0 1 3.402318 3.05
5015 3.27 600 3.07 3 24 0 0 1 0 3.448164 2.905
5016 3.23 490 2.71 1 24 0 1 0 0 3.038107 2.747
5017 3.15 520 2.91 3 25 0 1 0 0 3.172707 2.584
5018 3.18 590 2.92 4 23 1 1 0 0 3.32216 2.324
5019 3.17 580 2.87 4 22 1 1 0 0 3.343787 2.844
5020 3.57 640 3.67 5 23 0 0 0 1 3.701518 3.226
5021 2.75 490 2.10 3 24 0 1 0 0 3.036631 3.156
5022 3.41 600 2.88 4 22 1 0 0 1 3.405348 3.079
5023 3.11 570 2.76 3 22 0 1 0 0 3.290372 2.764
5024 3.98 700 3.32 5 24 0 0 0 1 3.803691 2.713
5025 3.71 520 2.71 2 25 0 0 0 1 3.064438 3.092
5026 3.29 610 3.00 4 25 0 0 0 1 3.462108 3.076
5027 2.80 530 2.60 2 23 0 0 1 0 3.268354 2.458
5028 2.82 520 2.40 3 24 0 1 0 0 3.194423 2.706
5029 3.47 670 3.32 4 23 0 0 1 0 3.651137 2.774
5030 2.79 560 2.53 3 27 0 0 1 0 3.207967 2.599
5031 3.98 670 3.76 4 22 0 0 0 1 3.813372 2.974
5032 3.87 570 2.91 5 24 0 0 0 1 3.25993 2.846
5033 3.32 660 3.30 3 22 0 1 0 0 3.616231 2.839
5034 3.18 580 2.77 3 24 1 0 1 0 3.322602 2.824
5035 2.99 520 2.63 4 23 0 1 0 0 3.047936 2.568
5036 3.35 400 3.40 1 30 0 0 0 1 2.921531 3.355
5037 3.27 510 3.12 3 29 0 1 0 0 3.18976 2.811
5038 3.78 560 3.37 2 22 1 0 0 1 3.331618 2.814
5039 3.30 610 2.85 5 26 0 0 1 0 3.430219 2.932
5040 3.44 690 3.33 4 23 0 0 1 0 3.776813 2.655
5041 3.88 760 3.77 5 22 0 1 0 0 4.022602 2.916
5042 2.92 570 2.32 3 23 0 1 0 0 3.325914 3.352
5043 2.56 470 2.34 4 23 0 1 0 0 2.895151 2.73
5044 2.77 460 3.35 1 22 0 0 0 1 3.028496 2.464
5045 3.37 610 3.12 4 22 0 1 0 0 3.623868 3.01
5046 3.98 460 2.52 2 24 0 0 0 1 2.841845 2.809
5047 3.31 600 2.66 4 22 0 1 0 0 3.356288 2.781
5048 2.92 570 2.84 4 24 1 1 0 0 3.443212 2.699
5049 2.93 570 2.84 3 23 0 0 1 0 3.307097 2.872
5050 3.90 570 2.80 3 24 0 0 0 1 3.298177 2.318
5051 2.98 540 2.28 3 23 0 1 0 0 3.091325 2.72
5052 2.88 560 2.66 5 27 0 1 0 0 3.236065 3.12
5053 2.71 590 2.57 3 26 0 0 1 0 3.306664 2.81
5054 2.93 520 2.52 3 25 0 0 1 0 3.086183 2.909
5055 2.98 590 2.58 5 23 0 1 0 0 3.445232 2.55
5056 2.96 590 2.88 5 23 0 1 0 0 3.375125 2.297
5057 2.75 510 2.20 4 26 0 1 0 0 2.921377 2.848
5058 3.63 670 3.75 4 31 0 1 0 0 3.944135 2.49
5059 3.98 760 3.91 4 22 0 1 0 0 4.052261 2.436
5060 3.00 530 2.81 4 25 1 1 0 0 3.18063 2.95
5061 3.46 550 2.82 2 24 0 1 0 0 3.243752 2.529
5062 2.81 470 2.39 3 27 0 1 0 0 3.041747 2.72
5063 3.68 610 2.99 4 23 0 0 0 1 3.397547 2.529
5064 3.00 610 2.75 5 24 0 0 1 0 3.542919 2.446
5065 3.75 480 3.01 2 24 0 0 0 1 3.01223 2.385
5066 3.20 590 3.00 2 26 0 1 0 0 3.34 2.358
5067 3.67 560 3.13 3 25 0 0 0 1 3.34199 2.693
5068 3.31 540 3.23 2 23 0 1 0 0 3.438398 2.597
5069 3.05 570 3.00 3 25 0 1 0 0 3.342777 2.924
5070 2.76 470 2.66 3 24 0 1 0 0 2.967849 2.632
5071 2.82 570 2.85 3 25 1 0 1 0 3.245658 2.753
5072 3.05 610 2.81 5 23 1 1 0 0 3.419738 2.73
5073 3.98 580 3.45 4 25 0 0 0 1 3.472458 2.581
5074 2.86 610 3.11 4 23 0 1 0 0 3.487976 2.569
5075 3.05 580 2.85 4 23 1 1 0 0 3.340219 2.547
5076 2.85 560 2.92 3 24 0 0 1 0 3.294268 2.275
5077 3.29 630 2.32 5 22 0 0 1 0 3.372252 2.604
5078 3.26 650 2.47 4 22 0 1 0 0 3.400918 2.598
5079 3.30 510 3.36 3 29 0 1 0 0 3.242165 2.401
5080 3.98 560 3.90 5 28 0 0 0 1 3.649146 3.397
5081 3.32 560 3.57 2 24 0 1 0 0 3.440556 2.923
5082 3.00 610 2.65 4 24 1 1 0 0 3.51995 2.555
5083 2.96 580 2.75 4 22 0 1 0 0 3.451581 2.515
5084 2.94 510 2.60 4 24 0 1 0 0 3.074692 2.709
5085 2.98 560 3.09 3 24 0 0 1 0 3.333516 2.434
5086 3.92 580 3.00 3 24 0 0 0 1 3.507777 2.343
5087 3.08 530 2.75 3 23 0 0 1 0 3.167919 2.675
5088 2.79 590 2.46 5 28 0 0 1 0 3.220472 2.534
5089 3.19 530 2.87 2 22 1 1 0 0 3.131456 2.521
5090 3.27 470 2.34 2 23 0 0 0 1 3.031489 2.237
5091 3.05 540 2.93 2 24 0 1 0 0 3.237836 2.199
5092 3.45 610 3.42 4 25 0 1 0 0 3.556214 2.842
5093 3.92 550 3.22 4 25 1 0 0 1 3.33206 2.663
5094 3.58 690 3.34 4 24 0 0 1 0 3.779043 2.6
5095 3.26 600 3.23 4 23 1 1 0 0 3.483844 2.235
5096 3.37 640 3.17 3 23 0 1 0 0 3.52791 2.242
5097 3.19 670 3.25 5 23 0 0 1 0 3.833304 2.381
5098 3.67 600 3.63 4 23 0 0 0 1 3.573267 2.558
5099 3.46 620 3.36 4 23 1 1 0 0 3.572834 2.389
5100 3.70 500 3.62 4 24 0 0 0 1 3.272152 2.097
5101 2.50 430 2.00 1 23 0 0 1 0 2.7 2.337
5102 3.86 570 2.88 4 23 0 0 0 1 3.254132 2.439
5103 3.37 550 2.81 2 23 0 1 0 0 3.240853 2.414
5104 3.72 720 4.00 5 23 0 1 0 0 4.016 2.329
5105 3.98 620 3.05 4 22 0 0 0 1 3.503258 2.447
5106 3.98 590 2.90 5 24 0 0 0 1 3.318369 2
a) Correlations MBAGPA GMAT UGPA UGRAT AGE International UG_MAJ = 1 UG_MAJ = 2 UG_MAJ = 3
MBAGPA 1
GMAT 0.449174314 1
UGPA 0.5711329981 0.5037596091 1
UGRAT 0.2445836644 0.5815365794 0.2096514197 1
AGE -0.083053042 -0.3062071536 -0.0313143958 -0.0995620735 1
International 0.0101529616 -0.0420428344 0.0085852497 -0.0055634321 -0.0263012109 1
UG_MAJ = 1 -0.3621995037 -0.0428987047 -0.0481793511 -0.0438627952 0.0505160043 0.0278423023 1
UG_MAJ = 2 -0.2011798415 0.2292118681 -0.1564027508 0.0756219132 -0.0590775771 -0.0811501632 -0.520038702 1
UG_MAJ = 3 0.5661079489 -0.150809785 0.1738334914 -0.0256783952 -0.0080570408 0.0474695827 -0.6269796235 -0.3260536696 1
b)
Covariances MBAGPA GMAT UGPA UGRAT AGE International UG_MAJ = 1 UG_MAJ = 2 UG_MAJ = 3
MBAGPA 0.1584763676
GMAT 12.3809186284 4794.147632585
UGPA 0.0923727464 14.1710945005 0.1650626062
UGRAT 0.0989018779 40.9004019214 0.0865200961 1.0317860994
AGE -0.0648018542 -41.5547495344 -0.0249354965 -0.1982158612 3.8414861288
International 0.0014373035 -1.0351926282 0.0012403686 -0.0020096069 -0.0183315361 0.1264581904
UG_MAJ = 1 -0.0720941639 -1.4851485149 -0.0097871287 -0.0222772277 0.0495049505 0.004950495 0.25
UG_MAJ = 2 -0.0327829579 6.4964219194 -0.0260105872 0.0314429958 -0.047397314 -0.0118125674 -0.1064356436 0.1675571022
UG_MAJ = 3 0.1014265298 -4.6995392609 0.0317854132 -0.0117390452 -0.0071071464 0.0075972944 -0.1410891089 -0.0600676404 0.2025536712
c)
Regression Analysis: MBAGPA versus GMAT, UGPA, UG_MAJ = 1, UG_MAJ = 2
The regression equation is
MBAGPA = 1.56 + 0.00259 GMAT + 0.213 UGPA - 0.515 UG_MAJ = 1 - 0.591 UG_MAJ = 2
Predictor Coef SE Coef T P
Constant 1.5604 0.1464 10.66 0.000
GMAT 0.0025917 0.0002932 8.84 0.000
UGPA 0.21297 0.04961 4.29 0.000
UG_MAJ = 1 -0.51490 0.03874 -13.29 0.000
UG_MAJ = 2 -0.59059 0.05132 -11.51 0.000
S = 0.226770 R-Sq = 68.3% R-Sq(adj) = 67.7%
Analysis of Variance
Source DF SS MS F P
Regression 4 21.8440 5.4610 106.19 0.000
Residual Error 197 10.1306 0.0514
Total 201 31.9746
Source DF Seq SS
GMAT 1 6.4507
UGPA 1 5.1054
UG_MAJ = 1 1 3.4777
UG_MAJ = 2 1 6.8102
ADMIT 540 540 510 570 640 540 470 670 560 540 570 700 640 610 640 510 650 560 480 690 540 540 510 580 700 480 580 570 550 580 610 600 650 430 570 570 670 490 680 660 470 680 540 670 650 680 540 650 570 460 520 500 510 630 610 570 500 480 670 590 460 620 750 580 490 540 450 510 580 460 550 540 630 500 590 600 540 430 600 540 520 690 460 570 660 600 670 600 600 520 560 630 670 560 520 500 520 550 600 570 520 610 680 500 500 740 570 570 480 570 600 490 520 590 580 640 490 600 570 700 520 610 530 520 670 560 670 570 660 580 520 400 510 560 610 690 760 570 470 460 610 460 600 570 570 570 540 560 590 520 590 590 510 670 760 530 550 470 610 610 480 590 560 540 570 470 570 610 580 610 580 560 630 650 510 560 560 610 580 510 560 580 530 590 530 470 540 610 550 690 600 640 670 600 620 500 430 570 550 720 620 590 3.6850000000000001 3.907 3.774 4 3.7639999999999998 3.9649999999999999 3.3170000000000002 3.42 3.964 3.2879999999999998 3.6659999999999999 3.7450000000000001 3.69 3.72 3.3410000000000002 3.331 2.8290000000000002 3.629 3.258 3.093 3.226 3.2970000000000002 3.1549999999999998 3.46 2.9390000000000001 3.319 3.9020000000000001 3.5409999999999999 3.0459999999999998 3.2480000000000002 3.08 3.1989999999999998 3.4460000000000002 3.3679999999999999 2.827 3.0910000000000002 3.2210000000000001 2.996 2.9889999999999999 3.17 3.181 3.0369999999999999 3.1110000000000002 3.3580000000000001 3.2759999999999998 3.4180000000000001 2.585 3.1720000000000002 2.8759999999999999 3.266 3.2480000000000002 3.3660000000000001 3.0030000000000001 2.7029999999999998 2.903 2.9990000000000001 3.097 3.7480000000000002 3.1360000000000001 3.1160000000000001 3.1120000000000001 3.2280000000000002 3.13 2.641 2.8969999999999998 3.22 2.4910000000000001 2.4660000000000002 3.7269999999999999 2.91 2.5049999999999999 2.8839999999999999 3.2770000000000001 3.2679999999999998 2.9910000000000001 3.5720000000000001 2.7989999999999999 2.806 2.9369999999999998 3.6240000000000001 3.1360000000000001 3 2.9980000000000002 2.7090000000000001 2.9769999999999999 2.8210000000000002 2.8079999999999998 2.863 3.0680000000000001 2.92 2.65 2.379 2.875 2.39 2.5819999999999999 2.4590000000000001 2.9780000000000002 2.8530000000000002 3.085 2.8580000000000001 2.6560000000000001 2.8140000000000001 3.0150000000000001 2.7530000000000001 2.8690000000000002 2.9990000000000001 2.8530000000000002 2.72 3.3759999999999999 3.05 2.9049999999999998 2.7469999999999999 2.5840000000000001 2.3239999999999998 2.8439999999999999 3.226 3.1560000000000001 3.0790000000000002 2.7639999999999998 2.7130000000000001 DON'T ADMIT 540 540 510 570 640 540 470 670 560 540 570 700 640 610 640 510 650 560 480 690 540 540 510 580 700 480 580 570 550 580 610 600 650 430 570 570 670 490 680 660 470 680 540 670 650 680 540 650 570 460 520 500 510 630 610 570 500 480 670 590 460 620 750 580 490 540 450 510 580 460 550 540 630 500 590 600 540 430 600 540 520 690 460 570 660 600 670 600 600 520 560 630 670 560 520 500 520 550 600 570 520 610 680 500 500 740 570 570 480 570 600 490 520 590 580 640 490 600 570 700 520 610 530 520 670 560 670 570 660 580 520 400 510 560 610 690 760 570 470 460 610 460 600 570 570 570 540 560 590 520 590 590 510 670 760 530 550 470 610 610 480 590 560 540 570 470 570 610 580 610 580 560 630 650 510 560 560 610 580 510 560 580 530 590 530 470 540 610 550 690 600 640 670 600 620 500 430 570 550 720 620 590 3.0920000000000001 3.0760000000000001 2.4580000000000002 2.706 2.774 2.5990000000000002 2.9740000000000002 2.8460000000000001 2.839 2.8239999999999998 2.5680000000000001 3.355 2.8109999999999999 2.8140000000000001 2.9319999999999999 2.6549999999999998 2.9159999999999999 3.3519999999999999 2.73 2.464 3.01 2.8090000000000002 2.7810000000000001 2.6989999999999998 2.8719999999999999 2.3180000000000001 2.72 3.12 2.81 2.9089999999999998 2.5499999999999998 2.2970000000000002 2.8479999999999999 2.4900000000000002 2.4359999999999999 2.95 2.5289999999999999 2.72 2.5289999999999999 2.4460000000000002 2.3849999999999998 2.3580000000000001 2.6930000000000001 2.597 2.9239999999999999 2.6320000000000001 2.7530000000000001 2.73 2.581 2.569 2.5470000000000002 2.2749999999999999 2.6040000000000001 2.5979999999999999 2.4009999999999998 3.3969999999999998 2.923 2.5550000000000002 2.5150000000000001 2.7090000000000001 2.4340000000000002 2.343 2.6749999999999998 2.5339999999999998 2.5209999999999999 2.2370000000000001 2.1989999999999998 2.8420000000000001 2.6629999999999998 2.6 2.2349999999999999 2.242 2.3809999999999998 2.5579999999999998 2.3889999999999998 2.097 2.3370000000000002 2.4390000000000001 2.4140000000000001 2.3290000000000002 2.4470000000000001 2

GMAT

Undergrad GPAe

Sheet1

MBAGPA GMAT UGPA UG_MAJ = 1 UG_MAJ = 2 UG_MAJ = 3
3.20 540 2.97 1 0 0
2.96 540 2.53 1 0 0
3.98 510 3.73 0 0 0
3.29 570 2.91 1 0 0
3.03 640 2.64 1 0 0
2.86 540 2.72 1 0 0
2.85 470 2.60 1 0 0
3.39 670 3.23 1 0 0
3.42 560 2.99 0 0 1
3.89 540 2.81 0 0 1
2.90 570 2.81 0 1 0
3.84 700 3.97 1 0 0
3.28 640 3.22 1 0 0
3.26 610 2.58 1 0 0
3.28 640 2.46 0 1 0
3.01 510 2.95 1 0 0
3.63 650 3.54 0 1 0
3.09 560 3.05 1 0 0
3.28 480 2.72 0 0 1
3.84 690 2.59 0 1 0
3.71 540 3.28 0 0 1
3.16 540 3.08 1 0 0
3.12 510 2.73 1 0 0
3.98 580 3.28 0 0 1
3.70 700 2.94 0 1 0
2.83 480 2.92 1 0 0
3.59 580 3.17 0 0 1
3.12 570 2.71 1 0 0
3.94 550 2.86 0 0 1
3.41 580 2.39 0 0 1
3.28 610 2.72 0 1 0
3.53 600 2.51 0 0 1
3.30 650 3.09 1 0 0
2.81 430 2.45 1 0 0
3.30 570 3.25 0 0 1
3.14 570 2.44 0 1 0
3.48 670 2.83 1 0 0
2.88 490 2.24 1 0 0
2.94 680 3.08 0 1 0
3.38 660 3.11 0 1 0
3.06 470 2.24 0 0 1
3.27 680 3.09 1 0 0
3.12 540 3.38 1 0 0
3.66 670 3.96 1 0 0
3.37 650 2.70 1 0 0
3.99 680 3.42 0 0 1
3.98 540 3.27 0 0 1
3.64 650 2.38 0 1 0
2.61 570 2.36 0 1 0
2.93 460 2.84 1 0 0
2.82 520 2.53 0 1 0
3.78 500 2.49 0 0 1
2.79 510 2.43 1 0 0
3.42 630 3.00 1 0 0
3.68 610 3.14 1 0 0
3.28 570 3.09 1 0 0
2.59 500 2.92 1 0 0
2.85 480 2.44 0 1 0
3.50 670 3.69 1 0 0
3.20 590 3.00 1 0 0
2.60 460 2.56 1 0 0
3.28 620 2.90 1 0 0
3.98 750 3.69 0 0 1
3.20 580 3.14 1 0 0
2.74 490 2.68 1 0 0
2.79 540 2.78 1 0 0
2.74 450 2.33 1 0 0
2.95 510 2.24 0 1 0
3.21 580 2.98 1 0 0
2.72 460 2.41 1 0 0
3.23 550 2.73 1 0 0
2.87 540 2.85 0 1 0
3.50 630 3.37 1 0 0
3.80 500 2.45 0 0 1
3.98 590 3.18 0 0 1
3.92 600 3.20 0 0 1
3.21 540 2.46 0 0 1
2.93 430 2.38 0 0 1
3.27 600 2.94 1 0 0
3.50 540 2.86 0 0 1
2.89 520 2.55 1 0 0
3.53 690 3.16 0 1 0
2.62 460 2.56 0 0 1
3.04 570 2.60 1 0 0
3.98 660 2.83 0 0 1
3.39 600 2.82 1 0 0
3.79 670 2.49 0 1 0
3.36 600 3.46 0 0 1
3.55 600 3.04 0 0 1
3.17 520 2.58 1 0 0
2.87 560 2.30 1 0 0
3.14 630 2.71 0 1 0
3.52 670 3.26 1 0 0
2.86 560 2.81 0 1 0
3.93 520 3.75 0 0 1
2.91 500 2.70 0 0 1
2.71 520 2.69 1 0 0
3.52 550 3.08 1 0 0
3.03 600 2.81 1 0 0
2.87 570 3.02 1 0 0
2.96 520 2.57 1 0 0
3.02 610 2.98 0 1 0
3.45 680 3.72 0 1 0
3.98 500 2.55 0 0 1
2.92 500 3.16 0 0 1
3.52 740 3.29 0 1 0
2.51 570 2.39 0 1 0
3.98 570 3.10 0 0 1
3.27 480 2.60 0 0 1
3.98 570 3.27 0 0 1
3.27 600 3.07 0 1 0
3.23 490 2.71 1 0 0
3.15 520 2.91 1 0 0
3.18 590 2.92 1 0 0
3.17 580 2.87 1 0 0
3.57 640 3.67 0 0 1
2.75 490 2.10 1 0 0
3.41 600 2.88 0 0 1
3.11 570 2.76 1 0 0
3.98 700 3.32 0 0 1
3.71 520 2.71 0 0 1
3.29 610 3.00 0 0 1
2.80 530 2.60 0 1 0
2.82 520 2.40 1 0 0
3.47 670 3.32 0 1 0
2.79 560 2.53 0 1 0
3.98 670 3.76 0 0 1
3.87 570 2.91 0 0 1
3.32 660 3.30 1 0 0
3.18 580 2.77 0 1 0
2.99 520 2.63 1 0 0
3.35 400 3.40 0 0 1
3.27 510 3.12 1 0 0
3.78 560 3.37 0 0 1
3.30 610 2.85 0 1 0
3.44 690 3.33 0 1 0
3.88 760 3.77 1 0 0
2.92 570 2.32 1 0 0
2.56 470 2.34 1 0 0
2.77 460 3.35 0 0 1
3.37 610 3.12 1 0 0
3.98 460 2.52 0 0 1
3.31 600 2.66 1 0 0
2.92 570 2.84 1 0 0
2.93 570 2.84 0 1 0
3.90 570 2.80 0 0 1
2.98 540 2.28 1 0 0
2.88 560 2.66 1 0 0
2.71 590 2.57 0 1 0
2.93 520 2.52 0 1 0
2.98 590 2.58 1 0 0
2.96 590 2.88 1 0 0
2.75 510 2.20 1 0 0
3.63 670 3.75 1 0 0
3.98 760 3.91 1 0 0
3.00 530 2.81 1 0 0
3.46 550 2.82 1 0 0
2.81 470 2.39 1 0 0
3.68 610 2.99 0 0 1
3.00 610 2.75 0 1 0
3.75 480 3.01 0 0 1
3.20 590 3.00 1 0 0
3.67 560 3.13 0 0 1
3.31 540 3.23 1 0 0
3.05 570 3.00 1 0 0
2.76 470 2.66 1 0 0
2.82 570 2.85 0 1 0
3.05 610 2.81 1 0 0
3.98 580 3.45 0 0 1
2.86 610 3.11 1 0 0
3.05 580 2.85 1 0 0
2.85 560 2.92 0 1 0
3.29 630 2.32 0 1 0
3.26 650 2.47 1 0 0
3.30 510 3.36 1 0 0
3.98 560 3.90 0 0 1
3.32 560 3.57 1 0 0
3.00 610 2.65 1 0 0
2.96 580 2.75 1 0 0
2.94 510 2.60 1 0 0
2.98 560 3.09 0 1 0
3.92 580 3.00 0 0 1
3.08 530 2.75 0 1 0
2.79 590 2.46 0 1 0
3.19 530 2.87 1 0 0
3.27 470 2.34 0 0 1
3.05 540 2.93 1 0 0
3.45 610 3.42 1 0 0
3.92 550 3.22 0 0 1
3.58 690 3.34 0 1 0
3.26 600 3.23 1 0 0
3.37 640 3.17 1 0 0
3.19 670 3.25 0 1 0
3.67 600 3.63 0 0 1
3.46 620 3.36 1 0 0
3.70 500 3.62 0 0 1
2.50 430 2.00 0 1 0
3.86 570 2.88 0 0 1
3.37 550 2.81 1 0 0
3.72 720 4.00 1 0 0
3.98 620 3.05 0 0 1
3.98 590 2.90 0 0 1

_STDS_DG5EB2EC6

Name Data Set #1 StatTools Version that generated sheet, Major 5 StatTools Version that generated sheet, Minor 5 StatTools Version that generated sheet, Revision 1 Min. StatTools Version to Read Sheet, Major (note ST versions before 1.1.1 don't perform forward compatibility check) 1 Min. StatTools Version to Read Sheet, Minor 0 Min. StatTools Version to Read Sheet, Revision 0 Min. StatTools version to not put up warning about extra info, Major 1 Min. StatTools version to not put up warning about extra info, Minor 0 Min. StatTools version to not put up warning about extra info, Revision 0
GUID DG5EB2EC6
Format Range 0
Variable Layout Columns
Variable Names In Cells TRUE
Variable Names In 2nd Cells TRUE
Data Set Ranges 2.855
Data Sheet Format 1
Formula Eval Cell 1
Num Stored Vars 11
1 : Info VG4F28C3B6C06631 var1 ST_ID TRUE 1 2
1 : Ranges 4012
1 : MultiRefs
2 : Info VGF154AE1EBC19F7 var2 ST_MBAGPA TRUE 1 4
2 : Ranges 3.28
2 : MultiRefs
3 : Info VG318C643D78A13EC var3 ST_GMAT TRUE 1 2
3 : Ranges 560
3 : MultiRefs
4 : Info VG1AF0E2BC1C3F093 var4 ST_UGPA TRUE 1 4
4 : Ranges 3.28
4 : MultiRefs
5 : Info VG4481097125316CF var5 ST_UGMAJ TRUE 1 4
5 : Ranges ERROR:#REF!
5 : MultiRefs
6 : Info VG1AE7B8BB2706191C var6 ST_UGRAT TRUE 1 3
6 : Ranges 4
6 : MultiRefs
7 : Info VG225F71E635CB2EA7 var7 ST_AGE TRUE 1 3
7 : Ranges 23
7 : MultiRefs
8 : Info VG2301C0642BB8830D var8 ST_FOREIGN TRUE 1 4
8 : Ranges 0
8 : MultiRefs
9 : Info VG7C82DD47276212 UG_MAJ = 1 ST_UGMAJ1 TRUE 0 4
9 : Ranges 0
9 : MultiRefs
10 : Info VG209F88FFFD86326 UG_MAJ = 2 ST_UGMAJ2 TRUE 0 4
10 : Ranges 1
10 : MultiRefs
11 : Info VG209334474F77902 UG_MAJ = 3 ST_UGMAJ3 TRUE 0 4
11 : Ranges 0
11 : MultiRefs