Report not found

There was a problem finding this report.
NCAA Check - Chart 2
March 28, 2014 · Refreshed about 5 years ago
Description
FiveThirtyEight's predictions using a narrow sample

Collaborators

Run History
SELECT CASE WHEN fte.favorite_probability >= 0.50 AND fte.favorite_probability < .60 THEN '50% to 59%' WHEN fte.favorite_probability >= 0.60 AND fte.favorite_probability < .70 THEN '60% to 69%' WHEN fte.favorite_probability >= 0.70 AND fte.favorite_probability < .80 THEN '70% to 79%' WHEN fte.favorite_probability >= 0.80 AND fte.favorite_probability < .90 THEN '80% to 89%' WHEN fte.favorite_probability >= 0.90 AND fte.favorite_probability < 1.0 THEN '90% to 100%' ELSE 'Error?' END AS bucket, AVG(fte.favorite_probability)*100 AS avg_win_prob_fte, COUNT(fte.id) AS games, COUNT(CASE WHEN fte.favorite_win_flag = 1 THEN fte.id ELSE NULL END)/COUNT(fte.id)::FLOAT*100 AS actual_win_pct FROM benn.ncaa_game_probabilities_538 fte WHERE year = 2014 OR (year = 2013 AND round != 1) GROUP BY 1 ORDER BY 1
SELECT CASE WHEN fte.favorite_probability >= 0.50 AND fte.favorite_probability < .60 THEN '50% to 59%' WHEN fte.favorite_probability >= 0.60 AND fte.favorite_probability < .70 THEN '60% to 69%' WHEN fte.favorite_probability >= 0.70 AND fte.favorite_probability < .80 THEN '70% to 79%' WHEN fte.favorite_probability >= 0.80 AND fte.favorite_probability < .90 THEN '80% to 89%' WHEN fte.favorite_probability >= 0.90 AND fte.favorite_probability < 1.0 THEN '90% to 100%' ELSE 'Error?' END AS bucket, AVG(fte.favorite_probability)*100 AS avg_win_prob_fte, COUNT(fte.id) AS games, COUNT(CASE WHEN fte.favorite_win_flag = 1 THEN fte.id ELSE NULL END)/COUNT(fte.id)::FLOAT*100 AS actual_win_pct FROM benn.ncaa_game_probabilities_538 fte WHERE year = 2014 OR (year = 2013 AND round != 1) GROUP BY 1 ORDER BY 1
<style> #bar { width: 100%px; padding: 10px 50px 70px 90px; color: #444444; font-family: Helvetica, Arial, sans-serif; font-weight: bold; } #bar h3 { text-align: center; margin: 0 0 5px 0; } #bar h5 { text-align: center; margin: 0 0 28px 0; } #bar chart { width: 100%; height: 250px; } #bar bar { margin: 0 8px; border: none; background-color: #398482; } #bar annotation { bottom: -8px; font-size: 12px; } #bar guide-y { width: 110%; border: none; } #bar guide-y .tick { width: 98%; border-color: #e2e2e2; } #bar .legend-y, #bar .legend-x { position: absolute; } #bar .legend-y { left: -120px; top: 50%; -webkit-transform: rotate(-90deg); -moz-transform: rotate(-90deg); -o-transform: rotate(-90deg); transform: rotate(-90deg); } #bar .legend-x { width: 100%; text-align: center; bottom: -60px; } #bar guide-y .tick .label { right: auto; left: -25px; width: auto; padding: 0 4px; } </style> <script src="//variancecharts.com/cdn/variance-noncommercial-9bc0f5e.min.js" charset="UTF-8"></script> <script> angular.require('variance'); </script> <div id="bar"> <h3>Results vs. Predicted Probabilities</h3> <h5>FiveThirtyEight forecasts, 2013-2014</h5> <chart data="dataset.content" map-length="actual_win_pct" scale-y-linear="40 100"> <guide-y class="left" ticks="40 45 50 55 60 65 70 75 80 85 90 95 100"> <span class="label">{{value}}%</span> </guide-y> <span class="legend-y">Actual results</span> <span class="legend-x">Forecasts</span> <repeat> <bar></bar> <annotation class="bottom"> {{bucket}} </annotation> </repeat> </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