DB4

Grocery Zip

	Grocery Zip
	Customer Name	Average Satisfaction Score	Trend in Satisfaction	Predicted Satisfaction (Next Quarter)	Time to Delivery (Days)	Grocery Item Category	Average Order Cost ($)
	Wilson	7	Stable	7.1	2	Produce	52
	Patel	7.33	Increasing	7.5	3	Dairy	45
	Garcia	7	Decreasing	6.8	4	Frozen Foods	60
	Nguyen	6	Stable	6.1	5	Snacks	30
	Smith	7.67	Increasing	7.8	2	Condiments	40
	Johnson	6.33	Decreasing	6	6	Cleaning Supplies	55
	Kim	6	Stable	6.1	4	Personal Care	25
	Brown	10	Increasing	10.2	1	Premium Products	90
	Martinez	6.67	Stable	6.8	3	Beverages	35
	Lee	8.33	Increasing	8.5	2	Organic Foods	70
	Clean Dataset (numerical only)
	Customer Name	Average Satisfaction Score	Trend (Numerical)	Predicted Satisfaction	Time to Delivery (Days)	Average Order Cost ($)
	Wilson	7	0	7.1	2	52
	Patel	7.33	1	7.5	3	45
	Garcia	7	-1	6.8	4	60
	Nguyen	6	0	6.1	5	30
	Smith	7.67	1	7.8	2	40
	Johnson	6.33	-1	6	6	55
	Kim	6	0	6.1	4	25
	Brown	10	1	10.2	1	90
	Martinez	6.67	0	6.8	3	35
	Lee	8.33	1	8.5	2	70
	1. Average Satisfaction Score: The mean score calculated from Product A, B, and C scores for each customer
	2. Trend in Satisfaction: Identifies if customer satisfaction is stable, increasing, or decreasing based on the scores over time
	3. Predicted Satisfaction (Next Quarter): A predictive estimate of what customer satisfaction scores might look like next quarter using regression analysis or other predictive modeling techniques based on existing trends
	4. Time to Delivery (Days): The average time taken in days to deliver grocery orders to each customer, which may correlate with customer satisfaction
	5. Grocery Item Category: The primary category of grocery items that each customer typically orders, providing insight into market trends and customer preferences
	6. Average Order Cost ($): The mean cost of orders placed by each customer; helps in analyzing the relationship between order costs and customer satisfaction or delivery times

Average Satisfaction Score

Wilson Patel Garcia Nguyen Smith Johnson Kim Brown Martinez Lee 7 7.33 7 6 7.67 6.33 6 10 6.67 8.33

Predicted Satisfaction (Next Quarter) Stable Increasing Decreasing Stable Increasing Decreasing Stable Increasing Stable Increasing 7 7.33 7 6 7.67 6.33 6 10 6.67 8.33 Wilson Patel Garcia Nguyen Smith Johnson Kim Brown Martinez Lee 7.1 7.5 6.8 6.1 7.8 6 6.1 10.199999999999999 6.8 8.5

Average Order Cost ($) Wilson Patel Garcia Nguyen Smith Johnson Kim Brown Martinez Lee 52 45 60 30 40 55 25 90 35 70

Grocery Zip Raw Data

Customer Name	Average Satisfaction Score	Trend in Satisfaction	Trend (Numerical)	Predicted Satisfaction (Next Quarter)	Time to Delivery (Days)	Grocery Item Category	Average Order Cost ($)	Product A Score	Product B Score	Product C Score
Wilson	7	Stable	0	7.1	2	Produce	52	7	8	6
Patel	7.33	Increasing	1	7.5	3	Dairy	45	6	7	9
Garcia	7	Decreasing	-1	6.8	4	Frozen Foods	60	8	6	7
Nguyen	6	Stable	0	6.1	5	Snacks	30	5	5	8
Smith	7.67	Increasing	1	7.8	2	Condiments	40	9	8	6
Johnson	6.33	Decreasing	-1	6	6	Cleaning Supplies	55	4	9	7
Kim	6	Stable	0	6.1	4	Personal Care	25	6	7	5
Brown	10	Increasing	1	10.2	1	Premium Products	90	10	10	10
Martinez	6.67	Stable	0	6.8	3	Beverages	35	7	5	7
Lee	8.33	Increasing	1	8.5	2	Organic Foods	70	8	9	8