Thanks, but do I have to rank the students first. Also, the link you gave me
was not very helpful. Remember, I'm a new user. Therefore, could you
explain how this should and could be done? Thanks.

"Gary''s Student" wrote:

> Hi Rebecca:
>
> Excel has a built-in function to help you. See:
>
> http://office.microsoft.com/en-us/as...090231033.aspx
>
> This article also outlines the mathe behind the function.
> --
> Gary's Student
>
>
> "Rebecca" wrote:
>
> > Greetings. I realize this is a simple statistical question, but I don't have
> > a statistics package (or any knowledge of statistics), but I am using EXCEL
> > 2003. I would deeply appreciate your help because I can't figure out on my
> > own how to do this in EXCEL.
> >
> > I have a column of numbers in random order (5, 33, 4, 76, 32, 46, etc.).
> > The lower numbers are "better" than the higher numbers (they are scores on a
> > test; higher numbers mean more mistakes). I have another column of numbers
> > also in random order (not ranked). The lower numbers are "better" than the
> > higher numbers (they are scores on another test; the higher the number, the
> > more the mistakes). I want to see if there is a correlation between the two
> > columns of test scores: that is, I want to find out if those who did well on
> > the first test (those with lower numbers) also did well on the second test
> > (those with lower numbers). Could you please tell me in simple English how
> > to do this?