1. All data files are available separately. Go to data files and scroll down to use only the data files you need. 2. Put all your answers in ONE-word file 3. You can also upload ONE excel file that has all the calculations. 4. Interpret the results in ALL the questions. I want you to explain what the results mean in the context of the problem. The school success dataset includes numerical and categorical variables from a study comparing success of students at a Portuguese University. The data is for first year students who come from two schools “GP” and “MS.” The data contains the following variables school sex age First in Family traveltime studytime failures absences Grade Binary variable =0 if school is "GP" and =1 if school is "MS" Binary variable =0 if Male and =1 if Female Age in years Binary variable =1 if they are the first in their family to go to college =0 otherwise Binary variable =0 if travel time to school is less than 30 minutes =0 otherwise Binary variable =0 if weekly study time is less than 5 hours =1 otherwise No. of classes failed in first year No. of absences in first year Final grade on a scale of 0-100 Q1: Using the data calculate summary statistics for the following variables: Variable: Mean Median Std. Dev Minimum Maximum Q1 Q3 IQR Grade Age Failures Absences No. of Outliers Write one paragraph (5-6 sentences) describing the data above. Q2: “Students who study more than 5 hours score better than those who don’t.” Conduct a hypothesis test where the alternate hypothesis is that the average grade of students who study more than 5 hours is higher than the average grade of students who study less than hours. What is the result of the Hypothesis test? (Find the test statistic and the p-value) Q3: Can we predict the grade using all the other variables in the data file? Do regression analysis with grade as the dependent variable and all the other variables as independent variables. Answer the questions below and provide evidence for all your answers. 1. What is the regression equation? 2. Is the regression significant? 3. Which variables are significant? 4. Interpret the meaning of the coefficient for the variable “Sex” 5. What is the value of R2? Interpret its meaning.
Purchase answer to see full attachment