Normalizer: Useful to anyone?

ctorg · 10-17-2006, 11:04 AM

I made a little Access database from the Lahman database that allows you to enter a year, press a button, and have all statistics instantly normalized to that year.

I only have Batting stats in there right now, but I figured I'd bring it up here in case anyone was interested.

The way I went about normalizing is a bit unusual. I wanted to have something that was simple enough to do but would work with OOTP. I used number of standard deviations from the mean, weighted by at bats. So if a player was one standard deviation from the mean number of homeruns per at bat in 1910 and you normalize to 1998, he will be one standard deviation from the mean of homeruns per at bat in 1998.

I also did all the rates per at bat rather than per plate appearance, just because it was quicker. Potentially, this could be revamped to work with different formulas, include park factors, etc. It is more just an experiment to produce an instant normalizer than anything. It works, but there are error messages where no data exist for players in certain years (I don't mind much, since their data are blank in the database anyway).

It's an Access database, so you need Access to run it. And it's too big to upload here, although I could split it into multiple compressed files or upload it somewhere if there's interest. Is anyone interested in this sort of thing?

bp_ · 10-17-2006, 02:34 PM

I'm sure someone will be interested. We can host it. Email it to mods@ootpmodsquad.com

ctorg · 10-17-2006, 02:58 PM

Quote:

Originally Posted by bp_

I'm sure someone will be interested. We can host it. Email it to mods@ootpmodsquad.com

Okay. Thanks. I'll send it soon. I added a pitching calculator as well.

bp_ · 10-17-2006, 05:57 PM

now available on http://www.ootpmodsquad.com/ under database tools

10-17-2006, 11:04 AM	#1 (permalink)
ctorg Global Moderator Join Date: Nov 2002 Location: Brooklyn, NY Posts: 9,701 Thanks: 38 Thanked 91x in 51 posts	Normalizer: Useful to anyone? I made a little Access database from the Lahman database that allows you to enter a year, press a button, and have all statistics instantly normalized to that year. I only have Batting stats in there right now, but I figured I'd bring it up here in case anyone was interested. The way I went about normalizing is a bit unusual. I wanted to have something that was simple enough to do but would work with OOTP. I used number of standard deviations from the mean, weighted by at bats. So if a player was one standard deviation from the mean number of homeruns per at bat in 1910 and you normalize to 1998, he will be one standard deviation from the mean of homeruns per at bat in 1998. I also did all the rates per at bat rather than per plate appearance, just because it was quicker. Potentially, this could be revamped to work with different formulas, include park factors, etc. It is more just an experiment to produce an instant normalizer than anything. It works, but there are error messages where no data exist for players in certain years (I don't mind much, since their data are blank in the database anyway). It's an Access database, so you need Access to run it. And it's too big to upload here, although I could split it into multiple compressed files or upload it somewhere if there's interest. Is anyone interested in this sort of thing? __________________ THE VERY US ARTISTS - A project for musicians and visual artists My music Currently reading: Thirteen by Richard Morgan "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils

10-17-2006, 02:34 PM	#2 (permalink)
bp_ Hall Of Famer Join Date: Apr 2004 Location: Philadelphia Posts: 2,642 Thanks: 54 Thanked 23x in 11 posts	I'm sure someone will be interested. We can host it. Email it to mods@ootpmodsquad.com __________________ "al Qaeda wouldn't last a day in parts of Philadelphia" - Mayor Michael Nutter

10-17-2006, 05:57 PM	#4 (permalink)
bp_ Hall Of Famer Join Date: Apr 2004 Location: Philadelphia Posts: 2,642 Thanks: 54 Thanked 23x in 11 posts	now available on http://www.ootpmodsquad.com/ under database tools __________________ "al Qaeda wouldn't last a day in parts of Philadelphia" - Mayor Michael Nutter

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode