Please show the way with excel data analysis tools as much as possible.
Please show all a, b, c, d options with your interpretation
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 sample information in FILE1.
a) 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. How much does another diner add to the amount of the
tips?
b) Conduct a global test of hypothesis to determine if at least one
of the independent variables is significant. What is your
conclusion?
c) Conduct an individual test on each of the variables. Should one
or the other be deleted?
d) Use the equation developed in part (c) to determine the
coefficient of determination. Interpret the value.
Customer | Amount of Tip ($) | Amount of Bill ($) | Diners |
1 | 7 | 48,97 | 5 |
2 | 4,5 | 28,23 | 4 |
3 | 1 | 10,65 | 1 |
4 | 2,4 | 19,82 | 3 |
5 | 5 | 28,62 | 3 |
6 | 4,25 | 24,83 | 2 |
7 | 0,5 | 6,24 | 1 |
8 | 6 | 49,2 | 4 |
9 | 5 | 43,26 | 3 |
10 | 4,75 | 31,36 | 4 |
11 | 5,25 | 32,87 | 4 |
12 | 6 | 34,99 | 3 |
13 | 4 | 33,91 | 4 |
14 | 3,35 | 23,06 | 2 |
15 | 0,75 | 4,65 | 1 |
16 | 3,3 | 23,59 | 2 |
17 | 3,5 | 22,3 | 2 |
18 | 3,25 | 32 | 2 |
19 | 5,4 | 50,02 | 4 |
20 | 2,25 | 17,6 | 3 |
21 | 5,5 | 44,47 | 4 |
22 | 3 | 20,27 | 2 |
23 | 1,25 | 19,53 | 2 |
24 | 3,25 | 27,03 | 3 |
25 | 3 | 21,28 | 2 |
26 | 6,25 | 43,38 | 4 |
27 | 5,6 | 28,12 | 4 |
28 | 2,5 | 26,25 | 2 |
29 | 9,25 | 56,81 | 5 |
30 | 8,25 | 50,65 | 5 |
here is the excel link if necessary: https://drive.google.com/file/d/1WxCMXGpBRdc5IWv0bDCBixq4xPLXVOQz/view?usp=sharing
Please show the way with excel data analysis tools as much as possible. Please show all a, b, c, d options with your interpretation The Conch Café, located in Gulf Shores, Alabama, features casual lun...
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 duringthe 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 toprovide 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...