GMAT GPA 310 3.1 GNIAT GPA 350 4.0 21Q 3.0 300 3.1 300 3.0 lor\ 260 280 3.0 3,1 3.2 a. Calculate the slope and y-in1sLept fbr the linear regression equfltion for these data. b. Verify your results using Excel. 14.21 Use the data from Problem 14.20 to answer the followine questions: a. Calculate the SS?' b. Partition the SST into the S,SR and SSE. c. Calculate the sample coefficiEnt of determination. d. Test the significance of the population coeftlcient of determination usins a : 0.05,
Together we will work the following problem: Applications ta.g6 Thc Human Resourc:e Department at Neumann Universily would like to exarnine the linear relationsbip between a taculty menrber's pertbnnance rating (tneasured on a scale of l-20) and his or her annual salary inct'ease. The f<lllowing table shows these data for eiglrt randontly se- lected laculty memhers and can also be found in tbe Excel file Neumann.xlsx. Rating Increase ($) t6 zAm l8 2,500 t2 r,800 13 I,700 Rating Increase ($) t5 2,000 t5 2,600 t1 2,000 16 r.900 a. Construct a scatler plot fbr these data using Excel.
You've reached the end of your free preview.
Want to read all 4 pages?