This analysis focuses on GCSE (2016). [Pandas plotting]
GCSE (2016) |
Correlation
Command used: ver.corr() ------------------- GCSE (Entries) % of total sat A* \ GCSE (Entries) 1.000000 0.999068 -0.123027 % of total sat 0.999068 1.000000 -0.128540 A* -0.123027 -0.128540 1.000000 A*-A -0.154700 -0.162460 0.942397 A*-B -0.171565 -0.179008 0.815680 A*-C -0.099680 -0.106104 0.698398 A*-D -0.001655 -0.005573 0.581614 A*-E 0.001746 0.003251 0.483839 A*-F -0.018938 -0.015739 0.409217 A*-G -0.071089 -0.069469 0.338549 Change 2015-2016 (%) 0.160459 0.157287 0.060678 % Change A* (2015-2016) -0.233276 -0.213123 -0.086274 % Change (A-A*) (2015-2016) -0.383896 -0.390963 0.084182 % Change (A*-B) (2015-2016) -0.380611 -0.369719 0.123515 % Change (A*-C) (2015-2016) -0.416828 -0.408295 0.188272 % Change (A*-D) (2015-2016) -0.263911 -0.259507 0.147496 Male 0.994669 0.993707 -0.130948 Female 0.994933 0.994041 -0.114041 Gender balance % (M/F) -0.077481 -0.063509 -0.127673 A grade -0.168831 -0.178174 0.696194 B grade -0.122967 -0.125345 0.001365 C grade 0.276778 0.283103 -0.708404 D grade 0.256215 0.265737 -0.749531 E grade 0.006369 0.017658 -0.656255 F grade -0.024906 -0.024418 -0.539592 G grade -0.021220 -0.025411 -0.437630 % Change A* (2015-2016).1 -0.254145 -0.255218 0.561974 % Change A (2015-2016) -0.222896 -0.227761 -0.315357 % Change B (2015-2016) -0.189639 -0.175505 0.013984 % Change C (2015-2016) -0.113591 -0.113128 0.056883 % Change D (2015-2016) 0.212329 0.207284 -0.066777 % Change E (2015-2016) 0.369081 0.372602 -0.184946 % Change F (2015-2016) 0.220586 0.220397 -0.141953 A*-A A*-B A*-C A*-D A*-E \ GCSE (Entries) -0.154700 -0.171565 -0.099680 -0.001655 0.001746 % of total sat -0.162460 -0.179008 -0.106104 -0.005573 0.003251 A* 0.942397 0.815680 0.698398 0.581614 0.483839 A*-A 1.000000 0.956091 0.861288 0.733628 0.614232 A*-B 0.956091 1.000000 0.955329 0.847295 0.733635 A*-C 0.861288 0.955329 1.000000 0.956768 0.874108 A*-D 0.733628 0.847295 0.956768 1.000000 0.967960 A*-E 0.614232 0.733635 0.874108 0.967960 1.000000 A*-F 0.519840 0.635108 0.788207 0.900823 0.975677 A*-G 0.437373 0.540283 0.683934 0.785915 0.880535 Change 2015-2016 (%) 0.103046 0.097993 0.082529 0.060648 0.039888 % Change A* (2015-2016) -0.149273 -0.180023 -0.225548 -0.269403 -0.166059 % Change (A-A*) (2015-2016) 0.051515 0.008269 -0.075470 -0.174263 -0.151862 % Change (A*-B) (2015-2016) 0.086223 0.078740 0.059024 0.035020 0.089218 % Change (A*-C) (2015-2016) 0.193295 0.211731 0.182182 0.148107 0.166171 % Change (A*-D) (2015-2016) 0.179401 0.231374 0.249437 0.288109 0.296432 Male -0.159817 -0.177050 -0.109979 -0.014020 -0.010920 Female -0.148123 -0.164456 -0.088615 0.010418 0.014078 Gender balance % (M/F) -0.090908 -0.073053 -0.114635 -0.150330 -0.139013 A grade 0.896211 0.970039 0.922130 0.803049 0.676490 B grade 0.296535 0.563402 0.685088 0.692922 0.659126 C grade -0.714883 -0.600266 -0.337074 -0.109922 0.028457 D grade -0.894333 -0.930411 -0.845783 -0.654039 -0.497829 E grade -0.822109 -0.914548 -0.966852 -0.932186 -0.811424 F grade -0.684628 -0.801729 -0.919825 -0.987110 -0.969136 G grade -0.550467 -0.668090 -0.819105 -0.932945 -0.988532 % Change A* (2015-2016).1 0.435554 0.313903 0.190011 0.096791 0.083838 % Change A (2015-2016) -0.320644 -0.309112 -0.310062 -0.331721 -0.285970 % Change B (2015-2016) -0.002135 0.016918 0.059577 0.095849 0.145937 % Change C (2015-2016) 0.171929 0.257544 0.248826 0.223532 0.162924 % Change D (2015-2016) 0.009695 0.093333 0.183178 0.311322 0.293050 % Change E (2015-2016) -0.267116 -0.319589 -0.288632 -0.212239 -0.116998 % Change F (2015-2016) -0.177874 -0.233699 -0.265342 -0.314973 -0.322372 A*-F A*-G ... \ GCSE (Entries) -0.018938 -0.071089 ... % of total sat -0.015739 -0.069469 ... A* 0.409217 0.338549 ... A*-A 0.519840 0.437373 ... A*-B 0.635108 0.540283 ... A*-C 0.788207 0.683934 ... A*-D 0.900823 0.785915 ... A*-E 0.975677 0.880535 ... A*-F 1.000000 0.954091 ... A*-G 0.954091 1.000000 ... Change 2015-2016 (%) 0.048141 0.094429 ... % Change A* (2015-2016) -0.056996 0.061118 ... % Change (A-A*) (2015-2016) -0.088929 -0.016616 ... % Change (A*-B) (2015-2016) 0.097871 0.024001 ... % Change (A*-C) (2015-2016) 0.140882 0.058453 ... % Change (A*-D) (2015-2016) 0.230585 0.101242 ... Male -0.032747 -0.086895 ... Female -0.005280 -0.054947 ... Gender balance % (M/F) -0.152883 -0.126317 ... A grade 0.572885 0.489631 ... B grade 0.604155 0.527629 ... C grade 0.109857 0.129746 ... D grade -0.397567 -0.337152 ... E grade -0.690222 -0.559920 ... F grade -0.891522 -0.746550 ... G grade -0.974557 -0.862682 ... % Change A* (2015-2016).1 0.083151 0.068341 ... % Change A (2015-2016) -0.217394 -0.152130 ... % Change B (2015-2016) 0.126573 0.018426 ... % Change C (2015-2016) 0.101339 0.075554 ... % Change D (2015-2016) 0.209958 0.108424 ... % Change E (2015-2016) -0.026158 0.059425 ... % Change F (2015-2016) -0.253405 -0.115326 ... E grade F grade G grade \ GCSE (Entries) 0.006369 -0.024906 -0.021220 % of total sat 0.017658 -0.024418 -0.025411 A* -0.656255 -0.539592 -0.437630 A*-A -0.822109 -0.684628 -0.550467 A*-B -0.914548 -0.801729 -0.668090 A*-C -0.966852 -0.919825 -0.819105 A*-D -0.932186 -0.987110 -0.932945 A*-E -0.811424 -0.969136 -0.988532 A*-F -0.690222 -0.891522 -0.974557 A*-G -0.559920 -0.746550 -0.862682 Change 2015-2016 (%) -0.083659 -0.028285 -0.010623 % Change A* (2015-2016) 0.387666 0.279045 0.141977 % Change (A-A*) (2015-2016) 0.186688 0.213797 0.137727 % Change (A*-B) (2015-2016) 0.047102 -0.074293 -0.147297 % Change (A*-C) (2015-2016) -0.105183 -0.184936 -0.194143 % Change (A*-D) (2015-2016) -0.243266 -0.353227 -0.313589 Male 0.016892 -0.014263 -0.009733 Female -0.003955 -0.035028 -0.032203 Gender balance % (M/F) 0.149506 0.115321 0.163621 A grade -0.893941 -0.753621 -0.600930 B grade -0.662647 -0.682574 -0.625295 C grade 0.296870 0.064743 -0.088405 D grade 0.804662 0.581602 0.419003 E grade 1.000000 0.900489 0.746458 F grade 0.900489 1.000000 0.946698 G grade 0.746458 0.946698 1.000000 % Change A* (2015-2016).1 -0.104430 -0.079729 -0.089261 % Change A (2015-2016) 0.359857 0.346443 0.253235 % Change B (2015-2016) -0.012717 -0.159219 -0.199935 % Change C (2015-2016) -0.285418 -0.222697 -0.114575 % Change D (2015-2016) -0.302170 -0.369436 -0.273385 % Change E (2015-2016) 0.325338 0.212346 0.088638 % Change F (2015-2016) 0.268400 0.381165 0.341582 % Change A* (2015-2016).1 \ GCSE (Entries) -0.254145 % of total sat -0.255218 A* 0.561974 A*-A 0.435554 A*-B 0.313903 A*-C 0.190011 A*-D 0.096791 A*-E 0.083838 A*-F 0.083151 A*-G 0.068341 Change 2015-2016 (%) -0.252343 % Change A* (2015-2016) 0.452344 % Change (A-A*) (2015-2016) 0.525624 % Change (A*-B) (2015-2016) 0.347275 % Change (A*-C) (2015-2016) 0.318384 % Change (A*-D) (2015-2016) 0.139920 Male -0.255091 Female -0.250613 Gender balance % (M/F) -0.031333 A grade 0.189409 B grade -0.204946 C grade -0.485749 D grade -0.316639 E grade -0.104430 F grade -0.079729 G grade -0.089261 % Change A* (2015-2016).1 1.000000 % Change A (2015-2016) -0.066361 % Change B (2015-2016) -0.094137 % Change C (2015-2016) -0.122279 % Change D (2015-2016) -0.313672 % Change E (2015-2016) -0.162833 % Change F (2015-2016) -0.116233 % Change A (2015-2016) % Change B (2015-2016) \ GCSE (Entries) -0.222896 -0.189639 % of total sat -0.227761 -0.175505 A* -0.315357 0.013984 A*-A -0.320644 -0.002135 A*-B -0.309112 0.016918 A*-C -0.310062 0.059577 A*-D -0.331721 0.095849 A*-E -0.285970 0.145937 A*-F -0.217394 0.126573 A*-G -0.152130 0.018426 Change 2015-2016 (%) -0.156641 -0.201528 % Change A* (2015-2016) 0.167728 -0.124430 % Change (A-A*) (2015-2016) 0.702843 0.070338 % Change (A*-B) (2015-2016) 0.568726 0.792228 % Change (A*-C) (2015-2016) 0.302520 0.725310 % Change (A*-D) (2015-2016) 0.098659 0.636858 Male -0.239312 -0.205546 Female -0.204602 -0.172182 Gender balance % (M/F) -0.126616 -0.088173 A grade -0.269881 -0.023127 B grade -0.103383 0.061148 C grade 0.145613 0.107335 D grade 0.197924 0.020869 E grade 0.359857 -0.012717 F grade 0.346443 -0.159219 G grade 0.253235 -0.199935 % Change A* (2015-2016).1 -0.066361 -0.094137 % Change A (2015-2016) 1.000000 0.283078 % Change B (2015-2016) 0.283078 1.000000 % Change C (2015-2016) -0.471026 -0.129376 % Change D (2015-2016) -0.337217 -0.078081 % Change E (2015-2016) -0.109434 -0.468827 % Change F (2015-2016) -0.081887 -0.562536 % Change C (2015-2016) % Change D (2015-2016) \ GCSE (Entries) -0.113591 0.212329 % of total sat -0.113128 0.207284 A* 0.056883 -0.066777 A*-A 0.171929 0.009695 A*-B 0.257544 0.093333 A*-C 0.248826 0.183178 A*-D 0.223532 0.311322 A*-E 0.162924 0.293050 A*-F 0.101339 0.209958 A*-G 0.075554 0.108424 Change 2015-2016 (%) -0.112124 0.072723 % Change A* (2015-2016) -0.190636 -0.527534 % Change (A-A*) (2015-2016) -0.353030 -0.512689 % Change (A*-B) (2015-2016) -0.252547 -0.312062 % Change (A*-C) (2015-2016) 0.269229 -0.148381 % Change (A*-D) (2015-2016) 0.398012 0.392392 Male -0.108706 0.211740 Female -0.117187 0.210723 Gender balance % (M/F) 0.109461 0.032212 A grade 0.293529 0.109371 B grade 0.354577 0.276812 C grade -0.147055 0.198393 D grade -0.237118 0.094660 E grade -0.285418 -0.302170 F grade -0.222697 -0.369436 G grade -0.114575 -0.273385 % Change A* (2015-2016).1 -0.122279 -0.313672 % Change A (2015-2016) -0.471026 -0.337217 % Change B (2015-2016) -0.129376 -0.078081 % Change C (2015-2016) 1.000000 0.291165 % Change D (2015-2016) 0.291165 1.000000 % Change E (2015-2016) -0.349635 -0.148318 % Change F (2015-2016) -0.371747 -0.452232 % Change E (2015-2016) % Change F (2015-2016) GCSE (Entries) 0.369081 0.220586 % of total sat 0.372602 0.220397 A* -0.184946 -0.141953 A*-A -0.267116 -0.177874 A*-B -0.319589 -0.233699 A*-C -0.288632 -0.265342 A*-D -0.212239 -0.314973 A*-E -0.116998 -0.322372 A*-F -0.026158 -0.253405 A*-G 0.059425 -0.115326 Change 2015-2016 (%) 0.207019 0.349142 % Change A* (2015-2016) 0.145934 0.252838 % Change (A-A*) (2015-2016) -0.177301 -0.079676 % Change (A*-B) (2015-2016) -0.507756 -0.533992 % Change (A*-C) (2015-2016) -0.682698 -0.752236 % Change (A*-D) (2015-2016) -0.686454 -0.953066 Male 0.377963 0.234722 Female 0.356631 0.204539 Gender balance % (M/F) 0.014087 0.103709 A grade -0.327963 -0.193464 B grade -0.288423 -0.260115 C grade 0.236978 0.026399 D grade 0.361362 0.112338 E grade 0.325338 0.268400 F grade 0.212346 0.381165 G grade 0.088638 0.341582 % Change A* (2015-2016).1 -0.162833 -0.116233 % Change A (2015-2016) -0.109434 -0.081887 % Change B (2015-2016) -0.468827 -0.562536 % Change C (2015-2016) -0.349635 -0.371747 % Change D (2015-2016) -0.148318 -0.452232 % Change E (2015-2016) 1.000000 0.590185 % Change F (2015-2016) 0.590185 1.000000 [33 rows x 33 columns]