3. You decided to use all of the data in Table C4-1 and the key in Table C4-2 to find any further implications of the data. This time we will see if there is a difference in all sales by location.

Formulate a hypothesis (articulate both the null hypothesis and alternative hypothesis) and decision rule relating to exploring a potential difference in average daily sales by location type ( A: Full Service Travel Center vs. B: Fuel & Go Rest Stop).

Conduct a paired samples t-test to compare sales at the two location types. Highlight your t- statistic, Critical T, and p-value of your output (if you use a program other than Excel, copy your output and paste it into your Excel file).

Based on the t-statistic and p-value of your t-test output, can you say there is a statistically significant difference in average daily sales by location type? Articulate your answer as a sentence within your Excel file.

Table C4-2: Key to location type code
Location Code	Description
A	Full-Service Travel Center
B	Fuel & Go Rest Stop

Table C4-1: Average daily sales by vending machine number, brand and location type
Vending Machine	Location Type	Brand	Avg Daily Sales
1	A	COKE	1051
2	A	COKE	1385
3	B	COKE	890
4	A	COKE	857
5	B	PEPSI	997
6	B	COKE	994
7	A	COKE	1521
8	A	PEPSI	701
9	A	PEPSI	899
10	B	PEPSI	834
11	B	PEPSI	405
12	A	COKE	925
13	B	PEPSI	892
14	A	PEPSI	1098
15	A	COKE	945
16	B	PEPSI	1060
17	A	COKE	850
18	B	PEPSI	448
19	B	COKE	626
20	B	PEPSI	695
21	B	PEPSI	411
22	A	COKE	907
23	A	COKE	818
24	B	COKE	682
25	B	COKE	395
26	B	PEPSI	771
27	B	COKE	379
28	B	COKE	563
29	B	COKE	730
30	A	COKE	985
31	B	PEPSI	1011
32	A	PEPSI	960
33	B	COKE	358
35	B	COKE	1050
36	B	PEPSI	565
37	A	COKE	857
38	A	PEPSI	488
39	B	COKE	239
40	B	COKE	186
41	A	COKE	826
42	A	COKE	784
43	B	COKE	1068
44	A	PEPSI	601
44	A	PEPSI	781
45	B	COKE	496
46	B	COKE	1084
47	A	COKE	1001
48	B	COKE	322
49	A	COKE	833
50	B	COKE	990
51	B	COKE	680
52	A	PEPSI	687
53	B	PEPSI	1174
54	A	PEPSI	605
55	B	PEPSI	487
56	B	PEPSI	824
57	B	PEPSI	455
58	B	PEPSI	698
59	A	PEPSI	477
60	A	PEPSI	902
61	B	PEPSI	196
62	A	PEPSI	508
63	A	PEPSI	661
64	A	COKE	629
65	B	COKE	1113
66	A	COKE	823
67	B	PEPSI	995
68	B	COKE	927
69	B	PEPSI	500
70	A	COKE	892
71	A	PEPSI	396
72	A	PEPSI	874
73	B	PEPSI	903
74	A	COKE	959
75	A	PEPSI	499
76	B	COKE	939
77	B	PEPSI	800
78	A	COKE	785
79	A	PEPSI	697
80	A	PEPSI	856
81	B	COKE	603
82	B	COKE	642
83	A	COKE	909
84	A	PEPSI	401
85	A	PEPSI	794
86	B	PEPSI	750
87	A	PEPSI	496
88	B	PEPSI	205
89	A	COKE	900
90	A	COKE	455
91	A	COKE	1299
92	A	PEPSI	985
93	A	PEPSI	633
94	B	COKE	821
95	A	PEPSI	785
96	B	COKE	785
97	A	PEPSI	939
98	B	COKE	1106
99	A	PEPSI	784
100	B	PEPSI	782