Compare Total to Average Total For THAT Season

66 views
Skip to first unread message

OffshoreInsiders.com

unread,
Jan 9, 2022, 8:53:25 PMJan 9
to SportsDataBase
As scoring goes up, how we'd define high or low totals does too. I know if I do the below calculation, it will tell me games in which the total is 30 point higher than the average total for the entire database. But how would look at games that are 30 points higher than the average total posted THAT season? TIA

total-A(total)>=30

Joe Meyer

unread,
Jan 10, 2022, 8:23:52 AMJan 10
to sportsdatabase
OffshoreInsiders,

Yes, A(total) gives the average total for the entire database.

The SDQL shortcut tA(total) expands out to A(total@team and season) and gives the average total for that team in that season.

From there can you figure out the league-wide average total for that season?
How about for the previous season?

best regards,

Joe Meyer
Sports Database LLC

On Sun, Jan 9, 2022 at 8:53 PM OffshoreInsiders.com <offshore...@gmail.com> wrote:
As scoring goes up, how we'd define high or low totals does too. I know if I do the below calculation, it will tell me games in which the total is 30 point higher than the average total for the entire database. But how would look at games that are 30 points higher than the average total posted THAT season? TIA

total-A(total)>=30

--
You received this message because you are subscribed to the Google Groups "SportsDataBase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sportsdatabas...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/2e137ed8-e7d9-4433-8751-fecb60241ad6n%40googlegroups.com.

OffshoreInsiders.com

unread,
Jan 10, 2022, 9:18:43 AMJan 10
to SportsDataBase
Thanks Dr. Meyer, so it would be? 

total-A(total@season)>=20 it appears as it is not heavily shaded towards the high totals of recent play. 
Reply all
Reply to author
Forward
0 new messages