Report not found

There was a problem finding this report.
NCAA Check - Chart 4
March 27, 2014 · Refreshed 4 months ago
Description
Comparison of models by game

Collaborators

Run History
SELECT fte.round, CASE WHEN fte.round = 2 THEN 1 ELSE 0 END AS first_round, fte.favorite, fte.underdog, ROUND(fte.favorite_probability*1000)/10 AS fte_prob, vegas.favorite_probability AS vegas_prob, ROUND((vegas.favorite_probability - fte.favorite_probability)*1000)/10 AS difference FROM benn.ncaa_game_probabilities_538 fte JOIN benn.ncaa_game_probabilities_vegas vegas ON vegas.year = fte.year AND vegas.round = fte.round AND vegas.favorite = fte.favorite AND vegas.underdog = fte.underdog ORDER BY 7
SELECT fte.round, CASE WHEN fte.round = 2 THEN 1 ELSE 0 END AS first_round, fte.favorite, fte.underdog, ROUND(fte.favorite_probability*1000)/10 AS fte_prob, vegas.favorite_probability AS vegas_prob, ROUND((vegas.favorite_probability - fte.favorite_probability)*1000)/10 AS difference FROM benn.ncaa_game_probabilities_538 fte JOIN benn.ncaa_game_probabilities_vegas vegas ON vegas.year = fte.year AND vegas.round = fte.round AND vegas.favorite = fte.favorite AND vegas.underdog = fte.underdog ORDER BY 7
<style> #scatterplot { width: 100%px; padding: 10px 50px 70px 90px; color: #444444; font-family: Helvetica, Arial, sans-serif; font-weight: bold; } #scatterplot h3 { text-align: center; margin: 0 0 5px 0; } #scatterplot h5 { text-align: center; margin: 0 0 28px 0; } #scatterplot chart { width: 100%; height: 250px; } #scatterplot guide-y { width: 110%; border: none; } #scatterplot guide-x { border: none; } #scatterplot guide-x .tick { border: none; } #scatterplot guide-y .tick { width: 98%; border-color: #e2e2e2; } #scatterplot guide-y .tick .label { right: auto; left: -25px; width: auto; padding: 0 4px; } #scatterplot .legend-y, #scatterplot .legend-x { position: absolute; } #scatterplot .legend-y { left: -120px; top: 50%; -webkit-transform: rotate(-90deg); -moz-transform: rotate(-90deg); -o-transform: rotate(-90deg); transform: rotate(-90deg); } #scatterplot .legend-x { width: 100%; text-align: center; bottom: -60px; } #scatterplot group:first-child point { background-color: rgba(57,132,130,0.8); } #scatterplot group:last-child point { background-color: rgba(227,110,49,0.8); } #scatterplot .first{ color:rgba(227,110,49,1); } #scatterplot .other{ color:rgba(57,132,130,1); } </style> <script src="//variancecharts.com/cdn/variance-noncommercial-9bc0f5e.min.js" charset="UTF-8"></script> <script> angular.require('variance'); </script> <div id="scatterplot"> <h3>Difference Between Models By Game</h3> <h5><span class="first">First round</span> vs <span class="other">all other rounds</span></h5> <chart data="dataset.content" scale-x-linear="50 100" scale-y-linear="-30 30"> <guide-y><span class="label">{{value}}%</span></guide-y> <guide-x><span class="label">{{value}}%</span></guide-x> <span class="legend-y">Model difference</span> <span class="legend-x">FiveThirtyEight model</span> <groups by="first_round"> <points map-xy="fte_prob difference"></points> </groups> </chart> </div>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled