Lab Assignment #3

In this assignment, you develop two purpose statements using the same data set (different purposes, same data) and will use regression and two sample hypothesis testing to analyze the same set of data. For example, you may want to determine if there is a relationship between the amount of space product to a product on shelves and sales volume. Your independent variable (the one thatisn'tchanged by anything) is shelving space. Your dependent variable (the one that is changed by the independent variable) is sales volume. Using regression, you would hope to be able to conclude something similar to this: " As shelving space increases, sales volume increases." Or, it could be worded the other way around. The point is there is a relationship, either positive or negative. Then, you'll use regression or something similar to determine if the relationship is significant - meaning that you can predict the results will be similar if tested in another environment and that your test wasn't a fluke! You'll do the same for the T-test, that is, you will split the data into two groups (you decide the groups and run a two sample T-test)

For this assignment:

1. Use the TIPS dataset.
2. Develop two purpose statements (one suitable for regression analysis, and one suitable for a two sample hypothesis test).
3. Develop two corresponding research questions for your purpose statements.
4. Develop two corresponding hypotheses for each research question.
5. For the report:first, you will provide an analysis, using MS Excel and statistical functions, on the data collected. Then, you will provide a write up to report your results, and give an interpretation of the results. Finally, you will provide conclusions and recommendations for further action based upon your findings.
6. Follow the Lab Assignment #3 Writing Template. Follow the step by step instructions and you will succeed. The writing template is to guide you, and allow you to use in your own real world activities. This course, again,isn'tdesigned to make you a statistician, but to show you how managers use analytics to make decisions.
7. Be sure to include a proper reference.

Important:You must use the TIPS dataset that I providedfor your analysis.

Customer	Bill	Tip	Tip_Rate%	Size	Smoking	Time
1	32.76	3.70	11.3	3	1	3			Customer = customer number (nothing to analyze)
2	18.17	2.60	14.3	2	1	1			Bill = total bill in dollars
3	25.66	4.20	16.4	2	0	3			Tip = total tip in dollars
4	32.66	3.30	10.1	2	0	3			Tip_Rate = tip as % of bill
5	31.43	3.40	10.8	2	0	3			Size = size of party at table
6	10.96	3.60	32.8	2	0	3			Smoking = 1 (smoking table), 0 (non-smoking)
7	20.72	3.80	18.3	2	0	3			Time = 1 (breakfast), 2 (lunch), 3 (dinner)
8	17.67	2.80	15.8	2	1	1
9	24.82	5.30	21.4	2	1	2
10	15.89	1.80	11.3	2	0	3
11	14.68	1.50	10.2	2	0	3
12	24.08	2.50	10.4	3	1	2
13	9.87	2.40	24.3	1	1	2
14	10.63	2.20	20.7	3	1	2
15	32.73	4.00	12.2	2	1	1
16	7.06	1.60	22.7	1	0	3
17	24.37	5.10	20.9	2	0	3
18	22.36	2.80	12.5	3	0	2
19	17.53	3.00	17.1	3	1	2
20	19.59	4.10	20.9	2	0	1
21	54.31	4.80	8.8	5	0	1
22	21.45	4.90	22.8	2	0	2
23	26.74	5.30	19.8	3	0	2
24	30.68	3.10	10.1	3	0	3
25	9.81	2.60	26.5	3	0	2
26	5.40	2.50	46.3	2	0	2
27	14.80	3.00	20.3	2	1	2
28	15.94	3.10	19.4	3	0	2
29	21.36	3.40	15.9	3	0	2
30	27.20	4.50	16.5	2	0	1
31	9.55	2.00	20.9	2	0	2
32	27.04	2.30	8.5	3	0	1
33	17.44	4.10	23.5	2	0	1
34	28.46	3.30	11.6	2	1	2
35	4.62	2.60	56.3	1	1	1
36	37.65	4.60	12.2	4	1	3
37	17.10	2.10	12.3	3	1	1
38	33.03	5.90	17.9	4	0	2
39	17.06	2.90	17.0	2	0	1
40	29.39	4.20	14.3	3	0	3
41	22.94	3.60	15.7	2	1	3
42	16.70	4.30	25.7	2	1	2
43	17.86	1.80	10.1	4	0	1
44	17.61	1.60	9.1	3	0	1
45	12.04	4.10	34.1	3	0	3
46	12.42	2.90	23.3	2	1	3
47	11.41	0.50	4.4	1	0	3
48	19.07	3.30	17.3	4	1	1
49	45.78	5.40	11.8	4	0	3
50	21.10	3.00	14.2	3	1	2
51	32.44	6.80	21.0	2	0	1
52	28.09	2.40	8.5	3	0	3
53	40.02	5.60	14.0	4	0	3
54	25.19	3.20	12.7	2	1	2
55	24.33	4.70	19.3	2	0	2
56	36.89	5.30	14.4	4	0	3
57	41.39	6.00	14.5	5	1	2
58	22.14	6.70	30.3	4	1	1
59	25.41	4.10	16.1	3	0	1
60	24.70	4.60	18.6	2	0	3
61	40.65	5.00	12.3	4	0	2
62	19.23	3.20	16.6	3	0	2
63	22.14	4.10	18.5	3	1	2
64	17.24	4.10	23.8	3	0	2
65	6.29	1.50	23.8	1	0	1
66	12.32	2.40	19.5	1	1	3
67	17.93	4.60	25.7	2	0	1
68	25.14	4.30	17.1	3	0	3
69	14.20	3.20	22.5	4	1	1
70	16.36	1.20	7.3	2	1	1
71	24.29	4.00	16.5	2	1	3
72	28.61	4.70	16.4	3	1	1
73	24.39	2.90	11.9	3	0	2
74	23.44	2.00	8.5	2	1	2
75	14.45	4.00	27.7	2	1	1