How can I calculate Nash-Sutcliffe efficiency in EXCEL?
 

Does anyone know an easy way to calculate Nash-Sutcliffe efficiency in EXCEL?
Thanks.

Answer: How can I calculate Nash-Sutcliffe efficiency in EXCEL?
 

Calculating Nash-Sutcliffe Efficiency in Excel

1. Have two sets of data: observed values and simulated/predicted values in columns A and B, respectively.
2. Calculate the mean of the observed values using the AVERAGE function: =AVERAGE(A:A)
3. Subtract each observed value from the mean and square the result using the formula: =(A2-$A$1)^2. Copy this formula down for all the observed values.
4. Calculate the sum of the squared differences from step 3 using the SUM function: =SUM(C:C)
5. Calculate the sum of the squared differences between the observed and simulated values using the formula: =(A2-B2)^2. Copy this formula down for all the values.
6. Calculate the sum of the squared differences from step 5 using the SUM function: =SUM(D:D)
7. Finally, calculate the Nash-Sutcliffe efficiency using the formula: 1-(D5/C5), assuming the sum of squared differences between observed and simulated values is in cell D5 and the sum of squared differences from step 3 is in cell C5.

How can I calculate Nash-Sutcliffe efficiency in EXCEL?
 

What is the formula?

"jpm" wrote in message
...
Does anyone know an easy way to calculate Nash-Sutcliffe efficiency in
EXCEL?
Thanks.

How can I calculate Nash-Sutcliffe efficiency in EXCEL?
 

On Oct 5, 2:13 pm, jpm wrote:
Does anyone know an easy way to calculate Nash-Sutcliffe
efficiency in EXCEL?

I know nothing about Nash-Sutcliffe. But based on the Wikipedia entry
[1], I think the following might work (untested):

=1 - sumproduct((A1:A12 - B1:B12)^2) / sumproduct((A1:A12 - C1)^2)

where C1 is:

=average(A1:A12)

and A1:A12 contains the observed discharges Qo, and B1:B12 contains
the modeled discharges Qm.

HTH.


Endnotes:

[1] http://en.wikipedia.org/wiki/Nash-Su...cy_coefficient

The Nash-Sutcliffe is a Regression Coefficient for hydrological applications. From the can use the

Tools-Data Analysis-Regression. You can also use the =RSQ(xi,yi) function.

In French excel, it's the =coefficient.determination(xi,yi)) function

is this

=1-(SUMXMY2(A1:A12;B1:B12)/SUMXMY2(B1:B12;C1:C12))

where C1:C12 is a colum with averages of observed discarges

How can I calculate Nash-Sutcliffe efficiency in EXCEL?
 

On Saturday, 6 October 2007 10:13:00 UTC+13, jpm wrote:
Does anyone know an easy way to calculate Nash-Sutcliffe efficiency in EXCEL?
Thanks.

You can do it using the SUMXMY2 function:

=1-SUMXMY2(data,model)/(COUNT(data)*VAR.P(data))

online calculators for Nash-sutcliffe coefficient
 

Hi

You can use these online calculators for Nash-sutcliffe coefficient

Nash Sutcliffe Model Efficiency Coefficient Calculator

It is free.