David Jones 5 Posted July 10, 2019 Share Posted July 10, 2019 I only see one Standard Deviation function, and it's for Sample Standard Deviation. Am I (hopefully) missing something simple, and there is a function for population standard deviation Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted July 11, 2019 Share Posted July 11, 2019 You can use the below-given customexpression in a calculated column to get the Population Standard Deviation. Sqrt(Sum(([Measure] - Avg([Measure])) ^ 2) / Count([Measure])) Link to comment Share on other sites More sharing options...
David Jones 5 Posted July 11, 2019 Author Share Posted July 11, 2019 Yes, I'm currently using that expression as a makeshift way to get what I want. Problem is I can't quite get that to work in box plots or some other visualizations. I was hoping there was a built in SD.P funciton. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now