It is often hard to calculate the total concentration of the major, but I thought I’d share with you the calculation that I did.
I calculated the total english majors concentration for the year 2017 based on the percentage of students who took a concentration test, as well as the average GPA of each student in the class.
Here is the calculation.
English majors concentration in each class 1st year 2nd year 3rd year GPA (points) 1st 2nd 3rd % 2.6% 4.2% 7.8% 5.1% 8.4% 5th 7.2 4.5 2.8 7.1 4.4 4.1 6.4 5th 6.3 3.6 4.3 5.5 4.0 4.9 5.7 6th 4.8 3.8 4.7 5.2 3.9 4.6 7th 2.7 3.7 4.14 5.6 2.9 3.5 5.4 8th 2 0.8 2.0 3.2 1.5 3.0 5.9 9th 2 1.1 2.1 3.1 1.7 2.3 4.07 10th 3.3 2.4 3.4 2.2 2.5 1.9 10th 5.3 1.3 6.5 6.0 2.88 4.70 11th 5 1.2 5.0 1.6 3.12 2.80 6.28 12th 4 1.0 7.5 0.6 5.16 3.13 2.77 7.60 13th 5 2.00 7.0 0.5 7.23 4.13 3.08 4.20 14th 5 0.80 0.10 5.11 4.31 2.91 2.65 8.90 15th 5 4.00 5.60 0.4 6.93 2.85 1.99 4.10 16th 6 0.00 0.50 4.60 2.38 2.13 1.75 4.05 17th 6 1.00 2.40 0.1 5.36 3.50 2.07 4.22 18th 6 2.30 1.70 0.2 6.06 3.15 2.37 4.21 19th 6 3.30 2.90 0.3 7.08 3.38 3.01 4.17 20th 6 4.50 3.00 1.4 7.68 4.23 3.21 4.25 21st 6 5.00 4.80 1.8 8.30 5.07 2.73 4.32 22nd 6 6.00 6.50 1.95 9.28 5.59 3.36 4.39 23rd 6 7.00 9.80 2.02 10.04 6.25 2.79 4.49 24th 6 8.00 11.80 3.20 10.84 6.81 2.95 5.17 25th 6 9.00 13.80 4.55 11.88 7.12 3.40 5.20 26th 6 10.00 15.80 5.61 12.08 8.24 3.56 6.17 27th 6 11.00 17.80 7.42 13.32 9.36 5.70 7.17 28th 6 12.00 19.80 8.68 14.52 10.60 6.72 8.14 29th 6 13.00 21.80 9.89 15.89 11.32 6.97 8.19 30th 6 14.00 23.80 10.21 16.69 11.56 7.24 9.03 31st 6 15.00 25.80 11.69 17.46 12.11 7.57 9.18 32nd 6 16.00 27.80 12.69 18.50 13.24 7.92 10.02 33rd 6 17.00 29.80 13.69 19.08 14.06 8.32 10.18 34th 6 18.00 31.80 14.69 20.18 14.70 8.70 10.37 35th 6 19.00 33.80 15.69 21.34 15.71 8.82 10.58 36th 6 20.00 35.80 16.68 22.03 16.88 9.09 11.08 37th 6 21.00 37.80 17.68 23.36 17.94 9.14 11.37 38th 6 22.00 39.80 18.68 24.02 18.94 10.23 11.52 39th 6 23.00 40.80 19.68 25.34 19.96 10.40 11.70 40th 6 24.00 41.80 20.