Your rm is a major retailer of outdoor recreation equipment and accessories with numerous locations spread throughout the southeastern United States. A recent idea is to have promotional signage throughout your stores with QR codes that customers could scan that would provide additional information about what products the customer might be interested in. The belief is that when a customer is exposed to additional information about the products available, they will spend more on those products. Your team has developed the QR app, and have produced and placed signage throughout all of your stores. The app provides, when used, information on products within the section of your store that the customer uses the QR scanner. For example, one section of the store is devoted to items for travel (clothing, transportation accessories, etc.) are located in section 1. Another section, section 2, is devoted to high-adventure products that are associated with things like mountaineering, mountain biking, whitewater paddling, etc. Section 3 has products that would appeal to young couples, such as outdoor furniture, dual sleeping bags and hammocks, etc. Finally, section 4 has equipment for outdoor sports such as golf, pickleball, and road cycling. You will be using the same data in the excel spreadsheet assignment and project data.xlsx that you used for the previous assignment.

section	scan	expenditures	age	married	sex
2	yes	1969	24	yes	M
2	no	1407	20	no	F
1	no	8923	60	yes	M
4	yes	5349	46	yes	M
2	no	1247	19	no	F
3	no	3650	32	no	F
4	yes	5351	42	yes	F
2	no	1376	28	yes	F
3	no	4017	44	yes	M
3	yes	5600	46	no	M
2	yes	1951	25	yes	M
2	yes	1971	23	yes	F
3	yes	4513	41	yes	F
3	yes	2245	28	yes	F
2	yes	1505	31	no	M
2	yes	2064	23	no	F
1	no	8630	58	no	F
3	yes	4689	45	yes	M
1	yes	9086	66	yes	M
2	no	1007	20	no	F
2	yes	1656	21	no	M
4	no	6327	47	no	F
1	no	8785	62	no	M
2	yes	2089	23	no	M
2	yes	1934	25	no	M
4	no	7060	49	yes	M
2	no	913	19	no	F
4	no	6357	44	yes	F
3	yes	2271	25	yes	M
1	no	8356	57	yes	M
3	no	3620	44	no	F
4	no	8315	53	no	M
1	no	8530	58	yes	F
4	yes	7681	42	yes	M
1	no	8466	56	yes	F
4	no	6684	24	yes	F
3	yes	5125	40	yes	M
4	yes	7597	53	yes	M
4	no	8304	57	yes	M
4	no	6575	45	yes	M
3	no	3844	24	no	F
2	no	601	19	no	F
4	yes	7718	53	yes	M
3	no	3746	33	yes	M
4	no	8197	44	yes	F
1	yes	9708	74	yes	M
4	yes	5369	44	yes	M
1	no	8972	62	yes	F
4	no	8147	53	yes	M
3	no	4279	40	yes	M
4	yes	7377	50	yes	M
4	no	6619	46	yes	F
1	yes	9069	70	yes	M
1	yes	9893	74	yes	M
3	no	3708	38	no	M
3	yes	4960	44	no	M
3	no	3989	35	no	F
1	no	8078	50	yes	F
3	no	3726	34	no	F
3	no	3782	33	yes	F
4	yes	7588	55	no	M
1	no	8577	54	yes	F
3	no	4005	22	no	F
2	no	1511	21	no	F
2	yes	1426	23	no	F
3	yes	9186	66	yes	F
3	no	4341	39	no	M
4	no	6128	35	yes	M
1	no	8762	59	yes	F
4	no	6732	44	yes	F
2	no	1077	20	no	F
1	yes	9410	69	yes	M
2	yes	1724	23	yes	M
3	yes	4372	42	no	M
2	yes	1506	23	no	F
4	no	6799	46	yes	F
3	no	4430	45	yes	F
2	yes	1729	23	no	M
4	no	6786	48	no	M
3	no	3936	33	no	F
4	no	6146	48	yes	M
2	no	900	19	no	F
2	yes	2004	24	no	M
2	no	1055	19	no	F
4	no	8268	53	yes	M
1	yes	10220	68	yes	F
4	yes	7940	53	yes	M
3	yes	4474	43	no	F
3	yes	2309	30	no	F
4	yes	7094	50	yes	M
4	no	6401	45	no	F
2	yes	1753	23	yes	M
4	yes	7529	50	yes	M
4	no	7890	52	yes	M
4	no	6792	45	yes	F
3	no	3732	33	no	M
4	no	8233	55	yes	F
4	no	6351	48	yes	M
2	no	1367	19	no	M
4	no	6434	46	yes	F
3	yes	4511	40	yes	F
3	no	4284	38	yes	F
2	yes	1581	21	no	F
3	no	4053	37	yes	F
4	no	5894	44	yes	F
1	no	8755	57	yes	M
3	yes	4802	45	no	F
3	yes	4786	44	yes	F
2	yes	1931	28	no	M
1	no	8832	60	yes	M
2	yes	2077	25	no	M
2	yes	2107	23	no	F
4	no	5902	45	yes	F
3	no	3950	34	no	F
1	no	8969	61	yes	F
3	no	4183	37	yes	M
3	no	3983	36	no	M
2	yes	1555	20	no	F
2	no	769	18	no	F
3	no	3660	31	no	M
4	no	6019	32	yes	F
4	yes	7431	24	yes	F
2	yes	2421	29	no	F
4	yes	7471	54	yes	M
3	no	4114	43	no	M
1	yes	9402	66	yes	M
1	yes	9061	69	yes	M
3	yes	4738	41	no	M
2	yes	2042	25	no	M
1	no	8356	47	yes	M
4	no	6710	46	no	M
1	no	8858	62	yes	M
1	yes	9293	67	yes	M
1	yes	9302	69	yes	M
4	no	6387	44	yes	F
2	yes	1899	24	no	M
2	yes	2366	22	no	M
3	no	3484	31	no	M
2	yes	1738	25	no	M
2	no	1220	20	no	F
4	no	6816	46	yes	M
4	no	6053	44	no	M
3	yes	4677	43	no	F
3	yes	4900	32	yes	M
2	no	628	25	yes	F
2	no	913	18	no	F
1	no	8505	54	yes	M
3	yes	5148	43	no	M
4	yes	7987	50	yes	M
4	yes	7326	48	yes	M
1	yes	10166	73	yes	M
4	yes	7678	55	no	M
4	no	6574	52	yes	M
4	no	6640	44	no	F
1	yes	9456	55	yes	M
4	no	6603	44	yes	F
1	no	8616	58	yes	F
4	no	6444	47	no	F
4	no	6855	46	no	M
4	no	6790	44	yes	M
4	yes	7322	47	yes	M
1	no	8650	54	no	F
4	yes	7238	49	yes	M
4	no	6451	48	no	F
1	no	8764	60	yes	F
3	no	4187	39	no	F
3	yes	4841	44	no	M
2	no	659	24	yes	F
3	no	4184	24	yes	M
3	yes	2286	26	no	M
4	no	6464	45	yes	F
4	no	6154	44	yes	F
1	yes	9132	47	yes	F
4	yes	7956	34	no	M
3	yes	4960	45	yes	M
1	no	8723	57	yes	M
4	no	6393	44	no	F
2	no	787	19	no	F
2	yes	1953	28	no	F
4	no	5993	43	yes	F
4	no	8288	55	yes	M
1	yes	8811	59	yes	M
1	no	8356	37	yes	M
4	no	6546	24	yes	M
3	yes	2453	30	no	F
1	no	8086	51	yes	F
1	yes	9931	72	yes	M
4	no	6819	24	yes	F
4	no	6383	47	yes	F
2	yes	1899	25	no	F
2	no	1159	20	no	F
2	no	942	25	no	F
1	no	8849	61	yes	F
2	no	1442	25	no	M
3	yes	5043	24	no	M
1	no	8594	56	yes	F
4	no	6301	44	yes	F
3	yes	2108	32	no	F
4	no	6770	47	yes	F
4	no	7116	46	yes	F
4	no	6610	45	yes	M
4	yes	7434	54	yes	M
3	yes	4818	40	no	F
4	no	8197	54	yes	F
2	yes	2016	32	no	M
4	yes	7222	47	yes	M
1	no	8709	55	yes	M
4	no	6906	49	no	M
3	yes	2244	27	yes	M
3	yes	4338	38	no	M
4	no	6709	52	yes	M
3	yes	5022	43	yes	M
3	yes	5265	44	no	F
3	no	3683	32	no	M
1	no	8975	65	yes	F
2	no	1470	21	no	F
3	yes	9247	65	yes	M
1	no	8530	57	no	F
4	yes	7310	44	yes	M
2	yes	2057	24	no	M
1	no	8415	56	no	F
3	yes	5183	44	no	F
4	yes	7341	49	yes	M
4	yes	7669	34	yes	F
1	yes	9790	44	yes	M
4	no	6842	52	yes	M
3	yes	2110	31	yes	M
3	yes	4853	40	yes	M
3	no	3640	31	no	M
1	no	8437	58	yes	M
4	yes	7674	54	no	F
1	yes	9548	65	yes	M
2	yes	1525	21	no	F
2	no	1034	19	no	M
3	no	4059	34	yes	F
2	yes	2098	25	yes	M
1	no	9140	70	yes	F
3	yes	2351	31	no	F
2	yes	2464	31	no	M
1	yes	10027	75	yes	M
2	yes	1890	31	no	M
3	yes	2135	32	no	F
4	yes	7669	53	yes	F
4	yes	7384	47	no	M
1	no	8866	65	no	M
1	no	9164	65	yes	F
4	no	8116	52	yes	M
2	yes	2321	26	no	M
1	yes	9754	72	yes	M
3	yes	5109	44	no	M
3	yes	4785	32	yes	F
4	yes	7442	51	yes	M
4	no	6582	44	no	F
1	yes	9466	67	yes	M
3	no	3930	34	no	M
2	yes	1803	23	no	M
1	no	8066	55	yes	M
4	no	6402	46	yes	M
1	no	8581	54	yes	M
2	yes	1689	23	no	M
1	yes	9702	75	yes	M
4	no	6717	47	no	F
3	yes	4746	48	no	F
3	no	3957	33	yes	F
3	no	4240	39	no	M
3	yes	4352	40	yes	M
1	no	8592	55	yes	M
4	no	6313	45	yes	F
2	no	880	23	no	F
1	yes	9495	70	yes	M
4	no	6953	47	yes	F
2	no	1181	25	yes	F
3	no	4433	28	yes	F
1	no	8187	54	no	M
3	no	4033	36	no	F
3	yes	4820	41	yes	M
4	no	6488	48	yes	F
3	yes	4677	32	no	F
3	yes	4575	45	no	F
2	no	1054	32	no	M
4	no	6414	32	yes	M
3	no	3718	32	no	F
2	yes	1942	24	no	F
1	no	8941	60	yes	M
1	yes	9314	45	yes	M
4	no	6703	44	yes	F
3	yes	2302	28	no	M
3	yes	2215	28	yes	M
4	no	5973	42	no	M
3	no	4506	45	yes	F
3	yes	4972	40	yes	M
4	yes	7867	51	yes	F
4	yes	7631	50	yes	M
1	no	8502	47	yes	F
4	no	6629	47	yes	M
1	no	8389	34	yes	F
2	yes	1723	25	yes	M
3	yes	5067	42	yes	M
4	yes	5355	43	yes	M
4	yes	7291	42	yes	M
2	yes	1940	23	no	M
1	no	8406	55	yes	F
3	yes	5073	32	no	M
3	yes	5558	45	no	F
2	no	1298	20	no	M
2	yes	1725	25	no	M
3	no	3812	34	yes	F
2	no	1426	20	no	M
4	no	6258	46	no	F
4	yes	7849	50	yes	F
4	no	6700	48	yes	M
2	no	1175	28	yes	F
2	no	1104	19	no	M
4	no	6381	46	yes	M
3	yes	4879	41	no	M
1	no	8549	56	yes	F
4	no	6930	46	yes	M
3	no	3881	33	no	F
4	yes	7411	49	no	M
1	no	8841	60	yes	F
3	yes	4659	40	yes	F
1	yes	9844	73	yes	M
2	no	606	18	no	F
2	no	924	18	no	M
4	no	6028	46	yes	F
3	yes	9243	70	yes	F
2	yes	2000	23	no	F
2	yes	1491	20	no	M
2	no	1204	19	no	F
4	no	6519	45	no	F
4	yes	7229	48	yes	M
3	no	4208	40	no	F
4	yes	7816	55	yes	M
3	no	4176	36	no	M
2	yes	2066	28	yes	M
1	no	8524	57	yes	F
2	yes	1724	24	no	M
1	no	8667	55	no	F
3	yes	2219	25	yes	F
3	yes	4909	40	no	M
2	no	555	18	no	M
3	yes	4503	44	no	F
4	no	6429	45	yes	F
3	no	3833	34	no	F
4	yes	7628	55	yes	M
4	no	6403	47	yes	F
4	no	6562	48	yes	F
4	no	6534	46	no	F
3	no	4229	38	no	F
4	yes	7765	54	yes	M
1	no	8791	65	yes	F
1	no	8551	58	no	F
1	yes	9564	66	yes	M
1	yes	9619	70	yes	F
1	no	8568	56	yes	F
4	yes	5333	44	yes	M
4	yes	5343	45	yes	F
1	no	8772	60	no	M
4	no	6843	50	yes	M
4	no	6481	47	yes	M
4	yes	5376	44	yes	F
1	no	8628	56	yes	M
4	yes	7666	37	yes	M
2	no	658	19	no	F
3	yes	2214	25	no	M
1	no	8801	47	yes	F
4	yes	7463	37	yes	M
3	no	4117	37	yes	M
2	no	872	25	yes	F
4	no	6064	24	no	F
2	yes	1913	23	no	M
2	no	996	23	no	F
4	no	6756	46	yes	M
4	yes	7596	51	yes	M
2	no	1044	19	no	F
3	no	4032	35	no	M
1	yes	9650	74	yes	M
4	yes	7241	50	no	F
4	yes	5409	42	yes	F
4	no	6177	45	no	M
2	yes	1976	23	yes	M
3	yes	2112	24	yes	M
1	no	8675	47	no	M
2	yes	1346	20	no	F
4	yes	7315	46	yes	M
3	yes	9216	67	yes	F
3	no	4554	43	no	M
4	yes	5693	42	yes	M
3	no	4108	35	no	F
4	yes	7544	51	yes	M
3	yes	5209	45	no	F
2	yes	2081	24	no	M
4	no	6976	48	yes	M
4	yes	7377	46	yes	M
2	yes	1468	20	no	F
2	yes	2097	24	yes	F
3	yes	4663	24	yes	F
2	yes	1489	21	no	M
1	no	8473	58	yes	F
4	no	8326	55	no	M
1	no	8762	45	yes	F
2	yes	1999	31	yes	M
2	yes	1697	24	yes	M
4	no	6899	48	no	F
4	yes	8006	51	yes	M
4	yes	5539	44	yes	F
2	no	992	20	no	F
2	yes	1839	25	yes	M
4	no	6695	47	yes	F
1	yes	9630	72	yes	M
1	no	8686	57	yes	M
3	yes	4393	43	no	M
3	yes	5130	41	no	M
4	yes	7546	52	no	M
3	no	4030	36	no	M
1	no	8745	56	yes	M
1	yes	9604	69	yes	M
1	no	8016	52	yes	M
4	no	6266	47	yes	M
1	no	8539	58	no	M
1	yes	9705	55	yes	M
3	yes	2215	24	no	M
3	yes	2114	25	yes	M
1	no	9034	66	yes	M
2	yes	1577	20	no	F
1	no	8061	54	yes	F
4	no	8319	54	no	M
1	no	8540	54	no	F
3	yes	4713	40	yes	M
1	yes	9341	44	yes	M
2	yes	1799	25	no	M
2	yes	1416	20	no	F
1	no	8357	55	yes	M
1	yes	8859	45	yes	M
3	yes	2304	32	no	F
1	no	8743	55	yes	M
4	no	6819	48	yes	M
3	no	4090	36	no	F
3	yes	2145	24	no	F
3	yes	4827	43	no	M
3	no	3802	33	yes	F
3	no	3843	33	no	F
3	yes	4943	42	yes	M
1	yes	9571	45	no	M
4	yes	7596	52	yes	M
1	no	8613	57	yes	F
4	no	6457	44	yes	M
1	no	8544	54	yes	F
3	no	3732	34	yes	M
1	no	8568	47	yes	F
2	yes	2079	23	no	F
4	no	8287	54	yes	M
3	no	4158	36	no	F
2	no	976	19	no	F
2	yes	1487	20	no	F
1	yes	9263	66	yes	M
1	no	8773	61	no	M
4	no	6363	45	yes	M
3	no	4123	35	no	F
2	no	767	18	no	F
2	yes	1460	21	no	F
4	no	7963	55	no	M
4	yes	7454	52	yes	F
3	no	4456	41	yes	M
1	no	8545	55	yes	M
2	yes	1563	25	yes	F
3	no	3970	34	yes	F
1	no	8538	37	no	M
4	yes	5387	35	yes	F
2	yes	1636	21	no	M
3	yes	5066	41	yes	M
2	yes	2107	24	no	M
2	no	1414	21	no	F
3	yes	4301	40	no	F
2	yes	1796	24	no	M
1	yes	10187	74	yes	F
4	no	6474	46	yes	M
3	no	4014	38	yes	F
1	no	8929	60	yes	M
2	no	1316	19	no	F
4	yes	7386	48	no	M
2	no	1161	19	no	F
4	no	6276	48	yes	M
3	no	3792	34	yes	F
1	yes	9443	70	yes	M
4	no	6505	44	yes	F
2	no	1161	20	no	F
4	yes	7295	52	yes	M
4	no	5940	46	no	F
3	yes	5112	48	yes	M
1	no	8625	55	yes	M
3	yes	2252	29	yes	M
4	no	6630	48	yes	M
2	yes	2309	25	no	F
1	no	9036	47	yes	M
1	yes	9825	75	yes	F
2	yes	2087	25	no	F
3	no	3910	34	no	M
3	yes	2744	32	no	F
4	no	6921	50	yes	M
1	no	8563	57	no	M
3	no	4368	44	yes	M
3	yes	4900	45	no	F
1	yes	9125	67	yes	F
4	no	8246	34	yes	M
3	no	4118	34	yes	F
4	yes	6894	47	no	M
2	yes	1897	23	yes	F
3	yes	4885	42	no	M
1	no	8550	47	yes	M
1	yes	9084	65	yes	M
4	yes	7566	54	no	M
4	no	6412	52	yes	M
3	no	4351	40	yes	M
4	yes	8196	55	no	M
1	yes	9463	66	yes	F
1	yes	8835	60	yes	M
2	no	430	23	no	M
2	no	885	18	no	M
3	no	4089	35	no	F
3	yes	4937	41	yes	F
4	yes	5439	43	yes	F
1	no	8396	54	yes	F
4	yes	7314	50	yes	M
1	no	8448	57	yes	F
2	yes	2028	24	yes	F
1	no	8333	56	no	M
4	no	6316	32	no	F
3	no	3584	31	no	M
4	no	6645	45	no	F
3	yes	9232	69	yes	F
3	no	3524	22	no	F
1	no	8434	57	no	M
2	yes	1433	21	no	F
3	yes	4532	42	no	M
4	yes	7440	42	yes	F
4	yes	7717	52	yes	M
4	yes	6810	47	yes	F
2	no	585	23	no	F
3	yes	4845	44	yes	M
3	no	3756	34	yes	F
2	yes	1733	25	yes	M
1	no	8517	56	yes	F
4	no	6578	46	yes	F
4	no	6742	45	yes	F
4	yes	5720	43	yes	F
2	yes	1994	24	yes	F
3	yes	4672	42	no	F
3	yes	5004	42	no	M
1	yes	9406	67	yes	M
4	no	8041	37	yes	F
3	yes	4291	43	no	F
3	yes	5316	43	yes	M
1	yes	9965	55	yes	M
3	yes	5000	41	no	M
4	no	8250	57	yes	M
3	yes	2235	26	yes	F
3	no	4158	22	no	F
3	no	3975	35	no	M
1	no	8506	34	yes	M
3	yes	4890	35	yes	F
4	yes	6026	45	yes	M
3	yes	4822	42	yes	M
3	yes	5278	42	yes	M
4	yes	7620	54	yes	F
3	yes	5039	44	yes	M
4	no	6729	48	yes	F
2	no	1512	20	no	F
3	no	3769	22	no	F
3	yes	4606	45	yes	F
1	yes	9489	69	yes	M
4	yes	7271	46	no	M
1	no	8718	56	yes	M
4	yes	7595	50	yes	M
3	no	4017	35	no	M
3	yes	5139	42	no	M
3	yes	4947	43	no	F
3	yes	5063	40	no	M
1	yes	8998	65	yes	M
3	no	4421	44	no	F
2	yes	2071	24	no	F
2	yes	1634	20	no	F
3	yes	2268	30	no	F
2	yes	1637	20	no	M
4	yes	7710	51	yes	M
2	no	1043	20	no	F
4	yes	7477	55	yes	M
1	no	8370	56	yes	M
4	no	8294	56	yes	M
2	yes	1657	31	no	M
2	yes	2052	23	no	F
4	no	6813	48	yes	F
3	no	4456	45	no	M
4	no	6140	47	yes	F
1	no	8910	59	no	M
4	no	6588	48	no	F
4	yes	7556	53	no	M
2	yes	2298	27	no	M
2	no	1371	20	no	F
2	yes	2012	25	no	F

