MANN_WHITNEY_U_TEST (Lakehouse v2)

Performs a Mann-Whitney U test on two independent samples.

Analyze Syntax

func.mann_whitney_u_test(get_column(table, 'sample'), get_column(table, 'treatment'))

Analyze Examples

func.mann_whitney_u_test(get_column(table, 'score'), get_column(table, 'group_id'))

┌─────────────────────────────┐
│ {"U":245.0,"p-value":0.032} │
└─────────────────────────────┘

SQL Syntax

MANN_WHITNEY_U_TEST(<sample>, <treatment>)

SQL Examples

SELECT MANN_WHITNEY_U_TEST(score, group_id) FROM experiment;

┌─────────────────────────────┐
│ {"U":245.0,"p-value":0.032} │
└─────────────────────────────┘