Calculating St. Pius X Festus rating - a lesson for coach Chris Miller

 Chris Miller, boys coach for a solid St. Pius X Festus team, inquired about how the model works.  I share a few screenshots with him and am providing them below. 

I use a large Excel spreadsheet for the boys and the girls.  Every team is entered into the spreadsheet and I calculate an average rating by summing the game ratings and dividing by the number of games.  I calculate some other things along the way and it is easy to copy the results and dump them into a report.

Each team is listed in the Excel Formulas section under defined names.  I use abbreviations for each school and link that defined name to the average rating for the team.  When St. Pius X beats 

Valmeyer, Illinois by 31, I add the Valmeyer rating and the 31-point differential to give St. Pius X a game rating of 109.  The table below shows how I get the game ratings that enter into the master spreadsheet.  I don't do a table like this for all teams unless I get a squabble going late in the season and there are three or four top teams that I need to re-evaluate.  

You can see that St. Pius X played opponents with an average rating of 100.5 and their rating was 99.8, meaning that they probably had about a 50-50 chance of winning these games.  Their actual record is    7 wins-9 losses and their point differential of 52.8 scored to 53.5 given up (which works out to a predicted season finish of 48% winning percentage or 13 wins and 14 losses).

But I don't get this deep with every team.  I used the spreadsheet screenshot below this table to calculate team ratings.

I took the teams just above and just below St. Pius X to show the calculation table.  I added a line below St. Pius X to illustrate the defined formulae that are entered into the spreadsheet.

          As I collect team scores, I add them to the list and continue for the entire season.   

         About this time of year, I start to focus on the top 20 or 30 teams in each class and catch up on the           lower-rated teams as I have time.

         I don't know if any of that makes sense.  It probably muddies the waters more than it helps, but               that is how Gramps ratings work.






Comments

Post a Comment

Popular posts from this blog

Gramp's Missouri High School Basketball Ratings

Image
Updated March 28, 2023 It must be another full moon tonight or at least all the planets will be aligned in a rare concentration of planets under the moon at sunset in the west.  You should go outside and take a look.  It might not happen again in your lifetime. I have finished all the boys' and girls' Missouri basketball ratings for every school in every class in the state.  That includes about 550 boys and 530 girls schools.  Does anybody else do that?  Would anyone else ever attempt rating all those teams? So this is a wrap.  I may add some additional statistics about playoff predictions or most improved teams but this is it, folks.  I hit about 83% of all games based on my ratings and eight of the twelve class winners were my #1 rated team in early February.  Not bad for this old coot. I hope you have enjoyed my ratings this season.  If you want to get involved next year and do one of the boys or girls classes, I will gladly train you in d...
Read more

Gramp's Missouri Boys Class Five Final Basketball Ratings

Image
 Gramp's Missouri Boys Class Five Final Basketball Ratings - Update March 26, 2023 No one can argue that Cardinal Ritter is #1 again this year.  But who should be #2?  Well, the MBCA poll takes the final four and places them above everyone else, no matter how good they were or what their record might have been.  Was Ladue good this year?  Oh, yeah, baby.  But Cape Girardeau Central was 27-3 and lost to Chicago Simeon, who was comparable to Vashon, CBC, and then was upset by Sikeston in the district final after beating them by 27 during the season.  So Cape Central deserves better than seventh in the MBCA poll.  I guess you could call Cape Central and Ladue tied for #2. Westminster Academy sneaks in at #4 ahead of third-place Jeff City and De Smet sneaks in ahead of Pembroke Hill who finished fourth at state.  Sikeston, who upset Cape Central, comes in at #8.  Borgia, who was undefeated at one point in the season, ends up #9 and Bolivar t...
Read more

Gramp's Class One Boys and Girls Basketball Ratings by district

Image
 It's that time of year.  Missouri class one districts start tonight and everyone is looking to go deep into the tournament.  Well, maybe not everyone.  Some would like to play another game.  Some teams just want to finish with a good game, even if it is the end of the season.  All that work!  Time to get it done. Gramp's is putting the boy's and girl's rating together here.  Take a good look.  The team rank in all of class one is followed by the school name, district and Gramp's rating. Updated 2/21/2023 - Richland Essex and Osborn/Stewartville were incorrectly put in district one boys.  Tina Avalon and Norborne were misplaced in the girls.
Read more