Re: Area under the curve with Excel

From: N (Casnovatuad_at_doramail.com)
Date: 09/25/04 

Date: Sat, 25 Sep 2004 01:59:41 +0000 (UTC)

I have my lab result in excel form. I'd like to find area under the
curve for my calculation.

Can you tell me in details how to do that by R? I just downloaded it.

Sincerely,

N

On Tue, 27 Nov 2001 01:50:59 GMT, Frank E Harrell Jr wrote:
>Why use Excel for serious work? If you want excellent free
>comprehensive statistical software try R at www.r-project.org.
>Then define an S-language function in R to compute the area under the

>ROC curve using the Mann-Whitney U-statistic:
>
> n1 <- sum(y==1)
> mean.rank <- mean(rank(x)[y==1])
> roc.area <- (mean.rank - (n1+1)/2)/(n-n1)
>
>Frank Harrell
>
>
>In article <5890a172.0111260214.575bf144@posting.google.com>,
"Sandrine
>Briand" <sandrine.briand@ccecqa.asso.fr> wrote:
>
>> Hello,
>>
>> I'm french (sorry for my very bad english !) How can I calculate
the
>> area under the curve with Excel (Microsoft) ? I hope somebody can
help
>> me.
>> Thanks.
>>
>> Sandrine