Statistically significantly higher than average

Dear Colleagues,

I've the following data table:

Group	Case	Variable 1	Variable 2	Variable 3	...
Group A	C0001	545646	56465456	3	...
Group A	C0002	878946	5645465456	13	...
Group A	C0003	456456	2123	321231	...
Group B	C0004	545646	131321	54564	...
Group B	C0005	5656	1311	564	...
...	...	...	...	...	...

I need to make the following statements about each case:

• Given case is statistically significantly higher than average
• Given case is statistically significantly lower than average
• Given case is not statistically significantly different from the average

I have to merge the statements in one table that will be dynamically colour coded depending on the selected group. I have defined a number of dynamic offset formulas:

• case_value - returns value for each case from the table depending on case number and variable number
• group_values - return the values for the whole (Group A, B, etc.) depending on the selected variable
• variable_value - returns the variable values for whole column depending on the selected variables

What I presently need is to develop a formula that will take value 1 for cases that are statistically significantly higher than average, 2 for cases that are statistically significantly lower than average and 0 for cases that are not not statistically significantly different from the average. I have no problem with devising additional lookup and offsets formulas that will pull required strings of data from the data table. What I would like to know is how I get from numerical data to underlined logic formula that will return the value depending on the characteristics of statistical significance. I came across this helpful page, but unfortunately, it's not enough for me. Needles to say, I will appreciate any help!