I have a problem with a distribution and analysis of frequency in Qlik Sense.
First here is an example of my data,
Student
Module
Note
A
X
8
A
Y
9
A
Z
10
B
Y
11
B
Z
8
C
V
9
C
W
15
C
X
14
C
Y
17
C
Z
12.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 passed
Frenquency
Cumul freq
%
Cumul %
1
0
0
0%
0%
2
1
1
33%
33%
3
1
2
33%
66%
4
0
2
0%
66%
5
1
3
33%
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)
