Calculate median in quartile

j_mig As a dynamic array variant (for MS365):

=DROP(REDUCE("", UNIQUE(tblData[Sex]), LAMBDA(a,v, LET(
    arr, SORT(FILTER(tblData[Payment], tblData[Sex]=v)),
    m, MAKEARRAY(1, 4, LAMBDA(r,c, LET(
        pq, QUARTILE.INC(arr, c-1),
        cq, QUARTILE.INC(arr, c),
        MEDIAN(FILTER(arr, IFS(c=1, arr<=cq, c=4, arr>pq, TRUE, (arr>pq)*(arr<=cq))))))),
    VSTACK(a, m)))), 1)

Adjust the table name and/or column names as needed.

Calculate Median by Quartile

EDIT: A couple of tweaks to the above-mentioned formula...

• Use TOCOL(UNIQUE(tblData[Sex]), 1) to ignore blanks
• Remove the SORT function (not needed)

The formula can also be written as a single-cell report, complete with headers and row labels:

=LET(
    arr, TOCOL(UNIQUE(tblData[Sex]), 1),
    HSTACK(
        VSTACK("Median", arr),
        REDUCE("Q"&UNICHAR(SEQUENCE(1, 4, 8321)), arr, LAMBDA(p,v, LET(
            a, FILTER(tblData[Payment], tblData[Sex]=v),
            m, MAKEARRAY(1, 4, LAMBDA(r,c, LET(
                pq, QUARTILE.INC(a, c-1),
                cq, QUARTILE.INC(a, c),
                MEDIAN(FILTER(a, IFS(c=1, a<=cq, c=4, a>pq, TRUE, (a>pq)*(a<=cq))))))),
            VSTACK(p, m)))
        )
    )
)

Please see the attached workbook...