Do The Statistical Calculation InfoPath

[anuarna]

Hi, I'm completely new to Infopath so I wish to get somebody help to assist me to solve my problem regarding MS InfoPath functions that I can use to do statistical calculation automatically.
Let say
I have the following repeating table (gp_qualification_data) as per below

Result 1 Result 2 Result Range
X A X-A
Y B Y-B
Z C Z-C

Average


Then, my problem is
1. What functions or method/suggestion that i can use to compute the following [Std Deviation] and [Repeatibility] of Result Range?

2. How to compute the [Status] field automatically base on [Repeatibility] field when the value less than 5?

3. How can i do to eliminate the negative values of [Result_Range]?



Thanks