Thanks to everybody who has done my homework for me. As one able Exceller put it:<div>&quot;<span style="color:rgb(31,73,125);font-family:Calibri,sans-serif;font-size:14.44444465637207px;background-color:rgb(255,255,255)">If you understand the VLOOKUP, HLOOKUP, MATCH &amp; OFFSET functions in Excel, then data manipulation becomes so much easier to do in Excel.</span> &quot;</div>
<div><br></div><div>These are all new words in my vocabulary - thanks very much!</div><div><br></div><div>JOHN BIBBY</div><div><br></div><div><br>
<br><div class="gmail_quote">On 22 July 2012 22:30, John Bibby <span dir="ltr">&lt;<a href="mailto:[log in to unmask]" target="_blank"><a href="/cgi-bin/wa-jisc.exe?LOGON=A3%3Dind1207%26L%3DALLSTAT%26E%3Dquoted-printable%26P%3D1809847%26B%3D--f46d04462fbcbe9d5e04c57b5cf0%26T%3Dtext%252Fhtml%3B%2520charset%3DISO-8859-1%26pending%3D" target="_parent" >[log in to unmask]</a></a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

I know I should not be using Excel for this but ...  (the things one does for pedagogy!)<br><br>I have tables such as<br><br>Group ranges   2-3  3-5 5-10 10-20<div>Frequency</div><div>(n in group)     13    17   34      23<br>


<div><br></div><div>(More complicated than these and many of them)</div><div><br></div><div>Problem: How to use Excel to calculate the nth percentile.</div><div><br></div><div>The main problem is how to find which group the percentile is in. (The only Excel formula I have is itertaive &amp; tortuous with lots of IFs - there must be a simpler way of doing it.)</div>


<div><div><br></div></div></div>
</blockquote></div><br></div>
You may leave the list at any time by sending the command
<p>
SIGNOFF allstat
</p><p>
to <a href="mailto:[log in to unmask]"><a href="/cgi-bin/wa-jisc.exe?LOGON=A3%3Dind1207%26L%3DALLSTAT%26E%3Dquoted-printable%26P%3D1809847%26B%3D--f46d04462fbcbe9d5e04c57b5cf0%26T%3Dtext%252Fhtml%3B%2520charset%3DISO-8859-1%26pending%3D" target="_parent" >[log in to unmask]</a></a>, leaving the subject line blank.