0 Replies Latest reply: Jun 15, 2017 8:26 AM by benjamin raquin

# Distribution and frequency table in Qlik sense

Hello,

I have a problem with a distribution and analysis of frequency in Qlik Sense.

First here is an example of my data,

StudentModuleNote
AX8
AY9
AZ10
BY11
BZ8
CV9
CW15
CX14
CY17
CZ12.5

With that table I try to do several things:

1) Create an histogram with the distribution of the average for each student

2) Implement the distribution curve, For now I use the following function for the distribution of the grades but I cannot find the solution for the average per student

Only(Normdist(Round(

Note

,BinWidth),round(Avg(total

Note

)),round(Stdev(total

Note

)), 0))*BinWidth*Count(total

Note

)

With BinWidth = 1

3) the last step is to publish the frequency table with the number of exam passed as an entry.

The result should be as followed:

Number of exam passedFrenquencyCumul freq% Cumul %
1000%0%
21133%33%
31233%66%
4020%66%
51333%100%

The last line (first column) should equal the max number of exam passed and results without observations should be integrated as well (for example 4)