Thursday, November 09, 2006

Ramblings on Research: Coping with data and spreadsheets

I have posted about statistics before (see Statistics Course from Hell). So I won't ramble on too much about that. However, I've just spent most of the day today on spreadsheets of data AGAIN. This time I was calculating AUC (area under the curve). This is about as spellbinding as it gets around here folks!!! My ass is as about as numb as my brain is getting here... Luckily I've got a new CD and the fridge to keep me from dying of boredom. Yeah ok, my ass isn't doing well in this situation at all...

So you take a person, you take their blood every two hours for 8 hours and then plot some of their clinical data results over time (i.e. cholesterol levels). From this you can calculate AUC, then I take that AUC and plug it into our stats program and voila! You can see if the computer validates your whole existence over the past few years or not.

Honk shew.

Then you can go out and get trashed on vino and dance to hip hop all night!!!! Yay! Some call it "stress management." (Yeah, I know you're probably thinking that I've developed quite the set of stellar coping skills...)

Ahem... Then the next day you meet with your supervisor and hope he doesn't detect the tired eyes, alky breath and of course that ultimate hangover hallmark- the always lovely 50 point drop in I.Q. It usually goes something like this:

Supervisor: Why were we meeting today?
You: Uh...
Supervisor: What have you been up to lately?
You: Uh... things.
Supervisor: How does the program calculate AUC?
You: Uh... I dunno.

You: Can I go now?

3 comments:

Rosie said...

did you really do that?

HAHAHAHAHA! I spent a day or two at the lab completely hungover. Nice.

Enjoyed reminiscing about stats though. Our graduate department here doesnt ahve a stats requirement so i'm considered the expert ;) Although, my husband (who was in my stats class and apparently not the guy I'd repopulate the earth with in the case of nuclear war)probably thinks that HE is the stats expert. I tell him that his computer stats software sucks and is nothing compared to SAS. Then he takes it to heart because I've insulted his prescious MAC (CRAP!).

michie said...

No, K-os is tonight!!!!!

I hope my meeting with the boss man doesn't go that badly tomorrow...

We'll be good tonight:)

ps. His stats program rocks, I was using it today for the AUC.

Al said...

I thought that "area under the curve" was how an umpire determined whether a pitch was a strike.