The Human Resource Department at Neumann University would like to examine the linear relationship between a faculty member’s performance rating (measured on a scale of 1– 20) and his or her annual salary increase. The following table shows these data for eight randomly selected faculty members and can also be found in the Excel file Neumann. xlsx.

a. Construct a scatter plot for these data using Excel.

b. Using α = 0.05, determine if the slope for the regression equation is statistically significant.

Transcribed Image Text:

tating Incras ncease () 16 18 12 13 2.400 2.500 1,800 1,700 15 15 17 16 2,000 2,600 2.000 1,900