This article is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the Logistic Regression Tool on our way to mastering the Alteryx Designer:
As many of you know, Logistic regression can be applied to a variable with two possible outcomes. It creates a model that relates a binary target variable (such as a 0/1 or Yes/No) to one or more predictor variables and obtains the estimated probability for each of the two possible outcomes. Logistic Regression is different from other types of regression because it creates predictions within a range of 0-1 and it does not assume that the predictor variables have a constant marginal effect on the target variable, making it appropriate for dichotomous target variables (one that has only two possible values).
Logistic regression can be applied to many problems, including: estimating the probability that a student will graduate, the probability that a voter will vote for a specific candidate, or the probability that someone will respond to a marketing campaign.
Aa a side note, before building a statistical model, you should always perform a thorough analysis of your data, and the Data Investigation Tool Series provides a great resource to begin your pre-model analysis. Once a pre-model analysis has been performed, you can begin building your model and can focus on the details of the Logistic Regression Tool.
We will walk through the configuration of the Logistic Regression Tool using the sample workflow that can be found within Designer:
The first step is to connect your data, which should include your target variable and one or more predictor variables, to the Logistic Regression Tool.
The next step is to provide a name for the model (optional), select the target field, and select the predictor variables. This can be done in the Setup window.
The customization screen can be reached from the setup screen.
A. Model Screen
Note: The Model screen has three customizable options for building a logistic model (Use sampling weights, Use regularized regression, and Select model type).
The “Use sampling weights” option allows you to specify a field that contains sampling weights. This option can be used to standardize sample data (survey data) so that it better represents a population
Regularized Regression allows you to mitigate over-fitting (e.g., preventing your model from being fit to the “noise” in your data). This method will generate its own density curve, and is discussed in further detail in this article. The Use regularized regression option contains four customizable options:
I. Enter value of alpha
II. Standardize predictor variables
III. Use cross-validation to determine model parameters
IV. Value of Lambda used for predictions
If you do not select Use regularized regression, you can select a model type from a drop-down menu. Your options are logit, probit, or complementary log-log (cloglog). Different models will be better suited for different use cases. You can learn more about model selection from this article.
B. Cross-validation Screen
The Cross-Validation tab allows you to perform cross-validation in your model. The cross-validation option can be enabled by clicking on the slider in the top-right of the configuration screen. You can learn more about Cross-validation from this article.
C. Plots Screen
The plots screen allows the user to choose Graph resolution. There are 3 options:
1x (96 dpi)
2x (192 dpi)
3x (288 dpi)
Now you know how to configure the tool, let’s look at interpreting the results. The tool has 3 outputs:
O (Output): Displays the model name and size – this outputs the actual model object. You can connect this output to the Score Tool, which generates a predicted value (score) from a separate data stream.
R (Report): Generates a report with the fit statistics for the model. In general, there are 3 major fit statistics that are generated with this output.
I (Interactive): Displays the dashboard with various statistics about the data such as actual positive and actual negative.
That’s it folks, now you should be an expert on the Logistic Regression Tool!
Alteryx has a wide variety of kits where you can learn various subjects. The Predictive Starter Kit provides step-by-step tutorials that will teach you how to build core predictive insights, from developing a proper dataset to analyzing the results without requiring niche tools or R-coding.
By now, you should have expert-level proficiency with the Logistic Regression Tool! If you can think of a use case we left out, feel free to use the comments section below! Consider yourself a Tool Master already? Let us know firstname.lastname@example.org you’d like your creative tool uses to be featured in the Tool Mastery Series.
Stay tuned with our latest posts everyTool Tuesday by followingAlteryx on Twitter! If you want to master all the Designer tools, considersubscribing for email notifications.