Question

Q1. Quickmeal

Description of data

Quickmeal is a local grocery shop that carries a limited variety of meat products, vegetable and fruits, dairy products, and beverages. The owner of Quickmeal, let’s call him John, wants to expand his business. John wants to understand the purchasing behaviour of his customers, so he can predict future demands. He recorded daily sales of products in June. The dataset is called “Quickmeal”, which is available in different formats. It shows the daily sales in Canadian Dollars for four different types of products. This is the structure of data:

Day	Day of the month
Meat	Sales of meat products in CAD
Bev	Sales of beverages in CAD (except dairy beverages)
FRVEG	Sales of all fruits and Vegetables in CAD
Dairy	Sales of all dairy products in CAD

Analyze data and help John to understand his customers. Label your graphs appropriately and provide full descriptions.

1. Prepare histogram and boxplot for beverages. Copy your plots (Label them as Figure 4 and Figure 5). Comment on data distribution. Do you see any unusual case(s)? (Hint. Let software take care of plots.) (4 points)

Data:

day	meat	Bev	FRVEG	dairy
1	201.5	58.2	211.2	75.5
2	153.5	57.3	213.5	65.7
3	210.5	49.5	249.5	75.3
4	209.5	51.5	279.5	74.4
5	189.5	53.5	283.5	80.9
6	348.5	61.5	303.5	79
7	401.5	63.5	421.5	73.6
8	225.68	64.602	232.32	85.1
9	171.92	63.603	234.85	78.6
10	235.76	54.945	274.45	82.2
11	234.64	57.165	307.45	70.9
12	212.24	59.385	311.85	91.8
13	390.32	68.265	333.85	85.9
14	449.68	70.485	463.65	72.9
15	259.532	73.64628	278.784	72.4
16	197.708	72.50742	281.82	68.1
17	271.124	62.6373	329.34	70.1
18	269.836	65.1681	368.94	60.5
19	244.076	67.6989	374.22	75.4
20	448.868	77.8221	400.62	62.3
21	517.132	80.3529	556.38	78.2
22	306.2478	84.693222	306.6624	67.8
23	233.2954	83.383533	310.002	70.5
24	319.9263	72.032895	362.274	71.1
25	318.4065	74.943315	405.834	60.3
26	288.0097	77.853735	411.642	70.7
27	673.302	116.73315	721.116	65
28	775.698	20	612.018	71.8
29	367.4973	110.1011886	321.99552	65.3
30	279.9545	100.0602396	325.5021	55.6

Answer 1

From histogram we observed that Sales of meat products in CAD (Meat) and Sales of all fruits and Vegetables in CAD (FRVEG) is positively skewed whereas Sales of beverages in CAD (Bev) and Sales of all dairy products in CAD (dairy) are symmetrically distributed.

From box plots we see that average sale of all fruits and Vegetables is higher than average sales of meat products in CAD. However average sales of beverages and dairy products in CAD are more or less same. Moreover sales of all fruits and Vegetables and sales of meat products in CAD are significantly higher than sales of beverages and dairy products in CAD.

Here we notice that data for sales of dairy product has no outliers, whereas data for other three products have outliers.

From above box plots we see that meat has maximum variation, dairy has smallest variation. However, variation of Bev and dairy are significantly low than meat and FRVEG.