1

I have a model and need to compute a new value from two other values upstream, and then feed the new value to the Kernel Density tool.

Here is the formula I am trying to reproduce in the "Calculate Values" tool:

hopt formula

Excel

Here is what the formula looks like in Excel: =((2/(3*n))^(1/4))*(σ)

For example, if n = 9 and σ = 42840 it results in the correct answer of 22350

Python

Here is the formula as I currently have it in "Calculate Values Tool": ((2/(3*%Row Count%))**(1/4))*(%SD%)

It does not return the correct value. Am I missing a parenthesis somewhere?

The model, for context

asked Apr 14, 2020 at 16:46
1

0

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.