Jetbrains scripting

STANDARD_DEVIATION.groovy

import static java.math.MathContext.DECIMAL128

def toBigDecimalFunc = { value ->
  value instanceof Number ? value as BigDecimal :
  value.toString().isBigDecimal() ? value.toString() as BigDecimal :
  null
}

def valuesList = []

ROWS.each { row ->
  COLUMNS.each { column ->
    def bigDecimalVal = toBigDecimalFunc(row.value(column))
    if (bigDecimalVal != null) {
      valuesList.add(bigDecimalVal)
    }
  }
}

if (valuesList.isEmpty()) {
  OUT.append("Not enough values")
  return
}

def sumTotal = BigDecimal.ZERO
valuesList.each { val ->
  sumTotal = sumTotal.add(val, DECIMAL128)
}
def avgValue = sumTotal.divide(valuesList.size(), DECIMAL128)
def sumSquaredDifference = BigDecimal.ZERO
valuesList.each { val ->
  BigDecimal diff = val.subtract(avgValue, DECIMAL128)
  sumSquaredDifference = sumSquaredDifference.add(diff.multiply(diff, DECIMAL128), DECIMAL128)
}

def varianceValue = sumSquaredDifference.divide(valuesList.size(), DECIMAL128)
def stdDeviation = varianceValue.sqrt(DECIMAL128)
def coefficientOfVariation = stdDeviation.divide(avgValue, DECIMAL128)
OUT.append(stdDeviation.round(2) + "%")