topic Bell chart / normal distribution in QlikView

Bell chart / normal distribution

Tue, 17 Nov 2009 18:42:04 GMT

We were discussing the possibility to do a bell chart in QlikView. I am fairly sure you can but my lack of knowledge about QlikView combined with my lack of mathematics renders me short in the task.

Anyone here with a easy to grasp example of a chart for normal distribution?

Need a base example?

A class of 21 students have a test. Each student can get between 1 and 100 points in the test.
StudentA, 60
StudentB, 60
StudentC, 60
StudentD, 60
StudentE, 60
StudentF, 10
StudentG, 40
StudentH, 50
StudentI, 50
StudentJ, 50
StudentK, 50
StudentL, 95
StudentM, 95
StudentN, 98
StudentO, 40
StudentP, 70
StudentQ, 70
StudentR, 80
StudentS, 80
StudentT, 70
StudentU, 30

The X axis will be the point groups and the Y axis is the number of students in the point group.

Bell chart / normal distribution

prieper — Fri, 20 Nov 2009 03:18:24 GMT

Would it be something like the attached?

HTH
Peter

Bell chart / normal distribution

Tue, 24 Nov 2009 15:51:27 GMT

looks really good, problem is that it's based on a good example.

I have 60000 points in my table and close to none of them are the same this renders to me that I have to do some clustering of the points (in steps of hundreds for example) and then show the number of hits for that cluster.