B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|

1 | party | source | nation-wide | Baden-W | Bayern | Berlin | Brandenb. | Bremen | Hamburg | Hessen | Meck.-V. | Nieders. | Nordr.-W. | R.-Pfalz | Saarland | Sachsen | Sachsen-A. | S.-Holst. | ThÃ¼ringen | |||||||||||||||||||||||||

2 | How does Germany calculate parliament seats from absolute votes? A spreadsheet essay, meaning you can click on each cell to understand the calculation. By @lisacrost. | |||||||||||||||||||||||||||||||||||||||||||

3 | Disclaimer 1: You'll need some basic knowledge of the German voting system to follow this essay. Super-short eplanation: With the ERSTSTIMME (=first vote), voters vote one representative (often affiliated with a party) of their election district into parliament. With the ZWEISTIMME (=second vote), voters vote for a party and therefore decide how many seats each party should get in parliament. Disclaimer 2: Don't trust these numbers. It's a rough calculation to show the basics. If you are a government and clueless how to deal with all the votes you gathered in your last election, please consult an expert. Mistakes? Ideas to improve the understanding? Please: lisacharlotterost@gmail.com | |||||||||||||||||||||||||||||||||||||||||||

4 | ||||||||||||||||||||||||||||||||||||||||||||

5 | 1. The Basics, to get started. | |||||||||||||||||||||||||||||||||||||||||||

6 | Hi! Here are some facts about the 2013 election, which we'll take as an example to show the calculation from votes to parliament seats. | eligible voters | https://www.bundeswahlleiter.de/dam/jcr/a832ae2d-3ffc-4805-92c6-c92cc8668d17/btw13_heft3.pdf | 61946900 | 7689895 | 9472738 | 2505718 | 2065944 | 483823 | 1281918 | 4413271 | 1350705 | 6117473 | 13253554 | 3092424 | 796072 | 3406430 | 1930880 | 2251796 | 1834259 | ||||||||||||||||||||||||

7 | voters | https://www.bundeswahlleiter.de/dam/jcr/a832ae2d-3ffc-4805-92c6-c92cc8668d17/btw13_heft3.pdf | 44309925 | 5711469 | 6633726 | 1815415 | 1412785 | 333022 | 901213 | 3230483 | 881718 | 4491281 | 9605247 | 2251979 | 577428 | 2368758 | 1198248 | 1645750 | 1251403 | |||||||||||||||||||||||||

8 | turnout in % | calculated | 71.5 | 74.3 | 70.0 | 72.5 | 68.4 | 68.8 | 70.3 | 73.2 | 65.3 | 73.4 | 72.5 | 72.8 | 72.5 | 69.5 | 62.1 | 73.1 | 68.2 | |||||||||||||||||||||||||

9 | valid ZWEITSTIMMEN | https://www.bundeswahlleiter.de/dam/jcr/a832ae2d-3ffc-4805-92c6-c92cc8668d17/btw13_heft3.pdf | 43726856 | 5642019 | 6580755 | 1787721 | 1388362 | 329412 | 890829 | 3148091 | 867743 | 4445260 | 9498157 | 2214497 | 562560 | 2332652 | 1178815 | 1628290 | 1231693 | |||||||||||||||||||||||||

10 | ||||||||||||||||||||||||||||||||||||||||||||

11 | To understand how the election results result in parliament seats, we need election results. Here is the absolute number of ZWEITSTIMME voters for each party and each state. We'll use that to calculate things below. | CDU | https://www.bundeswahlleiter.de/dam/jcr/a832ae2d-3ffc-4805-92c6-c92cc8668d17/btw13_heft3.pdf | 14921877 | 2576606 | 508643 | 482601 | 96459 | 285927 | 1232994 | 369048 | 1825592 | 3776563 | 958655 | 212368 | 994601 | 485781 | 638756 | 477283 | |||||||||||||||||||||||||

12 | SPD | https://www.bundeswahlleiter.de/dam/jcr/a832ae2d-3ffc-4805-92c6-c92cc8668d17/btw13_heft3.pdf | 11252215 | 1160424 | 1314009 | 439387 | 321174 | 117204 | 288902 | 906906 | 154431 | 1470005 | 3028282 | 608910 | 174592 | 340819 | 214731 | 513725 | 198714 | |||||||||||||||||||||||||

