> I guess "nice" is in the eye of the beholder. I view this as
> another good reason NOT to use Excel for Statistics!
>
> Please use the right tool for the job.
>
> Jon Cryer
Sometimes the right tool for the job is Excel. Most of my students will not
have access to specialist statistical software after they graduate. Although
Excel has many shortcomings, it is widely-available.
Dr Graham D. Smith
Psychology Division
School of Behavioural Studies
University College Northampton
Boughton Green Road
Northampton
NN2 7AL
Tel (01604) 735500 Ext 2393
Email [EMAIL PROTECTED]
----- Original Message -----
From: Jon Cryer <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 29, 1999 5:54 PM
Subject: Re: Rank Awful
> I guess "nice" is in the eye of the beholder. I view this as
> another good reason NOT to use Excel for Statistics!
>
> Please use the right tool for the job.
>
> Jon Cryer
>
> At 05:58 PM 11/26/99 +0100, you wrote:
> >Very nice solution.
> >It can be reduced even to the last part:
> >RANK(A1,A$1:A$6,1)+(COUNTIF(A$1:A$6,A1)-1)/2)
> >
> > Ivan
> >
> >> You can modify the rank() function using the following one:
> >>
> >> IF(COUNTIF(A$1:A$6,A1)=1, RANK(A1,A$1:A$6,1),
> >> RANK(A1,A$1:A$6,1)+(COUNTIF(A$1:A$6,A1)-1)/2)
> >>
> >> In this setting, the data range is A1:A6 (as the example you mentioned
in
> >> your email), and ranking is in the ascending order, e.g. smaller number
> >> gets smaller rank. You can type this function in cell B1, and copy the
> >> formula to B1:B6. Let me know if you need further info.
> >>
> >> Jay
> >>
> >
> >********************************************************
> > Ivan Zezula, Safarik University, Kosice
> >
> >
> _____________
> ------------------------------------------------- | \
> Jon Cryer [EMAIL PROTECTED] ( )
> Department of Statistics http://www.stat.uiowa.edu\ \_
University
> and Actuarial Science office 319-335-0819 \ * \ of
Iowa
> The University of Iowa dept. 319-335-0706 \ /
Hawkeyes
> Iowa City, IA 52242 FAX 319-335-3017 |____________ )
> ------------------------------------------------- V
>
