Enter your data for Best Subsets Regression

In the Best Subsets Regression dialog box, specify the response and predictors variables to analyze.

Complete the following steps to specify the columns of data that you want to analyze.

  1. In Response, enter the column of numeric data that you want to explain or predict. The response is also called the Y variable.
  2. In Continuous variables, enter the columns of numeric data that may explain or predict changes in the response. The predictors are also called X variables. You can specify up to 12 variables.
In this worksheet, Strength is the response and contains strength measurements for a sample of plastic pipe. Time, Pressure, Temp, and Humidity are predictors and may explain differences in strength.
C1 C2 C3 C4 C5
Strength Time Pressure Temp Humidity
102.3 3 .45 78.3 56
94.1 7 2.3 97.6 67
113.6 13 4.7 110.4 34
131.9 12 .98 100.6 45
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy