Use that regression equation to predict the LIKELIHOOD OF LEAVING ABC you would expect for a JOB SATISFACTION score of 5.

(Note that this correlation is not the multiple correlation as the Excel table indicates, but is merely the correlation, r, instead.)

But how does Excel treat negative correlations?

when there is a negative correlation between the two variables under study.
You know that the correlation is negative when:
(1) The slope,

b, is a negative number, which can only occur when there is a negative correlation.
(2) The chart clearly shows a downward slope in the regression line, which can only happen when the correlation is negative.

Note that you found a negative correlation of
.39 between JOB SATISFACTION and LIKELIHOOD OF LEAVING ABC. You know that the correlation is a negative correlation for two reasons: (1) the regression line slopes downward and to the right on the chart, signaling a negative correlation, and (2) the slope is
0.483 which also tells you that the correlation is a negative correlation.