Question: hello please show work in excel Restaurant Digest, a famous restaurant magazine writes that the amount of tips servers get in Florida is affected by
hello please show work in excel


Restaurant Digest, a famous restaurant magazine writes that the amount of tips servers get in Florida is affected by several factors including the amount of bill, number of adult diners as well as kids and the income of the diners. Use the data below to answer the following questions: 1. Find the multiple regression model. 2. At a level of significance of 0.03, is there a significance relationship between the amount of tip and at least one of the independent variables? 3. What is the likely amount of tip if a group of diners spend $40.33 and had an annual income of $81,000. The diners included 4 adults and 3 kids? 4. What percent of the variation in amount of tip is accounted for by amount of bill, annual income, number of adults and kids? Customer Amount of Tip Amount of Bill Number of adult Number of Annual Diners kids Income $ $ 1 7.00 5 48.97 3 100000 $ $ 4.50 28.23 3 80000 $ $ 3 1.00 10.65 0 20000 $ $ 2.40 19.82 2 19000 $ $ 5 3 5.00 28.62 2 50000 $ $ 6 4.25 2 24.83 2 25000 $ $ 7 0.50 6.24 8000 $ $ 4 6.00 49.20 3 106000 $ 9 $ 3 5.00 2 43.26 98000 $ $ 10 4 4.75 31.36 3 60000 $ 11 $ 4 5.25 32.87 3 61000 $ 12 $ 3 6.00 N 34.99 63000 $ $ 13 A 4.00 33.91 2 62000 $ 14 $ 3.35 2 23.06 25000 $ $ 15 0.75 4.65 5000\f
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
