
Re: Distribution normal
Stefan Wühl Nov 10, 2013 7:14 PM (in response to Iñigo Elviro Bodoy)That's because your xaxis is not continuous. Have a close look to the intervals shown at the axis, you'll notice that some intermediate intervals are missing (e.g.118  118.5).
If you use a continuous axis on axis tab, the curve should look much more as you expect it.

Re: Distribution normal
Clever Anjos Nov 14, 2013 3:08 PM (in response to Iñigo Elviro Bodoy)Using swuehl recomendation

419565.qvw 151.0 K

Re: Distribution normal
Iñigo Elviro Bodoy Nov 15, 2013 5:00 PM (in response to Clever Anjos )Hi Clever:
But I am usign Persoanl Edition, therefore I can not open the file.
Could you explain what is your solution with formuls?
Thanks in advance

Re: Re: Distribution normal
Clever Anjos Nov 15, 2013 6:43 PM (in response to Iñigo Elviro Bodoy)I´ve used an expression (and marked as Line/Smooth)
normdist( (floor(Min([Net Weight Roll Control (gr)]),0.5)+Ceil(Min([Net Weight Roll Control (gr)]),0.5))/2,
avg({1} total {<[Net Weight Roll Control (gr)]={">0"}>} [Net Weight Roll Control (gr)]),
stdev({1} total {<[Net Weight Roll Control (gr)]={">0"}>} [Net Weight Roll Control (gr)]),0)
I marked "continuous" into Axes Tab

Re: Distribution normal
Clever Anjos Nov 15, 2013 9:00 PM (in response to Clever Anjos )normdist( Count({<[Net Weight Roll Control (gr)]={">0"}>}[Net Weight Roll Control (gr)]),
avg({1} total {<[Net Weight Roll Control (gr)]={">0"}>} [Net Weight Roll Control (gr)]),
stdev({1} total {<[Net Weight Roll Control (gr)]={">0"}>} [Net Weight Roll Control (gr)]),0)
gives almost the same curve


Re: Re: Distribution normal
Stefan Wühl Nov 16, 2013 10:18 AM (in response to Iñigo Elviro Bodoy)I think you won't necessarily get a perfect symmetric curve because you are using discrete sampling points.
You can get a smoother, more symmetric curve if you create additional dimension values so your line curve gets calculated for more sampling points:
// Script to read your data and create a complete range of dimension values (adapt 115 start value and 20 sampling
// points to your range
LOAD class(115+recno()/2,0.5) as Class
AutoGenerate 20;
LOAD [Net Weight Roll Control (gr)],
class([Net Weight Roll Control (gr)],0.5) as Class
FROM
[Net Values Weight.xlsx]
(ooxml, embedded labels, table is Sheet1);
Then use a dimension Class and as expression for the line
=normdist( Class,
avg({1} total {<[Net Weight Roll Control (gr)]={">0"}>} [Net Weight Roll Control (gr)]),
stdev({1} total {<[Net Weight Roll Control (gr)]={">0"}>} [Net Weight Roll Control (gr)]),0)

comm98523.qvw 154.2 K





