Suppose that HR manager at COMPANY ABC, a large multi-institutional organization, wants to analyze the data from a recent “Morale Survey” with managers at different locations, and that you have been asked to design this email survey. You have not completed the design of the survey, but you do know that you want to include items that ask managers how satisfied they are with their jobs (ITEM #30), and also their likelihood of leaving the employment at ABC sometime during the next 2 years (ITEM #18).

Suppose that you want to study the relationship between these twos survey items.

Create an Excel spreadsheet and enter the data using JOB SATISFACTION as the independent (predictor) variable, and LIKELY TO LEAVE ABC as the dependent (criterion) variable. You decide to test your Excel skills on last year’s data using the hypothetical data presented in Fig. 6.34.

(a) create an XY scatterplot of these two sets of data such that:
• top title: RELATIONSHIP BETWEEN JOB SATISFACTION AND • LIKELIHOOD OF LEAVING ABC • x-axis title: JOB SATISFACTION • y-axis title: LIKELIHOOD OF LEAVING ABC • re-size the chart so that it is 7 columns wide and 25 rows long • delete the legend • delete the gridlines • move the chart below the table

(b) Create the least-squares regression line for these data on the scatterplot.

(c) Use Excel to run the regression statistics to find the equation for the leastsquares regression line for these data and display the results below the chart on your spreadsheet. Use number format (two decimal places) for the correlation, r, and three decimal places for both the y-intercept and the slope of the line. Change all other decimal figures to four decimal places.

(d) Print the input data and the chart so that this information fits onto one page.

(e) Then, print out the regression output table so that this information fits onto a separate page.
By hand:
(1a) Circle and label the value of the y-intercept and the slope of the regression line on the regression output table that you just printed.
(2b) Read from the graph the likelihood of leaving ABC you would predict for a JOB SATISFACTION score of 6, and write your answer in the space immediately below:
_____________________

(f) save the file as: SATIS16