Skip to content

Instantly share code, notes, and snippets.

@derickson

derickson/stddev.js

Created March 11, 2014 14:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save derickson/9486939 to your computer and use it in GitHub Desktop.
Save derickson/9486939 to your computer and use it in GitHub Desktop.
Download ZIP
standard deviation MongoDB aggregation pipline using method from http://en.wikipedia.org/wiki/Standard_deviation#Rapid_calculation_methods
Raw
stddev.js
// standard deviation MongoDB aggregation pipline
// using method from http://en.wikipedia.org/wiki/Standard_deviation#Rapid_calculation_methods
var parts = db.stat.aggregate( { $group: { _id: null,
s0: {$sum:1},
s1:{$sum:"$stat"},
s2:{$sum:{$multiply:["$stat","$stat"]}} }} ).result[0];
var stddev = Math.sqrt( parts.s0 * parts.s2 - Math.pow( parts.s1, 2) ) / parts.s0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment