Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
Standard Deviation and Median on Summary Columns
I would like Standard Deviation and Median choices on Summary Columns for different calculations.

Blake Cabot

Blake Cabot
Date Created
4/9/2013 3:36:05 PM
Date Updated
8/21/2015 10:28:39 AM
In Development
Promoted By
Scott MillerGii SystemsRick Cogley
Blake CabotPhilipp Matuschkabasenine
Sam Parish
Sam Parish 8/3/2012 6:55:31 AM
For years I've been avoiding this, but now have the regular need for standard deviation functionality in our civil engineering reports. Doing a side table in excel is a waste of time (and wouldn't be necessary if this existed). I'm sure the business folk probably could use it from time to time as well... It makes your reports real legit too. Anybody else?
basenine 8/3/2012 7:05:00 AM
Definitely - great for comparison reports.
These graphs are a must for Educational Institutions too - for some reason, they love them!

At the moment I'm manipulating data using a third party web service... works ok but brings up security risks and attentions within the page
Evgen Goncharov  Staff  4/10/2013 9:47:46 AM
@Blake, can you provide some real-life example(s) of possible "Standard Deviation" and/or "Median" usage.
Slava Shinderov  Staff  4/10/2013 10:14:48 AM
Merged with:
545 - Standard Deviation
Slava Shinderov  Staff  4/11/2013 9:19:36 AM
We've added following aggregate functions:

* Standard Deviation
* Population Standard Deviation
* Variance
* Population Variance
Rick Cogley 4/15/2013 1:28:09 AM
Thank you.
Blake Cabot 3/20/2015 7:32:26 AM
Is Median in development?
Scott Miller 8/21/2015 9:40:56 AM
Hi Evgen

You asked for an example of Median. I am calculating Mileage Rates which change once a certain threshold is reached. The formula in excel is:-

=[Miles]*[Below Threshold Rate]-MEDIAN(0,[Miles],[Running Mileage Total]-[Mileage Threshold])*([Below Threshold Rate]-[Above Threshold Rate])

Slava Shinderov  Staff  8/21/2015 10:28:39 AM
@Scott please try following formula for calculating median of 3 numbers:

(n1 + n2 + n3) - min(n1, n2, n3) - max(n1, n2, n3)

Back to Search Results