Background

At Innovation Engineering Corporation (IEC) engineers are recruited for convergent creativity ability - the

ability to generate novel ways of thinking to determine the correct or best answer to a complex problem.

Historically, IEC used a design competition among undergrad engineering school seniors and used a panel of

judges to determine which student generated the best idea. The score is a composite rating across all judges.

Although fun and beneficial to both recruits and IEC, the contest is expensive to run. So, IEC would like to

know how to identify engineering students who have high convergent creativity abilities to hire. You are asked

to help IEC to organize what it has learned about recruits and creativity. What, if anything, can you say about

the relationship between undergraduate classroom performance and convergent creativity given the data

provided by IEC? Changes in engineering school curricula over the years might impact that relationship. Is

there evidence for different relationships in different competition years?

Data

Your contact at IEC has provided you with a data file containing results from several years of its undergraduate

design competition. Among the results are measures of convergent creativity (panelist ratings), overall GPA and

engineering GPA. Competition year is also provided.

Deliverables

Provide a 10-minute presentation of your findings, insights and recommendations to the CHRO. Refer to the

assignment description and rubric in Canvas to guide what you should include in your presentation.

The exercise purpose is to effectively communicate to key stakeholders the data analytic insights to your research/business question.

The findings should include:

• Detail the research question that is being addressed and the hypothesis considered.
• Explain the research design and analytic methods used.
• Review and explain results (including any insights).
• Conclude by highlighting your recommendation, as well as potential next steps.

ENGAGEMENT DATA

• EmployeeID => Employee identification number (a unique identifier for each employee)
• competition_year => IEC competition year
• design_overall => overall judges' score for design
• undergrad_GPA => undergraduate GPA (4-pt scale)
• eng_maj_GPA => GPA within engineering major courses only

Below are the data for DesignScore.csv, TotalGPA.csv and for EngGPA.csv.

DesignScore.csv

EmployeeID,competition_year,design_overall

3,2019,28.52

10,2016,17.4

24,2016,18.27

34,2016,19.73

56,2018,21.38

65,2015,18.25

81,2015,25.12

93,2019,19.88

105,2019,26.22

112,2016,24.31

115,2017,27.05

120,2018,27.16

136,2019,21.78

151,2018,16.48

174,2015,26.12

181,2016,29.28

206,2015,19.99

211,2017,20.82

216,2016,27.83

218,2018,25.35

219,2019,20.54

247,2018,26.86

260,2016,17.06

265,2016,19.75

287,2017,17.19

303,2018,30.32

309,2019,16.83

317,2017,18.9

332,2017,24.04

340,2016,26.25

342,2016,15.94

350,2016,21.53

367,2019,19.56

400,2016,21.24

404,2019,22.38

408,2019,21.92

435,2016,22.53

439,2016,20.05

455,2016,28.34

457,2019,21.69

460,2018,26.89

478,2016,21.68

485,2016,23.88

491,2015,20.06

513,2018,28.62

528,2018,25.05

538,2018,20.3

562,2018,21.68

582,2017,25.64

587,2019,20.41

601,2017,19.51

609,2019,15.71

652,2017,24.59

657,2016,25.42

675,2015,15.42

689,2019,23.18

695,2018,20.51

702,2018,25.28

704,2019,20.17

708,2018,19.62

716,2018,19.27

729,2019,27.54

742,2018,25.41

745,2018,20.95

746,2015,16.94

748,2016,19.2

751,2016,20.89

758,2016,17.81

761,2015,19.8

769,2016,22.64

770,2016,26.2

784,2015,18.13

800,2019,19.39

803,2017,24.56

808,2018,24.02

826,2018,20.06

846,2017,23.61

854,2018,26.61

870,2019,25.35

890,2015,24.82

892,2016,23.11

898,2016,21.33

899,2019,17.89

904,2019,22.94

918,2018,24

935,2018,19.29

943,2019,20.37

953,2018,21.49

962,2018,21.19

991,2018,25.61

1001,2018,18.96

1019,2016,31.13

1026,2017,24.2

1037,2017,21.76

1040,2016,20.47

1045,2018,20.18

1054,2017,23.13

1059,2016,21.06

1062,2016,15.61

1066,2018,16.52

1071,2016,11.51

1081,2018,14.14

1083,2015,16.67

1094,2019,23.93

1124,2016,15.71

1127,2018,16.42

1131,2018,23.35

1138,2018,21.9

1155,2015,19.22

1156,2015,20.85

1170,2017,23.32

1174,2016,19.97

1213,2017,29.14

1229,2019,17.17

1234,2019,19.5

1238,2018,20.79

1262,2015,23.36

1267,2018,24.77

1268,2017,23.07

1280,2018,21.32

1289,2016,20.82

1296,2019,25.03

1299,2017,18.74

1302,2018,21.25

1310,2018,24.74

1312,2019,17.36

1327,2018,25.05

1337,2017,21.71

1346,2016,26.26

1373,2016,20.44

1394,2016,20.12

1398,2017,24.02

1419,2016,23.95

1421,2018,19.03

1442,2018,22.54

1451,2015,19.33

1454,2016,15.24

1469,2016,24.23

1492,2017,29.24

1494,2018,21.44

1498,2018,24.22

1499,2016,29.65

1513,2019,28.75

1526,2019,25.09

1558,2016,21.43

1564,2018,21.86

1571,2019,22.47

1591,2016,22.89

1595,2019,18.7

1601,2016,24.21

1631,2019,19.92

1634,2018,23.95

1638,2016,19.3

1646,2019,19.8

1666,2016,36.26

1671,2018,23.13

1699,2019,27.81

1709,2016,21.74

1720,2016,28.28

1721,2017,21.41

1726,2017,21.76

1741,2016,21.73

1747,2016,21.18

1748,2017,27.87

1751,2019,18.71

1754,2018,26.37

1755,2016,21.55

1769,2019,26.62

1776,2018,26.26

1782,2015,20.49

1794,2015,18.98

1808,2019,16.13

1822,2016,23.28

