Question #28 14803.179302.211360800 900 1000 1100 1200 13ỏo 1400 15003.708502.43Standardized test scoreFigure 18902.7314002.94Send data to calculatorSend data to ExcelThe value of the sample correlation coefficient r for these data is approximately 0.752.Answer the following. Carry your intermediate computations to at least four decimal places, and round your answers as specified below. (If necessary, consult alist of formulas.)(a) 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.(b) 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. A popular, nationwide standardized test taken by high-school juniors and seniors may or may not measure academic potential, but we can nonetheless examinethe relationship between scores on this test and performance in college.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 standardizedtest (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 the00standardized test and y denoting the first-year college grade point average. A scatter plot of the data is shown in Figure 1.國Standardized testGrade point average, yscore, x11802.9210602.8712503.163.8-3.649903.063.412802.863.247902.302.811102.232.615203.412.49902.432214803.171.8-9302.21800 900 1000 1100 1200 1300 1400 150013603.70Standardized test score8502.43Figure 18902.732.941400Send data to calculatorSend data to Excelthoco data is approximately 0 752.Grade point average

Solution: 28. The given table of data isa. The regression equation is obtained by using excel. Procedure: Enter the data in excel. Click on Data>Data analysis>Regression. Enter the Y column in input Y range ($B$1:$B$16). Enter the X column in input X range ($A$1:$A$16). Check on labels. Click on ok. Output: From the above output, the coefficient of intercept is 1.2157 and the coefficient of X is 0.0014. Then, the slope is the value of coefficient of X. Thus, the slope of the least-squares regression line for these data is 0.0014.b. The coefficient of intercept is 1.2157. Thus, the value of the y-intercept of the least-squares regression line for these data is 1.2157.