Interested in the possible relationship between the size of
Interested in the possible relationship between the size of his tip versus the size of the check and the number of diners in the party, a food server has recorded the following for a sample of 8 checks:
Observation
Number y = Tip x1 = Check x2 = Diners
1 $7.5 $40 2
2 0.5 15 1
3 2.0 30 3
4 3.5 25 4
5 9.5 50 4
6 2.5 20 5
7 3.5 35 5
8 1.0 10 2
a. Using EXCEL determine the multiple regression equation. Interpret the partial regression coefficients.
b. What is the estimated tip amount for 3 diners who have a $40 check?
c. Determine the 95% prediction interval for the tip left by a dining party like the one in part (b).
d. Determine the 95% confidence interval for the mean tip left by all dining parties like the one in part (b).
e. Determine the 95% confidence interval for the partial regression coefficients, 1 and 2.
f. Interpret the significance tests in the computer printout.
Solution
