excel assignment

BUSU610ExcelAssignment7.xlsx

Task 1

Day	Revenue	Occupied	PART I TASKS:	A suburban hotel derives its revenue from its hotel and restaurant operations. The owners are interested in the relationship between the number of rooms occupied on a nightly basis and the revenue per day in the restaurant. The dataset is a sample of 25 days (Monday through Thursday) from last year showing the restaurant income and the number of rooms occupied.
1	1452	32
2	1361	20
3	1426	21
4	1470	25
5	1456	26		1) Does the revenue seem to increase as the number of occupied rooms increases? Draw a scatter diagram to support your conclusion.
6	1430	23			5 points
7	1354	20		2) Determine the correlation coefficient between the two variables. Interpret the value.
8	1442	39			5 points
9	1394	15		3) Is it reasonable to conclude that there is a positive relationship between revenue and occupied rooms? Use the .10 significance level.
10	1459	50			5 points
11	1399	41		4) What percent of the variation in revenue in the restaurant is accounted for by the number of rooms occupied?
12	1458	35			5 points
13	1537	41
14	1425	31
15	1445	51
16	1439	62
17	1348	45
18	1450	41
19	1431	62
20	1446	47
21	1485	43
22	1405	38
23	1461	36
24	1490	60
25	1426	65

Customer	Amount of Tip ($)	Amount of Bill ($)	Diners	PART II TASKS:	The Cronch Café, located at the Gulf of Mexico, has an increase in business during the summer vacation season. 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 this sample information.
1	5.15	74.5	2
2	4.5	28.23	4
3	1	10.65	1
4	2.4	19.82	3
5	5	28.62	3		1) Develop a multiple regression model with the amount of tips as the dependent variable and the amount of the bill and the amount of diners as independent variables. (5 points) Write out the regression equation. (4 points) How much does another diner add to the amount of the tips? (3 points)
6	4.25	24.83	2			12 points
7	0.5	6.25	1
8	6	49.2	4
9	5	43.26	3		2) Conduct a global test of hypothesis to determine if at least one of the independent variables is significant. (4 points) What is your conclusion? (4 points)	8 points
10	4.65	62.23	1
11	5.6	84.81	1
12	6	34.99	3
13	4	33.91	4
14	3.35	23.06	2
15	0.75	4.65	1
16	3.3	23.59	2
17	3.5	22.3	2
18	3.25	32	2
19	5.4	50.02	4
20	2.25	17.6	3
21	4.35	63.16	6
22	3	20.27	2
23	1.25	19.53	2
24	3.25	27.03	3
25	3	21.28	2
26	6.25	43.38	4
27	5.6	28.12	4
28	2.5	26.25	2
29	6.85	53.08	7
30	8.6	87.85	8