how to calculate Mean and Standard Deviation in Qlik

[pawwy1415]

Hi,

We have to calculate Mean and Standard Deviation in Qlik as it's in attached screenshot (Column K is Mean and Column L is standard Deviation)..

Could someone HELP HOW TO REPLICATE THIS IN QLIK?

Mean formaula >>

EXPRESSION USED IN K10

=SUM(I9:I10)/2   

K11

=SUM(I9:I11)/3

K12

=SUM(I9:I12)/4

so on

EXPRESSION USED IN L10

=STDEV.P(I9:I10)

L11

=STDEV.P(I9:I11)

L12

=STDEV.P(I9:I12)

so on...

EXPRESSION USED IN  M10

=(I11-K11)/L10

M11

=(I11-K11)/L11

M11

=(I11-K11)/L12

[sunny_talwar · Accepted solution]

Have you seen this?

How to calculate Mean from Frequency field

[pawwy1415]

Hi Sunny,

Thank you so much. All your expressions worked fine.. Could you please look last column M as well?

EXPRESSION USED IN  M10

=(I11-K11)/L10

M11

=(I11-K11)/L11

M11

=(I11-K11)/L12

Regards,

PK

[sunny_talwar]

Check here

=(Column(2)-Column(4))/Column(5) is not working in the table‌

Is this some kind of interview question?