1834,2018,23.32

1859,2016,18.45

1916,2016,24.33

1920,2016,16.44

1922,2019,24.93

1925,2017,22.45

1942,2018,27.38

1950,2019,25.91

1957,2017,28.11

1965,2018,22.14

1996,2018,25.64

1998,2019,27.16

2001,2017,24.49

2004,2016,25.41

2014,2018,25.47

2046,2019,20.97

2058,2016,21.56

2060,2018,21.85

2069,2015,19.42

2070,2017,28.71

2073,2016,23.94

2090,2017,25.96

2107,2019,23.48

2111,2019,27.52

2112,2017,20.78

2114,2016,23.79

2130,2017,13.65

2133,2016,22.99

2152,2016,25.16

2167,2019,21.7

2200,2017,29.09

2222,2015,24.42

2226,2016,19.66

2245,2016,20.06

2271,2019,25.28

2299,2017,21.67

2313,2016,30.78

2315,2018,26.95

2321,2016,22.09

2331,2019,23.67

2335,2015,21.13

2338,2018,20.54

2344,2019,16.07

2346,2015,17.16

2364,2019,19.04

2370,2018,22.05

2398,2016,27.6

2406,2015,24.67

2425,2015,16.87

2446,2019,28.31

2454,2015,21

2474,2019,25.75

2478,2016,24.21

2510,2019,23

2518,2019,24.52

2523,2018,23.15

2528,2017,30.54

2537,2019,22.96

2560,2018,23.34

2561,2018,24.67

2573,2016,24.92

2586,2018,22.84

2598,2017,19.84

2668,2018,24.1

2717,2019,25.26

2720,2019,24.1

2732,2018,24.61

2751,2017,25.7

2753,2019,22.19

2805,2019,22.38

2809,2016,23.41

2814,2019,20.28

2819,2017,22.91

2825,2016,19.64

2855,2015,22.92

2864,2017,27.44

2879,2018,17.3

2883,2017,15.71

2885,2016,14.01

2904,2015,22.52

2925,2019,22.78

2930,2018,19.33

2939,2019,16.82

2939,2017,26.31

2960,2019,23.84

2963,2016,17.82

2976,2019,23.64

2982,2017,22.86

2999,2018,19.54

3000,2018,21.91

3002,2019,26.3

3005,2019,28.07

3018,2017,22.33

3022,2015,21.01

3025,2018,20.16

3038,2017,22.64

3063,2018,23.43

3074,2016,28.28

3093,2018,23.9

3093,2018,26.94

3115,2016,24.39

3122,2017,23.03

3128,2019,19.86

3129,2018,22.91

3130,2016,25.39

3131,2017,18.23

3137,2016,25.14

3142,2019,24.19

3183,2016,19.62

3185,2016,25.36

3187,2019,22.65

3188,2017,21.13

3238,2018,22.11

3258,2018,22.2

3272,2018,26.56

3274,2019,28.32

3288,2019,24

3296,2017,20.61

3309,2015,24.17

3344,2018,22.4

3371,2017,27.27

3381,2019,24.11

3399,2019,23.7

3409,2018,25.4

3418,2018,19.91

3420,2016,20.72

3455,2015,18.27

3458,2019,17.08

3466,2017,22.92

3474,2015,15.66

3485,2016,21.42

3498,2019,27.07

3503,2019,20.48

3512,2019,28.88

3546,2016,28.88

3560,2019,23.56

3567,2015,25.83

3576,2019,24.86

3584,2016,23.45

3601,2018,25.44

3632,2019,24.8

3681,2016,18.48

3683,2015,24.27

3689,2016,29.29

3711,2018,28.52

3730,2017,26.62

3752,2017,22.3

3755,2018,18.81

3756,2018,19.91

3764,2016,25.62

3769,2016,24.06

3770,2018,26.87

3773,2019,25.56

3778,2015,21.31

3786,2018,21.42

3787,2017,24.57

3788,2018,24.85

3798,2019,20.88

3807,2016,22.08

3808,2019,21.6

3824,2016,19.1

3832,2017,26.15

3844,2018,22.23

3855,2015,28.86

3860,2017,22.33

3869,2016,26.12

3899,2018,22.43

3911,2018,25.13

3965,2016,17.43

3972,2019,20.5

3989,2018,15.89

3992,2019,28.55

3998,2019,23.48

4000,2015,23.47

4001,2016,24.68

4002,2016,28.37

4014,2019,30.3

4047,2016,17.34

4065,2018,22.07

4075,2018,25.26

4095,2019,19.67

4135,2018,19.74

4153,2017,26.02

4160,2019,19.73

4192,2017,23.75

4199,2017,21.34

4211,2018,17.84

4212,2016,26.72

4219,2018,19.26

4224,2016,23.25

4226,2018,21.59

4229,2019,23.93

4234,2015,24.01

4246,2018,26.1

4264,2016,24.76

4283,2018,25.81

4289,2018,23.5

4299,2016,25.45

4304,2018,22.03

4312,2019,14.91

4323,2017,16

4397,2016,18.18

4402,2018,19.08

4409,2015,17.73

4438,2018,22.27

4439,2018,23.83

4446,2015,14.53

4447,2018,21.17

4449,2018,17.75

4450,2015,23.76

4451,2017,25.85

4457,2018,25.52

4489,2019,25.33

4492,2019,25.2

4497,2015,21.92

4524,2018,25.83

4537,2016,20.4

4541,2016,26.65

4545,2016,24.24

4553,2016,25.52

4566,2017,22.24

4570,2017,21.74

4594,2015,22.38

4612,2018,22.22

4616,2019,22.5

4620,2019,24.37

4642,2016,25.88

4653,2016,22.37

4659,2015,26.06

4668,2019,24.64

4674,2019,20.78

4683,2018,20.91

4687,2019,26.65

4688,2019,23.29

4701,2018,21.16

4731,2016,16.75

4753,2015,27.88

4792,2019,21.45

4798,2018,21.71

4805,2019,29.15

