Correlations and Significance

[hellcat83]

Hi

I'm trying to do some fairly simple statistics using excel and I'm struggling to find the built in functions.

I have 2 columns of data and want to calculate the correlation co-efficient of the two data sets, one against the other. This if fairly simple.

I also want to calculate the statistical significance of that correlation. I can't seem to fins a function for that and wondered if anyone had ever done that before.

Cheers
jim

 

[Reid]

Correlation is:

=CORREL(array1,array2)

There are also many statistical functions such as t scores and the like, but I haven't used them in so long that I can't tell you what they are or exactly how they work. If you open the Insert Function dialog box, you can select "Statistical" from the category drop down and browse all of the available functions.

Hope this helps.

 

[hellcat83]

Thanks for the help