Forum Discussion
Standard Deviation Part 2
Hi Expert here is the link to the fist part of the question which an expert Ash solved and provideed excellent feedback. https://community.powerbi.com/t5/Desktop/Standard-deviation-of-a-calcula...
Hi,
Does this mesure work?
=1.96*[Revised]/(DISTINCTCOUNT([HP Outome Type])^(1/2))
Revised is the measure which returns 6.5 in the last column. HP Outome Type is a column.
Hi Ash
the x bar is the upper and lower limits of the total std dev so for "Revised" the Std Dev is 6.5, its the upper and lower bands for that.. n 1s the total observations in this case 12977.
and its not caclulated for each yr. many thanks once again.
Hi,
Does this mesure work?
=1.96*[Revised]/(DISTINCTCOUNT([HP Outome Type])^(1/2))
Revised is the measure which returns 6.5 in the last column. HP Outome Type is a column.
hi Ash, let me test and come back to you.