Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Standard Deviation of multiple values same dates

Hi Experts

 

See attached sample data. I am trying to work out the std dev - the value in the card in the sample file is wrong ANSWER is 2.1%

I need to workout the Std dev of the data in the table..

 

Sample file.

https://www.dropbox.com/s/pnl9cvjp0tm3xkg/standard%20deviation.pbix?dl=0 

Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    I see what you are doing now.  This measure will give you the standard deviation of the sum of net amt for each Date.  This version give 1.5%.  The .S version gives 2.1%.

     

    Standard Deviation =
    STDEVX.P (
        DISTINCT ( 'STD Dev'[Date] ),
        CALCULATE ( SUM ( 'STD Dev'[Net Amt %] ) )
    )

     

    Pat

     

4 Replies

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    How did you calculate 2.1% for this data set?  3.65% looks correct.

     

    Pat

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      in excel i have = Stdevpa(040:o41) where the i have 37%,34% in column A cell A1,A2 and this give me 1.6% APOLOGIES. should be 1.6%.

      • mahoneypat's avatar
        mahoneypat
        Icon for Microsoft Employee rankMicrosoft Employee
        5 years ago

        I see what you are doing now.  This measure will give you the standard deviation of the sum of net amt for each Date.  This version give 1.5%.  The .S version gives 2.1%.

         

        Standard Deviation =
        STDEVX.P (
            DISTINCT ( 'STD Dev'[Date] ),
            CALCULATE ( SUM ( 'STD Dev'[Net Amt %] ) )
        )

         

        Pat