How to calculate variance in excel without using loop

Help Studio
, ,
1

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

2

Hi

We can try in same way using write cell like
excel_formula

Instead of countIF here use a var function

Cheers @kaavya

1 Like
3

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

4

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
5

@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?

6

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

7

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
8

thank you @Palaniyappan

9

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