Question
Background At Innovation Engineering Corporation (IEC) engineers are recruited for convergent creativity ability - the ability to generate novel ways of thinking to determine the
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.
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started