[Oz-teachers] Excel Formula
barbara at iimetro.com.au
Sat Aug 20 19:24:48 EST 2005
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?
who should stick to quilting.
Palmerston District Primary School
PALMERSTON ACT 2913
T. 61 2 6205 6162
F. 61 2 6205 7242
E. barbara at iimetro.com.au
"Together we learn from each other."
From: oz-teachers-bounces at rite.ed.qut.edu.au
[mailto:oz-teachers-bounces at rite.ed.qut.edu.au]On Behalf Of Elham
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?
> Olga Laurantus
> oz-teachers mailing list
> oz-teachers at rite.ed.qut.edu.au
oz-teachers mailing list
oz-teachers at rite.ed.qut.edu.au
More information about the oz-teachers