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

    Distribution and frequency table in Qlik sense

    benjamin raquin

      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)

       

      Thanks in advance