13 | DIE LINKE | https://www.bundeswahlleiter.de/dam/jcr/a832ae2d-3ffc-4805-92c6-c92cc8668d17/btw13_heft3.pdf | 3755699 | 272456 | 248920 | 330507 | 311312 | 33284 | 78296 | 188654 | 186871 | 223935 | 582925 | 120338 | 56045 | 467045 | 282319 | 84177 | 288615 | |||||||||||||||||||||||||

14 | GRÃœNE | https://www.bundeswahlleiter.de/dam/jcr/a832ae2d-3ffc-4805-92c6-c92cc8668d17/btw13_heft3.pdf | 3694057 | 623294 | 552818 | 220737 | 65182 | 40014 | 112826 | 313135 | 37716 | 391901 | 760642 | 169372 | 31998 | 113916 | 46858 | 153137 | 60511 | |||||||||||||||||||||||||

15 | CSU | https://www.bundeswahlleiter.de/dam/jcr/a832ae2d-3ffc-4805-92c6-c92cc8668d17/btw13_heft3.pdf | 3243569 | 3243569 | ||||||||||||||||||||||||||||||||||||||||

16 | ||||||||||||||||||||||||||||||||||||||||||||

17 | Here are the voting percentages for the ZWEITSTIMME for each party in each state. Since we'll use the absolute voters, these numbers are just for orientation. | CDU | calculated | 34.1 | 45.7 | 28.5 | 34.8 | 29.3 | 32.1 | 39.2 | 42.5 | 41.1 | 39.8 | 43.3 | 37.8 | 42.6 | 41.2 | 39.2 | 38.8 | |||||||||||||||||||||||||

18 | SPD | calculated | 25.7 | 20.6 | 20.0 | 24.6 | 23.1 | 35.6 | 32.4 | 28.8 | 17.8 | 33.1 | 31.9 | 27.5 | 31.0 | 14.6 | 18.2 | 31.5 | 16.1 | |||||||||||||||||||||||||

19 | DIE LINKE | calculated | 8.6 | 4.8 | 3.8 | 18.5 | 22.4 | 10.1 | 8.8 | 6.0 | 21.5 | 5.0 | 6.1 | 5.4 | 10.0 | 20.0 | 23.9 | 5.2 | 23.4 | |||||||||||||||||||||||||

20 | GRÃœNE | calculated | 8.4 | 11.0 | 8.4 | 12.3 | 4.7 | 12.1 | 12.7 | 9.9 | 4.3 | 8.8 | 8.0 | 7.6 | 5.7 | 4.9 | 4.0 | 9.4 | 4.9 | |||||||||||||||||||||||||

21 | CSU | calculated | 7.4 | 49.3 | ||||||||||||||||||||||||||||||||||||||||

22 | Because of the election threshold, only the parties with more than 5% of the votes get into parliament and get our attention. Here we calculate the sum of voters of the parties who did get into parliament. We'll need it later. | CDU+SPD+LINKE+GRÃœNE+CSU | calculated | 36867417 | 4632780 | 5359316 | 1499274 | 1180269 | 286961 | 765951 | 2641689 | 748066 | 3911433 | 8148412 | 1857275 | 475003 | 1916381 | 1029689 | 1389795 | 1025123 | ||||||||||||||||||||||||

23 | ||||||||||||||||||||||||||||||||||||||||||||

24 | The German parliament offers 598 seats to fill, and it's easy to figure out how many seats per state can be allocated to each party: For approx. every 124k inhabitants, each state gets one parliament seat to fill. | inhabitans | https://www.bundeswahlleiter.de/mitteilungen/bundestagswahl-2013/20130902-sitzkontingente.html | 74.5 | 9482902 | 11353264 | 3025288 | 2418267 | 575805 | 1559655 | 5388350 | 1585032 | 7354892 | 15895182 | 3672888 | 919402 | 4005278 | 2247673 | 2686085 | 2154202 | ||||||||||||||||||||||||

