The Conch Caf, located in Gulf Shores, Alabama, features casual lunches with a great view of the
Question:
The Conch Café, located in Gulf Shores, Alabama, features casual lunches with a great view of the Gulf of Mexico. To accommodate the increase in business during the summer vacation season, Fuzzy Conch, the owner, hires a large number of servers as seasonal help. When he interviews a prospective server, he would like to provide data on the amount a server can earn in tips. He believes that the amount of the bill and the number of diners are both related to the amount of the tip. He gathered the following sample information. Customer Amount of Tip Amount of Bill Number of Diners Customer Amount of Tip Amount of Bill Number of Diners
1 $8.00 $56.88 4 16 $3.30 $23.59 2 2 4.50 28.23 4 17 3.50 22.30 2 3 1.00 10.65 1 18 3.25 32.00 2 4 2.40 19.82 3 19 5.40 50.02 4 5 5.00 28.62 3 20 2.25 17.60 3 6 4.25 24.83 2 21 4.20 48.42 2 7 0.50 6.24 1 22 3.00 20.27 2 8 6.00 49.20 4 23 1.25 19.53 2 9 5.00 43.26 3 24 3.25 27.03 3 10 3.45 36.90 4 25 3.00 21.28 2 11 6.54 94.14 3 26 6.25 43.38 4 12 6.00 34.99 3 27 5.60 28.12 4 13 4.00 33.91 4 28 2.50 26.25 2 14 3.35 23.06 2 29 7.20 87.66 7 15 0.75 4.65 1 30 6.90 64.70 3
(a-1) Complete the table. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 3 decimal places. Negative amounts should be indicated by a minus sign.)
(a-2) Develop a multiple regression equation with the amount of tips as the dependent variable and the amount of the bill and the number of diners as independent variables. Write out the regression equation.
(a-3) How much does another diner add to the amount of the tips? (Round your answer to 2 decimal places.) Another diner on average adds $ to the tip.
(b-1) Complete the ANOVA table. (Leave no cells blank - be certain to enter "0" wherever required. Round SS, MS to 3 decimal places and F to 2 decimal places.) Source DF SS MS F P Regression Residual Error Total
(c-1) Conduct an individual test on each of the variables. What is the decision rule?
(c-2) Which variable should be deleted? should be deleted.
(d) Use the equation developed in requirement 3 to determine the coefficient of determination.
Statistical Techniques in Business and Economics
ISBN: 9781260239478
18th Edition
Authors: Douglas Lind, William Marchal, Samuel Wathen