4806,2018,17.15

4809,2016,27.28

4824,2015,22.31

4833,2016,26.72

4873,2019,16.09

4908,2015,25.7

4914,2019,26.15

4942,2016,26

4959,2016,22.56

4991,2017,24.52

4996,2016,24.88

5006,2016,23.27

5018,2016,15.84

5029,2018,21.59

5059,2018,20.74

5075,2019,22.48

5085,2016,35.13

5099,2018,23.22

5114,2019,18.67

5118,2015,18.94

5131,2016,23.39

5136,2016,21.7

5152,2018,18.59

5160,2019,23

5165,2017,21.46

5170,2016,29.72

5171,2019,24.88

5182,2019,25.11

5217,2018,21.11

5221,2017,23.24

5254,2018,23.54

5260,2019,22.48

5267,2016,21.82

5275,2016,20.72

5286,2019,24.28

5310,2016,22.96

5318,2016,30.18

5319,2017,20.68

5323,2018,24.37

5330,2019,20.54

5331,2018,19.09

5362,2017,24.26

5392,2018,24.93

5398,2016,26.16

5401,2015,23.77

5405,2017,20.79

5410,2015,20.88

5411,2018,23.22

5412,2017,29.36

5420,2019,18.54

5431,2016,28.64

5440,2016,17.42

5441,2019,20.84

5445,2017,20.93

5473,2018,24.37

5482,2019,24.72

5498,2019,26.78

5501,2017,17

5503,2017,21.92

5504,2016,25.71

5505,2017,23

5512,2019,21.01

5517,2017,26.9

5535,2016,27.28

5548,2017,14.82

5554,2018,27.55

5562,2018,25.14

5563,2018,26

5565,2018,25.98

5584,2018,25.59

5592,2018,18.83

5606,2019,19.83

5608,2016,23.37

5633,2019,22.41

5644,2018,21.99

5650,2016,23.2

5655,2019,21.11

5688,2018,25.36

5721,2016,17.97

5733,2019,23.8

5739,2016,24.54

5764,2019,18.83

5766,2019,20.9

5780,2018,20.11

5786,2018,22.73

5828,2018,23.76

5829,2019,24.19

5830,2018,17.81

5831,2016,26.74

5832,2019,24.62

5835,2018,18.68

5862,2016,23.87

5865,2019,22.31

5870,2015,18.72

5872,2015,24.6

5888,2017,20.79

5890,2019,18.27

5912,2018,22.12

5919,2017,21.43

5942,2019,25.49

5962,2019,22.03

5963,2018,23.89

5977,2018,23.27

5979,2019,20.38

5986,2019,24.83

5996,2016,22.41

6006,2015,21.34

6013,2018,28.26

6030,2016,18.78

6031,2017,19.95

6051,2016,18.07

6074,2016,25.26

6077,2019,17.34

6095,2015,19.31

6098,2016,20.67

6109,2016,17.76

6120,2016,26.78

6161,2018,24.52

6163,2018,17.4

6172,2015,23.67

6189,2017,27.95

6220,2019,23.07

6221,2015,11.69

6224,2016,18.75

6228,2019,27.28

6266,2018,21.8

6289,2018,23.44

6297,2018,19.99

6307,2016,20.26

6314,2019,14.8

6346,2019,24.06

6350,2016,19.83

6372,2018,17.99

6386,2017,14.37

6410,2019,17.06

6426,2016,23.03

6438,2015,19.08

6442,2016,19.69

6446,2018,26.64

6450,2019,20.23

6456,2017,24.65

6463,2016,28.42

6470,2016,23.01

6473,2017,24.97

6489,2019,23.66

6494,2019,21.5

6496,2016,30.17

6503,2019,20.71

6507,2018,25.38

6544,2015,21.77

6557,2016,22.43

6602,2019,20.51

6614,2019,22.75

6617,2016,23.76

6621,2019,23.96

6638,2016,17.91

6655,2019,24.26

6656,2019,17.02

6686,2018,25.73

6692,2017,22.02

6704,2019,25.84

6709,2019,23.68

6728,2019,22.63

6730,2016,16.04

6741,2016,28.14

6767,2017,22.41

6773,2017,16.52

6801,2019,26.73

6815,2019,21.56

6832,2018,19.05

6844,2017,23.92

6854,2016,26.17

6855,2019,26.46

6860,2016,27.93

6870,2018,20.55

6888,2018,20.8

6893,2019,19.73

6923,2017,18.82

6925,2018,20.06

6929,2017,19.9

6935,2016,21.81

6939,2016,23.06

6946,2019,14.41

6948,2018,22.75

6953,2016,17.12

6955,2018,21.06

6956,2018,22.61

6969,2019,20.59

6980,2017,26.38

7019,2016,27.71

7049,2015,28.4

7062,2018,25.6

7069,2018,14.12

7074,2019,25.65

7081,2018,22.65

7112,2016,21.32

7121,2018,28.17

7132,2019,26.74

7167,2015,24.04

7169,2016,23.69

7181,2017,19.88

7192,2019,25.8

7224,2019,17.65

7229,2019,18.44

7234,2017,19.15

7249,2015,21.77

7250,2017,24.14

7319,2018,24.04

7325,2016,28.84

7332,2019,22

7334,2016,19.06

7345,2019,23.54

7358,2017,14.35

7362,2018,21.93

7366,2016,25.21

7385,2019,24.43

7404,2019,20.11

7422,2019,22.58

7430,2016,21.63

7433,2017,25.23

7442,2016,26.05

7455,2016,27.03

7457,2017,18.4

7462,2018,21.7

7467,2015,26.41

7477,2017,24.12

7479,2016,26.26

7480,2019,20.79

7498,2018,24.69

7505,2019,23.15

7522,2015,19.83

7524,2016,21.7

7526,2019,20

7534,2016,18.86

7547,2019,22.22

7594,2017,18.97

7609,2019,30.54

7643,2018,18.04

7646,2015,23.71

7659,2017,22.34

7680,2018,23.63

