Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I calculate Nash-Sutcliffe efficiency in EXCEL?
Does anyone know an easy way to calculate Nash-Sutcliffe efficiency in EXCEL?
Thanks. |
#2
|
|||
|
|||
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.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
|
|||
|
|||
Quote:
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 |
#6
|
|||
|
|||
Quote:
=1-(SUMXMY2(A1:A12;B1:B12)/SUMXMY2(B1:B12;C1:C12)) where C1:C12 is a colum with averages of observed discarges |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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)) |
#8
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to calculate e^2 in excel | Excel Discussion (Misc queries) | |||
can't get excel to calculate | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Range efficiency | Excel Worksheet Functions | |||
Question re efficiency in vlookup | Excel Worksheet Functions |