APPLIED MANAGERIAL STATISTICS
See attached Excel spreadsheet.
“Y” is the dependent variable and the “X”‘s are independent variables. Use MegaStat and its Regression capabilities to find the “best” equation that predicts Y based upon the X’s. (Don’t accept the first equation you find, try others also.) What do you notice in the regression analysis? Which variables affect Y significantly? Include only those in your final equation.