7681,2019,20.73

7713,2016,22.19

7739,2019,21.95

7744,2018,22.59

7753,2016,23.5

7757,2018,22.79

7766,2018,21.05

7785,2016,16.67

7803,2019,13.55

7808,2018,25.83

7811,2017,21.9

7817,2017,16.06

7827,2017,17.75

7830,2019,23.99

7856,2017,18.47

7860,2018,26.16

7863,2019,21.03

7866,2018,21.15

7899,2018,26.16

7923,2018,22.31

7950,2019,17.83

7960,2018,19.86

7974,2016,21.57

7977,2015,20.19

8013,2018,20.19

8014,2017,23.37

8015,2018,22.86

8029,2015,15.51

8033,2018,29.28

8050,2017,24.11

8051,2017,22.82

8052,2016,19.64

8053,2016,19.01

8054,2018,16.31

8058,2019,26.16

8061,2019,27.58

8065,2018,23.98

8074,2017,25.33

8080,2019,14.31

8084,2017,27.8

8095,2016,22.07

8102,2016,22.77

8153,2018,22.73

8169,2017,24.41

8175,2017,28.56

8185,2019,17.89

8187,2016,27.57

8221,2016,17.65

8230,2018,20.59

8237,2017,24.03

8238,2019,21.63

8240,2019,22.67

8268,2019,22.17

8270,2016,21.47

8271,2015,11.52

8272,2019,18.48

8283,2017,24.5

8287,2018,22.55

8315,2016,23.62

8323,2017,22.9

8332,2016,26.39

8340,2018,20.97

8347,2018,26.12

8353,2017,18.81

8357,2015,25.42

8364,2019,23.09

8369,2017,19.62

8380,2019,21.74

8387,2019,15.87

8394,2019,22.53

8404,2019,18.1

8417,2018,21.3

8436,2016,20.14

8439,2016,21.53

8458,2017,18.7

8463,2018,19.86

8467,2016,24.93

8481,2017,16.58

8502,2017,24.88

8516,2017,19.6

8541,2017,27.08

8552,2019,24.16

8557,2016,24.87

8571,2018,18.68

8584,2016,27.3

8592,2017,17.89

8594,2016,27.32

8596,2019,28.83

8598,2017,21.61

8609,2019,17.68

8635,2016,20.47

8639,2019,16.69

8643,2017,26.17

8652,2017,23.53

8654,2017,22.04

8660,2019,25.2

8664,2015,25.23

8668,2016,24.73

8674,2016,24

8676,2017,23.46

8709,2019,28.91

8710,2018,24.88

8734,2016,24.04

8750,2018,26.12

8795,2017,21.89

8796,2017,22.93

8819,2016,18.99

8825,2016,14.72

8843,2018,27.7

8859,2016,20.14

8863,2018,17.06

8871,2018,14.56

8876,2016,21.57

8879,2015,21.07

8882,2016,21.72

8889,2017,22.33

8905,2018,30.79

8909,2018,28.63

8921,2017,28.86

8935,2018,18.62

8953,2019,17.47

8960,2019,27.91

8961,2017,19.45

8962,2016,17.6

8987,2017,22.69

8999,2017,19.65

9004,2016,26.93

9007,2018,18.71

9016,2016,25.36

9027,2017,20.09

9029,2016,21.46

9043,2016,26.84

9077,2018,25.24

9084,2016,25.8

9099,2016,28.67

9110,2016,20.2

9127,2019,18.89

9130,2016,21.13

9144,2016,24.11

9152,2018,25.22

9155,2018,21.53

9157,2016,23.8

9160,2018,19.78

9171,2019,20.99

9184,2016,18.15

9185,2018,22.4

9188,2018,18.84

9196,2019,23.99

9201,2015,21.3

9202,2019,32.8

9204,2018,21.46

9207,2018,24.07

9209,2016,18.52

9213,2019,21.21

9217,2019,22.4

9229,2019,25.35

9234,2019,19.01

9258,2019,24.62

9294,2015,28.2

9299,2015,21.48

9313,2016,14.88

9315,2016,21.22

9341,2016,21.47

9344,2019,24.9

9357,2018,23.83

9358,2018,15.25

9379,2015,22.77

9389,2017,20.6

9399,2019,26.57

9400,2016,23.56

9402,2019,15.13

9406,2018,28.15

9432,2015,17.15

9451,2016,22

9455,2017,24.02

9462,2017,27.35

9494,2019,19.63

9494,2016,24.48

9504,2019,22.43

9506,2017,25.71

9520,2016,27.07

9532,2018,21.32

9536,2019,19.33

9548,2015,22.06

9553,2016,23.96

9567,2018,20.93

9586,2018,24.69

9591,2018,25.1

9603,2016,30.65

9615,2017,20.22

9618,2018,24

9660,2019,16.38

9665,2019,23.16

9700,2019,22.23

9715,2019,19.23

9724,2019,18.23

9740,2018,21.93

9758,2019,22.79

9761,2018,18.5

9808,2015,24.34

9816,2019,16.2

9818,2018,15.67

9831,2018,24.08

9836,2019,21.1

9851,2018,12.75

9852,2018,21.48

9857,2016,23.01

9861,2019,26.63

9892,2018,24.41

9894,2015,26.22

9895,2018,24.86

9922,2015,16.59

9935,2019,27.87

9938,2018,25.36

9939,2015,17.94

9941,2018,22.54

9945,2017,20.92

9952,2019,25.42

9953,2019,16.12

9955,2018,24.66

9975,2018,25.95

9980,2017,23.04

9987,2019,26.25

9994,2015,21.56

9995,2017,21.3

TotalGPA.csv

EmployeeID,undergrad_GPA

3,2.32

24,2.91

34,2.61

56,2.46

65,2.04

81,3.15

93,2.06

105,2.76

112,2.73

115,3

120,2.85

136,3.16

151,2.2

174,2.09

181,2.83

206,2.21

211,2.23

216,2.57

218,2.38

219,2.5

247,2.72

