Soldato
- Joined
- 7 Aug 2004
- Posts
- 11,289
Have this graph here:
What I want to know is, how do I run a correlation formula in excel? basically want to measure (put a number on) if there is a correlation between the 2 data sets shown on the graph (there are 15 graphs, all showing a similar trend, so its easy to 'see' there is one, but i need to put a mathematical number on it - which I have no idea how to do ! lol)
Any pointers would be awesome, the data in the excel spread sheets are obviously a1 and b1 columns for 'trans' and c1 and d1 for water depth
What I want to know is, how do I run a correlation formula in excel? basically want to measure (put a number on) if there is a correlation between the 2 data sets shown on the graph (there are 15 graphs, all showing a similar trend, so its easy to 'see' there is one, but i need to put a mathematical number on it - which I have no idea how to do ! lol)
Any pointers would be awesome, the data in the excel spread sheets are obviously a1 and b1 columns for 'trans' and c1 and d1 for water depth