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.

Rating Increase ($) Rating Increase ($)

16 2,400 15 2,000 18 2,500 15 2,600 12 1,800 17 2,000 13 1,700 16 1,900

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

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

AppendixLO1