Week1_Coffee_Survey_Data.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Customer_ID	Age	Gender	Suburb	Preferred_Drink	Monthly_Visits	Items_Per_Visit	Avg_Spend_AUD	Wait_Time_Min	Satisfaction	Membership	Distance_KM	Payment_Method	Visit_Time

2	CUST-1001	41	Female	CBD	Mocha	4	1	$11.98	6.5	Satisfied	No	0.3	Cash	Morning
3	CUST-1002	37	Male	Collingwood	Long Black	9	3	$12.71	5.6	Satisfied	No	3.0	Card	Morning
4	CUST-1003	28	Female	Fitzroy	Chai Latte	3	2	$10.45	5.9	Satisfied	Yes	1.4	Cash	Evening
5	CUST-1004	20	Male	Richmond	Hot Chocolate	13	2	$12.24	5.2	Very Satisfied	No	8.6	Mobile Pay	Evening
6	CUST-1005	32	Non-binary	Brunswick	Chai Latte	3	2	$10.03	1.8	Very Satisfied	Yes	2.2	Card	Morning
7	CUST-1006	34	Female	Richmond	Matcha Latte	4	2	$12.00	3.8	Very Satisfied	No	1.2	Cash	Evening
8	CUST-1007	47	Male	Fitzroy	Iced Coffee	6	4	$16.40	4.9	Neutral	No	0.8	Card	Evening
9	CUST-1008	26	Male	Fitzroy	Cappuccino	7	1	$9.85	4.8	Satisfied	No	1.3	Cash	Morning
10	CUST-1009	34	Male	Richmond	Matcha Latte	12	1	$8.01	1.5	Satisfied	Yes	2.2	Cash	Morning
11	CUST-1010	33	Male	Richmond	Matcha Latte	10	2	$14.65	6.2	Very Satisfied	No	0.6	Card	Morning
12	CUST-1011	59	Male	CBD	Hot Chocolate	5	1	$13.33	2.7	Very Satisfied	Yes	0.3	Mobile Pay	Evening
13	CUST-1012	20	Female	Southbank	Matcha Latte	10	1	$5.58	4.9	Satisfied	No	1.3	Card	Afternoon
14	CUST-1013	53	Male	Richmond	Espresso	20	3	$12.31	5.4	Neutral	Yes	1.0	Card	Morning
15	CUST-1014	30	Male	Southbank	Flat White	4	4	$18.91	3.9	Neutral	No	0.7	Cash	Evening
16	CUST-1015	48	Female	Brunswick	Long Black	10	4	$18.71	5.3	Satisfied	No	1.5	Mobile Pay	Afternoon
17	CUST-1016	42	Female	CBD	Espresso	9	4	$19.56	5.3	Satisfied	Yes	0.6	Card	Evening
18	CUST-1017	19	Female	Collingwood	Latte	2	5	$24.89	0.5	Very Satisfied	No	0.6	Card	Morning
19	CUST-1018	26	Male	Carlton	Espresso	1	2	$15.83	2.9	Satisfied	No	2.8	Mobile Pay	Afternoon
20	CUST-1019	37	Female	Fitzroy	Mocha	4	1	$8.62	3.8	Satisfied	Yes	1.5	Mobile Pay	Afternoon
21	CUST-1020	25	Male	Southbank	Cappuccino	2	1	$10.34	2.9	Very Satisfied	No	1.9	Cash	Morning
22	CUST-1021	44	Female	Docklands	Matcha Latte	5	2	$10.85	3.0	Satisfied	Yes	2.3	Card	Evening
23	CUST-1022	19	Male	Brunswick	Hot Chocolate	20	5	$23.05	5.1	Satisfied	No	4.5	Mobile Pay	Morning
24	CUST-1023	22	Female	Collingwood	Mocha	8	5	$21.32	4.3	Very Satisfied	Yes	2.4	Mobile Pay	Morning
25	CUST-1024	24	Female	Collingwood	Cappuccino	5	3	$14.76	3.2	Satisfied	Yes	1.5	Mobile Pay	Afternoon
26	CUST-1025	21	Female	Richmond	Flat White	1	3	$13.83	3.3	Very Satisfied	No	1.3	Cash	Morning
27	CUST-1026	48	Female	Collingwood	Flat White	11	3	$15.88	5.3	Satisfied	No	3.4	Mobile Pay	Evening
28	CUST-1027	28	Male	Southbank	Chai Latte	10	4	$15.40	6.0	Neutral	No	4.2	Mobile Pay	Afternoon
29	CUST-1028	27	Male	Carlton	Chai Latte	10	2	$9.93	1.6	Neutral	Yes	2.6	Card	Morning
30	CUST-1029	35	Male	Fitzroy	Iced Coffee	5	4	$19.53	3.5	Very Satisfied	No	0.9	Cash	Afternoon
31	CUST-1030	28	Male	South Yarra	Matcha Latte	5	1	$10.09	3.4	Satisfied	No	0.3	Card	Morning
32	CUST-1031	60	Male	South Yarra	Hot Chocolate	19	1	$10.01	3.7	Dissatisfied	No	1.7	Mobile Pay	Afternoon
33	CUST-1032	54	Male	St Kilda	Espresso	2	3	$14.05	6.0	Very Satisfied	No	0.9	Card	Morning
34	CUST-1033	26	Non-binary	Collingwood	Cappuccino	4	3	$12.09	6.8	Neutral	No	1.2	Mobile Pay	Morning
35	CUST-1034	28	Female	Docklands	Hot Chocolate	8	2	$10.28	5.0	Satisfied	No	3.4	Card	Morning
36	CUST-1035	40	Female	St Kilda	Latte	11	3	$14.27	3.2	Neutral	Yes	0.8	Card	Afternoon
37	CUST-1036	19	Female	South Yarra	Hot Chocolate	4	3	$13.23	4.6	Satisfied	Yes	3.0	Mobile Pay	Morning
38	CUST-1037	29	Male	Carlton	Matcha Latte	6	3	$16.20	4.0	Neutral	No	1.7	Card	Morning
39	CUST-1038	56	Female	Docklands	Matcha Latte	6	4	$16.91	4.9	Very Satisfied	No	3.0	Mobile Pay	Morning
40	CUST-1039	59	Male	Brunswick	Long Black	5	1	$8.26	6.1	Satisfied	No	0.5	Card	Afternoon
41	CUST-1040	50	Male	Southbank	Espresso	6	2	$10.43	5.2	Satisfied	No	2.0	Mobile Pay	Evening
42	CUST-1041	57	Female	South Yarra	Iced Coffee	1	2	$12.01	0.6	Very Satisfied	No	3.0	Card	Afternoon
43	CUST-1042	30	Female	Fitzroy	Mocha	6	1	$6.76	7.1	Satisfied	Yes	1.5	Cash	Afternoon
44	CUST-1043	21	Female	Docklands	Hot Chocolate	8	1	$4.18	6.2	Neutral	Yes	1.0	Card	Morning
45	CUST-1044	32	Non-binary	South Yarra	Mocha	11	2	$11.89	3.8	Very Satisfied	Yes	0.3	Mobile Pay	Morning
46	CUST-1045	21	Male	Fitzroy	Flat White	8	2	$10.68	4.7	Very Satisfied	No	0.8	Card	Afternoon
47	CUST-1046	55	Female	Carlton	Mocha	3	1	$7.27	7.3	Very Satisfied	No	2.7	Cash	Afternoon
48	CUST-1047	40	Male	Southbank	Mocha	12	3	$20.30	8.5	Very Satisfied	Yes	1.3	Card	Afternoon
49	CUST-1048	27	Male	South Yarra	Iced Coffee	3	5	$18.41	1.7	Very Satisfied	No	2.8	Mobile Pay	Morning
50	CUST-1049	63	Male	Brunswick	Iced Coffee	6	3	$14.54	8.4	Very Satisfied	Yes	4.5	Card	Morning
51	CUST-1050	38	Female	St Kilda	Flat White	6	2	$9.57	4.6	Neutral	Yes	2.0	Mobile Pay	Afternoon
52	CUST-1051	41	Male	Southbank	Long Black	9	2	$12.10	1.4	Satisfied	No	3.3	Cash	Morning
53	CUST-1052	48	Male	Richmond	Hot Chocolate	5	3	$10.41	10.1	Satisfied	No	1.4	Card	Morning
54	CUST-1053	52	Male	St Kilda	Latte	10	5	$20.90	3.3	Very Satisfied	Yes	2.0	Mobile Pay	Afternoon
55	CUST-1054	22	Male	Richmond	Long Black	5	2	$11.56	3.5	Dissatisfied	Yes	0.9	Mobile Pay	Afternoon
56	CUST-1055	56	Female	Southbank	Flat White	7	2	$10.41	5.0	Dissatisfied	No	1.5	Mobile Pay	Morning
57	CUST-1056	19	Female	CBD	Cappuccino	3	3	$12.45	10.5	Neutral	No	2.1	Mobile Pay	Morning
58	CUST-1057	41	Female	Brunswick	Iced Coffee	5	3	$12.18	5.6	Dissatisfied	No	0.4	Mobile Pay	Afternoon
59	CUST-1058	26	Female	Carlton	Long Black	4	1	$11.44	4.5	Satisfied	Yes	0.7	Mobile Pay	Afternoon
60	CUST-1059	33	Female	Fitzroy	Mocha	10	3	$12.02	0.5	Satisfied	No	2.3	Mobile Pay	Afternoon
61	CUST-1060	19	Male	Carlton	Mocha	8	4	$20.67	3.5	Satisfied	Yes	1.2	Card	Afternoon
62	CUST-1061	31	Female	Docklands	Flat White	13	3	$14.64	4.2	Neutral	No	4.1	Card	Morning
63	CUST-1062	57	Non-binary	Docklands	Flat White	10	1	$6.02	4.2	Satisfied	No	1.3	Mobile Pay	Evening
64	CUST-1063	35	Male	South Yarra	Chai Latte	5	1	$10.07	6.2	Satisfied	No	1.2	Mobile Pay	Morning
65	CUST-1064	21	Male	Richmond	Chai Latte	3	3	$18.18	1.7	Very Dissatisfied	No	1.4	Cash	Afternoon
66	CUST-1065	39	Female	Brunswick	Flat White	4	2	$14.31	3.6	Very Satisfied	Yes	7.4	Card	Morning
67	CUST-1066	22	Non-binary	Collingwood	Flat White	7	1	$14.22	4.3	Satisfied	Yes	3.8	Card	Afternoon
68	CUST-1067	40	Non-binary	South Yarra	Iced Coffee	19	2	$9.57	3.9	Very Satisfied	No	4.4	Mobile Pay	Morning
69	CUST-1068	61	Female	St Kilda	Matcha Latte	4	1	$7.99	0.7	Satisfied	No	4.2	Card	Morning
70	CUST-1069	26	Male	Collingwood	Espresso	6	2	$13.35	7.4	Satisfied	Yes	3.2	Cash	Afternoon
71	CUST-1070	50	Female	South Yarra	Cappuccino	7	1	$5.36	4.5	Very Satisfied	No	1.4	Card	Morning
72	CUST-1071	52	Female	South Yarra	Cappuccino	2	3	$14.77	7.3	Satisfied	Yes	1.0	Mobile Pay	Afternoon
73	CUST-1072	33	Female	Collingwood	Flat White	8	2	$11.08	3.0	Neutral	Yes	7.9	Mobile Pay	Afternoon
74	CUST-1073	22	Female	Carlton	Mocha	14	1	$9.30	2.9	Satisfied	Yes	1.7	Card	Afternoon
75	CUST-1074	23	Female	Southbank	Hot Chocolate	13	3	$15.42	8.9	Neutral	No	0.8	Card	Morning
76	CUST-1075	62	Female	Richmond	Matcha Latte	3	2	$10.02	6.7	Satisfied	No	0.8	Mobile Pay	Morning
77	CUST-1076	33	Female	Southbank	Long Black	5	2	$10.80	7.5	Very Dissatisfied	No	1.2	Cash	Evening
78	CUST-1077	59	Male	Docklands	Iced Coffee	11	4	$18.59	3.1	Very Satisfied	Yes	0.6	Card	Afternoon
79	CUST-1078	58	Female	Southbank	Flat White	5	2	$8.34	2.9	Dissatisfied	Yes	3.0	Card	Morning
80	CUST-1079	44	Male	Collingwood	Matcha Latte	14	4	$18.10	8.2	Satisfied	No	2.9	Card	Morning
81	CUST-1080	19	Female	Fitzroy	Espresso	17	4	$15.36	7.1	Very Dissatisfied	No	1.4	Mobile Pay	Afternoon
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100