25 | seats | calculated | 598 | 76 | 92 | 24 | 19 | 5 | 13 | 43 | 13 | 59 | 128 | 30 | 7 | 32 | 18 | 22 | 17 | |||||||||||||||||||||||||

26 | ||||||||||||||||||||||||||||||||||||||||||||

27 | ||||||||||||||||||||||||||||||||||||||||||||

28 | 2. Oh No: Statewide ZWEITSTIMME Seats vs. Nationwide ZWEISTIMME Seats Result in Overhang Mandates ðŸ˜± | |||||||||||||||||||||||||||||||||||||||||||

29 | To find out the number of seats per party per state, let's look at the ZWEITSTIMME first. Here we calculate the number of seats that every party in each state should get according to the ZWEITSTIMME. To do so, we first divide the total number of big-party-voters by the number of seats, answering the question: How many voters decided one seat in the whole state? Then we'll see how often that number of one-seat-voters fits into the number of voters for each party. And voila, we get the number of seats that each party deserves. | CDU | calculated | 239 | 42 | 0 | 8 | 8 | 2 | 5 | 20 | 6 | 28 | 59 | 15 | 3 | 17 | 8 | 10 | 8 | ||||||||||||||||||||||||

30 | SPD | calculated | 183 | 19 | 23 | 7 | 5 | 2 | 5 | 15 | 3 | 22 | 48 | 10 | 3 | 6 | 4 | 8 | 3 | |||||||||||||||||||||||||

31 | DIE LINKE | calculated | 60 | 4 | 4 | 5 | 5 | 1 | 1 | 3 | 3 | 3 | 9 | 2 | 1 | 8 | 5 | 1 | 5 | |||||||||||||||||||||||||

32 | GRÃœNE | calculated | 60 | 10 | 9 | 4 | 1 | 1 | 2 | 5 | 1 | 6 | 12 | 3 | 0 | 2 | 1 | 2 | 1 | |||||||||||||||||||||||||

33 | CSU | calculated | 56 | 0 | 56 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||

34 | total seats | calculated | 598 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||

35 | ||||||||||||||||||||||||||||||||||||||||||||

36 | But surprisingly, we're running into a problem here. Let me explain. Here we calculate how many seats the parties should have on a national level, if we just take into account the number of seats (598) and allocate them on the parties according to their relative ZWEITSTIMME votes. | CDU | calculated | 242 | ||||||||||||||||||||||||||||||||||||||||

37 | SPD | calculated | 183 | |||||||||||||||||||||||||||||||||||||||||

38 | DIE LINKE | calculated | 61 | |||||||||||||||||||||||||||||||||||||||||

39 | GRÃœNE | calculated | 60 | |||||||||||||||||||||||||||||||||||||||||

40 | CSU | calculated | 53 | |||||||||||||||||||||||||||||||||||||||||

41 | ||||||||||||||||||||||||||||||||||||||||||||

42 | Then we check if one of the parties deserves more seats according to the ZWEITSTIMME then it does according to the relative values. Here we see that the CSU actually earned 56 seats, but according to the seat allocation based on relative values, it should only have 53 seats. This difference is called overhang mandates. Argh! We'll handle this later. | CDU | calculated | -3 | ||||||||||||||||||||||||||||||||||||||||

43 | SPD | calculated | 0 | |||||||||||||||||||||||||||||||||||||||||

44 | DIE LINKE | calculated | -1 | |||||||||||||||||||||||||||||||||||||||||

45 | GRÃœNE | calculated | 0 | |||||||||||||||||||||||||||||||||||||||||

46 | CSU | calculated | 3 | |||||||||||||||||||||||||||||||||||||||||

47 | ||||||||||||||||||||||||||||||||||||||||||||

48 | ||||||||||||||||||||||||||||||||||||||||||||

49 | 3. Oh No, Again: Statewide ZWEITSTIMME Seats vs. Statewide ERSTSTIMME Seats Result in Even More Overhang Mandates ðŸ˜± | |||||||||||||||||||||||||||||||||||||||||||

