As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/

Options

Folken Fanel
anime afWhen's KoFRegistered User regular

So I'm a grad student studying mathematics and I need to analyze a set of data and run some tests to decide what class of distribution the data belongs to. I'm interested in finding out the number of days that pass between no-hitters that are thrown in major league baseball. However, the biggest problem I'm having is finding said information. Wikipedia gives each no hitter ever thrown and the date of each, but calculating the number of days between each event would be a giant pain in the ass. Is there any chance that someone knows of such a site that will give me the number of days between no hitters?

0

## Posts

linky

lowlylowlycookon(Please do not gift. My game bank is already full.)

Paul_IQ164onPuzzle League: 073119-160185

There's even a nifty function in Excel for calculating the difference in days between two dates, and I'm pretty sure there's a working function for calculating the difference in weekdays, and you can give it a list of holidays to skip. I say I'm pretty sure and "working" because if you've got a bit of experience in the subject using Access, you'll note that Access hasn't been able to calculate business days properly since at least 1997. I don't know if Access 97 does it right either, in fact, I strongly suspect the function was broken back then, too.

PheezeronCUZ THERE'S SOMETHING IN THE MIDDLE AND IT'S GIVING ME A RASH

That's the way I learned how to process data into excel, but I have no idea if it's easier or harder than Pheezer's html method.

LavaKnightonActually, Excel stores dates as 5 digit numbers, always. 1/1/1900 is stored in Excel as "1", 3/24/2007 is stored as "39165", and is 39,165 days after January 1, 1900.

Because Excel does this lookup accurately, you can just type the dates into Excel, and subtract each no-hitter date from the previous one. Make sure the cell that you're doing the subtraction in had the data type set to "number" rather than "date" and the cell will display the number of days between those two dates.

ChenjesuonWhy aren't you using a stats package like SPSS? All you need is one column listing all dates, and another one coded as no-hitter (yes/no).

This seems pretty damn basic for postgrad study...

The CatonI decided to see if the number of total homeruns each team hits in a given year is part of some distribution (turns out its normally distributed) using the Kolmogorov-Smirnov Test.

Thanks for everyone's help though. I'll probably look into these suggestions when I don't have time constraints. Lock please.

Folken FanelonTwitter:Folken_fgcSteam:folken_XBL:flashg03PSN:folken_PASFV: folken_