260,2.32

265,2.07

287,2.52

303,2.71

309,2.5

317,2.48

332,2.64

340,2.77

342,2.28

350,2.99

367,2.66

400,2.71

404,2.28

408,2.61

435,2.49

439,2.68

455,2.52

457,2.77

460,2.54

478,2.46

485,2.92

491,2.09

528,2.42

538,2.83

562,2.67

582,2.79

587,2.35

601,3.41

609,2.26

652,2.78

657,3.01

675,2.04

695,2.6

702,2.93

704,2.29

708,2.59

716,2.4

729,2.38

742,2.64

745,2.02

746,2.6

748,2.27

751,2.53

758,3

761,2.2

769,2.94

770,2.16

784,2.02

800,2.21

803,2.48

808,2.62

826,2.17

846,3.28

854,2.93

870,2.62

890,2.6

892,2.12

898,2.69

899,2.42

904,2.95

918,2.94

935,3.16

943,2.62

953,2.2

962,2.55

991,2.95

1001,2.56

1019,3

1026,2.28

1037,2.3

1040,2.3

1045,2.67

1054,3.02

1059,2.71

1062,2.31

1066,2.56

1071,2.38

1081,2.07

1094,2.53

1124,2.48

1127,2.41

1131,2.71

1138,2.87

1170,2.97

1174,2.6

1213,2.58

1229,2.84

1234,2.23

1238,2.29

1267,2.08

1268,2.94

1280,2.49

1289,2.4

1296,2.83

1299,2.29

1302,3.08

1310,2.46

1312,2.15

1327,2.92

1337,2.94

1346,2.31

1373,2.22

1394,3.16

1398,2.65

1419,2.79

1421,2.06

1442,2.56

1454,3.03

1469,2.59

1492,3.13

1494,3.2

1498,2.41

1499,2.68

1513,2.62

1526,2.64

1558,2.62

1564,2.5

1571,2.75

1591,3.4

1595,2.47

1601,2.5

1631,2.6

1634,3.07

1646,2.55

1666,2.37

1671,2.92

1699,2.72

1709,2.77

1720,2.59

1721,2.49

1726,2.96

1741,2.18

1747,3.39

1748,2.72

1751,2.91

1754,2.5

1755,2.45

1769,2.38

1776,2.62

1808,2.84

1822,2.61

1834,3.36

1859,2.46

1916,2.54

1920,2.3

1922,3.07

1925,2.66

1942,3.11

1950,2.86

1957,2.81

1965,2.94

1996,2.44

1998,3.14

2001,2.54

2004,2.63

2014,3.24

2046,2.36

2058,2.92

2060,2.36

2069,2.16

2070,2.66

2073,2.73

2090,3.03

2107,2.77

2111,2.68

2112,2.7

2114,2.19

2130,2.71

2133,2.51

2152,2.09

2167,2.67

2200,2.75

2226,3.02

2245,2.24

2271,2.15

2299,2.1

2313,3.38

2315,2.49

2321,2.23

2331,2.93

2338,2.9

2344,2.84

2346,2.45

2364,3.03

2370,2.07

2398,2.35

2406,2.22

2446,2.62

2474,2.61

2478,2.65

2510,2.43

2518,2.1

2523,2.93

2528,2.44

2537,2.38

2560,2.23

2561,2.72

2573,3.15

2586,2.23

2598,2.23

2668,2.65

2717,2.93

2720,2.37

2732,2.49

2751,2.73

2753,2.81

2805,2.79

2809,2.75

2814,2.85

2819,2.86

2825,2.11

2855,2.33

2864,2.91

2879,2.79

2883,2.58

2885,2.27

2904,2.26

2925,3

2930,2.26

2939,2.05

2939,2.81

2960,2.75

2963,2.34

2976,2.8

2982,2.26

2999,2.59

3000,2.11

3002,2.53

3005,2.64

3018,2.06

3025,2.54

3038,2.79

3074,2.64

3093,2.45

3093,2.68

3115,2.41

3122,2.5

3129,2.55

3130,2.86

3131,2.39

3137,2.47

3142,3

3183,2.58

3185,2.52

3188,2.15

3238,2.73

3258,2.4

3272,2.04

3274,2.91

3288,2.58

3296,2.54

3309,2.36

3344,2.58

3371,3.17

3381,2.63

3399,2.62

3409,3.08

3418,2.73

3420,3.05

3455,2.5

3466,2.61

3474,2.43

3485,2.18

3498,2.75

3503,2.57

3512,2.43

3546,2.74

3560,3.18

3576,2.62

3584,2.7

3601,2.8

3632,2.7

3681,2.41

3683,2.29

3689,3.2

3711,3.08

3730,2.69

3752,2.41

3755,2.54

3756,2.69

3764,2.62

3769,2.97

3770,2.07

3773,2.97

3786,2.23

3787,2.9

3788,2.38

3798,2.68

3807,3.53

3808,2.94

3824,2.77

3832,3.03

3855,2.84

3860,2.57

3869,2.63

3899,2.65

3911,2.58

3965,3.08

3972,2.5

3989,2.51

3992,2.95

3998,2.87

4000,2.75

4001,2.12

4002,3.06

4014,2.95

4047,2.61

4065,2

4075,2.99

4095,2.43

4135,2.79

4153,2.16

4160,2.65

4192,2.74

4199,2.31

4211,2.15

4212,2.33

4219,2.67

4224,2.21

4226,2.08

4229,2.52

4234,2.26

4246,2.77

4283,2.26

4289,2.62

4299,2.78

4304,2.44

4312,2.85

4323,2.24

4397,2.52

4402,2.55

4409,2.83

4438,2.64

4439,2.86

4447,3.26

4449,2.27

4450,2.01

4451,2.83

4457,2.59

4489,3.5

4492,2.45

4524,2.57

4537,3.15

4541,2.79

4545,2.77

4553,2.39

4566,2.64

4570,2.32

4594,2.24

4612,3.44

4616,2.94

4620,2.6

4642,2.31

4653,2.79

4659,2.23

4668,2.93

4674,2.41

4683,2.53

4687,2.66

4688,2.41

4701,2.68

4731,2.86

4753,2.28

4792,2.51

4798,2.84

4805,3.09

4806,2.44

4809,2.6

4833,2.84

4873,2.71

4914,2.55

4942,2.84

4959,2.57

4991,2.78

4996,2.59

5006,2.7

5018,2.4

5029,2.14

5059,2.73

5075,2.45

5085,2.8

5099,2.37

5114,2.36

5118,2.43

5131,2.41

5136,2.95

5152,2.75

5160,2.18

5165,3.08

5170,3.42

5171,2.64

5182,2.12

5217,2.45

5221,2.6

5254,2.59

5260,3.22

5267,3.04

5275,2.83

5286,2.77

5310,3.31

5318,2.19

5319,2.64

5323,3.37

5330,2.39

5331,2.32

5362,2.53

5392,3.07

5398,2.3

5405,3.11

5410,2.28

5411,2.66

5412,3.15

5420,2.83

5431,2.7

5440,3.06

5441,2.58

5445,2.02

5473,2.67

5482,2.93

5498,2.63

5501,2.58

5503,2.69

5504,2.57

5505,2.64

5512,3.32

5517,3.02

5535,2.08

5548,2.49

5554,3.02

5562,2.83

5563,3.07

5565,2.77

5584,2.35

5592,3.06

5606,2.2

5608,2.49

5633,2.48

5644,2.34

5650,2.46

5655,2.95

5688,2.75

5721,3.11

5733,2.68

5739,2.42

5764,2.9

5766,3.07

5780,2.35

5786,2.36

5828,2.61

5829,2.21

5830,2.63

5831,2.73

5832,2.79

5835,2.25

5862,2.74

5865,3.24

5870,2.56

5872,2.25

5888,2.8

5890,2.51

5912,2.84

5919,2.44

5942,2.98

5962,2.26

5963,2.63

5977,2.33

5979,2.65

5986,3.04

6013,3.31

6030,2.74

6031,2.41

6051,2.44

6074,2.39

6077,2.75

6095,2.21

6098,2.88

6109,3

6120,2.68

6161,2.37

6163,3.14

6172,2.16

6189,2.51

6220,2.24

6221,2.08

6224,2.65

6228,2.79

6266,2.93

6289,2.68

6297,2.5

6307,2.41

6314,2.36

6346,2.59

6350,3.06

6372,2.68

6386,2.73

6426,2.43

6438,2

6442,2.08

6446,2.23

6450,2.47

6456,2.58

6463,2.7

6470,2.07

6473,2.85

6489,2.5

6494,2.59

6496,2.26

6503,2.44

6507,2.62

6544,2.83

6557,2.69

6602,2.42

6614,2.53

6617,2.49

6621,2.21

6638,2.39

6655,2.78

6656,2.51

6686,2.91

6692,2.73

6704,2.27

6709,2.4

6728,2.77

6730,2.62

6741,2.95

6767,3.03

6773,2.87

6801,3

6815,2.86

6832,2.11

6844,3.22

6854,2.81

6855,2.62

6860,2.66

6870,2.71

6888,2.23

6893,2.53

6923,3.22

6925,2.31

6929,2.56

6935,2.34

6939,2.85

6946,2.26

6948,2.84

6953,2.43

6955,2.87

6956,2.47

6969,2.6

6980,2.08

7019,3.09

7049,2.41

7062,2.26

7069,2.84

7074,2.1

7081,3.07

7112,2.9

7121,2.82

7132,2.85

7169,2.79

7181,2.24

7192,2.65

7224,2.51

7234,2.64

7249,2.15

7250,3.24

7319,2.76

7325,3.03

7332,2.55

7334,2.34

7345,2.77

7358,2.71

7362,2.8

7366,2.92

7385,2.26

7404,2.42

7422,3.1

7430,2.19

7433,3.02

7442,2.37

7455,2.94

7457,2.73

7462,3.23

7467,2.04

7477,2.09

7479,3.15

7480,2.49

7498,2.22

7505,2.34

7522,2.49

7524,2.48

7526,2.44

7534,2.38

7547,2.28

7594,2.8

7609,2.24

7643,2.68

7646,2.18

7659,2.57

7680,3.09

7681,2.63

7713,2.39

7739,2.57

7744,2.43

7753,3.01

7757,2.38

7766,2.2

7785,2.65

7803,2.57

7808,3.38

7811,2.29

7817,2.47

7827,2.72

7830,2.97

7856,3.05

7860,2.01

7863,3.17

7866,2.52

7899,2.31

7923,2.81

7950,2.11

7960,2.39

7974,2.82

8013,2.38

8014,2.28

8015,2.61

8033,2.72

8050,2.51

8052,2.88

8053,2.13

8054,2

8058,2.65

8061,3.56

8065,2.64

8074,2.66

8080,2.28

8084,2.47

8095,2.31

8102,2.61

8153,3.01

8169,2.73

8175,2.64

8185,2.33

8187,2.88

8221,2.55

8230,2.27

8237,2.43

8238,2.83

8240,2.25

8268,2.7

8270,2.59

8272,2.66

8283,2.85

8287,2.17

8315,2.32

8323,2.14

8332,2.42

8340,2.75

8347,2.81

8353,3.27

8357,2.48

8364,2.39

8369,2.29

8380,2.47

8387,2.04

8394,2.17

8404,2.6

8417,2.66

8436,2.8

8439,2.32

8458,2.21

8463,2.53

8467,2.44

8481,2.98

8502,2.72

8541,3.33

8552,2.26

8557,2.34

8571,2.16

8584,2.09

8592,2.1

8594,2.62

8596,2.95

8598,2.69

8609,2.29

8635,2.93

8643,3.11

8652,2.57

8654,2.65

8660,3.92

8664,3.19

8668,3.11

8674,2.03

8676,2.45

8709,2.35

8710,2.29

8734,2.62

8750,2.85

