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?