🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Is it possible to find the square root of a number using the calculator tool?

Bracha Tenenbaum asked on March 15, 2020

I need to normalize scores from a report. In order to do so, I need to calculate the standard deviation, which requires the square root function typically available on most calculators. Is it possible to do this sort of math in flex monster? 

Thank you,

1 answer

Vera Didenko Vera Didenko Flexmonster March 16, 2020

Hello, Bracha,
Thank you for writing to us.
1. Yes, it is possible to find the square root of a number using Flexmonster’s calculator tool.
The square root can be calculated using a fractional exponent, for example:

9 ^ 0.5 // Result: 3

Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/07a25oqz/
For more information about calculated values please see our guide.
2. Also, please notice that Flexmonster provides standard deviation aggregations: Population Standard Deviation and Sample Standard Deviation.
Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/m9txdLg4/
Please let us know if this works fine for you.
Looking forward to your response.
Kind regards.

Please login or Register to Submit Answer