8795,2.6

8796,2.45

8819,2.73

8825,2.85

8843,2.93

8859,2.83

8863,2.61

8871,2.21

8876,2.18

8879,3.32

8882,3.01

8889,3.1

8905,2.74

8909,3.4

8921,2.94

8935,2.44

8960,2.75

8961,2.33

8962,2.49

8987,2.05

8999,2.34

9004,2.7

9007,2.53

9016,2.29

9027,2.24

9029,2.14

9043,2.99

9077,3.13

9084,2.72

9099,3.38

9110,2.52

9127,2.06

9130,2.34

9144,2.06

9152,2.8

9155,2.4

9157,2.12

9160,2.51

9171,2.46

9184,2.36

9185,2.39

9188,2.71

9196,2.26

9202,2.81

9204,2.55

9207,2.65

9209,2.39

9213,2.48

9217,2.95

9229,2.59

9234,2.67

9258,3.05

9299,2.36

9313,2.58

9315,2.43

9341,2.36

9344,3.02

9357,3.57

9358,2.26

9379,2.68

9389,2.92

9399,2.95

9400,2.5

9402,2.13

9406,2.63

9451,2.62

9455,2.57

9462,2.58

9494,2.51

9494,2.31

9504,2.89

9506,2.94

9520,2.34

9532,2.71

9536,2.76

9553,2.49

9567,2.92

9586,2.32

9591,2.99

9603,3.28

9615,2.4

9618,2.08

9660,2.57

9665,2.35

9700,2.27

9715,3.1

9724,2.63

9740,2.22

9758,3.04

9761,2.75

9816,3.14

9818,2.52

9831,2.5

9836,2.28

9851,2.76

9857,2.96

9861,2.78

9892,2.46

9894,2.63

9895,2.49

9935,2.47

9938,2.9

9941,3.31

9945,2.66

9952,2.77

9953,2.34

9955,3.28

9975,2.88

9980,2.84

9987,2.77

9994,2.1

9995,2.48

EngGPA.csv

EmployeeID,eng_maj_GPA

4991,3.78

3129,3.75

8014,3.57

7455,3.49

3399,3.46

3992,3.46

5733,3.45

6617,3.4

5267,3.38

3824,3.35

7019,3.34

2299,3.33

5870,3.33

6496,3.33

9406,3.31

2717,3.29

890,3.29

81,3.28

6815,3.28

7422,3.21

5170,3.19

2406,3.19

1834,3.18

3711,3.18

1726,3.17

2999,3.14

9941,3.1

4447,3.1

6013,3.09

9952,3.08

3808,3.07

9922,3.06

7479,3.06

657,3.05

7467,3.05

8050,3.04

6314,3.04

7250,3.02

8596,3.02

5890,3.01

1499,2.99

5565,2.99

5152,2.99

9299,2.98

7234,2.98

9975,2.98

3474,2.98

8175,2.98

9313,2.97

8843,2.97

9432,2.97

6655,2.96

2819,2.95

3022,2.95

3689,2.95

6463,2.94

5830,2.93

9808,2.92

3503,2.92

7049,2.92

6935,2.92

3730,2.91

1916,2.91

5410,2.91

8668,2.91

8664,2.9

4570,2.9

6095,2.89

758,2.89

8240,2.89

3584,2.88

8635,2.88

8187,2.88

1066,2.88

6860,2.87

6946,2.87

9618,2.86

8571,2.86

7224,2.86

7856,2.86

8340,2.86

7442,2.86

784,2.85

4524,2.85

9110,2.85

2855,2.85

3769,2.85

1045,2.84

6741,2.84

7594,2.84

675,2.84

9591,2.84

9202,2.84

4701,2.84

4497,2.83

4833,2.83

8185,2.83

5888,2.83

219,2.83

4659,2.83

7860,2.83

6006,2.82

8357,2.82

7960,2.82

6224,2.82

918,2.82

8654,2.81

8463,2.81

2344,2.81

4824,2.81

4234,2.8

8953,2.8

2925,2.8

7609,2.8

4753,2.8

2335,2.79

8541,2.79

9099,2.79

2561,2.78

8084,2.78

6297,2.77

1419,2.77

2982,2.77

4409,2.77

8710,2.77

491,2.77

7977,2.76

7132,2.76

7192,2.76

1748,2.76

2004,2.76

729,2.76

5633,2.75

1312,2.75

3965,2.75

5872,2.75

8819,2.74

8380,2.74

5412,2.74

6438,2.74

7433,2.73

1131,2.73

3778,2.73

3681,2.73

4594,2.73

9715,2.73

8029,2.72

6728,2.71

1262,2.71

8074,2.7

716,2.7

2537,2.7

9980,2.7

746,2.69

8271,2.69

1782,2.68

1751,2.68

6470,2.68

8015,2.68

8594,2.68

4668,2.68

2879,2.68

56,2.68

2732,2.68

9152,2.67

3683,2.67

7325,2.67

3272,2.67

8332,2.67

4942,2.66

120,2.66

4450,2.66

9894,2.66

65,2.65

7167,2.64

8364,2.64

9389,2.64

761,2.64

7534,2.64

7830,2.63

9294,2.63

8221,2.63

4001,2.62

9994,2.62

991,2.62

6767,2.62

1794,2.62

8061,2.61

9939,2.61

8315,2.61

9861,2.61

5310,2.61

2271,2.61

1155,2.6

9027,2.59

1170,2.59

528,2.59

2474,2.59

9740,2.58

3998,2.58

9506,2.58

5554,2.58

9379,2.58

5075,2.58

6969,2.57

9357,2.57

2114,2.57

8481,2.57

3137,2.57

1421,2.56

9520,2.56

6544,2.56

1859,2.55

9548,2.55

3371,2.55

5398,2.55

1671,2.55

2226,2.55

115,2.55

7480,2.55

5160,2.55

3381,2.54

211,2.54

5482,2.54

1754,2.54

8169,2.53

538,2.53

935,2.53

943,2.53

