How to calculate Mean from Frequency field

[bhavvibudagam]

Hi Experts,

Can any one please help me on below requirement to calculate Mean and Standard Deviations in the attached excel.

Here the Mean is calculated from the Frequency field and aggregated by month like

Mean                                        Standard Deviation

N/A                                             N/A        

=SUM(I9:I10)/2                           = STDEV.P(I9:I10)

=SUM(I9:I11)/3                           = STDEV.P(I9:I11)

=SUM(I9:I12)/4                          = STDEV.P(I9:I12)

How to calculate these Excel calculations in Qlik. Please help me on this.

Thanks in advance

[sunny_talwar · Accepted solution]

Check this out