Sociology 215 Homework 6 50 Points Due: April 19th Use the following data to answer the questions below: S tudent Age 25 30 25 35 20 25 30 35 20 35 25 25 30 35 40 45 50 55 25 30 Major S OC PS CH Y CJ CJ CJ S OC PS CH Y CJ S OC S OC S OC PS CH Y CJ S OC S OC PS CH Y PS CH Y PS CH Y CJ CJ GPA E xam 1 3 2.5 3.5 2 1.5 3.5 4 3.5 2.5 3 4 2 2 3 3.5 2.5 2.5 3.5 2.5 2.5 85 80 75 80 75 95 85 75 90 100 95 90 80 80 85 90 85 80 80 90 Compute the Correlation Between S tudent Age and GPA Compute the Correlation Between S tudent Age and E xam 1 Compute the Correlation Between S tudent GPA and E xam 1 Compute a regression equation using student age to predict GPA Compute a regression equation using student age to predict Exam 1 Compute a regression equation using GPA to predict exam 1 Compute an ANOVA using Major to predict GPA Compute an ANOVA using Major to predict age Compute an ANOVA using Major to predict exam 1 Bonus: Compute independent samples t-tests to determine if the means of S majors and CJmajors oc have significant different means on GPA, Age and E xam 1 Age Major 25 SOC 30 PSYCH 25 CJ 35 CJ 20 CJ 25 SOC 30 PSYCH 35 CJ 20 SOC 35 SOC 25 SOC 25 PSYCH 30 CJ 35 SOC 40 SOC 45 PSYCH 50 PSYCH 55 PSYCH 25 CJ 30 CJ GPA Exam 1 3 2.5 3.5 2 1.5 3.5 4 3.5 2.5 3 4 2 2 3 3.5 2.5 2.5 3.5 2.5 2.5 85 80 75 80 75 95 85 75 90 100 95 90 80 80 85 90 85 80 80 90 Correlation Table Age GPA Exam 1 Age GPA Exam 1 1 0.163853 1 -0.050226 0.199621 1 1. 2. 3. 0.163853 -0.050226 0.199621 Age GPA 25 30 25 35 20 25 30 35 20 35 25 25 30 35 40 45 50 55 25 30 3 2.5 3.5 2 1.5 3.5 4 3.5 2.5 3 4 2 2 3 3.5 2.5 2.5 3.5 2.5 2.5 SUMMARY OUTPUT Regression Statistics Multiple R 0.163853 R Square 0.026848 Adjusted R-0.027216 Square Standard Error 0.718548 Observations 20 ANOVA df Regression Residual Total Intercept Age SS MS F Significance F 1 0.256395 0.256395 0.496591 0.49002 18 9.293605 0.516311 19 9.55 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 2.459302 0.577236 4.260483 0.000471 1.246575 3.672029 1.246575 3.672029 0.012209 0.017326 0.704692 0.49002 -0.024191 0.048609 -0.024191 0.048609 GPA=2.459302+0.012209*AGE Age Exam 1 25 30 25 35 20 25 30 35 20 35 25 25 30 35 40 45 50 55 25 30 85 80 75 80 75 95 85 75 90 100 95 90 80 80 85 90 85 80 80 90 SUMMARY OUTPUT Regression Statistics Multiple R 0.050226 R Square 0.002523 Adjusted R-0.052893 Square Standard Error 7.345799 Observations 20 ANOVA df Regression Residual Total SS MS F Significance F 1 2.456395 2.456395 0.045522 0.833445 18 971.2936 53.96076 19 973.75 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 85.9593 5.901145 14.56655 2.1E-011 73.56146 98.35715 73.56146 98.35715 Age -0.037791 0.177123 -0.213359 0.833445 -0.409912 0.334331 -0.409912 0.334331 EXAM1=85.9593-0.03779*AGE GPA Exam 1 3 2.5 3.5 2 1.5 3.5 4 3.5 2.5 3 4 2 2 3 3.5 2.5 2.5 3.5 2.5 2.5 85 80 75 80 75 95 85 75 90 100 95 90 80 80 85 90 85 80 80 90 SUMMARY OUTPUT Regression Statistics Multiple R 0.199621 R Square 0.039848 Adjusted R-0.013493 Square Standard Error 7.207048 Observations 20 ANOVA df Regression Residual Total Intercept GPA SS MS F Significance F 1 38.80236 38.80236 0.747039 0.398787 18 934.9476 51.94154 19 973.75 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 79.00524 6.839194 11.55183 9.3E-010 64.63662 93.37385 64.63662 93.37385 2.015707 2.332146 0.864314 0.398787 -2.88395 6.915363 -2.88395 6.915363 EXAM1=79.00524+2.015707*GPA