Name: T.A. name/Class time: MW Lecturer: Lab 10: Simple Linear Regression We are now interested in describing the relationship between the hours of sleep on a school night and the subject's grade point average. Can we predict Sleep_Duration using GPA? Refer to pages 13, 14 and 15 of in the SPSS Instruction Manual for this lab. 1. (2 points) GPA is the explanatory variable, and Sleep_Duration is the response variable. Create a scatterplot of the data in SPSS. Describe the form, direction, and strength of the relationship. Identify any outliers on your graph. 2. (1 point) Add the least squares regression line to the scatterplot from #1. Add this graph to your output. 3. (2 points) What is the correlation between the two variables? Include the output which contains the Pearson's correlation and the state the value below. 4. (1 point) Run the regression in SPSS. Include a copy of the model summary table and the coefficients table in your output. 5. (2 points) What percent of variation in Sleep_Duration is explained by the least squares regression line? Comment on whether this number is good or bad. (What do we like this value to be?) 6. (2 points) What is the equation of the least-squares regression line? Be sure to identify your variables by name, not just x and y. Also, remember to put a \"hat\" (^) on the response variable. 1 7. (2 points) Calculate (by hand, showing your work) the predicted Sleep_Duration when the GPA is 2.801. 8. (2 points) Calculate (by hand, showing your work) the residual for the 12th Grade female in the dataset with GPA of 2.801. (Hint: see calculations for the previous problem and the information for the subject with SubjectID=89 in the dataset.) 9. (2 points) Use SPSS to calculate a 95% individual prediction interval for the Sleep_Duration of the 12th Grade female subject above. Refer to pages 13 and 14 in the SPSS Instruction Manual. 10. (2 points) Make a Normal probability plot of the residuals. Attach the graph as part of your work. (1 point) Do the points fall around the 45 degree line? (Yes or No) (1 point) Does the distribution of the residuals look Normal? (Yes or No) 11. (2 points) Make a residual plot with a y = 0 reference line. Make sure that the explanatory variable is in the x-axis and the residual is in the y-axis. Attach the graph as part of your work. Refer to pages 13 and 15 in the SPSS Instruction Manual. (0.5 points) Do the residuals fall randomly around the 0 reference line? (Yes or No) (0.5 points) Can you find any clear pattern in the residual plot? (Yes or No) (1 point) Please circle any outliers in the residual plot. If there are no outliers, explain how this is determined from the plot. 2 Subject ID Gender 1 female 2 male 3 male 4 male 5 female 6 female 7 male 8 male 9 male 10 male 11 male 12 female 13 female 14 male 15 female 16 male 17 female 18 male 19 female 20 male 21 female 22 male 23 male 24 male 25 male 26 male 27 male 28 male 29 male 30 male 31 male 32 male 33 female 34 male 35 male 36 male 37 male 38 male 39 female 40 male 41 female 42 male 43 male 44 male 45 male 46 female 47 male Gender_NuGradeLevelGradeLevelGPA 1 junior 11 2 freshman 9 2 sophmore 10 2 freshman 9 1 freshman 9 1 freshman 9 2 junior 11 2 freshman 9 2 sophmore 10 2 freshman 9 2 sophmore 10 1 junior 11 1 senior 12 2 senior 12 1 freshman 9 2 senior 12 1 sophmore 10 2 freshman 9 1 sophmore 10 2 sophmore 10 1 senior 12 2 junior 11 2 sophmore 10 2 sophmore 10 2 sophmore 10 2 junior 11 2 junior 11 2 sophmore 10 2 sophmore 10 2 junior 11 2 senior 12 2 freshman 9 1 freshman 9 2 sophmore 10 2 freshman 9 2 junior 11 2 freshman 9 2 sophmore 10 1 junior 11 2 senior 12 1 senior 12 2 sophmore 10 2 sophmore 10 2 freshman 9 2 sophmore 10 1 senior 12 2 sophmore 10 AverageGra 1.312 D 1.508 C 2.476 C 1.797 C 2.441 C 1.844 C 2.125 C 2.190 C 1.742 C 2.188 C 2.165 C 2.532 B 2.264 C 2.926 B 1.557 C 1.073 D 2.389 C 2.126 C 2.300 C 2.335 C 2.256 C 2.884 B 2.818 B 2.143 C 2.066 C 2.973 B 3.581 A 2.422 C 1.775 C 2.397 C 2.656 B 2.501 B 2.649 B 2.650 B 1.725 C 2.297 C 2.852 B 2.479 C 2.390 C 2.791 B 2.881 B 2.272 C 2.714 B 1.791 C 2.613 B 2.546 B 2.621 B 48 female 49 female 50 female 51 female 52 female 53 male 54 male 55 female 56 male 57 female 58 male 59 male 60 female 61 female 62 female 63 female 64 male 65 female 66 female 67 male 68 female 69 male 70 female 71 female 72 male 73 male 74 male 75 female 76 male 77 female 78 female 79 female 80 female 81 female 82 female 83 female 84 female 85 female 86 female 87 female 88 female 89 female 90 female 91 male 92 female 93 female 94 female 95 male 1 freshman 1 senior 1 senior 1 junior 1 freshman 2 sophmore 2 sophmore 1 freshman 2 freshman 1 senior 2 freshman 2 sophmore 1 junior 1 senior 1 senior 1 freshman 2 junior 1 sophmore 1 junior 2 sophmore 1 freshman 2 sophmore 1 junior 1 freshman 2 junior 2 junior 2 sophmore 1 sophmore 2 junior 1 sophmore 1 sophmore 1 senior 1 sophmore 1 freshman 1 sophmore 1 senior 1 freshman 1 junior 1 sophmore 1 freshman 1 senior 1 senior 1 senior 2 junior 1 senior 1 sophmore 1 junior 2 sophmore 9 12 12 11 9 10 10 9 9 12 9 10 11 12 12 9 11 10 11 10 9 10 11 9 11 11 10 10 11 10 10 12 10 9 10 12 9 11 10 9 12 12 12 11 12 10 11 10 2.077 C 2.659 B 2.552 B 2.416 C 2.217 C 2.245 C 2.699 B 2.591 B 2.930 B 2.643 B 2.983 B 2.329 C 2.264 C 2.235 C 3.025 B 2.129 C 2.785 B 2.718 B 2.690 B 2.197 C 3.562 A 2.432 C 2.640 B 2.725 B 2.728 B 2.646 B 2.753 B 3.503 A 2.561 B 2.053 C 2.566 B 2.983 B 2.263 C 2.538 B 2.013 C 2.661 B 3.509 A 1.810 C 2.979 B 3.158 B 2.640 B 2.801 B 2.508 B 3.232 B 2.863 B 3.458 B 3.267 B 2.978 B 96 female 1 sophmore 10 3.229 B Athlete yes yes yes yes no yes no yes yes yes no yes yes no yes yes yes yes yes yes no yes no yes no yes yes no yes no no yes yes yes yes no yes yes yes no yes no yes yes no yes no DaytimeSleAdequateSlDSS yes no yes no yes no yes no yes no yes no yes yes no yes yes no no yes yes no yes yes no yes yes no no yes no yes yes no no yes no no no no no yes no yes no yes no yes no yes no yes yes no no yes yes no yes no no yes no yes yes no yes no no yes yes no yes yes no no no yes no yes no yes no yes no yes no yes no yes no yes yes no Sleep_DuraOtherActiviMessagingB 1 5.53 11.1 1.61 1 5.90 12.8 2.75 1 5.99 9.2 1.83 1 6.07 14.3 2.26 1 6.24 11.6 1.81 1 6.24 20.6 1.96 2 6.27 21.5 4.38 2 6.32 20.4 1.33 1 6.33 12.0 2.27 3 6.36 13.4 3.55 1 6.36 17.2 4.03 1 6.38 9.6 3.23 3 6.39 11.5 1.17 1 6.56 8.9 0.48 3 6.57 14.5 2.34 2 6.58 7.2 1.26 0 6.59 9.2 2.4 3 6.59 12.1 2.25 2 6.62 11.0 0.63 2 6.62 13.5 1.37 2 6.64 11.7 6.15 3 6.66 21.7 4.65 3 6.67 10.7 1.01 2 6.70 11.5 1.32 3 6.71 15.5 1.07 2 6.72 6.9 2.12 1 6.72 14.2 2.93 2 6.73 12.8 0.33 0 6.76 6.7 1.73 0 6.77 17.5 1.17 2 6.78 14.7 1.54 3 6.80 12.1 3.93 0 6.80 16.9 0.63 0 6.82 4.8 2.06 2 6.82 13.3 1.16 0 6.83 12.9 2.18 1 6.86 16.2 1.25 2 6.86 19.1 1.21 2 6.87 8.7 0.74 3 6.87 10.4 3.74 2 6.88 16.0 1.06 2 6.92 8.6 1.35 3 6.95 10.9 0.91 2 6.96 11.3 4.04 2 6.97 21.4 0.43 2 6.98 15.8 0.37 0 7.00 13.2 0.89 no yes no yes no no yes yes no yes no yes yes yes yes no no no no no no yes no no yes no no no yes no no no yes yes yes yes no no no no no yes no no no no yes no no yes yes yes yes no yes yes no no no no no yes yes no no yes yes no no no no no no yes no yes no no no no no no no no no no yes no no yes yes yes yes no yes yes yes no no no no yes no no yes yes yes yes yes no no yes yes no no yes yes no yes yes yes no yes no yes yes yes no yes no yes no yes yes no yes yes no no no yes yes no no 2 0 0 0 0 2 1 0 2 2 2 2 2 0 0 2 2 0 1 2 3 1 2 2 2 0 2 0 2 3 2 1 2 1 2 1 2 2 0 2 2 0 0 0 1 2 0 0 7.03 7.04 7.07 7.07 7.08 7.09 7.11 7.13 7.14 7.15 7.18 7.20 7.22 7.23 7.23 7.24 7.26 7.26 7.27 7.28 7.30 7.33 7.33 7.35 7.39 7.41 7.42 7.47 7.49 7.50 7.53 7.54 7.55 7.60 7.60 7.62 7.66 7.69 7.72 7.73 7.75 7.82 7.82 7.91 7.94 8.03 8.07 8.23 26.0 8.9 12.5 16.7 10.2 12.0 10.0 11.9 16.0 7.2 8.8 18.1 6.3 14.2 15.3 11.5 9.5 13.9 8.0 12.0 6.5 13.2 13.3 9.0 11.2 14.8 15.1 6.6 18.8 11.0 12.7 9.2 11.3 15.1 17.4 13.3 11.6 12.2 15.8 9.9 10.4 7.9 13.9 16.1 12.1 14.0 15.4 14.2 0.28 1.06 5.68 4.34 0.75 1.45 2.15 1.15 2.31 0.86 1.62 0.68 3.84 3.6 1.27 1.04 0.96 0.59 1.14 2.04 1.93 1.4 0.17 1.52 1.39 0.68 1.77 2.66 0.08 1.45 2.97 1.69 1.79 0.72 1.24 0.59 0.72 0.35 1.9 0.97 0.53 1.28 1.09 1.1 1.28 0.37 0.7 0.89 no yes no 0 8.30 7.2 0.08 MessagingANumberNapMessagingDuration SchoolTypeState 3.43 7.0 5.04 suburban-pr Texas 2.54 5.0 5.29 suburban-pr Texas 2.08 7.0 3.91 suburban-pu Texas 2.13 4.0 4.39 suburban-pu Texas 1.91 4.0 3.72 suburban-pr Texas 2.22 5.0 4.18 suburban-pu Texas 2.09 4.0 6.47 urban-publiTexas 1.93 3.0 3.26 suburban-pu Texas 2.45 5.0 4.72 suburban-pr Texas 2.53 4.0 6.08 suburban-pr Texas 2.17 5.0 6.20 suburban-pr Texas 2.07 3.0 5.30 urban-publiTexas 1.59 5.0 2.76 suburban-pu Texas 2.35 6.0 2.83 suburban-pu Texas 2.29 4.0 4.63 suburban-pu Texas 2.16 2.0 3.42 urban-publiTexas 2.66 2.0 5.06 suburban-pu Texas 1.87 3.0 4.12 suburban-pu Texas 1.88 6.0 2.51 suburban-pu Texas 1.38 12.0 2.75 suburban-pr Texas 1.92 2.0 8.07 suburban-pu Texas 1.76 3.0 6.41 urban-publiTexas 1.43 6.0 2.44 suburban-pr Texas 1.73 1.0 3.05 suburban-pu Texas 1.26 4.0 2.33 suburban-pr Texas 1.17 1.0 3.29 suburban-pr Texas 1.83 3.0 4.76 suburban-pu Texas 1.72 3.0 2.05 suburban-pu Texas 1.84 2.0 3.57 urban-publiTexas 1.80 2.0 2.97 suburban-pu Texas 2.34 2.0 3.88 suburban-pr Texas 1.13 3.0 5.06 suburban-pr Texas 2.19 1.0 2.82 suburban-pu Texas 2.03 1.0 4.09 suburban-pu Texas 1.97 2.0 3.13 suburban-pu Texas 1.73 1.0 3.91 suburban-pr Texas 1.93 1.0 3.18 urban-publiTexas 1.47 4.0 2.68 urban-publiTexas 1.55 1.0 2.29 urban-publiTexas 1.91 3.0 5.65 urban-publiTexas 1.46 2.0 2.52 suburban-pu Texas 1.57 2.0 2.92 suburban-pr Texas 1.40 4.0 2.31 suburban-pr Texas 1.46 3.0 5.50 suburban-pu Texas 1.61 3.0 2.04 suburban-pr Texas 1.27 2.0 1.64 urban-publiTexas 1.81 3.0 2.70 suburban-pu Texas 1.23 2.08 1.38 1.20 1.78 1.31 1.65 1.17 1.41 1.85 1.50 1.51 1.68 0.94 1.05 1.07 1.17 1.85 1.07 1.55 1.49 1.30 0.81 0.95 0.76 1.14 0.77 0.68 0.68 0.76 1.32 1.03 1.02 1.41 1.08 0.84 1.14 1.10 0.72 0.84 0.74 1.39 0.90 0.48 0.69 0.28 0.28 0.37 1.0 0.0 1.0 0.0 1.0 1.0 4.0 1.0 2.0 0.0 1.0 0.0 0.0 0.0 2.0 0.0 1.0 1.0 10.0 1.0 9.0 1.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 3.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 1.51 suburban-pu Texas 3.14 suburban-pu Texas 7.06 urban-publiTexas 5.54 suburban-pu Texas 2.53 urban-publiTexas 2.76 urban-publiTexas 3.80 urban-publiTexas 2.32 suburban-pu Texas 3.72 suburban-pu Texas 2.71 urban-publiTexas 3.12 suburban-pr Texas 2.19 suburban-pu Texas 5.52 suburban-pu Texas 4.54 urban-publiTexas 2.32 urban-publiTexas 2.11 urban-publiTexas 2.13 suburban-pr Texas 2.44 suburban-pu Texas 2.21 suburban-pr Texas 3.59 urban-publiTexas 3.42 suburban-pu Texas 2.70 urban-publiTexas 0.98 suburban-pu Texas 2.47 suburban-pu Texas 2.15 suburban-pr Texas 1.82 suburban-pu Texas 2.54 urban-publiTexas 3.34 suburban-pu Texas 0.76 suburban-pu Texas 2.21 suburban-pu Texas 4.29 urban-publiTexas 2.72 suburban-pu Texas 2.81 urban-publiTexas 2.13 urban-publiTexas 2.32 urban-publiTexas 1.43 suburban-pu Texas 1.86 suburban-pu Texas 1.45 suburban-pu Texas 2.62 suburban-pu Texas 1.81 suburban-pr Texas 1.27 urban-publiTexas 2.67 suburban-pr Texas 1.99 suburban-pu Texas 1.58 suburban-pu Texas 1.97 suburban-pu Texas 0.65 suburban-pu Texas 0.98 suburban-pr Texas 1.26 suburban-pr Texas 0.09 0.0 0.17 urban-publiTexas