Forum Discussion

nehajadhav166's avatar
nehajadhav166
Icon for Resolver I rankResolver 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
    Icon for Resolver I rankResolver 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