Calculate the slope of a Deming regression in Spotfire?

[Luke Shepherd]

I'm performing some modelling and have 6 columns (3 in X (x1,x2,x3), 3 in Y (y1,y2,y3)) each with thousands of rows. For each row I want to calculate the slope of the Deming regression of the X and Y values and output it to a new column.

I'm brand new to Python/R - wanting to start to pick it up but I need to solve this problem a little sooner than I will be able to myself.

[Julieta Diaz]

Hi Luke,

You can create a TERR data function in Spotfire and use the mcr package to perform the Demin regression.

• Here is the documentation about how to register a data function in Spotfire
• And here you can find an example of how to use the mcr package

Hope this is helpful.

Best regards,

[Luke Shepherd]

Thanks for the information Julieta, I'm struggling to understand how to combine this together with the 6 columns I have, and what is going on in the code. I haven't worked with R before so putting together a working script is difficult.

[Alain Martens]

Hi Luke,

I'm happy to help you with this. Would you be available for a zoom/teams call? In that case I can assist you.

Please let me what time works for you. P.S. I'm on CEST timezone (based in The Netherlands).

Thanks,

Alain

[Luke Shepherd]

Thank you for the offer Alain, however as its on my work laptop I don't think I'm allowed to make such external calls.

Thanks,

Luke

[Alain Martens]

Hi Luke,

I have plenty of calls with your ASML colleagues from their work laptop as I often offer support like this.

Let me know if that changes things.

Thanks,

Alain

[Alain Martens]

Hi Luke,

Do you perhaps have an update on this?

Happy to help you with this.

Thanks,

Alain