2016 Election Dashboard
We created this dashboard to show the poll data and the forecasts for the financial impact of the election.
First Chart
This chart compares national poll data for the past 65 days. We used FiveThirtyEight's analysis of more than 1,000 polls for the daily average. The gap is narrowing and the candidates are less than 3 points apart as of November 5.
We added the data column to show the November 5 data on the chart. To simplify the X axis, we chose to show every 10th label on the chart. This option can be found on the Bars, Options tab under Bars and Series.
Second Chart
In the chart, we compared FiveThirtyEight's election forecast, using the polls-plus methodology. It incorporates polls, economic and historical data to assess the probability of a win for each candidate. Again, you can see that the gap has narrowed considerably in the past 2 weeks.
Third Chart
This is a marimekko chart showing the Electoral College forecast using data from Real Clear Politics. You can see that Clinton has a 52 vote advantage according to the forecast and there are 158 votes up for grabs in the gray states.
We used the standard coloring scheme for politics where darker colors denote states with a larger advantage (e.g. California is dark blue). We colored this chart by first applying cell colors in Excel (see below) and then selecting Apply Cell Colors from Spreadsheet under the Style tab in the Format Chart Task pane. We also sorted the data for this chart to show the biggest column on the left and the biggest states, in terms of Electoral College votes, on the bottom of each bar.
Fourth Chart
In this chart, we highlight the economic impact of this election by focusing on the S&P 500. You can see the YTD actual return for the index is 2%, but the return for the last 10 days is -3%. Analysts attribute the declines to uncertainty about the election and, with 9 straight declining days, this is the longest losing streak for the index since 1980. We compared the actual returns to 3 different forecasts of short-term returns based on the outcome of the election. You can see that analysts are forecasting a 0-4% increase if Clinton is elected and a 5-13% decrease if Trump is elected.
You can download this dashboard on SlideShare.
