APBRmetrics Forum Index APBRmetrics
The statistical revolution will not be televised.
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Is there a formula to qualify players?

 
Post new topic   Reply to topic    APBRmetrics Forum Index -> General discussion
View previous topic :: View next topic  
Author Message
supersub15



Joined: 21 Sep 2006
Posts: 81
PostPosted: Tue Aug 07, 2007 10:03 am    Post subject: Is there a formula to qualify players? Reply with quote
I am building a personal database and was sorting players for different categories, and I ran into this issue: If I sort for example for 3-pt shooting, I get players like Dajuan Wagner, Elton Brand, etc. at the top with 100%, but only 1 attempt. I need to weed out all the non-qualified players when sorting. So far, my field query looks like this:
3FG%: [3P]/IIf(Nz([3PA],0)=0,1,[3PA])

What is the formula to qualify players for a certain category?
Back to top
View user's profile Send private message
Eli W



Joined: 01 Feb 2005
Posts: 286
PostPosted: Tue Aug 07, 2007 10:29 am    Post subject: Reply with quote
Well you could start by looking at the official NBA minimums:

http://www.nba.com/leader_requirements.html
Back to top
View user's profile Send private message Send e-mail Visit poster's website
supersub15



Joined: 21 Sep 2006
Posts: 81
PostPosted: Tue Aug 07, 2007 10:41 am    Post subject: Reply with quote
John Quincy wrote:
Well you could start by looking at the official NBA minimums:

http://www.nba.com/leader_requirements.html


Thanks for the link, but something is not right. For example, at game 41 of the season, a player needs to have a minimum of 400 rebounds to be listed among the league leader. That's an average of around 10 rebounds per game!!! That list will look mighty tiny.

Am I missing something?
Back to top
View user's profile Send private message
kjb



Joined: 03 Jan 2005
Posts: 665
Location: Washington, DC
PostPosted: Tue Aug 07, 2007 11:06 am    Post subject: Reply with quote
supersub15 wrote:
John Quincy wrote:
Well you could start by looking at the official NBA minimums:

http://www.nba.com/leader_requirements.html


Thanks for the link, but something is not right. For example, at game 41 of the season, a player needs to have a minimum of 400 rebounds to be listed among the league leader. That's an average of around 10 rebounds per game!!! That list will look mighty tiny.

Am I missing something?


You're missing the word "or." To qualify for league leaders 41 games into the season, the player must have appeared in 35 games OR have collected 400 total rebounds.
_________________
My blog
Back to top
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
jkubatko



Joined: 05 Jan 2005
Posts: 508
Location: Columbus, OH
PostPosted: Tue Aug 07, 2007 11:07 am    Post subject: Reply with quote
supersub15 wrote:
John Quincy wrote:
Well you could start by looking at the official NBA minimums:

http://www.nba.com/leader_requirements.html


Thanks for the link, but something is not right. For example, at game 41 of the season, a player needs to have a minimum of 400 rebounds to be listed among the league leader. That's an average of around 10 rebounds per game!!! That list will look mighty tiny.

Am I missing something?


Most of the per game leader minimums are either/or cases. For example, to qualify for the rebounds per game leader board a player needs to have played in at least 70 games *or* grabbed at least 800 rebounds. Using your example above, at game 41 of the season a player would need at least 35 games played or 400 rebounds to qualify for the leader board.
_________________
Regards,
Justin Kubatko
Basketball Stats!
Back to top
View user's profile Send private message Send e-mail Visit poster's website
DLew



Joined: 13 Nov 2006
Posts: 57
PostPosted: Tue Aug 07, 2007 11:13 am    Post subject: Reply with quote
With three point shooting I like to treat anyone who took less than .5 threes per 40 as having a 3% of 0. This is unscientific, but it weeds out the guys who shoot 3s from those who don't.
Back to top
View user's profile Send private message
gabefarkas



Joined: 31 Dec 2004
Posts: 879
Location: Durham, NC
PostPosted: Tue Aug 07, 2007 2:03 pm    Post subject: Reply with quote
supersub15 wrote:
John Quincy wrote:
Well you could start by looking at the official NBA minimums:

http://www.nba.com/leader_requirements.html


Thanks for the link, but something is not right. For example, at game 41 of the season, a player needs to have a minimum of 400 rebounds to be listed among the league leader. That's an average of around 10 rebounds per game!!! That list will look mighty tiny.

Am I missing something?


Possibly, yes. I think you're underrating how many players achieve that milestone. At the end of the year, the leaderboard for total rebounds looked like:
Dwight Howard 1008
Kevin Garnett 975
Tyson Chandler 904
Carlos Boozer 867
Tim Duncan 845
Ben Wallace 821
Marcus Camby 816
Amare Stoudemire 786
Shawn Marion 785
Andris Biedrins 762

Assuming you need 800 rebounds (total) to qualify, a healthy 7 players are in the running. Garnett actually won, averaging 12.8 rebounds per game. That makes sense to me. Otherwise, a guy could average (hypothetically) 14 per game for 55 games, for a total of 770 rebounds and be eligible to win the rebounding crown, despite only playing two-thirds of the season.
Back to top
View user's profile Send private message Send e-mail AIM Address
Display posts from previous:   
Post new topic   Reply to topic    APBRmetrics Forum Index -> General discussion All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group