You work in the corporate office for a nationwide convenience store franchise that operates nearly 10,000 stores.

Question:

You work in the corporate office for a nationwide convenience store franchise that operates nearly 10,000 stores. The per-store daily customer count (i.e., the mean number of customers in a store in one day) has been steady, at 900, for some time. To increase the customer count, the chain is considering cutting prices for coffee beverages. The question to be determined is how much prices should be cut to increase the daily customer count without reducing the gross margin on coffee sales too much. You decide to carry out an experiment in a sample of 24 stores where customer counts have been running almost exactly at the national average of 900. In six of the stores, the price of a small coffee will now be $0.59, in six stores the price of a small coffee will now be $0.69, in six stores, the price of a small coffee will now be $0.79, and in six stores, the price of a small coffee will now be $0.89. After four weeks at the new prices, the daily customer count in the stores is determined and is stored in CoffeeSales2 .

a. Construct a scatter plot for price and sales.

b. Fit a quadratic regression model and state the quadratic regression equation.

c. Predict the mean weekly sales for a small coffee priced at 79 cents.

d. Perform a residual analysis on the results and determine whether the regression model is valid.

e. At the 0.05 level of significance, is there a significant quadratic relationship between weekly sales and price?

f. At the 0.05 level of significance, determine whether the quadratic model is a better fit than the linear model.

g. Interpret the meaning of the coefficient of multiple determination.

h. Compute the adjusted r2.

i. What price do you recommend the small coffee should be sold for?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Statistics For Managers Using Microsoft Excel

ISBN: 9780134173054

8th Edition

Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat

Question Posted: