Question: A representative sample of 219 students from a large class of incoming MBA students were surveyed. The data are provided in the cool spreadsheet midtermdata


A representative sample of 219 students from a large class of incoming MBA students were surveyed. The data are provided in the cool spreadsheet midtermdata alex under the "student data" tabs. An admissions counselor notices that there is a slight correlation between an MBA student's weight and their GMAT weare. Perhaps we can stop requiring GMAT scores and just collect applicants' weights? You are asked to perform the analysis. Assume that GMAT scores are a linear function of weight. Using regression linear analysis in excel. estimate a regression line that predicts OMLAT scores with weight. Looking at the 1-statistic associated with the coefficient on weight you can formally test the hypothesis that weight is a statistically significant predictor of OMAT score using an alpha of 5%%. What do you conclude from your analysis? O Weight and GMAT scorn are only weakly complaind O Weight and GMAT score have a positive and statistic ificant relationship O We can reject the null hypothesis that weight and GMAT scenes are independent O Weight has a positive effect on GMAT scores, but the effect is not statistically significant
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
