Bar_dataset.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Segment	Country	Product	Qty Sold	Sales Date	Unit Price	Gross Sale	Unit Cost	Net Sales	Profit
2	Government	Canada	Pen	20	11/11/2019	21.00	420.00	20	400	20.00
3	Government	Germany	Pen	15	7/7/2019	2.00	30.00	1	15	15.00
4	Midmarket	France	Pen	1999	8/6/2018	5.00	9995.00	3	5997	3998.00
5	Midmarket	Germany	Pen	350	2/9/2019	7.00	2450.00	1	350	2100.00
6	Midmarket	Mexico	Pen	12	8/21/2019	13.00	156.00	8	96	60.00
7	Government	Germany	Pen	7	9/11/2020	12.00	84.00	10	70	14.00
8	Midmarket	Germany	Pen	15	11/22/2019	3.00	45.00	1	15	30.00
9	Channel Partners	Canada	Pen	120	11/11/2020	44.00	5280.00	40	4800	480.00
10	Government	France	Pen	15	9/8/2019	21.00	315.00	11	165	150.00
11	Channel Partners	Germany	Pencel	7	11/11/2018	34.00	238.00	20	140	98.00
12	Midmarket	Mexico	Pencel	22	2/1/2020	21.00	462.00	11	242	220.00
13	Enterprise	Canada	Pencel	12	11/22/2019	56.00	672.00	23	276	396.00
14	Small Business	Mexico	Pencel	15	7/11/2019	55.00	825.00	22	330	495.00
15	Government	Germany	Pencel	20	11/22/2019	77.00	1540.00	33	660	880.00
16	Enterprise	Canada	Pad	800	6/8/2018	89.00	71200.00	81	64800	6400.00
17	Midmarket	United States of America	Pad	7	9/8/2019	9.00	63.00	3	21	42.00
18	Government	Canada	Pad	125	11/6/2020	76.00	9500.00	75	9375	125.00
19	Midmarket	Mexico	Pad	12	8/11/2019	45.00	540.00	21	252	288.00
20	Channel Partners	Canada	Pad	150	9/22/2018	32.00	4800.00	31	4650	150.00
21	Government	Germany	Mouse	12	9/3/2019	56.00	672.00	23	276	396.00
22	Channel Partners	Germany	Mouse	125	11/23/2018	78.00	9750.00	45	5625	4125.00
23	Government	Mexico	Mouse	125	9/12/2019	44.00	5500.00	42	5250	250.00
24	Midmarket	France	Mouse	300	8/9/2020	32.00	9600.00	21	6300	3300.00
25	Small Business	Mexico	Mouse	12	6/8/2019	12.00	144.00	11	132	12.00
26	Midmarket	Mexico	Mouse	15	5/4/2019	45.00	675.00	30	450	225.00
27	Government	United States of America	Keyboard	312	9/30/2018	67.00	20904.00	50	15600	5304.00
28	Government	Canada	Keyboard	350	12/9/2019	43.00	15050.00	41	14350	700.00
29	Channel Partners	United States of America	Keyboard	300	9/5/2018	32.00	9600.00	21	6300	3300.00
30	Midmarket	Canada	Keyboard	20	9/22/2020	21.00	420.00	11	220	200.00
31	Government	Canada	Keyboard	350	6/8/2019	21.00	7350.00	11	3850	3500.00
32	Government	Germany	Keyboard	12	8/24/2020	23.00	276.00	21	252	24.00
33	Government	Mexico	Keyboard	125	12/9/2019	45.00	5625.00	45	5625	0.00
34	Enterprise	France	Keyboard	20	9/5/2018	67.00	1340.00	33	660	680.00
35	Channel Partners	Germany	CPU	20	7/9/2020	89.00	1780.00	78	1560	220.00
36	Government	Germany	CPU	20	9/22/2019	8.00	160.00	5	100	60.00
37	Channel Partners	Germany	CPU	15	8/29/2019	65.00	975.00	55	825	150.00
38	Enterprise	United States of America	CPU	15	12/9/2019	44.00	660.00	33	495	165.00
39	Enterprise	Canada	CPU	15	8/22/2018	36.00	540.00	23	345	195.00
40	Small Business	Canada	CPU	350	3/30/2019	78.00	27300.00	76	26600	700.00
41	Channel Partners	Germany	CPU	15	9/6/2020	32.00	480.00	31	465	15.00
42	Midmarket	France	CPU	12	4/25/2019	55.00	660.00	33	396	264.00
43	Midmarket	Germany	CPU	20	9/24/2018	44.00	880.00	22	440	440.00
44	Government	France	CPU	12	7/12/2019	88.00	1056.00	77	924	132.00
45	Small Business	France	Hard Disk	15	4/30/2018	76.00	1140.00	75	1125	15.00
46	Government	Canada	Hard Disk	125	9/18/2018	2.00	250.00	1	125	125.00
47	Government	France	Hard Disk	300	7/9/2020	8.00	2400.00	6	1800	600.00
48	Channel Partners	United States of America	Hard Disk	7	9/19/2019	45.00	315.00	41	287	28.00
49	Enterprise	Germany	Hard Disk	125	2/7/2018	31.00	3875.00	29	3625	250.00
50	Government	France	Hard Disk	15	8/8/2020	12.00	180.00	10	150	30.00
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100