Help with regression formula / sum reals

[paulusB]

Hello,

I am looking for some help to build a linear regression formula (https://en.wikipedia.org/wiki/Simple_linear_regression).

The scope is to write a function block with a variable "n". The measured "y" will be a real value. The "n" can be 5, 10, 20 or 40. In Excel I have the formula working and made function block without a variable n. I just sum the totals and do the calculations

Looking for a way to easy sum the results for different "n". Not much experience with structured text. Please advice.

200727 - Regression_Test_V1.0.cxp

200727 - Regression_Test_V1.0.opt

200727 - Regression_Test_V1.0.bak

200727 - regression - v1.0.xlsx