Standard Deviation Formula

HCL Domino Domino Forum
1

Does anyone know if there is a formula that calculates Standard Deviation or has anyone created one in Lotus Notes before?? Thank you!

2

Subject: it depends

If you’re OK with LotusScript, have a look at this link:Software applications news, help and research - WhatIs

If not, I’ll have a think. Should be do-able, I reckon.

Phil

3

Subject: Standard Deviation formula

Thanks Phil for the quick response. It looks like you’ve given me a couple of good options. I’ll see what I can do! Much appreciation - j d

4

Subject: and here’s the formula

This formula is for if you have a multi-value number field called “input”, and a number field called “output”. It takes advantage of how good formula language is at working with lists.

count := @Count(input);

sum := @Sum(input);

mean := sum/count;

meanlist := @TextToNumber(@Repeat(@Text(mean) + “:”; count));

vars := input - meanlist;

squarevar := vars * vars;

squaresum := @Sum(squarevar);

squaremean := squaresum/count;

stDev := @Sqrt(squaremean);

@SetField(“output”; stDev)

Hope this helps,

Phil