A regional manager at Acme Markets would like to develop a model to predict weekly sales of pet food based on the shelf space. The following table shows the data collected from nine randomly selected stores and can also be found in the Excel file Acme.xlsx.

Shelf Space

(Feet)

Sales

($100)

Shelf Space

(Feet)

Sales

($100)

2 3 2 4 3 3 4 5 4 6 5 7 6 14 5 10 5 12

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 weekly sales based on four feet of shelf space.

e. Calculate the SST.

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

AppendixLO1