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]

Recently wrote a document on Standard deviation... this might help

Standard Deviation (Population vs. Sample)

[bhavvibudagam]

Hi Sunny,

I have tried below Two expressions:

=Stdev(aggr(sum(Frequency),Month))

Stdev(TOTAL <Month> Frequency)

But these are not working. Getting NULL.

Please help me on this. Please let me know How to calculate the Mean also.

I am new to these topics.

Thanks in advance.

[sunny_talwar]

Try this

RangeStdev(Above(Sum(Frequency), 0, RowNo()))

[bhavvibudagam]

Hi Sunny,

Thanks for your reply.

The above expression is not working Showing null.

[sunny_talwar]

Would you be able to share your qvf file?

[pradosh_thakur]

RangeStdev(Above( total Sum(Frequency), 0, RowNo(total)))

or

RangeStdev(Above( Sum(Frequency), 0, RowNo(total)))

[sunny_talwar]

Please find attached the whole thing

[bhavvibudagam]

Thank you so much sunny

Mean is not in the app

Mean                                    

N/A                                               

=SUM(I9:I10)/2                         

=SUM(I9:I11)/3                         

=SUM(I9:I12)/4  

How to get this mean from frequency fields

[sunny_talwar]

Isn't this the mean?