Results 1 to 4 of 4
  1. #1
    Prospect
    Points: 7,635, Level: 26
    Level completed: 15%, Points required for next Level: 515
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points

    Join Date
    Jan 2008
    Posts
    19
    Points
    7,635
    Level
    26
    Thumbs Up
    Received: 0
    Given: 0

    Just for Fun - PointsBetter.xls

    So how much better than last year's MBB team do we have to be this year to get to the NCAA tourney? It's obviously impossible to answer, but the attached spreadsheet attempts to estimate the impact of better players against last year's schedule/results and says we need to be 6 or 7 points better on average per game.

    This assumes of course that the overall average difficulty of this year's schedule is about equal to last year's.

    Enter the value 6 into cell G1 and it calculates we would have been 21-10 overall and 7-9 in conference. Use 7 points better per game and we're 24-7 and 9-7 which is a definite NCAA berth.

    Surely we're 7 points better per game this year right? We have a ton more fire power, so we'll easily score 3.5 more points per game on average. We'll have many more capable bodies to shuffle in for an all out aggresive defense ALL GAME. That means 3.5 points per game less that the opponent will score on us.
    Attached Files Attached Files



  2. #2
    Pro
    Points: 72,425, Level: 83
    Level completed: 58%, Points required for next Level: 725
    Overall activity: 0%
    Achievements:
    50000 Experience PointsVeteran
    SvrWxCy's Avatar
    Join Date
    Aug 2010
    Location
    Kansas
    Posts
    2,851
    Points
    72,425
    Level
    83
    Thumbs Up
    Received: 0
    Given: 0

    Re: Just for Fun - PointsBetter.xls

    This also assumes that all other teams do not change either, while it is an interesting statistic there is just too many variables to make it worthwhile.



  3. #3
    Pro
    Points: 67,902, Level: 80
    Level completed: 91%, Points required for next Level: 148
    Overall activity: 3.0%
    Achievements:
    Veteran50000 Experience Points

    Join Date
    Dec 2008
    Location
    Des Moines
    Posts
    3,244
    Points
    67,902
    Level
    80
    Thumbs Up
    Received: 52
    Given: 1

    Re: Just for Fun - PointsBetter.xls

    Nice work on the spreadsheet Bob. ISU lost 6 conference games last year by 6 points or less. That would have given ISU a final record of 24-10 and and at least a NIT bid if it swung ISU's way. I think depth would have made a serious impact last year if we had it.

    It appears however that ISU's problems were definitely not scoring but stopping the other team from scoring. ISU in conference games were ranked 5th in scoring but 9th in scoring D, and 9th in scoring margin.

    I think this team will go as far as their defense will take them.



  4. #4
    Addict
    Points: 131,420, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 42.0%
    Achievements:
    50000 Experience PointsSocialVeteran
    ISUCyclones2015's Avatar
    Join Date
    Dec 2010
    Location
    Ames via Akron, Ohio
    Posts
    5,395
    Points
    131,420
    Level
    100
    Thumbs Up
    Received: 403
    Given: 137

    Re: Just for Fun - PointsBetter.xls

    If we're 34 points better than we will go 31-0!



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
  • Football
  • Iowa State vs. North Dakota State
  • August 30, 2014
  • 11:00 AM