Complete the following steps if the response data is a single column with two distinct values. Optionally, the data can include a column that contains the count of responses that corresponds to the response and predictor values in the row.
- From the drop-down, select Response in binary response/frequency
format.
- In Response, enter the column of binary data that you want to explain or predict. Binary variables are categorical variables that have two possible levels, such as pass/fail or true/false. The response is also called the Y variable.
- In Response
event, select which event the analysis will describe. Changing the response event does not affect the overall significance, but it can make the results more meaningful.
- (Optional) In Frequency, enter the column that contains the counts that correspond to the response and predictor values.
- In Continuous
predictors, enter the continuous variables that may explain or predict changes in the response. The predictors are also called X variables.
- In Categorical
predictors, enter the categorical classifications or group assignments, such as type of raw material, that may explain or predict changes in the response. The predictors are also called X variables.
In this worksheet, Bought is the response and indicates whether a consumer purchased a new brand of cereal. The response event is Yes. Income is a continuous predictor and Children is a categorical predictor. The first row in the worksheet shows that one consumer with children and with an income of $37,000 bought the new brand of cereal.
C1-T |
C2 |
C3-T |
Bought |
Income |
Children |
Yes |
$37,000 |
Yes |
No |
$47,000 |
Yes |
Yes |
$34,000 |
No |
Yes |
$58,000 |
No |
In this worksheet, the response and predictor variables are the same as the previous example but the data also include a frequency variable. Frequency contains the count of consumers that correspond to the combination of response and predictor values in each row. The first row in the worksheet shows that 2 consumers with children and with an income of $40,000 bought the new brand of cereal.
C1-T |
C2 |
C3-T |
C4 |
Bought |
Income |
Children |
Frequency |
Yes |
$40,000 |
Yes |
2 |
No |
$40,000 |
No |
12 |
Yes |
$45,000 |
Yes |
1 |
No |
$45,000 |
No |
6 |