As a measure of productivity, Verizon Wireless records the number of customers each of its retail employees activates weekly. An activation is defined as either a new customer signing a cell phone contract or an existing customer renewing a contract. The following table shows the number of weekly activations for eight randomly selected employees along with their job-satisfaction levels rated on a scale of 1–10 110 = Most satisfied2. These data can also be found in the Excel file activations.xlsx.

Activations Satisfaction Activations Satisfaction 36 8.0 19 6.1 25 7.9 28 7.0 40 8.5 33 8.2 38 9.0 25 7.7

a. Construct a scatter plot for these data.

b. Calculate the slope and the y-intercept for the regression equation.

c. Provide an interpretation for the value of the slope.

d. Predict the number of activations next week for an employee with a satisfaction level of 7.5.

e. Calculate the SST.

f. Partition the SST into the SSR and the SSE.

g. Verify your results using Excel.

AppendixLO1