Skip to Content
0
Former Member
Nov 17, 2008 at 09:13 AM

Regression Analysis using the APD

45 Views

Hello,

Currently I am working for an internal client who is interested in linear regression analysis.

I have created a query that delivers records with the actual costs for placing power cables and the kilometres of placed kable. My client wants to receive the linear regression formula based on this query in the form of Y = Ax + B. I have to estimate A and B.

I have tried to use the APD to do this, since i want to be able to schedule the calculation.

I have discovered that I can create a mining model for scoring and then train the model. After traing the model the values for A and B can be found in the table RSDMESC_NET_SCOR. There are some disadvantages to this method. For everytime I want to calculate the parameters i have to reset the model and train it again. Furthermore I would like to save the values to a dataprovider so I can use them furtheron. I am not interested in using the model for predictions.

Does anybody have any suggestions how to automate the process of regression analysis with the sole purpose of presenting the model?

Thanks in advance,

Guido