2.8 Calculate median
Calculate the median salary of all employees based on the following employee salary table.
| ID | NAME | SALARY |
|---|---|---|
| 1 | Rebecca | 7000 |
| 2 | Ashley | 11000 |
| 3 | Rachel | 9000 |
| 4 | Emily | 7000 |
| 5 | Ashley | 16000 |
| … | … | … |
SPL script:
| A | |
|---|---|
| 1 | =T(“salary.xlsx”) |
| 2 | =A1.median(,SALARY) |
A2 Calculate median salary of all employees.
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_SPL
SPL Learning Material 👉 https://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProc_SPL
