Very Quick Excel Question, to anyone in the know !

[Combat squirrel]

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

 

[wmb]

Simplest was is plot transmittance v water depth (i.e. one on x axis the other as y) i.e. you don't want time on the plot at all.

Goto chart>add trendline and voila! You can then double click on the trendline and fiddle with options such as displaying equation, showing R^2 etc.

However, to het a more accurate regresion you need to use the data analysis tools (optional add in that may not be installed).

 

[M0KUJ1N]

Hi,

Do you have much stats experience? Excel has a range of Statistical functions, such as CORREL, PEARSON and RSQ which would give you some sort of figure for whether there is any correlation between 2 random independent variables but of course it would be up to you to interpret this figure