Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Algebra With Trigonometry

Authors: Charles P McKeague

1st Edition

1483218759, 9781483218755

More Books

Students also viewed these Mathematics questions