Question

A popular, nationwide standardized test taken by high-school juniors and seniors may or may not measure academic potential, but we can nonetheless exarmiune the relationship between scores on thos test and peroracen measure academie potental. but We have chosen a random sample of fifteen students just finishing their first year of college, and for each student we've recorded her score on this standardized test (from 400 to 1600) and her grade point average (from 0 to 4) for her first year in college. The data are shown below, with x denoting the score on the standardized test and y denoting the first-year college grade point average. A scatter plot of the data is shown in Figure 1 Standardized test score, X 1010 1100 1190 1250 890 1490 1360 1060 1520 950 860 800 1410 1010 1290 Grade point average, y 3.13 2.24 2.84 3.19 2.67 3.05 3.77 2.90 3.48 2.04 2.17 2.41 3.05 2.49 3.10 3.8 3.6 3.4 3.2 2.8 2.6 2.4 2.2 2 800 900 1000 1100 1200 1300 1400 1500 Figure 1 The value of the sample correlation coefficient r for these data is approximately 0.751 Answer the following. Carry your intermediate computations to at least four decimal places, and round your answers as specified below. (If necessary, consult a list of formulas.) What is the value of the slope of the least-squares regression line for these data? Round your answer to at least four decimal places What is the value of the y-intercept of the least-squares regression line for these data? Round your answer to at least four decimal places

Answer 1

Answer Date: 11/04/2019 The least-squares regression of GPA 0) on test score (x) is. By using Excel software, find regression equation with help of following stetps 1) Import the data. 2) Select Data Analysis from Data menu 3) Select Regression and click Ok. 4) Input Y Range and Input X range. 5) Click Ok Coefficients Standard Error t Stat p-value Intercept 1.006920192454227084 2.2167771 Test score 0.001595474 0.000388935 4.1021563 0.045085407 0.001248091 From the Excel output, the least-squares regression ofGPA (V) on test score (is 1.0069 0.0016 x The value of slop of least-squares regression line is 0.0016 and the intercept of slop of least-squares regression line is 1.0069