(i need to know if the answers I have are good so far, please answer the rest, I
ID: 2949586 • Letter: #
Question
(i need to know if the answers I have are good so far, please answer the rest, I'm not sure if the ANOVA table is correct...PLS USE EXCEL)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 following sample information.
a-1. 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 and complete the table. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.)
a-2. Write out the regression equation. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.)
a-3. How much does another diner add to the amount of the tips? (Round your answer to 2 decimal places.)
b-1. Complete the ANOVA table. (Leave no cells blank - be certain to enter "0" wherever required. Round"SS, MS" to 3 decimal places and "F" to 2 decimal places.)
b-2. What is your decision regarding the null-hypothesis?
c-1. Conduct an individual test on each of the variables. What is the decision rule at the 0.05 level of significance? (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.)
c-2. Which variable should be deleted?
Use the equation developed in part (c) to determine the coefficient of determination. (Round your answer to 2 decimal places.)
State true or false.
True
False
Choose the right option from the following graph.
The residuals look random.
The residuals do not look random.
Customer Amount of Tip Amount of Bill Number of Diners Customer Amount of Tip Amount of Bill Number of Diners 1 $ 5.50 $ 42.70 1 16 $ 3.30 $ 23.59 2 2 4.50 28.23 4 17 3.50 22.30 2 3 1.00 10.65 1 18 3.25 32.00 2 4 2.40 19.82 3 19 5.40 50.02 4 5 5.00 28.62 3 20 2.25 17.60 3 6 4.25 24.83 2 21 3.60 42.44 4 7 .50 6.25 1 22 3.00 20.27 2 8 6.00 49.20 4 23 1.25 19.53 2 9 5.00 43.26 3 24 3.25 27.03 3 10 4.10 37.67 1 25 3.00 21.28 2 11 5.15 73.62 2 26 6.25 43.38 4 12 6.00 34.99 3 27 5.60 28.12 4 13 4.00 33.91 4 28 2.50 26.25 2 14 3.35 23.06 2 29 4.75 66.94 3 15 .75 4.65 1 30 5.15 55.95 3 Histogram of the Residuals (response is Tip) ?3 1.2 -0.6 0.0 Residual 0.6 1.2Explanation / Answer
Sol:
Go to
data>data analysis >Regression
Tip=0.509+0.062*Amount of Bill+0.509*number of Diers
ANSWERS: MARKED BY YOU ARE CORRECT
For answer b1 it is p=0.00
c-1. Conduct an individual test on each of the variables. What is the decision rule at the 0.05 level of significance? (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.)
variable should be rejected if its less than 0.05 and accepted if it is more than 0.05
c-2. Which variable should be deleted?
Do not delete any variable as p<0.05
For number of Diners p=0.013 as p<0.05
For Bill p=0.000 s p<0.05
he coefficient of determination is
R sq=0.66
From the graph, the residuals appear normally distributed.
True
Why true is it is distributed symetrically. from Histogram
Choose the right option from the following graph.
The points in a residual plot are randomly dispersed around the horizontal axis,a linear regression model is appropriate for the data.
ANSWER:
The residuals look random.
SUMMARY OUTPUT Regression Statistics Multiple R 0.812376 R Square 0.659954 Adjusted R Square 0.634766 Standard Error 0.976227 Observations 30 ANOVA df SS MS F Significance F Regression 2 49.93924 24.96962 26.20055 4.74E-07 Residual 27 25.73151 0.953019 Total 29 75.67075 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 0.508695 0.517627 0.982744 0.334458 -0.55339 1.570778 Amount of Bill 0.061634 0.012181 5.059622 2.59E-05 0.036639 0.086628 Number of Diners 0.509535 0.190819 2.670248 0.012677 0.118006 0.901063Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.