Biostat Home work 9.xlsx - The following table reports data exam their GPA(based on a 100 point scale score on an aptitude test taken prior to admission

The followi exam, their GPA (based on a 100 point scale), score on an aptitude test taken prior to admission to nursing wether the variables are signific Board GPA Apt test Gender Gender 440 87 92 1 F To find the significance of GPA, test scores and gend 480 87 79 1 F 535 87 99 0 M 460 88 91 1 F 525 88 84 1 F Regression tools from data analysis is used to explai 480 89 71 1 F 510 89 78 0 M Male GPA Fem GPA 530 89 78 1 F 637 1626 545 89 71 1 F 91 90.33 600 89 76 1 F 495 90 89 0 M 545 90 90 1 F SUMMARY OUTPUT 575 90 73 1 F 525 91 71 1 F Regression Statistics 575 91 81 0 M Multiple R 0.556171557 600 91 84 1 F R Square 0.3093268008 490 92 70 1 F Adjusted R Squ 0.210659201 21.07% 510 92 85 0 M Standard Error42.647072089 575 92 71 1 F Observations 25 540 93 76 1 F 595 93 90 1 F ANOVA 525 94 94 0 M df SS 600 94 93 0 M Regression 3 17105.77 625 94 73 1 F Residual 21 38194.23 545 94 94 1 F Total 24 55300 25 count Coefficients andard Erro Intercept -444.9909059 362.7488 GPA 11.287274488 3.777318 Apt test -0.525133292 1.071838 Gender 4.7093960485 21.41138 Intercept: when variables equal zero, test score is -445 For every unit increase in GPA, board score increases by 11.29 points. t stat is 2.99 which is >2 a For every unit increase in Apt test, board score increases by -0.53. t stat is -0.49 which is <2 and Board score changes by 4.71 based on gender, t stat is 0.22 which is <2 and p value of 0.83 is > GPA is the only significant variable that explains board scores, hence may be considered for hiri Y^ -445+11.29-5.3+4.71*e R 2, F, coefficients and the intercept. Discuss the relationships between GPA, aptitude test and gen