I have a problem with a distribution and analysis of frequency in Qlik Sense.
First here is an example of my data,
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
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 %|
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)
Thanks in advance