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.

Questions

1. John wants to understand the association between the amount of money people spend on meat products, beverages, and dairy. Prepare two scatter plots.

One scatter plot should show the association between Meat and Bev (Label it Figure 1). Copy the plots in your solution. Then describe the associations between the meat and beverages. (2 points)

The next scatter plot should show the association between Meat and Dairy (Label it Figure 2).  Copy the plots in your solution. Then describe the associations between the meat and dairy products. (2 points)

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

Scatter plot between Meat and Bev

The scatter plot is obtained in excel by following these steps,

Step 1: Write the data values in excel. The screenshot is shown below,

в с 1 meat Bev 201.5 58.2 153.5 57.3 210.5 49.5 209.5 51.5 189.5 5350% 348.5 6150% 401.5 63.5

Step 2: select the meat and Bev column then INSERT > Recommended Charts > Scatter > OK. The screenshot is shown below,

FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW neeraj n A Recommended Charts Tables Illustrations Add- ins chet Sparklines Filters Links Text Insert Chart Recommended Charts All Charts Scatter Bev 0 100 200 300 400 500 600 700 800 5

The Chart is obtained. The screenshot is shown below,

Figure 1 Bev 0 100 200 300 600 700 800 900 400 500 meat

Conclusion: From the scatter plot we can observe that sales of meat product in Canada and sales of beverages in Canada (except dairy beverages) are positively correlated.

Scatter plot between Meat and Dairy

The scatter plot is obtained in excel by following these steps,

Step 1: Write the data values in excel. The screenshot is shown below,

1 meat 201.5 153.5 210.5 209.5 189.5 348.5 401.5 dairy 75.5 65.7 75.3 74.4 80.9 79 73.6 A

Step 2: select the meat and Dairy column then INSERT > Recommended Charts > Scatter > OK. The screenshot is shown below,

FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW neeraj Tables Illustrations Add- ins PivotChart Sparklines Filters Links Recommended Charts Text Insert Chart Recommended Charts All Charts Scatter dairy 0 100 200 300 400 500 600 700 800 9 A scatter chart is used to compare at least two sets of values or pairs data. Use it to show relationships between sets of values.

The Chart is obtained. The screenshot is shown below,

Figure 2 dairy 0 100 200 300 600 700 800 900 400 500 meat

Conclusion: From the scatter plot we can observe that sales of meat product in Canada and sales of all dairy products in Canada have weak negative correlation.