Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check this out