Forum Discussion

netanel's avatar
netanel
Post Prodigy
4 years ago

Standard Deviation

Hey All!

 

I want to bring my economists analysis of "Standard Deviation"
I have 2 Measure

 

The daily average:  

[Gross USD AVG] 
 

and I have Standard Deviation Measure:

Standard Deviation = STDEVX.P(
        VALUES('Date'[Date] ),
        [Gross USD AVG]   )


The problem is I do not know how to look at it in relation to the average
Is it possible to make it 1 and -1 to understand where the company is in relation to the bell?

 

 

Need Help

2 Replies

    • netanel's avatar
      netanel
      Post Prodigy
      4 years ago

      Hey Anonymous 

       

      Your'e right!
      I wrote in a not so clear way
      Things have changed a bit
      But the story is like that and the question is more statistical
      I show the users a standard deviation that is a Simple number? A standard deviation of a particular company is 126,200. Is it correct to show this?
      I received feedback from the user that it is difficult to understand when there are several companies and each has a different standard deviation (I know that when the larger the standard deviation is the AVG not stable) but for the user it is not clear
      I wanted to know if there is a formula that can put all the standard stays in an area of (-1,1, -2,2, -3,3) as long as the user gets the area where his average is clearly

       

      https://en.wikipedia.org/wiki/Standard_deviation

       

      You can look at the link for the areas marked by numbers -1,1 and more

       

      Thanks!