Statistics

• Let's download data from https://herosports.com/colleges/teams/edinboro-mens-football-stats.
  • Data tab, get external data, from web, paste in the url
  • It will be sloppy, but better than typing int all in.
  • Delete junk.
  • Copy each table to a new worksheet.
• Columns to text in the data tab, data tools workgroup.
  • Move the names so there are blank columns to the left.
  • Columns to text, break on space
  • Put them back.
  • Possibly insert column
• Sort by last name.
• Sort sort and clear out the zeros in the various columns
• Some stat functions
  • count, counta, countblank
  • max, min, average
  • standard deviation
  • mode
  • quartile
  • median (quartile too)