AnsweredAssumed Answered

STDev - Standard Deviation

Question asked by DivyashPatel on Aug 8, 2011
Latest reply on Aug 9, 2011 by DivyashPatel

Title

STDev - Standard Deviation

Post

Hello,

I would like to calcualte standard deviation for a field across 3 records. I would like to calculate based on the following:

FieldA - number

FieldB - Name

FieldC - Stdev for FieldA in found set. Found set is by FieldB.

 

Record 1 = FieldA = 10, FieldB = Sample1

Record 2 = FieldA = 12, FieldB = Sample1

Record 3 = FieldA = 14, FieldB = Sample1

STDev should be for 3 records found by Sample1.

Record 4 = FieldA = 10, FieldB = Sample2

Record 5 = FieldA = 12, FieldB = Sample2

Record 6 = FieldA = 14, FieldB = Sample2

STDev should be for 3 records found by Sample2.

I would like to get the Standard Deviation for FieldA across the 3 records based on FieldB data. Each set of records based on FieldB should have a STDev. How would I calculate this or create the appropriate fields?

Thank you in advance.

D

Outcomes