Jorge Jones, a recent management graduate has a new job as ashelf stocker at the local Shop and Stop (bad job market). In orderto maintain some of the knowledge he gained in college, Jorge wantsto apply regression analysis to predict weekly sales on the cerealaisle.

He believes there would be a relationship between the shelfspace that a particular product takes up and the sales of thatproduct. Jorge has gathered the following data:

Shelf Space	Weekly Sales
5	160
16	230
7	220
15	270
6	140
17	280
10	190
21	260
11	240
25	350
14	260
22	310

a. Which is the independent/explanatory variable?

b. Which is the dependent/response variable?

Enter the data into an Excel spreadsheet.

c. Create a scatterplot for these data. How would you interpretthe scatterplot?

Run a regression analysis using Data Analysis/RegressionTool and use the output to answer the following questions:

d. What is the value of the correlation coefficient? How wouldyou interpret it?

e. What is the value of the coefficient of determination? Howwould you interpret it?

f. Write the hypotheses for the test of the slope.

g. What is the p-value for the test of the slope? How would youinterpret the p-value?

h. What is the regression formula resulting from this analysisbetween Shelf Space and Weekly Sales?

i. Use the regression formula to estimate the Weekly Sales for aproduct that has a Shelf space of 23.

j. Use the regression formula to estimate the Weekly Sales for aproduct that has a Shelf space of 8.