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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

nehajadhav166 How is CPK being calculated? Your formula. If I use STDEV.S I get back 0.0297 whereas STDEV.P returns 0.02831. So use STDEV.S?

nehajadhav166's avatar
nehajadhav166
Resolver I
3 years ago

Greg_Deckler , yes I am using STDEV.S.

How did you calculate? in power BI?

 

Thanks,

Neha