50 | So far we've only looked at the ZWEISTIMME results. Let's change that. Here we can see which party earned how many election districts (and therefore seats) with their ERSTSTIMME in which state. | CDU | https://www.bundeswahlleiter.de/dam/jcr/a832ae2d-3ffc-4805-92c6-c92cc8668d17/btw13_heft3.pdf | 191 | 38 | 5 | 9 | 1 | 17 | 6 | 17 | 37 | 14 | 4 | 16 | 9 | 9 | 9 | ||||||||||||||||||||||||||

51 | SPD | https://www.bundeswahlleiter.de/dam/jcr/a832ae2d-3ffc-4805-92c6-c92cc8668d17/btw13_heft3.pdf | 58 | 2 | 1 | 2 | 5 | 5 | 13 | 27 | 1 | 2 | ||||||||||||||||||||||||||||||||

52 | DIE LINKE | https://www.bundeswahlleiter.de/dam/jcr/a832ae2d-3ffc-4805-92c6-c92cc8668d17/btw13_heft3.pdf | 4 | 4 | ||||||||||||||||||||||||||||||||||||||||

53 | GRÃœNE | https://www.bundeswahlleiter.de/dam/jcr/a832ae2d-3ffc-4805-92c6-c92cc8668d17/btw13_heft3.pdf | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||

54 | CSU | https://www.bundeswahlleiter.de/dam/jcr/a832ae2d-3ffc-4805-92c6-c92cc8668d17/btw13_heft3.pdf | 45 | 45 | ||||||||||||||||||||||||||||||||||||||||

55 | total | calculated | 299 | 38 | 45 | 12 | 10 | 2 | 6 | 22 | 6 | 30 | 64 | 15 | 4 | 16 | 9 | 11 | 9 | |||||||||||||||||||||||||

56 | ||||||||||||||||||||||||||||||||||||||||||||

57 | In most states, parties earn far more seats with their ZWEISTIMME than they earn election district seats. But we can see that in four states, the CDU won more election districts than they won seats through the ZWEITSTIMME. Yay, another problem! | CDU | calculated | 4 | 3 | -1 | 2 | 4 | 3 | 0 | 11 | 22 | 1 | -1 | 1 | -1 | 1 | -1 | ||||||||||||||||||||||||||

58 | SPD | calculated | 19 | 23 | 5 | 4 | 0 | 0 | 10 | 3 | 9 | 21 | 9 | 3 | 6 | 4 | 6 | 3 | ||||||||||||||||||||||||||

59 | DIE LINKE | calculated | 4 | 4 | 1 | 5 | 1 | 1 | 3 | 3 | 3 | 9 | 2 | 1 | 8 | 5 | 1 | 5 | ||||||||||||||||||||||||||

60 | GRÃœNE | calculated | 10 | 9 | 3 | 1 | 1 | 2 | 5 | 1 | 6 | 12 | 3 | 0 | 2 | 1 | 2 | 1 | ||||||||||||||||||||||||||

61 | CSU | calculated | 11 | |||||||||||||||||||||||||||||||||||||||||

62 | ||||||||||||||||||||||||||||||||||||||||||||

63 | These extra seats are also overhang mandates. | CDU | calculated | 4 | ||||||||||||||||||||||||||||||||||||||||

64 | SPD | calculated | 0 | |||||||||||||||||||||||||||||||||||||||||

65 | DIE LINKE | calculated | 0 | |||||||||||||||||||||||||||||||||||||||||

66 | GRÃœNE | calculated | 0 | |||||||||||||||||||||||||||||||||||||||||

67 | CSU | calculated | 0 | |||||||||||||||||||||||||||||||||||||||||

68 | ||||||||||||||||||||||||||||||||||||||||||||

69 | ||||||||||||||||||||||||||||||||||||||||||||

70 | 4. The Solution to Both Problems | |||||||||||||||||||||||||||||||||||||||||||

71 | Here, we put everything together. These are the minimum parliament seats that every party deserves after calculating the overhang mandates from the two problems. We see that in this list, the CSU has its deserved 56 seats (instead of 53) and the CDU has its deserved 243 seats (instead of 239). | CDU | calculated | 243 | ||||||||||||||||||||||||||||||||||||||||

