I missed your comment because it probably overlapped with my answer
A few comments :
- we need to apply stepwise regression or lasso regression ...
None of these methods exists in Maple.
I wrote a piece of code over a decade ago that does ridge regression (another possibility), I'll dig around and see if I can get my hands on it (actually, I'm fed up with implementing algorithms in Maple and prefer using R directly).
- If no such model comes with two or three regressor variables even are certain number of number of run
I supposed you consider only polynomial models of degree 1 (at most) in all regressors?
Is the model y=x1+x1^2+x1*x2 a two regressors model for you?
For information the best 3-regressors model is the 4th one (ranked in increasing values of the Akaike criterion) and has regressors [X3, X6, X9]
- Step 4
There is no difficulties at all to ExcelTools:-Export the data nor to generate drawings.
Subsidiary question: do you use any data analysis software (beyond the Excel statistics package maybe)?
If not, would you be interested in the results that R would provide on your data?
I made a huge mistake: I didn't see the response (Y) was in first column andI imagined that it was in rightmost one.
The correction is easy
XY := Data[2..-1]:
N, P := LinearAlgebra:-Dimensions(XY):
P := P-1:
XY := XY[.., [$2..P+1, 1]]: # add this line to put Y in rightmost column
Train_fraction := 0.7:
Here is the corrected file (you will see that Akaike criterion doesn't seem well suited here, chich probably pleads for the use of something more reliable.