Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 | Science residual plot ? maths residual plot? and predicted SAT model? | |||||||||||||||||||||||||
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started