Need help with the following statistics sheet. Please find attached.

12/3/2017 BUS 8013 Research Methods Stats Sheet 5 40 Points Fill in the yellow cells on the Regression tab. Be sure to show your work. Academic Performance of Portuguese Students Dependent (outcome) variable GradePor Final grade in Portuguese (range is 0 to 20 based on Portuguese grading system; higher scores indicate better p Independent (predictor) variables GradeMath Final grade in Math (range is 0 to 20 based on Portuguese grading system; higher scores indicate better perform School School student attends 1 Gabriel Pereira 0 Mousinho da Silveira Age Student's age (ranges from 15 to 22) Gender Student's gender 1 Female 0 Male Urban Home address type 1 Urban 0 Rural Pstatus parent's cohabitation status 1 Living together 0 Living apart ParTeacher One or both parents are teachers 1 Yes 0 No StudyTime Weekly study time 1 less than 2 hours 2 2 to 5 hours 3 5 to 10 hours 4 greater than 10 hours Failures Number of past class failures (Range is 0 to 3) SchoolSup Extra educational support 1 Yes 0 No FamSup Family educational support 1 Yes 0 No Activities Student involved in extra-curricular activities 1 Yes 0 No Higher Wants to take higher education 1 Yes 0 No FreeTime Free time after school 1 very low 2 3 4 5 very high Health Current health status 1 very bad 2 3 4 5 very good Absenses Number of school absenses (range 0 to 93) higher scores indicate better performance) scores indicate better performance) GradePor GradeMathSchool 13 10 11 5 12 13 10 8 13 10 12 11 12 0 11 8 15 16 10 11 15 15 13 0 12 10 12 11 13 11 14 15 13 12 10 8 11 6 11 0 10 6 14 15 15 14 13 18 15 0 12 11 12 8 12 7 14 9 13 11 14 15 13 13 11 11 11 6 12 10 11 6 16 13 12 10 13 11 11 10 16 11 12 10 13 14 12 7 10 0 14 11 13 10 16 11 13 0 12 10 10 12 10 13 13 0 11 8 13 11 Gender 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Age 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Urban 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 Pstatus 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ParTeacherStudyTime Failures 1 0 4 1 0 2 1 0 1 1 0 3 1 0 3 1 0 3 1 1 3 1 0 2 1 0 4 0 0 4 0 0 2 1 0 1 1 0 2 1 0 2 1 0 2 1 0 2 1 0 3 1 0 4 1 0 1 1 0 2 1 0 2 1 0 3 1 0 3 1 0 1 1 0 3 1 0 1 1 0 2 1 1 2 1 1 2 1 1 3 1 1 1 0 0 1 0 0 2 0 0 2 1 0 2 1 0 2 1 0 2 1 0 2 1 0 4 1 0 3 1 1 2 0 0 2 0 0 2 0 0 2 0 0 1 0 0 1 1 0 1 1 0 1 1 0 2 1 0 2 1 0 1 1 0 2 1 0 2 1 0 2 1 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 14 12 12 13 14 10 16 13 11 14 11 11 18 16 14 15 13 13 15 17 17 13 14 16 13 11 10 11 11 10 13 13 12 15 16 14 11 16 13 11 13 15 17 12 10 19 11 16 14 14 17 13 11 12 12 15 11 8 10 13 17 6 12 10 8 10 11 5 16 16 10 16 8 9 13 14 14 14 14 14 11 13 9 6 9 11 13 13 6 9 15 16 10 10 11 6 6 14 10 7 11 18 10 12 0 9 13 6 6 0 9 10 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 0 0 0 0 0 1 1 1 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 1 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 2 1 2 2 2 4 2 2 3 2 2 2 2 2 2 2 3 3 2 2 1 1 3 3 2 1 2 2 2 2 2 2 2 2 2 3 2 2 2 2 1 3 3 3 3 4 1 3 2 2 2 2 2 3 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 14 13 14 13 13 16 17 17 18 17 15 13 8 14 16 13 18 10 13 16 13 15 15 12 12 12 16 15 14 17 12 10 11 10 14 8 12 18 11 13 11 15 18 13 14 16 17 12 17 17 15 13 13 15 13 12 12 10 11 9 8 10 17 15 18 15 0 9 9 15 14 15 15 4 12 18 9 14 15 12 12 0 15 15 8 13 14 9 10 0 0 7 11 12 6 10 0 0 19 0 10 14 14 0 9 14 18 8 11 11 11 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 3 3 2 2 1 2 2 3 4 2 2 3 3 3 3 3 3 2 1 1 3 3 3 1 2 4 2 2 2 4 2 2 1 2 4 2 2 4 2 2 3 2 3 3 3 4 3 2 3 4 2 2 2 2 2 2 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 15 14 11 12 12 13 10 8 11 15 11 15 16 12 12 10 13 9 12 13 14 9 11 11 10 13 13 11 14 11 12 11 16 12 15 15 16 11 17 9 14 14 12 13 12 18 14 12 11 13 12 11 10 11 11 15 17 8 9 8 9 0 9 8 0 16 13 16 18 12 11 11 15 11 12 15 13 12 10 15 10 14 11 10 15 0 15 12 14 14 17 18 15 10 19 10 19 9 14 15 12 19 18 14 12 15 8 15 10 9 15 18 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 18 18 19 19 19 19 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 16 16 16 16 16 16 16 1 1 1 1 1 1 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 1 1 1 1 0 0 1 0 0 1 1 0 0 0 1 0 0 0 0 1 1 0 1 1 0 0 0 1 0 1 4 2 2 4 2 2 2 2 2 2 4 3 2 4 1 1 4 3 1 2 1 1 4 1 4 2 2 2 2 4 1 2 2 1 2 2 2 1 2 1 1 2 4 2 2 1 3 1 1 3 1 1 1 1 1 1 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12 11 18 11 16 11 11 12 14 11 12 12 10 1 15 14 13 10 17 11 13 14 15 8 16 14 8 12 13 10 9 10 10 16 13 10 11 14 12 13 15 18 10 11 13 13 10 10 12 8 10 9 12 12 10 6 10 15 16 11 18 10 10 14 14 15 10 15 10 12 13 18 12 0 20 8 13 13 12 5 17 16 0 11 11 7 6 12 14 15 11 12 9 16 10 15 0 14 10 8 12 11 10 0 12 7 13 0 11 8 10 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 1 1 1 0 1 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 1 2 1 1 2 2 1 1 4 3 1 2 2 1 3 2 1 4 2 1 2 1 1 3 2 1 2 2 2 2 2 1 2 2 2 1 2 1 2 1 2 2 2 1 2 1 2 2 2 1 1 2 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 3 1 0 0 3 0 13 14 7 15 10 17 14 13 14 13 13 10 10 16 11 15 11 13 12 10 12 17 16 15 10 16 6 15 10 8 11 7 14 16 11 14 13 13 12 17 0 11 12 10 17 10 17 11 11 14 15 5 9 9 13 9 13 10 5 11 6 16 11 11 16 9 10 8 8 13 12 12 9 10 13 10 12 16 17 14 5 14 8 14 13 0 8 8 10 11 8 9 11 0 9 15 0 9 8 8 15 10 16 12 0 11 18 8 0 5 12 10 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 17 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 18 19 19 19 20 22 17 17 17 17 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 0 0 0 0 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 1 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 1 1 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 1 1 1 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 1 2 1 1 2 1 2 2 1 2 1 1 1 2 2 2 2 1 2 2 3 3 2 3 2 2 1 3 2 2 2 1 2 2 2 3 3 2 1 2 1 2 4 2 2 1 1 2 1 2 1 1 1 1 2 2 0 0 3 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 3 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 2 3 1 0 0 0 12 12 15 15 12 15 0 10 17 14 9 10 16 10 13 18 16 10 11 16 10 10 9 0 11 0 10 11 19 14 9 16 10 11 0 13 11 11 15 10 10 11 6 19 10 0 10 15 9 10 16 8 0 11 10 13 16 10 7 13 5 12 10 14 10 8 13 8 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17 17 17 17 18 18 18 18 18 18 18 18 18 18 18 18 18 19 17 17 17 17 18 18 18 18 18 18 18 18 18 18 19 19 19 0 1 1 1 0 0 0 0 0 0 1 1 1 1 1 1 1 0 0 1 1 1 0 0 0 0 0 0 1 1 1 1 0 0 0 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 1 1 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 2 3 2 2 3 3 2 1 3 2 2 1 2 2 2 3 2 3 2 2 2 1 2 1 1 1 1 1 2 1 1 3 1 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 0 0 0 0 1 0 0 0 0 0 0 1 1 1 SchoolSupFamSup 1 1 1 1 0 1 0 1 0 1 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 1 0 1 0 0 0 0 1 1 1 0 0 1 0 1 0 0 1 0 0 0 0 1 0 0 0 1 0 0 0 Activities Higher 1 1 1 0 1 1 1 1 1 1 1 1 1 0 1 0 1 0 0 0 1 1 1 1 1 1 1 0 1 0 0 0 1 1 1 0 1 1 1 0 1 0 1 1 1 1 0 1 1 1 1 0 0 0 1 1 1 0 1 1 0 1 0 0 0 1 1 1 0 0 1 0 1 0 0 1 1 1 1 1 1 1 0 1 1 0 1 0 1 1 0 0 1 0 1 1 0 1 1 0 0 0 0 1 1 0 0 0 0 0 FreeTime Health 1 1 1 3 1 3 1 3 1 2 1 3 1 2 1 1 1 4 1 3 1 3 1 3 1 3 1 4 1 3 1 2 1 2 1 1 1 5 1 3 1 3 1 2 1 3 1 5 1 3 1 3 1 4 1 4 1 3 1 2 1 3 1 3 1 3 1 2 1 3 1 4 1 3 1 4 1 3 1 1 1 4 1 3 1 3 1 3 1 3 1 2 1 3 1 5 1 3 1 3 1 5 1 1 1 1 1 4 1 2 Absenses 1 2 5 2 2 8 5 2 3 8 5 2 5 0 4 2 3 12 4 10 1 0 4 0 4 2 5 0 5 2 1 2 4 4 3 8 5 0 3 0 2 26 5 2 1 4 1 4 5 0 5 0 5 6 3 2 2 0 5 2 5 0 1 6 1 0 5 8 3 10 5 10 5 2 2 0 5 6 2 0 4 6 2 8 4 0 4 5 5 0 5 16 5 6 5 6 3 0 5 2 5 20 5 6 4 0 5 0 3 0 0 0 1 0 1 1 0 0 0 1 1 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 1 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 1 0 0 1 1 1 1 1 1 1 0 1 1 1 1 1 0 1 1 0 1 1 1 0 0 1 0 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 0 1 1 0 1 0 0 0 0 0 0 1 1 0 0 0 1 1 0 1 1 0 0 1 1 1 0 0 1 0 1 1 0 1 0 1 1 1 0 0 1 1 0 0 1 1 1 0 0 1 0 0 0 0 0 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 4 2 4 3 3 3 2 3 3 3 3 4 2 2 3 3 3 4 3 4 4 3 2 3 3 4 4 3 3 3 3 2 3 4 4 4 5 3 1 2 3 4 3 4 3 1 2 2 3 3 2 1 3 3 3 4 5 5 4 2 3 5 1 5 4 4 5 3 3 5 1 2 3 4 1 3 2 1 2 5 3 1 1 2 5 3 4 5 2 4 1 4 3 2 3 5 3 5 5 4 3 3 3 3 4 3 5 1 3 5 3 1 2 14 6 10 2 4 14 4 0 4 54 12 0 2 0 2 0 2 10 0 4 6 6 0 12 2 4 4 14 25 2 2 4 4 2 4 0 4 2 2 18 7 0 6 3 6 12 10 0 6 23 6 4 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 1 1 1 1 1 1 1 1 0 1 0 1 0 1 1 1 0 1 1 1 1 0 1 1 0 0 0 1 1 0 0 1 1 0 0 0 1 0 0 1 1 1 1 1 1 0 0 1 1 1 1 1 1 1 0 0 1 0 0 0 0 1 0 1 1 0 1 0 0 0 1 0 0 0 0 1 0 0 0 0 1 1 0 1 1 1 0 1 0 1 1 1 1 0 1 0 1 0 1 0 1 0 1 1 0 0 1 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 3 4 2 3 3 4 4 2 3 3 2 4 4 3 4 2 4 2 2 4 3 3 4 4 4 3 4 3 2 2 1 2 3 4 3 3 2 3 4 4 3 3 3 3 5 4 3 3 3 1 4 4 2 4 3 3 4 5 3 3 1 5 5 5 3 2 4 5 5 3 4 3 1 4 2 4 4 2 5 5 2 5 1 1 4 3 5 4 3 4 4 4 3 3 4 3 1 2 3 3 2 1 4 5 3 2 4 5 4 3 2 6 4 4 12 3 2 0 1 0 10 0 4 28 16 0 0 0 22 0 24 7 4 0 12 6 0 0 2 56 6 14 75 6 0 0 16 8 1 6 4 0 0 5 0 4 4 7 0 9 0 21 15 2 14 2 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 1 1 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 1 1 1 1 1 0 0 1 1 1 1 1 1 1 1 1 0 1 1 0 0 0 0 0 1 1 1 0 1 1 1 1 1 1 1 1 0 1 0 0 1 1 0 0 0 1 1 1 1 0 0 1 1 1 0 0 0 0 1 1 1 1 1 0 1 1 0 1 1 0 0 1 0 1 1 0 0 1 0 0 0 0 1 0 0 0 0 1 1 1 1 1 0 0 0 1 1 1 1 1 0 1 1 0 1 1 0 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 4 4 3 3 3 4 4 3 5 3 5 4 3 2 4 5 3 2 5 4 5 4 2 3 3 4 3 4 2 4 4 4 3 3 3 2 5 2 5 5 3 3 3 3 5 4 3 4 4 3 2 3 3 3 5 1 2 5 3 5 2 5 1 5 5 1 3 1 3 5 1 5 5 3 5 4 5 1 1 3 5 3 5 1 3 5 5 2 5 5 5 5 5 1 5 4 5 4 4 2 3 4 5 5 5 3 3 5 3 4 4 7 10 2 10 15 0 8 2 0 0 6 0 0 4 2 0 6 4 2 0 6 0 8 4 0 2 2 6 0 0 0 0 2 4 0 2 4 0 0 6 6 2 6 4 0 10 2 2 8 7 0 2 8 10 2 8 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 1 0 0 0 0 0 1 0 1 1 1 0 1 0 1 0 1 1 1 0 1 1 1 1 1 1 1 1 0 0 0 0 1 1 0 0 1 0 1 0 1 0 1 1 0 1 0 0 0 0 0 1 1 1 0 1 1 0 0 1 0 1 0 1 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 0 0 0 1 1 0 1 1 1 1 1 1 1 0 1 0 1 0 0 0 1 0 1 0 1 1 0 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 0 1 1 0 1 3 3 3 3 3 3 4 3 3 3 3 4 3 5 4 3 2 4 2 4 4 2 3 5 4 4 3 4 3 1 4 4 4 2 4 4 3 5 1 4 4 5 1 2 4 5 4 4 3 3 2 3 3 4 5 4 3 5 3 3 4 4 3 3 5 5 2 5 2 5 5 5 3 2 2 3 5 1 5 4 4 5 5 5 5 5 5 5 5 5 3 5 2 5 5 5 3 1 3 5 5 1 4 5 4 5 5 5 4 5 3 5 8 0 2 2 6 4 12 0 2 0 10 0 6 4 0 2 2 0 4 10 18 2 0 14 0 2 0 16 4 18 18 0 6 0 0 0 8 2 4 10 0 2 4 20 0 4 8 0 2 0 8 0 2 12 2 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1 1 0 1 0 0 1 0 1 0 0 0 1 1 0 0 1 1 1 0 0 0 1 0 1 0 1 1 1 1 0 1 0 1 0 1 1 1 0 0 1 0 1 1 0 0 1 0 0 1 0 1 1 0 1 1 1 1 0 1 0 1 1 1 0 1 1 0 0 1 1 0 1 1 0 1 0 1 0 0 1 0 1 1 0 0 1 1 1 1 0 1 1 0 1 1 0 1 0 0 1 0 0 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 0 1 0 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 0 1 1 0 1 1 1 1 2 4 5 4 3 3 3 2 2 5 4 5 4 4 3 5 4 1 3 4 3 3 2 4 3 2 2 2 3 5 4 4 4 3 3 4 3 3 2 4 3 3 5 2 3 2 4 5 5 3 5 4 2 5 2 5 2 5 5 5 4 5 4 2 5 2 3 5 5 4 3 5 4 5 3 5 3 4 1 4 5 4 5 2 4 2 5 5 5 5 3 5 3 2 3 2 4 3 5 4 5 1 1 5 4 1 5 1 1 1 3 1 4 2 16 4 4 3 12 4 4 14 19 30 2 4 2 14 4 0 13 0 1 9 13 8 8 8 4 6 0 0 15 0 10 11 2 0 3 0 22 9 0 14 2 13 11 8 5 0 0 12 0 16 0 14 0 17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 1 1 0 0 0 1 0 1 1 0 1 0 1 0 1 0 1 0 1 0 1 0 0 0 0 0 1 0 0 1 1 0 1 0 0 0 1 0 1 1 0 0 0 0 0 0 1 1 1 0 0 0 1 0 0 1 0 1 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 0 1 1 1 1 3 4 2 3 3 3 2 4 4 4 1 2 1 3 3 3 3 4 5 4 5 4 3 4 5 4 3 4 2 3 3 2 4 4 3 5 3 5 1 4 4 5 5 1 2 5 4 1 5 3 4 1 5 2 3 3 2 3 5 5 3 3 5 2 3 3 5 5 2 5 4 8 2 0 2 2 10 7 0 4 0 0 0 0 0 0 0 0 4 2 2 3 4 5 10 14 3 0 4 4 7 0 4 8 0 Build a Regression Model Review the information in the Code Book to understand the underlying data You will build a regression model to explain or predict student grade performance in Portugues (GradePor). Initial Test Run the regression on all possible predictors to first determine which should be included in the model Coefficientp-Value Intercept GradeMath School Gender Age Urban Pstatus ParTeacher StudyTime Failures SchoolSup FamSup Activities Higher FreeTime Health Absenses R Square Final Regression Model Run as many regressions are necessary to obtain the best fit for the data Enter the names of the independent variables and their values below for only the variables included in the final model Coefficientp-Value Intercept R Square Change 0 R Square change from initial model How did you determine which variables to use in the final model? What does R-Square indicate about the final model? What does the change of the R Square from the initial model indicate? Consider the variables included/excluded and the direction (positiveegative) of the final coefficients. What are a few main callouts/observations you can make about the final model and specific variables? Point Estimate Use your final regression model to calculate an estimate for a student's grade in Portuguese Student's Data GradeMath School Gender Age Urban Pstatus ParTeacher StudyTime Failures SchoolSup FamSup Activities Higher FreeTime Health Absenses 11 1 1 15 0 1 0 3 0 1 1 1 1 3 5 2 Student's math grade School: Gabriel Pereira Female Age Lives in rural setting Parents live together Parents are not teachers Studies 5 to 10 hours weekly No prior class failures Receives additional school support Has family support Involved in extra-curricular activities Wants to attend higher education Average free time Very good health 2 school absenses Predicted Observed Error Your predication based on your final regression model 12 Actual student performance -12.00 Difference (residual) of actual performance to model prediction s (GradePor). cluded in the final model nal coefficients. ecific variables