Methods

Data sources:

  • Individual recruited athlete admission records

  • Individual athlete outcomes:
    • Penn athletics site
      • Rosters
      • Game utilization (GP, GS, Min/AB/IP)
      • Performance (limited)
    • ivy athletics site: https://ivyleague.com
      • all ivy team (performance metric)

  • Team outcomes:
    • Penn athletics site (W, L, T, runs/points)
    • ivy athletics site
      • ivy standings
    • national rankings
    • (the other things)




Outcome data collection & processing: where we head for all sports:

This example is ready to be connected to admission record (after di-identificaiton)

Example sport: Baseball

sport_wasbi player_name town_n_HS recruit year_min roster_tot GP_tot GS_tot MIN_tot russel_ID
M_Baseball adam_bleday Panama City Beach, Fla. / Titusville/Virginia/Gulf Coast CC TRUE 2016 2 0.5859079 0.3441734 1.2799602 12
M_Baseball adrian_lorenzo Miami, Fla. / Belen Jesuit Prep FALSE 2011 1 0.0000000 0.0000000 0.0000000 NA
M_Baseball alex_gabauer North Huntingdon, Pa. / Norwin Senior TRUE 2022 2 0.0000000 0.0000000 0.0082949 43
M_Baseball alex_ott Pompton Lakes, N.J. / Pompton Lakes TRUE 2011 2 0.0000000 0.0000000 0.0000000 95
M_Baseball andrew_burnick Matthews, N.C. / Providence Day School TRUE 2014 4 0.6087014 0.0487805 0.3209621 19
M_Baseball andrew_hernandez Miami, Fla. / Belen Jesuit Preparatory School TRUE 2019 4 2.9247967 2.6534553 2.4119203 57
M_Baseball andrew_miehe NA TRUE NA 0 NA NA NA 82
M_Baseball andrew_murnane Wayzata, Minn. / Salisbury School (CT) TRUE 2015 4 2.9393540 2.3981543 2.0903461 91


Developing individual outcome measures

Criteria for good outcome measures:

  • applicable to all sports.
  • equally valid across positions w/i sport (doesn’t bias against defensive players).
    • offense - defense
    • goalie - field player
    • pitcher - batter
  • differentiates between players w/i a sport
  • unambiguous
  • available in data

Player utilization measures

  • Roster years: number of years an athlete is on the roster
    • available for all sports: complete
  • Career GP: annual fraction of available games played
    • mostly available, or nearby proxy
  • Career GS: annual fraction of available games started
    • mostly available, or nearby proxy
  • Career Minutes (IP/AB, etc): annual fraction of available minutes played
    • sometimes available: ~9 sports
    • M/W Soccer, M/W Basketball, Softabll / Baseball, FH
  • Not: Points, Goals, etc

Constructing outcome variables (Ex: Pitcher only)




Constructing outcome variables (Ex: Pitcher & Position Player)



UPenn teams data availability & status

Years available

  • Roster: great, all sports 2011 +
  • Stats: variable by sport, typically 2011 +
    • Men’s Basketball only 2017/18 forward
  • Covid year?

All Sport Rosters by year


Roster

Roster year across all sports


UPenn teams data status by team



Sports with Minutes stat:

Men’s Soccer:

Women’s Soccer:

Women’s FH:


Men’s Baseball:


Women’s Softball:


Women’s Basketball:


Men’s Basketball:



Are there walkon players that make contributions? a few

Men’s Soccer:

Women’s Soccer:

Women’s FH:



BUT most sports don’t have Minutes.

GP, GS & roster years

Men’s LAX

Women’s LAX



Team Outcomes per season:



Career cum rank by within sport

M Baseball

W Softball

M LAX



Team Outcomes

Baseball

All Ivy

baseball