Question: c . Compute and report the regression equation that predicts amount of bill with number of diners. ( Negative amounts should be indicated by a

 c. Compute and report the regression equation that predicts "amount of

c. Compute and report the regression equation that predicts "amount of bill" with "number of diners." (Negative amounts should be
indicated by a minus sign. Round "amount of bill" to 3 decimal places and "number of diners" to 4 decimal places.)
Amount of Bill =
(Number of Diners)
d-1. Report the regression equation that predicts "amount of tip" with "amount of bill." (Negative amounts should be indicated by a
minus sign. Round your answers to 4 decimal places.)
Amount of Tip =
(Amount of Bill).
d-2. Report the coefficient of determination. (Round your answer to 2 decimal places.)
Coefficient of determination
d-3. Interpret the regression coefficient. (Round your answer to 4 decimal places.)
Regression coefficient e. Predict the tip based on a bill amount of $100.(Round your answer to 3 decimal places.)
Predicted Amount of tipThe 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.
\table[[Customer,\table[[Amount of],[Tip]],\table[[Amount of],[Bill]],\table[[Number of],[Diners]],Customer,Amount of Tip,\table[[Amount of],[Bill]],\table[[Number of],[Diners]]],[1,$7.00,$48.90,3,16,$3.30,$23.52,2],[2,3.80,28.30,2,17,3.50,22.30,2],[3,1.00,10.72,3,18,3.18,32.00,2],[4,3.80,19.89,3,19,5.40,50.09,4],[5,5.00,28.69,3,20,2.18,17.60,3],[6,4.18,24.90,2,21,5.50,44.40,4],[7,.50,6.31,1,22,3.00,20.34,2],[8,6.00,49.20,4,23,1.18,19.46,2],[9,5.00,43.33,3,24,3.18,27.10,3],[10,4.68,31.29,4,25,3.00,21.21,2],[11,5.18,32.94,4,26,6.46,43.45,4],[12,6.00,34.92,3,27,5.60,28.05,4],[13,4.00,33.98,4,28,2.50,26.32,2],[14,3.28,22.99,2,29,9.18,56.74,2],[15,0.89,4.72,1,30,8.18,50.72,5]]
picture Click here for the Excel Data File
a-1. Compute the following correlation matrix. (Round your answers to 4 decimal places.)
\table[[,Correlation Matrix,,],[,Amount of Tip ($),Amount of Bill ($),Diners],[Amount of Tip ($),1,,],[Amount of Bill ($),(0.1319),,],[Diners,,,1]]
bill" with "number of diners." (Negative amounts should be indicated by a

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!