Hi, i have a problem to solve, which i can’t figure it out myself.
It’s about to adding frequency to Distribution Curve.
I have created Distribution from this tutorial:
using the same measures for Avg and Standard DEV…
X-3a = [Avg Value EtOH] - 3*[Standard DEV]
X+3a = [Avg Value EtOH] + 3*[Standard DEV]
Normal distribution (x) = GENERATESERIES( FLOOR( [X-3a], 1 ), CEILING( [X+3a], 1 ), 1)
z = (‘Normal distribution’[x] - [Avg Value EtOH] / [Standard DEV])
f(x) = EXP(SUMX(VALUES(‘Normal distribution’[x]), ([x] - [Avg Value EtOH])^2 / (2 * [Standard DEV]^2) * -1)) / (SQRT(2 * PI()) * [Standard DEV])
It works correctly, but to have clear view i need to add the frequence.
Problem is that i can’t connect Normal distribution table with results table.
I tried to prepare mapping to connect normal distribution x with mapping column but results are different in normal distribution values are from -13 to 16 and in mapping column:
mapping = ROUND([Avg Value EtOH] - 3 * [Standard DEV], 0)
but values are from 0 to 69
I also tried with calendar function as in tutorial but it’s the same.
Do you have any ideas how i can connect data or count frequency in this case?