row by row multiplication problem

I want to compare the average data in table1 with a new derived field in table2, which is calculated by subtracting 3 times the Sigma value (Avg - 3xSigma). None of the currently used methods can achieve this.

Initially, I used Table Transposer to transpose the data, aiming to apply a mathematical formula to the transposed fields. However, since the field type became “?” after transposition, it was impossible to perform calculations.

Is there a better way to compute values between columns?

Thank you.

table1:

table2:

If anyone knows I’d be really grateful as this has stuck with me for a long time