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
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