Sum of squares calculation

Question

Hi guys, 
 
 I'm trying to implement a sum of squares equation using OpenLab V2.5 Inteligent Reporting. Currently this will be calculated using statistics in Excel using the SUMXMY2 function. We wanted to calculate sum of squares per analytical over calibration curve varying 5 - 8 standards. 
 I've already found this equation, but it's hard to use the Exp function. 
 but 
 Kind regards, 
 
 Peter

Andy Wright · Accepted Answer

I assume you have calculated a variable XBar to use in your equation. You can then calculate (XValue - XBar)^2 saving that as an aggregator variable (maybe with a suitable key) and then display the Sum() of the aggregator in a table that shows the other values. 
 /Andy

Sum of squares calculation

Top Replies