4. The primary hypothesis oftbis problem is that \"when a customer is ex-posed to additional information about e products available, they will spend. more on those products\". Is this hypothesis directly testable? What hypothesis (or hypotheses} is {are}? 5. The point of promoting the use of QR codes is to try to increase mail,- dint-FEE.- Conduct a ttest of di'erences in mean expenditures by QR scannsage . {a} What are the mean expenditures by scan? lab} What is the null hypothesis? {C} What is the test statistic? {:1} Would you reject e mil] hypoesis at a = 1105? {c} Ifthis were all the information you had available, what would you conclude about QR scan usage? ti. Now conduct e following hypoesis tests. Note at in these tests you are making inferences about the statistical dependence between a numeric variable and a categorical variable. Use a = 0.05. {a} Is ere a statistically signicant difference in the mean expenditures between male and female customers? {b} Is ere a statistically signicant difference in the mean expenditures between married and single customers? {C} Is there a statistically signicant difference in e mean age between customers who use the QR. scanner and ose who do not? {:1} Is there a statistically signicant difference in e mean age betweennrale and female customers? {13] Is there a statistically signicant difference in e mean age betweennrarried and slngle customers? In reporting e results ofthese hypothesis tests DO NUT cut and pasteexcel output. Write out your results in a summary narrative. ?. Now compare the categorical variables with x1 tests of independence (us-i354: = 0.05} between: {a} scan and section Are customers in some sections more likely to scan? {b} scan and married. Are single customers more likely to scan? {C} scan and sex. Are female customers more likely to scan? {:1} section and sex. Are male customers more likely to shop in specific sections? 'Note that this is essentially a test of independence between expenditures and QR. scan In reporting the results of these hypothesis tests DU NOT cut and paste excel output. Write out your results in a summary narrative. 3. There is a lot going on in is data set. Consider only one subset of the variables: expenditures, scan, and section. In question [:5], you found atcustomers who use the QR. scanner spend significantly less an custom erswho do not use e scanner, which seems to indicate at using the QR scanner does no: work in increasing spending. But now consider your ndings in question 3, where you found that e average expenditures were higher for those who scanned in our}? section. Finally, consider your answer in question Ta}, where you found that the probability ofusing thesc anner is different by section. 1|What might the interaction oftbese three variables (expenditures, scan, and section) say about the effectiveness (or-ine'ectiveness} ofusing the QR scanner in increasing expenditures? This is only one of many subsets that you could consider wi this data. You might think about oer interactions in anticipation ofyour final project