A representative sample of 219 students from a large class of incoming MBA students were surveyed. The data are provided in the excel spreadsheet midtermdata xlex under the "student data" tab. The fields included are; Student ID. Gender, Height, Weight, Pet Ownership, GMAT score. Using a 95% confidence level, are GMAT scores statistically different for Dog vs Cat owners?A representative sample of 219 students from a large class of incoming MBA students were surveyed. The data are provided in the excel spreadsheet midtermdata.xhx under the "student data" tab. An admissions counselor notices that there is a slight correlation between an MBA student's weight and their OMAT score. 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 GMAT scores with weight. Looking at the t-statistic associated with the coefficient on weight you can formally test the hypothesis that weight is a statistically significant predictor of GMAT score using an alpha of 5%. What do you conclude from your analysis? Weight and GMAT score are only weakly correlated ) Weight and GMAT score have a positive and statistically significant relationship O We can reject the null hypothesis that weight and GMAT scores are independent Weight has a positive effect on GMAT scores, but the effect is not statistically significant