Tag Archives: spreadsheet sumproduct function

2016 Pre-election Model – Calculating the Expected Electoral Vote

Richard Charnin
Aug. 29, 2017

77 Billion to One: 2016 Election Fraud
Matrix of Deceit: Forcing Pre-election and Exit Polls to Match Fraudulent Vote Counts
Proving Election Fraud: Phantom Voters, Uncounted Votes and the National Exit Poll
Reclaiming Science: The JFK Conspiracy
Last 3 Elections: Exact Forecast of Electoral Vote

2016 Pre-election Model – Calculating the Expected Electoral Vote

This is for those interested in Electoral Vote math based on pre-election polls. It discusses basic probability and spreadsheet functions. You won’t see a discussion of this anywhere else.The MSM doesn’t care for critical thinking. Perhaps because they are incapable of it.

One of the methods I have used in pre-election forecast modeling is to calculate the Expected Recorded Electoral Vote as well as the True Vote. Important Note: the RECORDED EV is based on MSM pre-election polls which are usually biased for the establishment candidate. In 2016, Clinton was the establishment candidate.

As I did not have 51 state pre-election polls, I used the following method to estimate them based on the average of nine pre-election national polls and Party-ID:

1) Each state’s estimated Party-ID was calculated using the proportional change from the 2012 National Party-ID to the 2016 Gallup National Voter affiliation survey: 40% Independents, 32% Democrats and 28% Republicans.

2) The average vote shares of nine national pre-election polls were applied to the Party-ID of each state to derive the projected state vote shares.

The Expected EV is based on state win probabilities. Calculating the pre and post-election TRUE EV is much more complicated.

In the 2016 Forecast Model, Trump’s Expected EV (before undecided voters) was 305.5, exactly matching his recorded 306 EV. His Snapshot 307 EV is the sum of the EVs for states that he was projected to win.┬áTrump led the weighted average pre-election polls (before undecided voter allocation) by 44.1-43.1%.

View the Recorded votes and two True Vote Models for all the states:

The following steps calculate the Expected RECORDED EV:
1. Using state forecasts derived from the National Gallup Voter Affiliation survey, calculate the probability P(i) of winning each state using Trump’s projected 2-party vote share. Assume a 3.0% margin of error.
P(i) = normdist(Trump%/(Trump%+Clinton%),0.5,.03/1.96,true)

2. Multiply the state win probability by the state electoral vote.
S(i) = P(i)* EV(i), i =1,51
3. Expected EV = sum [P(i)* EV(i)], i = 1,51

View the spreadsheet
State Electoral votes are in the range B129:B179
Trump’s state forecasts are in the range D129:D179
Corresponding state win probabilities are in the range J129:J179

The Expected EV calculation is in cell I128.
Expected EV = 305.5 = sumproduct(J129:J179, B129:B179)



Posted by on August 29, 2017 in 2016 election, electoral vote


Tags: , , , , , , , ,

Richard Charnin's Blog

JFK Conspiracy and Systemic Election Fraud Analysis