solution

Jennifer Dahl, supervisor of the Circle O discount chain, would like to forecast the time it takes to check out a customer. She decides to use the following independent variables: number of purchased items and total amount of the purchase. She collects data for a sample of 18 customers, shown in Table P-8.

 a. Determine the best regression equation.

 b. When an additional item is purchased, what is the average increase in the checkout time?

c. Compute the residual for customer 18.

d. Compute the standard error of the estimate.

e. Interpret part d in terms of the variables used in this problem.

 f. Compute a forecast of the checkout time if a customer purchases 14 items that amount to $70.

 g. Compute a 95% interval forecast for your prediction in part f.

h. What should Jennifer conclude?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

 What does the partial, or net, regression coefficient measure in multiple regression?  What does the standard error of the estimate measure in multiple regression? Most computer solutions for multiple regression begin with a correlation matrix. Examining this matrix is often the first step when analyzing a regression problem that involves more than one independent variable. Answer the following questions concerning the correlation matrix given in Table P-7.

 a. Why are all the entries on the main diagonal equal to 1.00?

b. Why is the bottom half of the matrix below the main diagonal blank?

 c. If variable 1 is the dependent variable, which independent variables have the highest degree of linear association with variable 1?

d. What kind of association exists between variables 1 and 4?

 e. Does this correlation matrix show any evidence of multicollinearity?

 f. In your opinion, which variable or variables will be included in the best forecasting model? Explain.

g. If the data given in this correlation matrix are run on a stepwise program, which independent variable (2,3,4,5, or 6) will be the first to enter the regression function?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

We might expect credit card purchases to differ from cash purchases at the same store. Table P-15 contains daily gross sales and items sold for cash purchases and daily gross sales and items sold for credit card purchases at the same consignment store for 25 consecutive days.

a. Make a scatter diagram of daily gross sales, Y, versus items sold for cash purchases, using a separate plot symbol or color, add daily gross sales and items sold for credit card purchases, visually compare the relationship between sales and number of items sold for cash with that for credit card purchases.

 

b. Define the dummy variable

c. Analyze the fit in part b. Be sure to include an analysis of the residuals. Are you happy with your model?

 d. Using the fitted model from part b, generate a forecast of daily sales for an individual that purchases 25 items and pays cash. Construct a large-sample 95% prediction interval for daily sales.

e. Describe the nature of the fitted function in part b. Do you think it is better to fit two separate straight lines, one for the cash sales and another for the credit card sales, to the data in Table P-15? Discuss.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Cindy Lawson just bought a major league baseball team. She has been receiving a lot of advice about what she should do to create a winning ball club. Cindy asks you to study this problem and write a report. You decide to use multiple regression analysis to determine which statistics are important in developing a winning team (measured by the number of games won during the 1991 season). You gather data for six statistics from the Sporting News 1992 Baseball Yearbook, as shown in Table P-16, and run a stepwise regression program, assuming a multiple regression model with “Wins” as the dependent variable.

 a. Discuss the importance of each independent variable.

b. What equation should Cindy use to forecast wins?

 c. Write a report for Cindy.

 d. Collect data from the most recent Sporting News Baseball Yearbook or other source of baseball statistics. Run a stepwise regression, and compare your results.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"