854,2.52

2112,2.52

6350,2.52

4299,2.52

1268,2.52

1965,2.52

5608,2.52

3770,2.52

1156,2.51

1394,2.51

1942,2.51

2825,2.51

2315,2.51

3567,2.51

1526,2.51

7646,2.5

3899,2.5

457,2.5

4566,2.5

6801,2.5

3187,2.5

400,2.49

803,2.49

9144,2.49

3309,2.49

7522,2.49

6557,2.49

4304,2.48

1631,2.47

8909,2.47

7713,2.47

3288,2.47

5411,2.47

9603,2.46

9077,2.46

1019,2.46

8660,2.46

2222,2.45

5548,2.45

1769,2.45

7358,2.45

4541,2.44

174,2.44

2046,2.43

3038,2.43

2425,2.43

582,2.43

9160,2.43

2864,2.43

8961,2.43

6221,2.43

5721,2.43

309,2.43

2510,2.42

6503,2.42

7249,2.41

1138,2.41

3855,2.41

6980,2.41

6456,2.41

2753,2.4

9344,2.4

6031,2.4

2338,2.4

2398,2.39

5766,2.39

5986,2.39

1721,2.39

8353,2.39

6844,2.39

2200,2.38

4683,2.38

6372,2.38

206,2.38

8795,2.38

4687,2.38

216,2.37

3122,2.37

9818,2.37

7659,2.37

5431,2.37

3560,2.37

6172,2.37

5171,2.37

3807,2.37

2014,2.37

5401,2.36

689,2.36

4805,2.36

1498,2.36

7974,2.36

8674,2.36

1808,2.35

2073,2.35

4264,2.34

4095,2.34

1229,2.34

4908,2.33

8557,2.33

5440,2.33

2478,2.33

5919,2.33

3074,2.33

9188,2.33

9213,2.33

3183,2.33

9892,2.33

3274,2.32

8825,2.32

2346,2.32

6923,2.32

6692,2.31

513,2.31

439,2.31

6507,2.31

6163,2.31

2364,2.31

702,2.31

5780,2.31

8750,2.31

8467,2.31

8065,2.3

7169,2.3

9451,2.3

7069,2.3

2573,2.29

7524,2.29

1280,2.29

4014,2.29

5584,2.28

8879,2.28

6686,2.28

6450,2.28

1638,2.28

1296,2.28

5217,2.27

9895,2.27

6494,2.27

4996,2.27

1346,2.27

2167,2.27

2809,2.27

9665,2.26

4289,2.26

3764,2.26

5979,2.26

7366,2.26

3130,2.25

367,2.25

5862,2.25

5505,2.25

9399,2.25

5029,2.25

4212,2.24

1741,2.24

1996,2.24

2454,2.24

5085,2.24

826,2.23

9155,2.23

7319,2.23

8709,2.23

1595,2.23

8404,2.23

4075,2.22

8871,2.22

1026,2.22

8230,2.22

6656,2.22

3576,2.22

6442,2.21

3911,2.21

1054,2.21

1720,2.21

1398,2.21

9258,2.21

6266,2.2

5912,2.2

2313,2.2

9953,2.2

562,2.19

8598,2.19

9341,2.19

7547,2.19

7950,2.19

1337,2.18

3601,2.18

9494,2.18

8584,2.18

1001,2.17

1492,2.17

3485,2.17

5942,2.17

5865,2.17

5441,2.17

1998,2.16

3455,2.16

5319,2.16

7680,2.16

7866,2.16

5832,2.16

3466,2.16

5650,2.16

3,2.15

6832,2.15

181,2.15

2904,2.15

8987,2.15

9217,2.15

8102,2.15

3752,2.15

5331,2.15

7526,2.14

9004,2.14

2331,2.14

2939,2.14

8905,2.14

1083,2.13

7498,2.13

8921,2.13

1920,2.13

2069,2.13

2058,2.13

4211,2.13

2751,2.13

4065,2.12

2930,2.12

1127,2.12

3798,2.12

3788,2.12

4674,2.12

1454,2.12

4446,2.12

4047,2.12

2001,2.12

6893,2.1

9831,2.1

8052,2.1

9567,2.1

9229,2.1

6948,2.1

9455,2.09

8436,2.09

6189,2.09

342,2.09

4457,2.09

2939,2.09

3093,2.08

4553,2.08

5286,2.08

5221,2.08

6074,2.08

4959,2.08

748,2.08

5405,2.07

5260,2.07

5131,2.07

1957,2.07

7334,2.07

5498,2.07

2960,2.07

6956,2.07

3063,2.06

3869,2.06

1037,2.06

9532,2.05

3128,2.05

2598,2.05

4199,2.05

3756,2.05

9938,2.04

4731,2.04

846,2.04

340,2.04

3632,2.04

5831,2.04

1755,2.04

5275,2.03

4798,2.03

8033,2.03

4653,2.03

6051,2.03

7681,2.03

1289,2.02

5118,2.02

9761,2.02

435,2.01

4135,2.01

8960,2.01

7744,2.01

8502,2.01

4000,2.01

9995,2

4160,2

6704,2

3773,2

7863,2

34,1.99

9851,1.99

8639,1.99

2130,1.98

601,1.98

485,1.98

136,1.98

7081,1.98

4246,1.98

4616,1.98

6161,1.98

2976,1.97

2523,1.97

9494,1.97

8643,1.96

6228,1.96

1513,1.96

3418,1.96

3185,1.96

1646,1.95

3188,1.95

6426,1.95

4192,1.95

7803,1.94

3860,1.94

7362,1.94

1699,1.94

1373,1.94

1442,1.94

1234,1.93

1776,1.93

6854,1.93

3093,1.92

5420,1.92

1310,1.92

6030,1.92

8999,1.92

2883,1.92

9358,1.91

3832,1.91

9185,1.91

1302,1.91

1494,1.91

9955,1.91

9700,1.91

4914,1.91

4612,1.9

5512,1.9

1062,1.9

3131,1.9

8859,1.9