# Lab 5.docx - Lab 5 Practice(Note numbers are truncated The...

• Lab Report
• 6
• 100% (10) 10 out of 10 people found this document helpful

This preview shows page 1 - 4 out of 6 pages.

Lab 5 / Practice: (Note numbers are truncated) The max grade for this lab is 110 but the scale is still 100 points. The 10 points are extra credit. Open SAT data, and convert it into the following format. Multiple regression. See related videos here . Click on “Data analysis,” then “Regression” 1. In dialog box for the input X-variables highlight all three columns. High school GPA, SAT, and Letters (and do not forget to include Labels)
2. In dialog box for Y-variable highlight the College GPA, click on the tab Labels, and then OK. 3. This table should appear:
Important numbers are highlighted R-square tells us about overall fit (0.399 being moderately good because R = Square Root(0.399735) = 0.632). Coefficients (y intercept and slope of each of the variable) are used for prediction. Example: Student with High school GPA = 3 and SAT = 1300 and letters = 9 is predicted to have College GPA = – 0.15326 + 3*0.37635 + 1300*0.0012269 + 0.022684*9 = 2.774957 . Standard error is 0.589 and interpretation is: This student is predicted to have College GPA = 2.7749 and the