[W2W3 MAY23]_Muhammad Shalhan_Assalam_Advanced_Sheet.xlsx

	A	B	C	D	E	F	G	H	I	J	L	M	N	O	P	Q	R	S	T	U	V
1	Amount Spent on Adibi	Income	Total Number of Order	Balena Quantity of Order	Celinna Quantity of Order	Amount Spent on Balena	Amount Spent on Celinna	Promotion Adibi	Promotion Balena	Promotion Celinna
2	140.91	110866	3	4	3	179.7	202.82	0.02	0.14	0.01
3	121.25	159052	1	1	1	155.6	174.61	0.02	0.19	0.01		Amount Spent on Adibi	Income	Total Number of Order	Balena Quantity of Order	Celinna Quantity of Order	Amount Spent on Balena	Amount Spent on Celinna	Promotion Adibi	Promotion Balena	Promotion Celinna
4	135.68	113212	3	1	6	170.54	194.55	0.01	0.11	0.05	Amount Spent on Adibi	1
5	119.09	119602	1	6	9	151.91	171	0.01	0.15	0.1	Income	0.02723784081	1
6	154.55	121466	3	4	1	198.87	222.65	0.02	0.11	0.03	Total Number of Order	0.06873363691	-0.03647996564	1
7	119.68	112347	5	1	4	153.15	172.85	0.01	0.09	0.05	Balena Quantity of Order	-0.006516914048	0.05013309654	-0.04196396307	1
8	115.08	125190	2	8	8	147.23	166.64	0.01	0.08	0.1	Celinna Quantity of Order	0.03701004535	-0.06523443293	-0.01659826888	-0.04320838368	1
9	135.8	131122	4	1	6	171.92	195.1	0.02	0.09	0.03	Amount Spent on Balena	0.9825121497	0.02859541603	0.0539376117	0.006257509524	0.04575154819	1
10	141.38	108960	2	4	1	181.35	204.93	0.01	0.2	0.09	Amount Spent on Celinna	0.9998184856	0.02635887731	0.06869342865	-0.007165583475	0.03590708538	0.9826812606	1
11	144.25	181262	2	4	2	186.97	209.11	0.03	0.07	0.03	Promotion Adibi	-0.1095932375	0.012663463	0.002840767756	0.04646929846	-0.01324340682	-0.1093078715	-0.1096591948	1
12	147.17	122830	1	9	6	188.62	210.69	0.02	0.05	0.03	Promotion Balena	-0.05069862822	-0.05970126778	-0.02492833571	-0.01272705951	-0.0573572273	-0.03726501782	-0.05135436651	-0.0253771776	1
13	143.71	116525	1	1	4	182.81	206.96	0.03	0.12	0.1	Promotion Celinna	-0.02542023738	-0.01332112965	-0.0885638305	0.01717474945	0.01431755157	-0.01336576307	-0.02479023399	0.01027000471	-0.02654819939	1
14	154.57	76881	1	2	4	196.91	222.12	0.01	0.17	0.05
15	138.49	102723	1	10	5	177.32	198.6	0.01	0.19	0.08
16	142.02	104505	2	3	5	180.33	204.67	0.03	0.18	0.1	Descriptive	Amount Spent on Adibi	Income	Total Number of Order	Balena Quantity of Order	Celinna Quantity of Order	Amount Spent on Balena	Amount Spent on Celinna	Promotion Adibi	Promotion Balena	Promotion Celinna
17	231.27	72429	1	5	10	293.75	334.71	0.01	0.12	0.01	Mean	163.86	121789.83	2.97	5.51	5.48	209.22	236.21	1.98%	12.83%	5.40%
18	140.92	58207	1	5	3	180.22	203.21	0.02	0.16	0.06	Median	158.36	117971	3	5	5	202.68	228.72	2%	13%	5%
19	145.13	135754	2	8	3	186.52	208.69	0.01	0.13	0.08	Mode	180.49	89374	1	4	8	241.09	228.72	2%	20%	3%
20	191.17	94868	1	6	7	242.71	273.92	0.03	0.16	0.03	Standard Deviation	37.15	41252.29	1.43	2.79	2.86	48.44	53.45	0.01	0.05	0.03
21	124.87	88428	3	3	5	161	181.22	0.03	0.2	0.01	Kurtosis	34.83	3.84	-1.32	-1.16	-1.22	33.48	34.6	-1.48	-1.23	-1.22
22	170	107633	2	3	6	216.63	245.66	0.01	0.09	0.01	Skewness	4.35	1.39	0.04	0.02	0.02	4.09	4.33	0.04	-0.07	0.08
23	140.84	170146	3	8	1	180.35	202.52	0.02	0.18	0.01	Range	397.32	292052	4	9	9	616.9	571.99	2%	15%	9%
24	170.2	112422	2	4	10	219.56	246.84	0.02	0.17	0.07	Minimum	101	17312	1	1	1	22.76	144.01	1%	5%	1%
25	129.87	53608	4	8	10	166.23	186.81	0.02	0.05	0.04	Maximum	498.32	309364	5	10	10	639.66	716	3%	20%	10%
26	140.97	81210	1	3	5	179.94	202.58	0.02	0.15	0.04	Quartile 1	143.71	95438	2	3	3	183.9	206.96	0.01	0.09	0.03
27	150.63	81014	1	10	10	192.77	216.79	0.02	0.18	0.02	Quartile 3	175.5	138525	4	8	8	224.18	252.93	0.03	0.17	0.08
28	221.97	103181	2	7	3	284.43	318.44	0.01	0.17	0.05	IQR	31.79	43087	2	5	5	40.28	45.97	0.02	0.08	0.05
29	149.53	172957	3	8	7	191.13	216.69	0.01	0.06	0.02	Lower Bound	96.025	30807.5	-1	-4.5	-4.5	123.48	138.005	-0.02	-0.03	-0.045
30	175.78	71310	3	4	5	224.48	254.2	0.02	0.11	0.06	Upper Bound	223.185	203155.5	7	15.5	15.5	284.6	321.885	0.06	0.29	0.155
31	182.9	121592	5	8	6	233.4	262.7	0.02	0.19	0.01	Potential Outlier?	Moderate	Slightly	No	No	No	Moderate	Moderate	No	No	No
32	142.07	94674	3	6	4	179.88	204.51	0.03	0.12	0.06
33	199.54	133105	5	10	8	255.08	288.93	0.01	0.07	0.09
34	162.53	124990	2	7	4	208.36	234.57	0.03	0.12	0.08
35	144.08	126400	5	7	9	183.38	208.12	0.03	0.11	0.09
36	156.59	106215	4	2	4	200.05	226.31	0.03	0.15	0.01
37	490.92	106205	3	4	8	631.76	706.33	0.01	0.09	0.08
38	170.13	85270	5	9	8	214.17	242.77	0.02	0.15	0.02
39	161.54	67861	2	1	9	208.05	232.3	0.02	0.12	0.06
40	151.4	102617	3	3	6	193.77	218.94	0.02	0.12	0.05
41	146.66	69487	2	8	5	187.75	211.02	0.01	0.12	0.08
42	163.16	135090	3	9	4	208.22	235.06	0.01	0.15	0.1
43	139.04	83442	1	7	4	177.49	200.52	0.02	0.2	0.08
44	187.8	146519	4	4	8	238.51	273.11	0.02	0.12	0.07
45	137.62	43805	1	8	7	174.29	197.33	0.02	0.09	0.1
46	168.68	103787	2	4	5	213.84	243.12	0.01	0.15	0.06
47	153.77	164915	5	8	10	195.82	220.63	0.01	0.17	0.03
48	178.87	43684	3	4	2	226.46	259.04	0.03	0.05	0.1
49	145.25	159714	1	2	10	185.39	208.55	0.03	0.1	0.08
50	193.56	91019	4	10	1	247.54	278.56	0.02	0.11	0.1
51	172.9	75705	3	5	6	220.38	248.8	0.01	0.08	0.04
52	141.78	215150	1	9	10	183.84	204.82	0.02	0.05	0.05
53	181.88	116261	1	5	9	232.52	262.33	0.02	0.13	0.04
54	173.54	106987	4	8	8	221.48	250.8	0.01	0.19	0.05
55	151.48	161999	2	5	1	194.41	218.59	0.01	0.18	0.02
56	106.52	113572	5	9	1	135.8	152.17	0.03	0.05	0.08
57	217.19	108315	4	4	9	280.37	312.59	0.01	0.1	0.07
58	152.03	123194	3	4	5	195.19	219.27	0.02	0.11	0.1
59	243.03	81200	1	4	6	312.1	351.29	0.03	0.19	0.04
60	154.41	120682	4	6	10	197.13	222.88	0.01	0.05	0.09
61	202.36	157940	5	2	5	258.45	290.81	0.02	0.07	0.09
62	149.38	64105	4	4	10	194	216.55	0.03	0.11	0.01
63	131.1	62263	3	4	2	167.71	188.66	0.01	0.16	0.07
64	110.47	109053	3	10	2	141.82	158.29	0.02	0.2	0.04
65	141.66	78754	1	8	1	182.47	205.32	0.01	0.15	0.02
66	130.45	168763	3	6	6	165.81	188.56	0.01	0.16	0.02
67	139.58	101210	2	8	4	180.04	202.74	0.03	0.2	0.1
68	180.94	151914	3	9	4	229.73	259.49	0.03	0.07	0.01
69	154.03	106559	5	8	7	197.02	222.73	0.02	0.1	0.02
70	135.41	111821	2	6	6	174.34	196.4	0.01	0.16	0.1
71	124.41	118396	4	7	1	160.21	180.72	0.03	0.18	0.09
72	152.23	87801	5	2	9	197.31	220.24	0.01	0.17	0.03
73	170.42	281084	3	7	5	218.78	247.22	0.01	0.16	0.1
74	140.44	129789	1	6	6	180.93	202.48	0.02	0.14	0.1
75	134.19	135332	5	1	10	172.72	194.7	0.01	0.07	0.05
76	163.71	158405	4	2	7	210.01	237.05	0.03	0.12	0.02
77	158.1	124156	1	2	4	202.08	226.27	0.01	0.07	0.03
78	139.66	141632	5	2	3	178.36	200.69	0.02	0.15	0.03
79	146.29	82082	1	5	6	185.48	210.75	0.03	0.15	0.06
80	219.33	153586	1	7	5	283.33	318.73	0.01	0.05	0.04
81	148.4	69588	2	4	5	192	214.89	0.02	0.16	0.1
82	147.92	68347	5	3	8	188.94	212.89	0.02	0.13	0.03
83	157.14	157299	4	7	1	202.15	226.47	0.01	0.1	0.03
84	140.2	123257	5	6	3	180	202.59	0.01	0.15	0.03
85	155.07	124725	1	3	8	197.13	222.72	0.01	0.17	0.08
86	239.29	147967	2	1	1	307.31	345.97	0.01	0.1	0.05
87	170.49	109195	2	4	10	217.27	244.49	0.02	0.18	0.08
88	163.5	71603	2	9	8	210.39	237.7	0.02	0.08	0.05
89	138.47	105726	5	5	2	177.8	198.47	0.01	0.1	0.02
90	174.91	109380	5	7	2	222.23	251.32	0.02	0.17	0.02
91	106.72	122267	3	6	9	136.78	152.82	0.03	0.07	0.04
92	255.05	135275	5	9	8	324.49	365.8	0.01	0.1	0.05
93	169.49	82357	2	1	5	215.72	243.02	0.03	0.06	0.01
94	204.88	79353	5	1	8	262.31	295.67	0.01	0.2	0.04
95	157.96	121852	2	5	8	203.28	229.54	0.03	0.05	0.05
96	168.13	205383	1	9	8	217.01	241.87	0.02	0.18	0.02
97	157.5	123641	5	2	5	202.58	228.33	0.01	0.16	0.07
98	167.58	88849	1	9	9	216.33	242.4	0.02	0.05	0.06
99	137.08	145781	2	6	1	173.81	198.98	0.01	0.09	0.01
100	186.14	63442	1	5	6	236.53	266.62	0.03	0.07	0.06