Forum Discussion

nehajadhav166's avatar
nehajadhav166
Resolver I
3 years ago
Solved

Stdev.s giving incorrect value

Hi Experts,   In my Cpk calculation, I see STDEV.S is giving incorrect value. Data set I have as below -11.67 -11.71 -11.67 -11.67 -11.69 -11.65 -11.68 -11.67 -11.63 ...
Need Help
  • nehajadhav166's avatar
    nehajadhav166
    3 years ago

    v-jianboli-msft ,

     

    Issue is resolved now. There was data discrepency when I am loading data using M query. I removed some colunms and removed duplicate values. Now its working fine.

    There is no issue with STDEV.S and STDEV.P calculation in power BI.

     

    Thanks,

    Neha

nehajadhav166's avatar
nehajadhav166
Resolver I
3 years ago

Greg_Deckler ,

 

This is strange.I use below formula.

CpkLoop =
VAR sigma = STDEV.S(RFLoopback[Value])
VAR estimatedMean = AVERAGE(RFLoopback[Value])
VAR Cplower = (estimatedMean-MIN(RFLoopback[LSL]))/(3*sigma)
VAR Cpupper = (MAX(RFLoopback[USL])-estimatedMean)/(3*sigma)
RETURN IFERROR(MIN(Cplower,Cpupper),1e6)
 
Still STDEV.S give me 0.0281.
Any idea what could be the issue?
 
Thanks,
Neha