You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
thank you for UDF MEDIAN function. It works well with one issue.
From Wikipedia:
If n is odd then Median (M) = value of ((n + 1)/2)th item term. If n is even then Median (M) = value of [((n)/2)th item term + ((n)/2 + 1)th item term ]/2
Issue is, when items count is even - for example, 2, or 4 items.
For example, for 2 items (5, 10), true median is 7.5, but MEDIAN function returns 5.
Could you implement this behavior?
Thank you very much.
The text was updated successfully, but these errors were encountered:
Hi,
thank you for UDF MEDIAN function. It works well with one issue.
From Wikipedia:
If n is odd then Median (M) = value of ((n + 1)/2)th item term.
If n is even then Median (M) = value of [((n)/2)th item term + ((n)/2 + 1)th item term ]/2
Issue is, when items count is even - for example, 2, or 4 items.
For example, for 2 items (5, 10), true median is 7.5, but MEDIAN function returns 5.
Could you implement this behavior?
Thank you very much.
The text was updated successfully, but these errors were encountered: