Question: heres the excel data The SAT has gone through many revisions over the years. People argue that femole students generally do worse on math sests


The SAT has gone through many revisions over the years. People argue that femole students generally do worse on math sests but better on writing tests. The accomponying dota fle shows a student's score on the writing and meth sections of the SAT (Wring ond Moth, respectively. the student's GPA and a Female dummy voriable that equals t if the student is fernale, 0 otherwise. Click here for the Ercelonta Fils a.1. Estimate a linear regression model with Writing as the response variable and GPA and Femble as the predictor vanebles. Note: Negetive values should be indicated by a minus sign. Round your onswers to 2 decimal ploces. 6.2. Compute the predicted writing score for a mole student with a GPA of 3.5 . Repeot the computation for a female student Note: Do not round intermediote caleulations. Round final answers to the nearest whole number. \begin{tabular}{|c|c|c|c|c|} \hline Wating & Math & GPA & Female \\ \hline & 620 & 600 & 3.44 & 0 \\ \hline 570 & 550 & 3.04 & 0 \\ \hline 540 & 540 & 2.67 & 0 \\ \hline 580 & 610 & 3.29 & 0 \\ \hline \hline 590 & 590 & 3.36 & 0 \\ \hline 550 & 520 & 2.88 & 1 \\ \hline 580 & 610 & 3.2 & 0 \\ \hline 480 & 510 & 2.3 & 0 \\ \hline 590 & 570 & 3.17 & 1 \\ \hline 620 & 660 & 3.71 & 0 \\ \hline 530 & 520 & 2.38 & 0 \\ \hline 610 & 600 & 3.25 & 1 \\ \hline \hline 600 & 530 & 3.13 & 1 \\ \hline 640 & 580 & 3.51 & 1 \\ \hline 540 & 570 & 2.82 & 1 \\ \hline 540 & 500 & 2.38 & 0 \\ \hline 560 & 620 & 3.39 & 0 \\ \hline 560 & 550 & 2.78 & 0 \\ \hline 540 & 590 & 3.03 & 0 \\ \hline 540 & 520 & 2.84 & 0 \\ \hline \end{tabular} Note: Do not round internediate calculotions, Round final onswers to the neorest whole number. b-1. Estimate a linear regression model with Moth os the response variable and GPA and female as the predictor varisbles. Note: Negative values ahould be indicoted by a minus siga. Round your answers to 2 decimal places. b-2. Compute the predicted math score for a male and fomole student with a GPA of 35 : Note: Do not round intermediate colculations. Round final answers to the nearest whole number
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
