Linear Regression Tool: Data Extraction
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello
I am using the Linear Regression tool and am wondering if there is a way/solution to extract the predicted data points (as seen in the model performance chart below) in a consolidated output rather than going point by point and extracting manually?
Ideally the solution would be able to align the actual values against the predicted values in side by side columns.
Solved! Go to Solution.
- Labels:
- Predictive Analysis
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @JK15 ,
The values you can see in the Model Performance tab of the Interactive output anchor are essentially the values you would get if you apply the predictive model you have created with the Linear Regression tool to the dataset you've used to train that model.
To get this output, all you have to do is use a Score tool, connect the O output anchor of the Liner Regression tool to the M input anchor of the Score tool and create a connection between the dataset you used to train your model to the D input anchor of the score tool.
I used the sample Alteryx workflows to mock up an example for you. What I described above is essentially this:
In the Interface output, I have displayed two data points as displayed below
which you can identify in the score tool output
However, be worry of model bias when using the training dataset to make predictions; obviously the model will appear to be performing better when the values it's called to predict are those used to train it.
Hope that helps,
Angelos
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you!! This worked great
