on 09-19-2021 9:44 AM
I am new to HANA, and was trying to write a SQL for finding standard deviation: select stddev(values) as stddev For example, the values are 6.8,10.2 and 3.4. When I am executing it in HANA, I am getting result as 3.39999. But when I try to calculate it manually, or by excel, it shows 3.4.
Similarly, for different example, I get 5.1999 in HANA, but in excel/manual check it shows 5.2.
What can be the reason/fix for this?
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.