A group of 11 students was selected at random and asked for their high school GPA and their freshmen GPA in college the subsequent year. The results were:Student High School GPA Freshmen GPA1 2.0 1.62 2.2 2.03 2.6 1.84 2.7 2.85 2.8 2.16 3.1 2.07 2.9 2.68 3.2 2.29 3.3 2.610 3.6 3.0I would like to know whether there is a linear relationship between the high school GPA and the college freshmen GPA, and we would like to be able to predict the freshmen GPA, if we know that the high school GPA of another student is, say, 3.4.
answer the following questions, a-h.
Then, provide the two requested scatter plots for this data (put college freshman GPA on the Y (vertical) axis!).
Enter the data into Excel, (or whatever software you have and can use,) do the regression statistics (directions below), and Scatter Plot the data.a. What is the intercept?b. What is Beta (slope)?c. What is the SE?d. What is the p-value?e. What is the R-square?f. Is there a relationship between high school and college freshmen GPA’s? What is the actual equation of the least-square regression line?g. IF a high school student had a GPA 0f 3.0, what would you predict the college freshman GPA to be?h. What would be your approximate 95% prediction interval for question (g)?i. Copy/paste your scatter plot belowj. Copy/paste your scatterplot with the predicted trend line below
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here