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)
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.