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

 hello please show work in excel Restaurant Digest, a famous restaurantmagazine writes that the amount of tips servers get in Florida is

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

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 Mathematics Questions!