When there are multiple predictor x variables combining then in such a way as

# When there are multiple predictor x variables

This preview shows page 7 - 9 out of 49 pages.

When there are multiple predictor (x) variables, combining then in such a way as to maximize the the correlation of the combined predictor variables with the dependent (y) variable. When the combination of the predictor variables is graphed against the dependent variable, y, a straightline, the regression line can be drawn through the data points in such a way as to minimize the distance between the plotted points and the line. See the scatterplot (scatter diagram) below where the predicted (PR) values computed in the next problem are plotted against the actual (itl) values.Use the TREND function as an ARRAY function to predict an itl value for each of the observations from the variables org to tr. Place the results in the column headed PR (for predicted).Use the LINEST function to compute a basic regression analysis predicting cptw for the variables icpy to tr. Select the cells in the box below to place the results. Note LINEST is an ARRAY function.Insert a Trendline and the regression equation, including R2.The correlation of the Actual values with the Predicted values is the Multiple Correlation, R, when the Predicted values is the linear comvariables. Using the CORREL function, verify this by calculating the correlation between itl and PR. Then, square the correlation. You sas displayed in the Scatterplot.R21.001.251.501.752.002.252.502.753.003.253.503.754.004.254.504.755.005.255.505.756.001.001.251.501.752.002.252.502.753.003.253.503.754.004.254.504.755.005.255.505.756.00f(x) = 0.3703571044x + 2.7190348119R² = 0.3703571044Scatterplot of Actual vs. Predicted Intention to Leave (itl) Values Actual itl ValuesPredicted itl values
13.832.002.503.252.673.501.331.251.502.435.004.001.003.002.311.253.405.003.5413.675.003.335.005.003.502.891.751.503.574.205.005.003.003.252.504.205.004.3813.753.503.833.004.003.253.222.672.003.574.204.002.502.333.313.503.504.004.1014.003.503.504.254.004.753.002.081.503.434.805.005.003.672.692.753.603.504.2213.174.002.673.003.674.253.782.753.003.004.403.505.002.333.063.003.605.004.1913.672.503.503.254.333.252.112.252.003.144.805.003.502.332.563.253.504.504.1914.423.503.673.004.334.003.893.004.003.713.805.003.503.673.503.754.105.004.8113.084.504.004.004.334.503.112.331.503.005.004.003.502.003.444.002.904.504.1213.673.003.833.503.674.002.562.422.003.434.202.003.003.332.003.753.004.504.0714.673.504.004.003.334.503.673.003.003.574.204.503.503.003.753.754.205.004.4614.334.004.333.504.003.502.673.084.003.433.604.003.502.003.692.754.303.504.7714.004.003.674.004.333.502.782.332.503.144.805.003.001.674.003.254.203.504.5113.923.002.672.753.503.502.292.903.002.334.604.004.502.332.773.253.904.754.2213.753.503.673.755.004.003.563.333.003.434.404.503.003.332.753.003.704.004.6024.704.004.002.255.004.503.783.383.003.675.005.003.004.003.713.254.865.005.0722.642.501.832.253.672.002.781.582.002.713.804.503.503.331.442.502.891.253.4024.673.504.504.004.004.253.443.924.003.714.204.504.003.674.193.504.505.004.8423.922.503.834.253.673.254.222.332.503.294.805.003.502.332.633.003.604.254.2223.834.004.173.754.004.003.562.673.504.004.404.002.502.673.634.003.705.004.6923.753.503.833.504.003.253.562.753.004.144.604.003.502.673.633.254.004.754.5223.833.504.174.003.673.503.502.582.504.004.204.004.003.674.062.753.804.504.1724.333.503.834.004.334.254.223.084.003.144.604.504.002.333.384.004.205.004.9722.582.502.831.753.331.251.561.501.501.864.603.003.002.002.133.002.703.253.3022.923.002.832.003.002.752.561.922.503.434.204.002.003.002.814.252.904.253.6423.424.003.003.334.003.503.112.423.003.004.604.503.504.002.503.753.505.004.3023.733.504.004.004.003.003.002.752.503.144.004.003.003.003.634.003.784.004.0724.253.003.833.754.334.002.892.923.503.004.004.003.002.333.693.003.904.504.5824.703.003.504.005.003.754.333.674.503.864.805.003.504.334.313.504.755.005.2323.674.003.674.004.003.503.783.274.502.714.204.504.003.333.813.503.905.004.5924.173.003.833.504.333.003.222.504.003.574.202.504.004.334.192.753.705.004.7623.583.503.831.752.674.001.892.251.502.433.804.501.503.672.693.753.201.753.3322.673.002.672.753.673.503.002.332.003.144.802.004.002.332.562.752.802.003.8124.094.003.505.003.674.252.673.082.003.294.603.502.502.673.062.504.002.754.1922.924.003.504.253.004.253.003.083.002.864.604.503.002.673.503.753.702.503.8223.642.503.503.504.003.002.783.084.003.144.004.502.002.333.002.753.895.004.3424.174.003.502.754.674.002.782.924.003.714.604.503.003.003.333.003.805.005.09sexGender: 1=Male; 2=FemaleorgThe Organizationini

#### You've reached the end of your free preview.

Want to read all 49 pages?