Multiple Regression Access tech supplements, videos, and data sets at www.TriolaStats.com TECH CENTER continued TI-83, 83 84 Plus Calculator 8 us Ca cu ator Requires program A2MULREG (available at TriolaStats.com) 1. Data must be entered as columns in Matrix D, with the first column containing values of the dependent y variable: Manually enter data: Press F then Qto get to the MATRIX menu, select EDIT from the top menu, select [D], and press [. Enter the number of rows and columns needed, press [, and proceed to enter the sample values. Using existing lists: Lists can be combined and stored in Matrix D. Press F then Q to get to the MATRIX menu, select MATH from the top menu, and select the item List Smatr. Enter the list names (the first list must contain values for the dependent y variable), followed by the matrix name [D], all separated by ,. Important: The matrix name must be entered by pressing F then Q, selecting [D], and pressing [. The following is a summary of the commands used to create a matrix from three lists (L1, L2, L3): List Smatr(L1, L2, L3, [D]). 2. Press N, select A2MULREG, press [ three times, select MULT REGRESSION, and press [. 3. Enter the number of independent x variables, then enter the column number of each independent x variable. Press [ after each entry. 4. The results will be displayed, including P-value and adjusted R2. Press [ to view additional results, including values used in the multiple regression equation. 5. Press [ to select the QUIT option. TIP: The list name L1 (and L2 . . . L6) can be quickly entered by pressing F1. R R commands: Regression results (y intercept and slope): lm1y=x+z2 Additional regression details: summary1lm1y=x+z2 2 Predictions of y: predict1lm1y=x+z2, interval = “confidence”, conf.level=0.95) Where y is the dependent variable. TIP: Additional independent variables can be added to the above formulas as needed. A complete list of R statistical commands is available at TriolaStats.com Excel XLSTAT Add-In 1. Click on the XLSTAT tab in the Ribbon and then click Modeling data. 2. Select Linear regression from the dropdown menu. 3. Enter the range of cells containing the Y>Dependent variable data and X>Explanatory variable data (multiple columns). Check the Quantitative box under X>Explanatory variable. If the first data row includes a label, check the Variable labels box. 4. Click the Outputs tab and ensure Correlations and Analysis of variance are both checked. 5. Click OK, and the equation of the multiple regression line will be displayed in the results. Excel (Data Analysis Add-In) 1. Click on the Data tab in the Ribbon and then click the Data Analysis tab. Select Regression under Analysis Tools. 2. For Input Y Range enter the data range for the dependent y variable. For Input X Range enter the data range for the independent x variables. The x variable data must be located in adjacent columns. 3. Check the Labels box if the first row contains a label. 4. Click OK to display the results. 560 CHAPTER 10 Correlation and Regression
RkJQdWJsaXNoZXIy NjM5ODQ=