How to calculate variance in excel without using loop

hi!
i am trying to calculate variance in excel sheet but i have no idea, how to calculate variance without using loop? so, Please any help would be appreciated

thanks
Kaavya

Hi

We can try in same way using write cell like

Instead of countIF here use a var function

Cheers @kaavya

1 Like

thanks for your reply @Palaniyappan, but can you please explain in detail?

Fine
May I know how you usually find the variance MANUALLY for your data

So that I can tell you the steps for UiPath
@kaavya

1 Like

@Palaniyappan ,for example, i have to get variance from columns (F - T) and the answer will be stored in U column and the count of the row is dynamic, so in such case, how should be performed without loop?

sure!,=A2-B2, this is how manually we calculate @Palaniyappan

Hi

Which function you are looking for
VAR, VAR.S, VARP, VAR.P

And did we try with write cell activity where you can mention the formula as input, between double quotes the one you use in manual approach
And mention the cell position also like where this formula has to be entered in your excel

@kaavya

1 Like

thank you @Palaniyappan

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.