US Electoral College scenarios

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
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Even assuming all states were winner-take-all, that's a lot of combinations to analyze.
 
Upvote 0
You could use a combinations code like this one: Combination of numbers that sum or match a target value

And just plough through all the different scenarios, but even at that it would take forever to do. To be honest unless you can find someone else who has already done it or are willing to put a serious amount of time into it, I wouldn't even go near it, there are just way to many scenarios that could happen.
 
Upvote 0

Forum statistics

Threads
1,215,108
Messages
6,123,132
Members
449,098
Latest member
Doanvanhieu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top