+1(978)310-4246 credencewriters@gmail.com
  

Description

ID
MBA_GPA
4001
3.201
4002
2.964
4003
3.745
4004
3.29
4005
3.028
4006
2.855
4007
2.847
4008
3.392
4009
3.035
4010
3.006
4011
2.902
4012
3.836
4013
3.275
4014
3.256
4015
3.283
4016
3.006
4017
3.633
4018
3.092
4019
2.957
4020
3.842
4021
3.546
4022
3.156
4023
3.115
4024
3.38
4025
3.697
4026
2.826
4027
3.443
4028
3.115
4029
3.075
4030
2.971
4031
3.275
4032
3.143
4033
3.302
4034
2.812
4035
3.245
4036
3.14
4037
3.479
4038
2.877
4039
2.943
4040
3.376
4041
2.895
4042
3.268
4043
3.117
4044
3.661
4045
3.373
4046
3.828
GMAT
540
540
580
570
640
540
470
670
560
540
570
700
640
610
640
590
650
560
480
690
540
540
510
580
700
480
580
570
550
580
610
600
650
430
570
570
670
490
620
660
570
680
540
670
650
680
UGPA
UG_MAJ UG_RAT
2.974
3
3
2.529
2
4
3.727
1
4
2.905
1
3
2.641
2
5
2.72
1
4
2.6
1
3
3.226
1
4
2.991
3
3
2.814
3
3
2.814
2
3
3.965
1
3
3.221
1
5
2.582
1
4
2.459
2
4
2.95
1
3
3.541
1
5
3.05
3
5
2.72
3
3
2.585
2
4
3.277
1
3
3.076
3
3
2.73
3
4
3.276
3
3
2.939
1
5
2.923
3
1
3.172
3
4
2.713
1
3
2.863
2
3
2.39
3
4
2.72
2
3
2.505
3
5
3.091
3
5
2.447
3
3
3.248
2
4
2.436
2
2
2.827
1
5
2.235
3
3
3.08
2
5
3.111
2
4
2.237
3
3
3.093
1
4
3.376
3
3
3.964
1
5
2.703
1
5
3.42
1
4
AGE
25
23
25
23
23
25
25
25
23
24
24
25
23
22
22
23
23
24
23
22
28
24
27
23
23
22
26
27
24
23
22
24
26
32
22
22
23
26
24
26
22
24
25
22
24
23
FOREIGN
1
0
1
0
1
0
0
0
0
0
0
1
0
0
0
1
1
0
0
0
0
0
1
0
1
0
0
0
1
0
0
0
0
0
1
1
0
0
0
1
0
0
0
0
0
1
4047
4048
4049
4050
4051
4052
4053
4054
4055
4056
4057
4058
4059
4060
4061
4062
4063
4064
4065
4066
4067
4068
4069
4070
4071
4072
4073
4074
4075
4076
4077
4078
4079
4080
4081
4082
4083
4084
4085
4086
4087
4088
4089
4090
4091
4092
4093
3.364
3.635
2.608
2.93
2.822
3.02
2.787
3.417
3.681
3.28
2.585
2.848
3.496
3.198
2.601
3.282
3.818
3.199
2.738
2.792
2.736
2.945
3.208
2.715
3.232
2.869
3.5
3.568
3.374
3.296
3.178
2.741
3.268
3.081
2.885
3.531
2.812
3.043
3.682
3.393
3.793
3.558
3.065
3.17
2.868
3.137
3.521
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
600
620
600
540
430
600
560
520
690
460
570
660
600
670
600
600
520
560
630
670
3.268
2.379
2.358
2.842
2.534
2.49
2.434
3.003
3.136
3.085
2.924
2.439
3.69
2.998
2.558
2.897
3.685
3.136
2.675
2.781
2.329
2.242
2.978
2.414
2.73
2.848
3.368
2.446
3.181
3.199
2.458
2.381
2.937
2.858
2.547
3.155
2.555
2.599
2.829
2.821
2.491
3.46
3.037
2.581
2.297
2.709
3.258
3
1
2
3
2
3
2
1
1
2
3
2
1
3
2
1
1
1
2
3
3
2
3
2
3
2
1
1
2
2
3
3
2
3
2
2
3
2
1
1
2
1
3
1
1
2
1
2
5
4
2
4
3
3
4
2
4
3
3
5
3
3
4
5
3
3
3
2
3
4
2
4
4
4
5
3
3
4
3
3
5
2
4
2
4
4
4
5
3
4
1
3
2
3
23
24
23
28
24
23
24
25
22
22
22
27
25
24
26
24
23
23
22
24
27
23
23
33
22
23
23
32
22
26
24
24
24
23
24
23
24
22
22
24
23
23
24
23
22
23
23
0
0
0
0
0
0
0
0
1
1
0
0
0
0
0
0
1
1
0
0
1
0
0
1
1
0
0
0
0
0
0
0
0
0
0
1
0
0
1
0
0
1
0
0
0
0
0
4094
4095
4096
5001
5002
5003
5004
5005
5006
5007
5008
5009
5010
5011
5012
5013
5014
5015
5016
5017
5018
5019
5020
5021
5022
5023
5024
5025
5026
5027
5028
5029
5030
5031
5032
5033
5034
5035
5036
5037
5038
5039
5040
5041
5042
5043
5044
2.864
3.517
2.638
2.71
3.516
3.027
2.866
2.959
3.02
3.452
2.947
3.056
3.52
2.509
3.463
3.233
2.981
3.272
3.225
3.153
3.18
3.165
3.444
2.746
3.015
3.113
3.829
3.369
3.211
2.802
2.821
3.474
2.787
3.952
3.032
3.316
3.176
2.991
2.468
3.269
3.335
3.296
3.435
3.88
2.915
2.562
2.704
560
520
500
520
550
600
570
520
610
680
500
500
740
570
570
520
570
600
490
560
590
580
640
490
600
570
700
520
610
530
520
670
560
670
570
660
580
520
400
610
560
610
690
760
570
470
460
2.809
3.748
2.699
2.693
3.079
2.808
3.015
2.569
2.977
3.72
2.55
3.156
3.288
2.385
3.097
2.597
3.266
3.068
2.709
2.909
2.92
2.869
3.666
2.097
2.876
2.764
3.317
2.706
2.996
2.598
2.401
3.319
2.529
3.764
2.91
3.297
2.774
2.632
3.397
3.12
3.366
2.853
3.331
3.774
2.318
2.337
3.352
2
1
3
2
1
3
2
1
2
2
3
3
2
2
3
2
3
2
1
1
2
1
1
3
3
1
1
3
3
2
3
2
2
1
3
1
2
1
3
1
3
3
2
1
2
3
3
2
5
4
3
3
3
3
4
4
3
3
3
4
4
3
3
3
3
1
3
4
4
5
3
4
3
5
2
4
2
3
4
3
4
5
3
3
4
3
3
2
5
4
5
3
4
3
25
24
22
23
28
26
22
22
24
22
25
27
23
23
23
23
24
24
24
25
23
22
23
24
22
22
24
25
25
23
24
23
27
22
24
22
24
23
30
29
22
26
23
22
23
23
22
0
0
0
0
0
1
0
0
1
0
1
0
0
0
0
1
1
0
0
0
1
1
0
0
1
0
1
0
1
0
0
0
0
1
0
0
1
1
0
0
1
0
0
1
0
0
0
5045
5046
5047
5048
5049
5050
5051
5052
5053
5054
5055
5056
5057
5058
5059
5060
5061
5062
5063
5064
5065
5066
5067
5068
5069
5070
5071
5072
5073
5074
5075
5076
5077
5078
5079
5080
5081
5082
5083
5084
5085
5086
5087
5088
5089
5090
5091
3.367
3.466
3.313
2.916
2.931
3.255
2.976
2.883
2.708
2.93
2.981
2.964
2.747
3.626
4
3.002
3.464
2.814
3.257
2.999
3.22
3.199
3.409
3.306
3.045
2.757
2.823
3.048
3.584
2.857
3.045
2.847
3.894
3.264
3.302
3.623
3.319
3.001
2.958
2.937
2.984
3.32
3.084
2.791
3.19
2.959
3.049
610
460
600
570
570
570
540
560
590
528
590
590
510
670
760
530
550
470
610
610
610
590
560
540
570
470
570
610
580
610
580
560
630
650
510
560
560
610
580
510
560
580
530
590
600
570
540
3.116
2.315
2.656
2.844
2.839
2.799
2.275
2.655
2.568
2.521
2.584
2.875
2.199
3.745
3.907
2.81
2.824
2.389
2.989
2.753
3.01
3
3.13
3.226
2.999
2.663
2.846
2.806
3.446
3.112
2.853
2.916
2.324
2.466
3.355
3.902
3.572
2.65
2.747
2.604
3.092
2.999
2.753
2.464
2.872
2.343
2.932
1
3
1
1
3
3
2
1
3
2
2
1
1
1
1
3
1
3
3
3
3
1
1
2
1
3
3
1
2
1
2
2
1
1
1
1
1
3
2
1
2
3
2
3
1
3
1
4
2
4
4
3
3
3
5
3
3
5
5
4
4
4
4
2
3
4
5
2
2
3
2
3
3
3
5
4
4
4
3
5
4
3
5
2
4
4
4
3
3
3
5
2
2
2
22
46
22
24
23
24
23
27
26
25
23
23
26
31
22
25
24
27
23
24
24
26
25
23
25
24
25
23
25
23
23
24
22
22
29
28
24
24
22
24
24
24
23
28
22
23
24
0
0
0
1
0
0
0
0
0
0
0
0
0
0
1
1
0
0
0
0
0
0
0
0
0
0
1
1
0
0
1
0
1
0
0
1
0
1
0
1
0
0
0
0
1
0
0
5092
5093
5094
5095
5096
5097
5098
5099
5100
5101
5102
5103
5104
5105
5106
3.453
3.184
3.576
3.261
3.366
3.193
3.325
3.459
3.64
2.5
3.263
3.367
3.72
3.542
3.427
610
550
690
600
640
670
600
620
500
430
570
550
720
620
590
3.418
3.22
3.341
3.228
3.17
3.248
3.629
3.358
3.624
2
2.884
2.811
4
3.046
2.903
1
3
1
2
1
2
1
1
1
2
2
1
1
1
1
4
4
4
4
3
5
4
4
4
1
4
2
5
4
5
25
25
24
23
23
23
23
23
24
23
23
23
23
22
24
0
1
1
1
0
0
0
1
1
0
0
0
0
1
0
Eastbrook MBA Program
The MBA program at Eastbrook University has undergone several dramatic changes over
the past five years. During that time, the goal of the business school was to recruit as
many students as possible into the MBA program in order to build up their student base
and credit hour production. A massive campaign was launched five years ago in order to
attract more applicants to the program. Special brochures containing information about
the program were printed and mailed to prospective students as well as to other
colleges and universities that were likely to have undergraduate students who might be
interested in coming to Eastbrook. Mailings were also sent to students who indicated
an interest in Eastbrook on their GMAT exam. (The GMAT exam is a national
standardized test used by most business schools in making admissions decisions for
applicants to their graduate programs.) Representatives from the Eastbrook School of
Business began attending regional MBA fairs and conventions where MBA programs are
able to meet with prospective MBA students and share Information. In the beginning,
the number of students applying to the Eastbrook MBA program was small, but
eventually the advertising campaign began to work and the number of qualified
applicants each year increased to the target value of 200 initially set by the dean of the
business school and the director of the MBA program. The yield, i.e., the number of
admitted applicants who actually enroll and attend Eastbrook, is typically around 80%.
Admitted students who do not enroll either attend other MBA programs or accept job
offers. The table below shows the admissions and enrollment figures for the five years
of the MBA student base building plan at Eastbrook.
Year
1
2
3
4
5
Admissions
86
108
134
141
154
Enrollment
54
77
91
125
134
Albert Razzick, the director of the program, is currently putting the second phase of the
plan into action. He knows that in order for the MBA program at Eastbrook to attain
national recognition they must become more selective in the admissions process. The
number of applicants is now large enough to do this without falling below a critical mass
of 60 enrolled students each year.
The major issue facing Albert and the MBA program is how to go about selecting
students into the program. Albert recently met with Dr. Kathleen Thompson, who is a
finance professor to discuss how they can improve their admissions process.
Albert shared his intentions of making the program better. He wants to make sure he
can get the best 60 students to the program next year.
Their current standards of minimum GMAT and minimum UG GPA had to be
abandoned.
He suggested a formula approach where a score is calculated by multiplying the UGGPA
by a constant and adding the GMAT score i.e.: SCORE = GMAT + 200 * UGGPA.
Kathleen suggests that formula approach should be extended to include other relevant
variables such as their UG major, the schools they are coming from, whether they are
local or international students and even more relevant variables if data can be found.
After a long conversation, Kathleen and Albert agreed that they should develop their
own formula with as many variables as they can get to improve their methodology’s
prediction power. Further discussion led them to decide to use the end of first year GPA
in their MBA program to judge whether the student is successful or not. They decided to
consider the student as successful if she/he has an MBA_GPA greater than 3.2 at the
end of the first year. They are also aware of the fact that not all students will achieve
that GPA and that is fine with them.
Albert promised Kathleen that he would get a set of data for the last two years of
students who are already in the program and that they can work on building the model.
Assignment
Albert Razzick’s assistant gathered the data for the past two years of experience with
the Eastbrook MBA program and stored the information in the file EASTBROOK.XLSX on
Blackboard. The Data Description section provides a partial listing of the data along
with variable definitions.
Using this data set and other information given in the case, help Albert Razzick develop
admissions guidelines for the Eastbrook MBA program. Keep in mind that you want to
set the guidelines in such a way that the best students are selected and the minimum
enrollment of 60 students per year is reached. For each proposal you consider, check
for any potential mistakes in the guidelines, i.e., check to see if there were any
unsuccessful students in the past two years who meet the proposed guidelines or any
successful students in the past two years who would not meet the proposed guidelines.
Please develop a model that best predicts the potentially successful student. Please
write your report consistent with the guidelines provided throughout the semester. Be
precise, concise, and professional. Avoid unnecessary speculations but feel free to add
recommendations if you believe they will improve the admissions process. Obviously,
there is a multiple regression model you have to use while you are doing your analysis
but make sure your suggestions are logical. Don’t do or say things just to sound
statistical but be rational and reasonable.
Data Description
The data for the Eastbrook MBA admissions case is contained in the file
EASTBROOK.XLSX on Blackboard. The file contains data for the 202 students who
completed their first year in the MBA program over the past two years. A partial listing
of the data is shown below.
ID
4001
4002
4003
MBA
GPA
3.201
2.964
3.745
GMAT
540
540
510
UG
UGPA
MAJOR
2.974
1
2.529
1
3.727
3
UG
School
Rating
Age
3
4
4
25
23
25
Foreign
0
0
0
The variables are defined as follows:
ID:
Student identification number.
MBA GPA:Grade point average for the first year of courses in the Eastbrook MBA
program.
GMAT:
Score on the GMAT test.
UGPA:
Undergraduate grade point average.
UG Major:
1, if business undergraduate,
2, if science, engineering or other technical,
3, otherwise.
UG School Rating:
Age:
Foreign:
5, if in the top 20% of undergraduate schools,
4, if in the second 20%,
3, if in the third 20%,
2, if in the fourth 20%,
1, if in the bottom 20%.
Age of the student in years.
1, if international student,
0, if U.S. citizen.

Purchase answer to see full
attachment

  
error: Content is protected !!