AnsweredAssumed Answered

How can I best calculate if a datum is above or below the mean?

Question asked by NCRC_Research on Feb 12, 2016
Latest reply on Feb 12, 2016 by Dan_Patterson



First time posting and I have searched for this issue but didn't find where it was previously addressed.  I have added a field call "Loans" and it contains hundreds or thousands of numbers including zeros and decimals.


I also have a new field called LoanScore


Compute the mean of Loans and if the item on that row is above the mean assign a "1" to that row in LoanScore.


I am running ArcGIS 10.3.1 and Python 10.3.1 on 64 bit Windows.


Previously, I was able to run this in excel using the statement =if(median(a$2:a$1000)<a2,1,0) and then just filled the whole LoanScore column with that formula [where a2 was the first number in the "Loans" column]

Thank you for any assistance.