Hi All,
I want to achieve standard deviation as per Business requirement. So that I want to first calculate rangesum for the value given with Product Category, Customer Name, Alloy, Temper, Gauge, Tage Name, Date and Monthname.
Rangesum = SUM(fabs(difference of upper value to Lower value))
Standard Deviation Business Formula = (Rangesum/(range_count-1))/1.128)
e.g.
| Row No | Value | Range |
| 1 | 0.65 | | |
| 2 | 0.72 | 0.07 | |
| 3 | 0.32 | 0.4 | |
| 4 | 0.89 | 0.57 | |
| 5 | 0.76 | 0.13 | |
| | 1.17 | Rangesum |
| | 5 | Range_count |
Subtract row no 1 - row no 2, row no 2 - row no 3 and so on to achieve rangesum i.e 1.17 in above image.
I have attached excel sheet for data value and screenshot of selection that I made.
As per my selection, rangesum will be 0.018 and standard deviation will 0.0080.
Please suggest backend or frontend logic for the same asap.
