jeff_the_ashtray
New Member
- Joined
- Sep 4, 2013
- Messages
- 1
Hello, I have recently been wondering about this one particular problem. It's about presidential elections in the United States. For those not familiar with how they are conducted, here is how it goes:
For each of the fifty states there is a number of presidential electors assigned relative to the state's population. The lowest the number gets is 3. So, the smallest state (Wyoming) gets 3 electoral votes, while the largest (California) gets 55. By adding all the states' electoral votes up (plus the District of Columbia, which is not a state, but still gets 3 EV) we get 538.
During a presidential election the candidate who received the largest vote total in each respective state receives all of that state's electoral votes. In order to win the presidency, the candidate has to receive an absolute majority of electoral votes (that is 270 or more).
Here and here are the entire lists of states with the number of EV each receives.
My problem is this: how to predict every mathematically possible outcome of an Election Day? Is it possible for MS Excel to count and display every scenario that gets the sum beyond 270, or any other chosen threshold of electoral votes?
I welcome your thoughts.
Jeff
For each of the fifty states there is a number of presidential electors assigned relative to the state's population. The lowest the number gets is 3. So, the smallest state (Wyoming) gets 3 electoral votes, while the largest (California) gets 55. By adding all the states' electoral votes up (plus the District of Columbia, which is not a state, but still gets 3 EV) we get 538.
During a presidential election the candidate who received the largest vote total in each respective state receives all of that state's electoral votes. In order to win the presidency, the candidate has to receive an absolute majority of electoral votes (that is 270 or more).
Here and here are the entire lists of states with the number of EV each receives.
My problem is this: how to predict every mathematically possible outcome of an Election Day? Is it possible for MS Excel to count and display every scenario that gets the sum beyond 270, or any other chosen threshold of electoral votes?
I welcome your thoughts.
Jeff