Hello,
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)
Thanks in advance
