[Oz-teachers] Excel Formula

[Barbara Braxton]

Dear Elham
Given the requirements for reports being foisted upon us by the federal Govt, I can see that this
function is going to be very useful.  But I can't quite work out how to use it.

I have installed the Analysis Tool Pack, entered and ordered the column of figures and highlighted
these.  When I click on Rank and Percentile it asks for an "input range" but I can't seem to find
what I should put in that field.  I have tried the column header A; and  the range of numbers but I
just get an invalid input message. Despite having just re-read the complete series of Harry Potter,
I know Excel is not a piece of magic so there is obviously a step I am missing.  Can you please tell
me( and all the others investigating this function) what it is?
Thanks
Barbara

who should stick to quilting.



Barbara Braxton
Teacher Librarian
Palmerston District Primary School
PALMERSTON ACT 2913
AUSTRALIA

T. 61 2 6205 6162
F. 61 2 6205 7242
E. barbara at iimetro.com.au
W. http://www.palmdps.act.edu.au
"Together we learn from each other."

-----Original Message-----
From: oz-teachers-bounces at rite.ed.qut.edu.au
[mailto:oz-teachers-bounces at rite.ed.qut.edu.au]On Behalf Of Elham
Jankowski
Sent: Saturday, 20 August 2005 4:08 PM
To: Professional community for teachers
Subject: Re: [Oz-teachers] Excel Formula


Try PERCENTILE function

Olga Laurantus wrote:

> To all Excel experts and non-experts on this list
>
> Does anyone know of an Excel formula which will sort a set of class
> marks into the top, the 2nd, 3rd and bottom 25%  of the given marks?
>
> Thanks
> Olga Laurantus
>
>
> _______________________________________________
> oz-teachers mailing list
> oz-teachers at rite.ed.qut.edu.au
> http://lists.rite.ed.qut.edu.au/mailman/listinfo/oz-teachers
>

_______________________________________________
oz-teachers mailing list
oz-teachers at rite.ed.qut.edu.au
http://lists.rite.ed.qut.edu.au/mailman/listinfo/oz-teachers