Forum Discussion
mkulikowski
Helper I
Helper INormal Distribution with ranges (bloody topic)
Hey folks, I need some help with calculation of total weight of carcasses of chickens based on this matrix table. For this I need to use normal distribution so let's say for 1000 birds each of t...
mkulikowskiHelper I
Helper IHey -
yes - eventually this is my measure which is working. I am only struggling with some birds are 'missing' when distributed over the ranges as per the screenshot:
Probability Measure Adjusted 3 =
VAR TotalChickens = [IloscZywca] -- total number of chickens
VAR MeanWeight = MAX('Matrix'[true_mean]) -- mean weight across dataset
VAR StdDevWeight = SD[SD Value] -- standard deviation value
VAR TotalProbability =
SUMX(
'Matrix',
VAR RangeStart = 'Matrix'[waga_min]
VAR RangeEnd = 'Matrix'[waga_max]
VAR CumulativeProbabilityStart = NORM.S.DIST((RangeStart - MeanWeight) / StdDevWeight, TRUE)
VAR CumulativeProbabilityEnd = NORM.S.DIST((RangeEnd - MeanWeight) / StdDevWeight, TRUE)
VAR ProbabilityInRange = CumulativeProbabilityEnd - CumulativeProbabilityStart
RETURN
ProbabilityInRange
)
RETURN
round(TotalProbability * TotalChickens, 0)
I have a slicer to input number of birds and standard deviation
lbendlin
Super User
Super UserProbably the hawk got them. I meant to say, probably rounding errors or insufficient statistical significance.