Access Millions of academic & study documents

Solnexcel

Content type
User Generated
Subject
Excel
Type
Homework
Showing Page:
1/21

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/21

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/21

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 21 pages?
Access Now
Unformatted Attachment Preview
Student Grades 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Midterm Final Exam 76 65 84 90 79 68 88 84 76 61 66 79 77 73 94 93 66 60 92 86 80 53 87 83 86 55 63 72 92 87 75 89 69 81 92 94 79 78 60 71 68 84 71 74 61 74 68 54 76 94 72 79 99 89 58 53 82 78 72 82 77 69 95 98 72 93 71 80 72 82 96 96 72 61 89 84 94 97 85 89 60 72 66 93 96 84 83 87 88 99 92 97 78 92 85 93 91 78 Scatter plot midterm vs final 120 100 Final Exam Student 80 60 40 20 0 0 20 40 60 Midterm The regression model is: Midterm score: Predicted Final Exam: y = 0.6192x + 31.739 70 75.083 80 50 51 52 53 54 55 56 74 96 80 62 70 87 89 82 99 72 79 75 90 95 dterm vs final y = 0.6192x + 31.739 R² = 0.3006 80 100 120 SUMMARY OUTPUT Home Market Value 33 32 32 33 32 1,812 1,914 1,842 1,812 1,836 $90,000.00 $104,400.00 $93,300.00 $91,000.00 $101,900.00 Regression Statistics Multiple R 0.745494776 R Square 0.555762462 Adjusted R Square 0.532981049 Standard Error 7211.848497 Observations 42 33 32 2,028 1,732 $108,500.00 $87,600.00 ANOVA 33 32 33 32 1,850 1,791 1,666 1,852 $96,000.00 $89,200.00 $88,400.00 $100,800.00 Regression Residual Total 32 1,620 $96,700.00 32 32 32 33 1,692 2,372 2,372 1,666 $87,500.00 $114,000.00 $113,200.00 $87,500.00 32 32 32 32 28 27 28 28 28 28 28 27 28 28 28 27 27 28 27 28 28 27 27 28 27 27 2,123 1,620 1,731 1,666 1,520 1,484 1,588 1,598 1,484 1,484 1,520 1,701 ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Documents