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	$ 48.82	5	16	$ 3.30	$ 23.44	2
2	3.00	28.38	4	17	3.50	22.30	2
3	1.00	10.80	1	18	3.10	32.00	2
4	5.40	19.97	3	19	5.40	50.17	4
5	5.00	28.77	3	20	2.10	17.60	3
6	4.10	24.98	2	21	5.50	44.32	4
7	.50	6.39	1	22	3.00	20.42	2
8	6.00	49.20	4	23	1.10	19.38	2
9	5.00	43.41	3	24	3.10	27.18	3
10	4.60	31.21	4	25	3.00	21.13	2
11	5.10	33.02	4	26	6.70	43.53	4
12	6.00	34.84	3	27	5.60	27.97	3
13	4.00	34.06	4	28	2.50	26.40	2
14	3.20	22.91	2	29	9.10	56.66	5
15	1.05	4.80	1	30	8.10	50.80	5

Click here for the Excel Data File a-1. Compute the following correlation matrix. (Round your answers to 4 decimal places.)

a-2. Which of the independent variables is stronger?

a-3. Do they indicate multicollinearity? multiple choice 1

Yes

No

b-1. Would it be logical to create a multiple regression equation to predict amount of tips? multiple choice 2

Yes

No

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.)

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.)

d-2. Report the coefficient of determination. (Round your answer to 2 decimal places.)

d-3. Interpret the regression coefficient. (Round your answer to 4 decimal places.)

e. Predict the tip based on a bill amount of $100. (Round your answer to 3 decimal places.)