Custom functions

To aid in resource planning for the emergency department, you've been tasked with computing an adjusted visit total based on the assigned ESI triage score. This is to account for the fact that visits with ESI of 1 require much more resources than a visit with ESI score of 5.

After consulting the team, you've determined the necessary transformation to take the square root of 4 divided by the ESI score.

Scaled ESI Score = √(4/ESI score)

Your task is to create a new custom function to compute this transformation and add a new column with scaled ESI scores.

If you lost progress, load the workbook 3_4_custom_functions.xlsx from the Workbooks folder and launch the Power Query editor.