SAS中文论坛

标题: NCAA football and computer rankings [打印本页]

作者: shiyiming 时间: 2011-10-26 11:40
标题: NCAA football and computer rankings
From Dapangmao's blog on sas-analysis

<div class="separator" style="clear: both; text-align: center;"><a href="http://4.bp.blogspot.com/-FWTeVkG2-lE/TqcLGxH7XyI/AAAAAAAAA0c/Yi1dQ_mMzbg/s1600/SGRender12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="300" src="http://4.bp.blogspot.com/-FWTeVkG2-lE/TqcLGxH7XyI/AAAAAAAAA0c/Yi1dQ_mMzbg/s400/SGRender12.png" width="400" /></a></div>I am a big fan of NCAA football. I found that in the past weeks the cold-blooded computer rankings are more accurate than the poll rankings(BCS, Harris Poll and USA Today). And they are pretty good in predicting the game results, such as the fall of Oklahoma last week.<br />
<br />
<b>Data and plotting</b><br />
Those ranking data are available on <a href="http://espn.go.com/college-football/bcs">ESPN’s website</a> (and they are well structured data and easy to grab). I subtracted the 6 computer rankings by the overall ranking and drew those differences on a scatter plot.  <br />
-Alabama seems to have more chance to take LSU’s place. <br />
-Although Michigan State beat Wisconsin last week, the computers still don’t favor it.<br />
-Auburn looks very promising.  <br />
-Oklahoma State is highly possible to become #2. <br />
<b>One complaint about the computer ranking</b><br />
I don’t like the<a href="http://espn.go.com/ncf/news/story?page=bcsexplanationnew"> averaging method</a> of the 6 computer rankings used by BCS. Transformation and factor analysis may make full use of the information - SAS’s user guide provided a <a href="http://support.sas.com/documentation/cdl/en/statug/63347/HTML/default/viewer.htm#statug_prinqual_sect030.htm">detailed solution</a> by PROC PRINQUAL and PROC FACTOR.<br />
<pre style="background-color: #ebebeb; border: 1px dashed rgb(153, 153, 153); color: #000001; font-size: 14px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code>
data week9;
input @1 RK: 20. @5 TEAM: $40. AVG_bcs: PVS_bcs: $2. RK_hp: $2. PTS_hp pct_hp RK_usa: $2.
   PTS_usa pct_usa AVG_computer AH RB CM KM JS PW;
cards;
/* COPY AND PASTE DATA FROM <a class="postlink" href="http://espn.go.com/college-football/bcs">http://espn.go.com/college-football/bcs</a>
*/
;;;
run;

data _tmp01;
set week9;
array rank[6] ah--pw;
do i = 1 to 6;
   if rank[i]= 0 then rank[i] = 25;
   rank[i] = rk - rank[i];
   drop i;
end;
run;
proc sort data=_tmp01;
by team;
run;
proc transpose data=_tmp01 out=_tmp02;
var ah--pw;
by team;
run;

proc template;
  define Style HeatMapStyle;
parent = styles.htmlblue;
style GraphFonts from GraphFonts /
   'GraphLabelFont' = (", ",6pt)
   'GraphValueFont' = (", ",6pt)
   'GraphDataFont' = (", ",6pt);
end;
run;
proc template;
define statgraph HeatMap.Grid;
begingraph;
layout overlay / border=true xaxisopts=(label='TEAM') yaxisopts=(label='COMPUTER ALGORITHM');
   scatterplot x=team y=_name_ / markercolorgradient=col1 markerattrs=(symbol=squarefilled size=32)
                                 colormodel=threecolorramp name='s';
   continuouslegend 's' / orient=vertical location=outside valign=center halign=right;
endlayout;
endgraph;
end;
run;
ods html style=HeatMapStyle image_dpi=300 ;
proc sgrender data=_tmp02 template=HeatMap.grid;
run;
</code></pre><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3256159328630041416-4215368331983503027?l=www.sasanalysis.com' alt='' /></div><img src="http://feeds.feedburner.com/~r/SasAnalysis/~4/g5jymPGShFA" height="1" width="1"/>

欢迎光临 SAS中文论坛 (http://mysas.net/forum/)