72 | SPD | calculated | 183 | |||||||||||||||||||||||||||||||||||||||||

73 | DIE LINKE | calculated | 60 | |||||||||||||||||||||||||||||||||||||||||

74 | GRÃœNE | calculated | 60 | |||||||||||||||||||||||||||||||||||||||||

75 | CSU | calculated | 56 | |||||||||||||||||||||||||||||||||||||||||

76 | total | calculated | 602 | |||||||||||||||||||||||||||||||||||||||||

77 | ||||||||||||||||||||||||||||||||||||||||||||

78 | But these can't be the final seats, because another condition needs to be considered: Every party should have seats according to the relative ZWEITSTIMME votes. Here we can see the difference between the percentage of minimum parliament seats and the voting percentage of ZWEITSTIMMEN. We can see that the CSU gains a lot of relative power (it is as if 0.5% more Bavarian voters had voted for the CSU) at the cost of other parties. That's not fair to the other parties. | CDU | calculated | -0.1 | ||||||||||||||||||||||||||||||||||||||||

79 | SPD | calculated | -0.1 | |||||||||||||||||||||||||||||||||||||||||

80 | DIE LINKE | calculated | -0.2 | |||||||||||||||||||||||||||||||||||||||||

81 | GRÃœNE | calculated | -0.1 | |||||||||||||||||||||||||||||||||||||||||

82 | CSU | calculated | 0.5 | |||||||||||||||||||||||||||||||||||||||||

83 | ||||||||||||||||||||||||||||||||||||||||||||

84 | How can we make it fair? By making all seats worth the same number of voters. To do so, we're checking how much CSU votes were needed to earn one of these 56 CSU seats (I admit: I have no idea why I need to substract 0.5 from the CSU voters in the calculation). Turns out, it's something around 58k voters. Now we're dividing the number of voters for each party (nationwide) by these 58k voters. That gives us a parliament in which each seat was determined by the same amount of voters. | divisor | calculated according to http://www.wahlrecht.de/news/2013/2013100901.html | 58443 | ||||||||||||||||||||||||||||||||||||||||

85 | ||||||||||||||||||||||||||||||||||||||||||||

86 | CDU | calculated | 255 | |||||||||||||||||||||||||||||||||||||||||

87 | SPD | calculated | 193 | |||||||||||||||||||||||||||||||||||||||||

88 | DIE LINKE | calculated | 64 | |||||||||||||||||||||||||||||||||||||||||

89 | GRÃœNE | calculated | 63 | |||||||||||||||||||||||||||||||||||||||||

90 | CSU | calculated | 56 | |||||||||||||||||||||||||||||||||||||||||

91 | ||||||||||||||||||||||||||||||||||||||||||||

92 | The disadvantage of this method: The parliament grows like crazy. Now we're up to 631 seats instead of the normal 598 seats. | total | calculated | 631 | ||||||||||||||||||||||||||||||||||||||||

93 | ||||||||||||||||||||||||||||||||||||||||||||

94 | ||||||||||||||||||||||||||||||||||||||||||||

95 | 5. The Grand Finale: Seats on State Level | |||||||||||||||||||||||||||||||||||||||||||

96 | So now we know the number of seats each party gets! But what's the number of seats each party gets on the state level? Easy peasy. Calculating the seats on the state level is very similar to calculating them on the national level. Here too, we try to understand how many voters were necessary for one seat â€“Â but for each party seperately. Turns out, for each CSU seat in 2013, only 57.9k voters were needed, while for one Green seat, 58.6k voters were necessary. | CDU | calculated | 58517.16 | ||||||||||||||||||||||||||||||||||||||||

97 | SPD | calculated | 58301.63 | |||||||||||||||||||||||||||||||||||||||||

98 | DIE LINKE | calculated | 58682.80 | |||||||||||||||||||||||||||||||||||||||||

99 | GRÃœNE | calculated | 58635.83 | |||||||||||||||||||||||||||||||||||||||||

100 | CSU | calculated | 57920.88 |

Loading...