Created
November 11, 2017 18:48
-
-
Save taivop/68d7a685382dfe6db790d0732d95c3ed to your computer and use it in GitHub Desktop.
Riigieksamite varieeruvus
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| library(dplyr) | |
| library(ggplot2) | |
| library(reshape2) | |
| # Read data | |
| df <- read.csv("postimees.csv") %>% | |
| mutate(postimehe_rank=seq(1, length(postimehe_skoor))) | |
| # Prepare ranks matrix | |
| num_samples <- 500 | |
| ranks <- matrix() | |
| length(ranks) <- nrow(df) * num_samples | |
| dim(ranks) <- c(nrow(df), num_samples) | |
| scores <- matrix() | |
| length(scores) <- nrow(df) * num_samples | |
| dim(scores) <- c(nrow(df), num_samples) | |
| # Calculate ranks for num_samples | |
| for(i in 1:num_samples) { | |
| weights <- runif(3) | |
| weights <- 3 * weights / sum(weights) | |
| scores[, i] <- weights[1] * df$eesti_keel + weights[2] * df$matemaatika + weights[3] * df$inglise_keel | |
| ranks[, i] <- rank(-scores[, i]) | |
| } | |
| # Convert to better format for plotting | |
| df_ranks <- cbind(df, as.data.frame(ranks)) %>% | |
| select(-eesti_keel, -matemaatika, -inglise_keel) %>% | |
| melt(id.vars=c("kool", "postimehe_skoor", "postimehe_rank")) | |
| df_scores <- cbind(df, as.data.frame(scores)) %>% | |
| select(-eesti_keel, -matemaatika, -inglise_keel) %>% | |
| melt(id.vars=c("kool", "postimehe_skoor", "postimehe_rank")) | |
| # Plot | |
| ggplot(df_ranks, aes(x=postimehe_rank, y=value)) + | |
| geom_point(alpha=0.03, shape=16) + | |
| xlab("Järjekorranumber, Postimees") + | |
| ylab("Järjekorranumber, simulatsioon") + | |
| theme_bw() + | |
| theme(panel.grid.minor=element_blank()) | |
| ggsave("plot_point.png") | |
| ggplot(df_ranks, aes(x=postimehe_rank, y=value, group=variable)) + | |
| geom_line(alpha=0.03) + | |
| xlab("Järjekorranumber, Postimees") + | |
| ylab("Järjekorranumber, simulatsioon") + | |
| theme_bw() + | |
| theme(panel.grid.minor=element_blank()) | |
| ggsave("plot_line.png") | |
| ggplot(df_scores, aes(x=postimehe_skoor, y=value)) + | |
| geom_point(alpha=0.01, shape=16) + | |
| scale_x_reverse() + | |
| xlab("Skoor, Postimees") + | |
| ylab("Skoor, simulatsioon") + | |
| theme_bw() + | |
| theme(panel.grid.minor=element_blank()) | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| kool | eesti_keel | matemaatika | inglise_keel | postimehe_skoor | |
|---|---|---|---|---|---|
| Tallinna Reaalkool | 83.7 | 89.3 | 99.5 | 272.5 | |
| Tallinna Inglise Kolledž | 81 | 87.9 | 100 | 268.9 | |
| Tallinna Prantsuse Lütseum | 81 | 83.9 | 100 | 264.9 | |
| Hugo Treffneri Gümnaasium | 83.1 | 73.9 | 98.5 | 255.5 | |
| Pärnu Sütevaka Humanitaargümnaasium | 76.3 | 74.5 | 96 | 246.8 | |
| Tallinna 21. Kool | 76.2 | 71.5 | 97 | 244.7 | |
| Gustav Adolfi Gümnaasium | 77.9 | 65.6 | 97.5 | 241 | |
| Nõo Reaalgümnaasium | 72.2 | 77.1 | 86.815 | 236.115 | |
| Miina Härma Gümnaasium | 75.2 | 60 | 99.5 | 234.7 | |
| Vinni-Pajusti Gümnaasium | 68.9 | 86.1 | 79 | 234 | |
| Tartu Jaan Poska Gümnaasium | 77.2 | 55.9 | 88.11 | 221.21 | |
| EBS Gümnaasium | 64.6 | 57 | 96.5 | 218.1 | |
| Kadrioru Saksa Gümnaasium | 69.1 | 58.6 | 89.5 | 217.2 | |
| Jakob Westholmi Gümnaasium | 69.9 | 66.3 | 80.995 | 217.195 | |
| Pärnu Koidula Gümnaasium | 68.7 | 72.6 | 75.53 | 216.83 | |
| Kohtla-Järve Järve Gümnaasium | 70 | 58 | 88.5 | 216.5 | |
| Vanalinna Hariduskolleegium | 70.1 | 52.2 | 93.06 | 215.36 | |
| Saue Gümnaasium | 64.6 | 62.2 | 83.79 | 210.59 | |
| Viimsi Keskkool | 67.3 | 49.6 | 91.63 | 208.53 | |
| Rapla Ühisgümnaasium | 75.2 | 48.3 | 84.77 | 208.27 | |
| Jõgevamaa Gümnaasium | 67.4 | 65.9 | 74.575 | 207.875 | |
| Loo Keskkool | 62.1 | 62.8 | 82.5 | 207.4 | |
| Võru Gümnaasium | 68.7 | 52.9 | 85.75 | 207.35 | |
| Rocca al Mare Kool | 68.6 | 53.4 | 85.025 | 207.025 | |
| Noarootsi Gümnaasium | 67.3 | 54.4 | 85.26 | 206.96 | |
| Toila Gümnaasium | 61.7 | 69.8 | 73.005 | 204.505 | |
| Tallinna Nõmme Gümnaasium | 62.6 | 60.5 | 81.31 | 204.41 | |
| Rakvere Gümnaasium | 65 | 55.4 | 82.32 | 202.72 | |
| Saaremaa Ühisgümnaasium | 67.3 | 59.1 | 76.26 | 202.66 | |
| Kose Gümnaasium | 63.9 | 66.1 | 71.55 | 201.55 | |
| Tallinna Kuristiku Gümnaasium | 58.2 | 72.8 | 69.42 | 200.42 | |
| Tallinna õismäe Gümnaasium | 62.1 | 54.4 | 82.45 | 198.95 | |
| Tabasalu Ühisgümnaasium | 69.2 | 52.2 | 77.55 | 198.95 | |
| Viljandi Gümnaasium | 65.9 | 58.3 | 74.06 | 198.26 | |
| Narva Vanalinna Riigikool | 49.8 | 72.5 | 73.14 | 195.44 | |
| Tallinna 32. Keskkool | 65.5 | 43.9 | 85.75 | 195.15 | |
| Tallinna Lilleküla Gümnaasium | 64.5 | 50 | 80.275 | 194.775 | |
| Kanepi Gümnaasium | 61.8 | 31.2 | 100 | 193 | |
| Jüri Gümnaasium | 63.2 | 49.9 | 78.85 | 191.95 | |
| Vändra Gümnaasium | 63.4 | 60.2 | 67.64 | 191.24 | |
| Taebla Kool | 65 | 45.8 | 78.715 | 189.515 | |
| Saku Gümnaasium | 64.1 | 45 | 79.9 | 189 | |
| Tartu Tamme Gümnaasium | 70.7 | 38.7 | 77.08 | 186.48 | |
| Tallinna Mustamäe Gümnaasium | 61.4 | 36.6 | 88.27 | 186.27 | |
| Loksa Gümnaasium | 78.2 | 60.8 | 46.875 | 185.875 | |
| Läänemaa Ühisgümnaasium | 66.8 | 61.7 | 56.99 | 185.49 | |
| Oskar Lutsu Palamuse Gümnaasium | 68.9 | 44 | 72.5 | 185.4 | |
| Paide Ühisgümnaasium | 54.8 | 49.3 | 80.5 | 184.6 | |
| Kuressaare Gümnaasium | 67 | 53.7 | 63.21 | 183.91 | |
| Kuusalu Keskkool | 65 | 49.7 | 68.85 | 183.55 | |
| Keila Kool | 63 | 44.2 | 76.14 | 183.34 | |
| Rakvere Reaalgümnaasium | 64.7 | 41.6 | 76.145 | 182.445 | |
| Paide Gümnaasium | 62.3 | 62.9 | 56.33 | 181.53 | |
| Koeru Keskkool | 69.6 | 52.7 | 58.74 | 181.04 | |
| Kohila Gümnaasium | 65.8 | 54.1 | 58.725 | 178.625 | |
| Lähte Ühisgümnaasium | 72.2 | 48.8 | 56.95 | 177.95 | |
| Tamsalu Gümnaasium | 53 | 58 | 66.43 | 177.43 | |
| Kadrina Keskkool | 59.3 | 63.3 | 54.675 | 177.275 | |
| Tallinna Laagna Gümnaasium | 58.3 | 59.8 | 58.93 | 177.03 | |
| Tallinna Ühisgümnaasium | 62.5 | 45.4 | 69 | 176.9 | |
| Tallinna Kristiine Gümnaasium | 56.7 | 40 | 80.025 | 176.725 | |
| Pärnu Ühisgümnaasium | 59.2 | 38.5 | 76.95 | 174.65 | |
| Tartu Kristjan Jaak Petersoni Gümnaasium | 65.3 | 41.9 | 67.34 | 174.54 | |
| Kiili Gümnaasium | 55.8 | 30.8 | 86.48 | 173.08 | |
| Põltsamaa Ühisgümnaasium | 62.3 | 51.4 | 58.38 | 172.08 | |
| Tallinna Saksa Gümnaasium | 65.6 | 27.3 | 78.585 | 171.485 | |
| Lüganuse Keskkool | 58.2 | 30.1 | 82 | 170.3 | |
| Tallinna Arte Gümnaasium | 56.2 | 46.2 | 67.795 | 170.195 | |
| Märjamaa Gümnaasium | 65 | 42.5 | 62.55 | 170.05 | |
| Avinurme Gümnaasium | 62.2 | 48.6 | 59.075 | 169.875 | |
| Põlva Gümnaasium | 61.4 | 46.9 | 58.8 | 167.1 | |
| Hiiumaa Gümnaasium | 60.7 | 43.5 | 62.78 | 166.98 | |
| Suure-Jaani Gümnaasium | 68.5 | 30.5 | 66.43 | 165.43 | |
| Türi Ühisgümnaasium | 64.9 | 34.1 | 65.86 | 164.86 | |
| Ülenurme Gümnaasium | 58.6 | 48 | 57.19 | 163.79 | |
| Lihula Gümnaasium | 61.2 | 48.4 | 50.43 | 160.03 | |
| Tallinna Järveotsa Gümnaasium | 56.3 | 33 | 70.525 | 159.825 | |
| Rapla Vesiroosi Gümnaasium | 66.1 | 34.6 | 58.91 | 159.61 | |
| Tõrva Gümnaasium | 62.5 | 31 | 64.68 | 158.18 | |
| Iisaku Gümnaasium | 63.8 | 46.3 | 46.875 | 156.975 | |
| Jõhvi Gümnaasium | 59.6 | 54 | 40.6 | 154.2 | |
| Tapa Gümnaasium | 56.3 | 33.6 | 63.635 | 153.535 | |
| Antsla Gümnaasium | 53.9 | 41.2 | 58.065 | 153.165 | |
| Tartu Waldorfgümnaasium | 59.8 | 22.6 | 70.525 | 152.925 | |
| Pirita Majandusgümnaasium | 56.6 | 25.7 | 70.38 | 152.68 | |
| Elva Gümnaasium | 60.1 | 29.7 | 61.92 | 151.72 | |
| Audentese Spordigümnaasium | 59.4 | 28.7 | 62.78 | 150.88 | |
| Audentese Spordigümnaasiumi Otepää filiaal | 60.3 | 34.2 | 56 | 150.5 | |
| Tallinna Tehnikagümnaasium | 59.7 | 28.7 | 61.49 | 149.89 | |
| Määramata | 56.1 | 43.4 | 48.585 | 148.085 | |
| Värska Gümnaasium | 60.7 | 38 | 47.19 | 145.89 | |
| Haljala Kool | 55.4 | 55.9 | 34.24 | 145.54 | |
| Otepää Gümnaasium | 64.2 | 33 | 43.5 | 140.7 | |
| Tartu Täiskasvanute Gümnaasium | 58 | 34.9 | 41.055 | 133.955 | |
| Häädemeeste Keskkool | 65 | 29.8 | 38.5 | 133.3 | |
| Kiviõli I Keskkool | 62.5 | 31 | 36.92 | 130.42 | |
| Paldiski Ühisgümnaasium | 45.8 | 63.4 | 20.25 | 129.45 | |
| Pelgulinna Gümnaasium | 52.5 | 21.2 | 52.29 | 125.99 | |
| Valga Gümnaasium | 58.2 | 31.1 | 36.225 | 125.525 | |
| Rakvere Eragümnaasium | 49.5 | 39.8 | 34.45 | 123.75 | |
| August Kitzbergi nimeline Gümnaasium | 54.4 | 35.6 | 28.8 | 118.8 | |
| Tallinna Vaba Waldorfkool | 52.4 | 15 | 50.955 | 118.355 | |
| Kilingi-Nõmme Gümnaasium | 59.7 | 19.6 | 32.495 | 111.795 | |
| Tallinna Polütehnikum | 46 | 13.9 | 50.43 | 110.33 | |
| Räpina Ühisgümnaasium | 54.1 | 21.1 | 33.075 | 108.275 | |
| Tallinna Kunstigümnaasium | 45 | 10.1 | 53.055 | 108.155 | |
| Tartu Kutsehariduskeskus | 50.3 | 8 | 48.19 | 106.49 | |
| Tsirguliina Keskkool | 58.3 | 35 | 12.255 | 105.555 | |
| Pärnumaa Kutsehariduskeskus | 40.3 | 4.6 | 59.69 | 104.59 | |
| Tallinna Täiskasvanute Gümnaasium | 51 | 15.4 | 37.74 | 104.14 | |
| Pärnu Täiskasvanute Gümnaasium | 54 | 17.7 | 30.69 | 102.39 | |
| Parksepa Keskkool | 51.8 | 28.6 | 21.375 | 101.775 | |
| Maardu Gümnaasium | 32.6 | 59.4 | 9.35 | 101.35 | |
| Tallinna Tööstushariduskeskus | 39.4 | 23.6 | 29.325 | 92.325 | |
| Tõstamaa Keskkool | 52.1 | 9.8 | 27 | 88.9 | |
| Haapsalu Kutsehariduskeskus | 37.1 | 20.3 | 21 | 78.4 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment