Is there a way to use standard deviation in calculations? I.e., is there a standard deviation formula, or as a roll-up aggregator?
Use case: I have multiple users reviewing applications and rating the apps within a rubric. Multiple people are reviewing each application. Using Zapier, I have the scores from the reviewers automatically loading into an “AppReads” table, with one row per app/reviewer instance. Because of the number of reviewers, I need to normalize the scores by reviewer - I need a t-score. So, I have a reviewer table that is linked to the AppReads table. Using rollups I can easily calculate the mean by reviewer. In order to calculate t-scores, though, I need the SD.
Could this be added as an rollup function? Or is there a work around I’m not seeing?
(I know that the Summary bar include standard deviation as an option, but I can’t figure out how to use that in calculations.)