I would like Standard Deviation and Median choices on Summary Columns for different calculations.
thanks, Blake Cabot
Date Created 4/9/2013 3:36:05 PM
Date Updated 8/21/2015 10:28:39 AM
Status In Development
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
Blake Cabot 3/20/2015 7:32:26 AM
Is Median in development?
Scott Miller 8/21/2015 9:40:56 AM
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:-