Question: Using the subject marks in English, Science, and Math in Grade 12 students, design a model to predict scores in SAT university admissions exam The
Science residual plot ? maths residual plot? and predicted SAT model?
Using the subject marks in English, Science, and Math in Grade 12 students, design a model to predict scores in SAT university admissions exam The SAT exam is conducted by US for undergraduate admissions English Science Math SAT 80 75 80 152 The data has following variables: 88 93 97 185 English - Marks in English in Grade 12 class 91 90 95 180 Science - Marks in Science in Grade 12 class 98 100 105 196 Math- Marks in Math/Calculus in Grade 12 class 66 70 71 142 SAT- Score in student SATs for US Undergraduate admissions exam 46 55 58 101 74 77 78 149 56 60 65 115 79 90 93 175 70 88 91 164 70 73 78 141 Questions 65 74 78 141 1. A regression model that predicts SAT scores based on these 3 subjects. Is the model you created a good model or a bad model? Why or why not? Which of the subjects is the best predictor when it comes to SAT Scores? 95 91 96 184 2. The regression equation for predicting SAT Scores using all subject marks in Science, Math, and English 80 73 74 152 73 78 81 148 Have to use excel. 89 96 100 192 75 68 73 147 90 93 97 183 92 86 90 177 83 77 79 159 86 90 91 177 82 89 94 175 83 85 87 175 83 71 75 149
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
