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.
- (Optional) In Frequency, enter the column that contains the counts that correspond to the response and predictor values in the row.
- In Predictor, enter the continuous variable that may explain or predict changes in the response. The predictor is also called the X variable.

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 the continuous predictor. The data in row 1 indicate that one consumer with an income of $37,000 bought the new brand of cereal.

C1 | C2 |
---|---|

Bought | Income |

Yes | $37,000 |

No | $47,000 |

Yes | $34,000 |

Yes | $58,000 |

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 shows that 2 consumers with an income of $40,000 bought the new brand of cereal.

C1 | C2 | C3 |
---|---|---|

Bought | Income | Frequency |

Yes | $40,000 | 2 |

No | $40,000 | 12 |

Yes | $45,000 | 1 |

No | $45,000 | 6 |

Complete the following steps if the response data are contained in two columns – one column that contains the number of successes or events of interest and one column that contains the number of trials.

- From the drop-down, select Response in event/trial format if your response data is contained in two columns that include events and trials.
- In Event name, enter a name for the event in the data. For example, the event could be successes, non-conforming units, or purchases.
- In Number of events, enter the column that contains the number of events.
- In Number of trials, enter the column that contains the number of trials. Trials represent the number of events plus the number of nonevents.
- In Predictor, enter the continuous variables that may explain or predict changes in the response. The predictor is also called the X variable.

In this worksheet, Bought contains the number of events, which indicates how many consumers bought a new brand of cereal. Trials contains the number of trials, which indicates the total number of consumers that were surveyed for that combination of predictor variables. Income is the continuous predictor. The first row shows that 20 consumers with an income of $37,000 were surveyed and 2 of them bought the new brand of cereal.

C1 | C2 | C3 |
---|---|---|

Bought | Trials | Income |

2 | 20 | $37,000 |

0 | 3 | $37,000 |

4 | 12 | $40,000 |

3 | 18 | $34,000 |