390 likes | 506 Views
2012 NCAA MARCH MADNESS . TREY RULE, ALEX STREET, VINCE DeLISE , CHESNEY YOUNG, and KENNY POPE. BASIC INFO. 64 TEAMS ENTER THE TOURNAMENT THERE ARE 4 REGIONS: SOUTH, EAST, WEST, MIDWEST 16 TEAMS IN EACH REGION TEAM WINS 6 STRAIGHT TIMES TO WIN THE TOURNAMENT. BRACKETOLOGY.
E N D
2012 NCAA MARCH MADNESS TREY RULE, ALEX STREET, VINCE DeLISE, CHESNEY YOUNG, and KENNY POPE
BASIC INFO • 64 TEAMS ENTER THE TOURNAMENT • THERE ARE 4 REGIONS: • SOUTH, EAST, WEST, MIDWEST • 16 TEAMS IN EACH REGION • TEAM WINS 6 STRAIGHT TIMES TO WIN THE TOURNAMENT
BRACKETOLOGY ESPN REPORTED THAT THEY RECEIVED 6.45 MILLION BRACKET ENTRIES IN 2012 (97.7%) predicted Kentucky and Syracuse and Michigan State and North Carolina to advance to the Round of 32; (67.9%) predicted all four No. 1 seeds to advance to the Sweet Sixteen (28.3%) predicted all four No. 1 seeds to advance to the Elite Eight (4.3%) predicted all four No. 1 seeds to advance to the Final Four
continued (38.8%) entries predicted Kentucky and Duke would meet in the Elite Eight (30.3%) entries predicted Kentucky to defeat Duke in the Elite Eight
GOAL OF PROJECT ANALYZE THE TOURNAMENT TO LEARN MORE ABOUT UPSETS, AVERAGE SCORE, AND AVERAGE MARGIN OF VICTORY
HOW TO DETERMINE UPSETS WITH EXCEL • =IF function was used • Compared seeds of competing teams • True value resulted in “expected” • False value resulted in “upset”
HOW TO DETERMINE AVERAGE SCORE WITH EXCEL • =AVERAGE function was used • Selected data and inserted into function Averages were determined for each region and overall round averages scores were computed
HOW TO COMPUTE MARGIN OF VICTORY WITH EXCEL • =abs absolute value function • Determined absolute difference between the teams • Used to compare the competitiveness between teams in each round of the tournament.
UPSETS • ROUND 2 • 10 TOTAL UPSETS: • 4 IN SOUTH REGION • NONE IN EAST REGION • 2 IN WEST REGION • 4 IN MIDWEST REGION
SOUTH REGION (12) VCU DEFEATED (5) WITCHITA STATE (11) COLORADO DEFEATED (6) UNLV (10) XAVIER DEFEATED (7) NOTRE DAME (15) LEE HI DEFEATED (2) DUKE
EAST REGION NO UPSETS
WEST REGION (9) ST. LOUIS DEFEATED (8) MEMPHIS (15) NORTHFOLK ST DEFEATED (2) MISSOURI
MIDWEST REGION (12) SOUTH FLORIDA DEFEATED (5) TEMPLE (13) OHIO DEFEATED (4) MICHIGAN (11) NC STATE DEFEATED (6) SAN DIEGO ST (10) PURDUE DEFEATED (7) ST. MARY’S
AVERAGE SCORE per GAME ROUND 2 SOUTH REGION – 73.5 POINTS EAST REGION – 68.5 POINTS WEST REGION – 78 POINTS MIDWEST REGION – 67.5 POINTS TOTAL – 71.875 POINTS A GAME
AVERAGE MARGIN OF VICTORY ROUND 2 (FOR EVERY GAME) 11.13 POINTS
UPSETS • ROUND 3 • ONLY 2 UPSETS: • BOTH UPSETS OCCURRED IN THE MIDWEST REGION
MIDWEST REGION (13) OHIO DEFEATED (12) SOUTH FLORIDA (11) NORTH CAROLINA STATE DEFEATED (3) GEORGETOWN
AVERAGE SCORE per GAME ROUND 3: SOUTH REGION – 69.13 POINTS EAST REGION – 63.5 POINTS WEST REGION – 61.25 POINTS MIDWEST REGION – 66.25 POINTS TOTAL AVERAGE SCORE – 65.03 POINTS
AVERAGE MARGIN OF VICTORY ROUND 3 (FOR EVERY GAME) 9.7 POINTS
UPSETS • SWEET 16 • ONLY 2 UPSETS • BOTH OCCURING IN THE WEST REGION
WEST REGION (4) LOUISVILLE DEFEATED (1) MICHIGAN STATE (7) FLORIDA DEFEATED (3) MARQUETTE
AVERAGE SCORE per GAME SOUTH REGION – 84.25 POINTS EAST REGION – 68.5 POINTS WEST REGION – 56.75 POINTS MIDWEST REGION – 63.75 POINTS TOTAL AVERAGE SCORE – 68.3 POINTS
AVERAGE MARGIN OF VICTORY SWEET 16 (FOR EVERY GAME) 8.375 POINTS
UPSETS 2 UPSETS IN THE ELITE 8: (2) OHIO STATE DEFEATED (1) SYRACUSE (2) KANSAS DEFEATED (1) NORTH CAROLINA
AVERAGE SCORE ELITE 8 (FOR EVERY GAME) 73. 25 POINTS
AVERAGE MARGIN OF VICTORY ELITE 8 (FOR EVERY GAME) 9 POINTS
UPSETS NONE
AVERAGE SCORE FINAL FOUR (BOTH GAMES) 64 POINTS
AVERAGE MARGIN OF VICTORY FINAL FOUR (BOTH GAMES) 5 POINTS
UPSET NO UPSET
AVERAGE SCORE CHAMPIONSHIP 63 POINTS
MARGIN OF VICTORY CHAMPIONSHIP 8 POINTS