NEW EXCEL DATA ANALYSIS PROJECT BY KEHINDE ODEWABI.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	orderid	orderdate	brand	state	customertype	unitssold	unitprice	unit cost	discount	customerage	customer_rating	Target Net Result
2	C001	4/13/2022	Opo	RIV	Returning	31	271965	157352.4194	0.23	44	4	3468175.657
3	C002	12/15/2022	Tecno	OYO	Returning	42	621405	402365.3571	0.06	22	3.5	3214228.167
4	C003	9/28/2022	Infinix	RIV	Returning	25	533940	355681.8	0.1	19	1.3	3602515.466
5	C004	4/17/2022	Oppo	OYO	New	13	139050	83469.23077	0.16	50	3.1	3468175.657
6	C005	3/13/2022	Xiaomi	OYO	Returning	6	384285	252837.5	0.17	33	2.4	3254441.12
7	C006	7/8/2022	Infinix	OYO	New	44	510465	208990.9091	0.01	40	2.3	4178362.073
8	C007	1/21/2022	Infinix	OYO	Returning	9	182010	104081.6667	0.28	55	3.4	3187999.222
9	C008	4/13/2022	Oppo	LAG	New	45	624285	319368.6667	0.21	33	2.3	3468175.657
10	C009	5/2/2022	Aple	FCT	Returning	36	412035	186103.75	0.15	31	4.1	3820467.881
11	C010	8/3/2022	Xiaomi	LAG	Returning	56	130185	57257.67857	0.28	46	1.3	2692693.382
12	C011	11/27/2022	Oppo	RIV	Returning	43	440370	282399.0698	0.13	43	3.6	3137536.062
13	C012	3/29/2022	Xiaomi	LAG	Returning	20	749790	456952.5	0.29	52	4.2	3254441.12
14	C013	4/10/2022	Xiaomi	LAG	New	18	119265	59803.33333	0.15	32	3.7	3468175.657
15	C014	12/26/2022	Infinix	RIV	Returning	58	613935	361227.1552	0.03	20	3	3214228.167
16	C015	6/1/2022	Tecno	RIV	Returning	43	161430	96356.51163	0.23	40	4.8	3559983.639
17	C016	5/11/2022	Xiaomi	RIV	New	57	588420	281266.8421	0.2	46	2.2	3820467.881
18	C017	5/30/2022	Google	LAG	Returning	21	552930	365396.4286	0.23	51	1.1	3820467.881
19	C018	11/5/2022	Infinix	LAG	New	4	230610	164280	0.29	50	2.7	3137536.062
20	C019	9/15/2022	Apple	RIV	Returning	50	249420	178730.7	0.23	58	1.1	3602515.466
21	C020	12/10/2022	Tecno	FCT	Returning	33	595950	381996.8182	0.18	58	4.8	3214228.167
22	C021	10/21/2022	Google	FCT	Returning	27	350130	211707.7778	0.26	40	1.8	3045477.385
23	C022	7/11/2022	Google	OYO	New	7	550125	233475	0.2	24	4.2	4178362.073
24	C023	10/4/2022	Apple	RIV	Returning	6	117375	60462.5	0.12	20	4.1	3045477.385
25	C024	6/10/2022	Tecno	OYO	Returning	15	640530	280109	0.27	49	1.9	3559983.639
26	C025	11/10/2022	Infinix	FCT	Returning	18	535335	420521.6667	0.07	48	3.5	3137536.062
27	C026	1/22/2022	Samsung	OYO	New	32	680910	309155.1563	0.21	35	1.2	3187999.222
28	C027	9/10/2022	Tecno	RIV	New	56	105780	48733.92857	0.26	60	2.9	3602515.466
29	C028	8/24/2022	Apple	RIV	Returning	11	447810	338468.1818	0.22	24	1.1	2692693.382
30	C029	12/11/2022	Google	RIV	New	20	452340	351726.75	0.21	58	4.7	3214228.167
31	C030	2/18/2022	Infinix	LAG	Returning	24	269940	190666.875	0.23	18	4.9	3352437.706
32	C031	2/28/2022	Tecno	OYO	Returning	15	347910	139916	0.14	31	1.9	3352437.706
33	C032	6/19/2022	Samsung	FCT	Returning	48	95700	59299.375	0.26	69	1.8	3559983.639
34	C033	7/7/2022	Samsung	FCT	Returning	7	561300	309411.4286	0.06	49	4	4178362.073
35	C034	9/28/2022	Xiaomi	FCT	Returning	21	415365	189970.7143	0.04	23	2	3602515.466
36	C035	7/9/2022	Xiaomi	LAG	Returning	42	50370	20518.57143	0.09	56	4.6	4178362.073
37	C036	6/24/2022	Oppo	LAG	Returning	26	512955	300400.3846	0.16	27	3.3	3559983.639
38	C037	2/20/2022	Apple	RIV	New	44	354090	275207.3864	0.15	24	2.4	3352437.706
39	C038	12/30/2022	Tecno	FCT	New	56	33090	17522.14286	0.25	43	4.3	3214228.167
40	C039	2/24/2022	Tecno	LAG	New	14	727440	483352.5	0.12	51	3	3352437.706
41	C040	9/1/2022	Oppo	RIV	New	57	712215	470698.6842	0.15	47	4.6	3602515.466
42	C041	11/16/2022	Google	FCT	New	37	388335	194335.1351	0	53	4.7	3137536.062
43	C042	5/11/2022	Google	OYO	New	58	77055	50869.39655	0.12	38	1.7	3820467.881
44	C043	11/3/2022	Oppo	RIV	New	21	567810	275350	0.19	34	1	3137536.062
45	C044	5/15/2022	Google	LAG	Returning	18	372765	167298.3333	0	50	4.9	3820467.881
46	C045	1/21/2022	Xiaomi	LAG	Returning	5	232065	157932	0.08	27	4.6	3187999.222
47	C046	11/25/2022	Tecno	RIV	Returning	3	372375	165845	0.06	68	1.2	3137536.062
48	C047	6/16/2022	Oppo	RIV	Returning	23	395415	315843.2609	0.01	64	4.3	3559983.639
49	C048	10/1/2022	Tecno	LAG	New	26	425310	201333.4615	0.14	59	2.8	3045477.385
50	C049	3/30/2022	Samsung	OYO	New	37	335115	213688.3784	0.05	68	2	3254441.12
51	C050	11/12/2022	Xiaomi	FCT	Returning	24	457275	258154.375	0.22	29	4.5	3137536.062
52	C051	1/14/2022	Infinix	OYO	Returning	49	689655	310727.1429	0.25	33	1.8	3187999.222
53	C052	8/30/2022	Xiaomi	RIV	New	19	276480	113671.5789	0.16	58	4.8	2692693.382
54	C053	9/22/2022	Oppo	OYO	Returning	51	546345	354628.5294	0.29	49	1.8	3602515.466
55	C054	12/12/2022	Infinix	LAG	Returning	25	671625	485385.6	0.14	32	3.5	3214228.167
56	C055	2/22/2022	Samsung	RIV	Returning	21	346065	254982.8571	0.15	44	1.9	3352437.706
57	C056	12/6/2022	Oppo	FCT	Returning	12	336765	199730	0.3	45	3.2	3214228.167
58	C057	4/2/2022	Apple	LAG	New	57	454575	323194.7368	0.07	34	3.7	3468175.657
59	C058	9/21/2022	Tecno	LAG	Returning	41	446625	298854.1463	0.28	63	1.8	3602515.466
60	C059	2/4/2022	Samsung	FCT	Returning	33	606390	418228.1818	0.01	67	3.1	3352437.706
61	C060	7/25/2022	Tecno	FCT	New	50	361290	215704.5	0.13	19	2.9	4178362.073
62	C061	3/22/2022	Google	OYO	New	53	747120	488141.8868	0.02	53	1.3	3254441.12
63	C062	2/19/2022	Apple	RIV	Returning	4	51660	37308.75	0.22	67	4.3	3352437.706
64	C063	12/26/2022	Apple	FCT	New	42	69855	50510.35714	0.18	24	2.3	3214228.167
65	C064	1/2/2022	Samsung	FCT	Returning	57	482850	348806.8421	0.21	30	3.3	3187999.222
66	C065	2/23/2022	Apple	RIV	Returning	7	229095	145890	0.11	32	3.1	3352437.706
67	C066	4/16/2022	Infinix	FCT	New	22	185985	86736.13636	0.11	42	3.1	3468175.657
68	C067	9/17/2022	Apple	FCT	Returning	55	239085	97994.72727	0.01	40	1.4	3602515.466
69	C068	11/6/2022	Tecno	OYO	Returning	33	197610	107717.2727	0.1	39	2.7	3137536.062
70	C069	7/10/2022	Tecno	LAG	Returning	17	30360	48782.64706	0.28	43	2.8	4178362.073
71	C070	8/6/2022	Oppo	LAG	Returning	24	728865	536392.5	0.11	50	3.9	2692693.382
72	C071	2/13/2022	Tecno	LAG	New	34	171405	77302.5	0.25	28	4.4	3352437.706
73	C072	6/11/2022	Oppo	LAG	New	28	552510	397853.0357	0.25	27	3.2	3559983.639
74	C073	7/21/2022	Tecno	FCT	Returning	58	573735	427549.3966	0.11	42	1.3	4178362.073
75	C074	9/27/2022	Infinix	RIV	New	43	697470	321027.907	0.19	54	1.9	3602515.466
76	C075	12/17/2022	Oppo	RIV	Returning	41	30180	22352.56098	0.03	65	1.7	3214228.167
77	C076	10/31/2022	Xiaomi	OYO	Returning	39	654990	521752.6923	0.03	60	1.5	3045477.385
78	C077	9/28/2022	Google	OYO	Returning	22	398970	275582.7273	0.01	55	2.5	3602515.466
79	C078	8/3/2022	Samsung	FCT	Returning	49	477165	340651.8367	0.17	58	1.9	2692693.382
80	C079	9/9/2022	Tecno	RIV	Returning	17	486015	387726.1765	0.13	62	1.9	3602515.466
81	C080	7/9/2022	Apple	RIV	New	34	616200	395718.9706	0.16	41	1.2	4178362.073
82	C081	10/23/2022	Tecno	LAG	Returning	6	255060	133435	0.16	57	1.1	3045477.385
83	C082	8/1/2022	Apple	FCT	New	46	551790	405572.6087	0.11	63	1.4	2692693.382
84	C083	7/27/2022	Google	FCT	New	6	399975	258302.5	0.2	50	1.7	4178362.073
85	C084	8/25/2022	Google	LAG	Returning	34	596595	377333.3824	0.23	34	2.7	2692693.382
86	C085	12/4/2022	Google	FCT	Returning	1	742980	372570	0	41	3	3214228.167
87	C086	2/22/2022	Apple	FCT	Returning	10	156480	109932	0.06	54	1.6	3352437.706
88	C087	10/7/2022	Tecno	OYO	Returning	21	746025	322780	0.21	19	2.7	3045477.385
89	C088	8/5/2022	Google	RIV	Returning	5	74190	57105	0.12	49	2.4	2692693.382
90	C089	9/9/2022	Infinix	FCT	New	2	93225	49890	0.2	41	1.7	3602515.466
91	C090	7/7/2022	Oppo	OYO	Returning	22	40290	18175.22727	0.1	26	1	4178362.073
92	C091	2/10/2022	Apple	RIV	Returning	48	261270	150738.75	0.12	21	2.9	3352437.706
93	C092	6/6/2022	Apple	LAG	New	57	477435	199084.7368	0.05	34	3.7	3559983.639
94	C093	1/15/2022	Tecno	OYO	New	2	58755	39592.5	0.08	34	1.9	3187999.222
95	C094	10/28/2022	Apple	OYO	Returning	10	107700	76404	0.18	67	1.5	3045477.385
96	C095	3/6/2022	Apple	RIV	New	34	703290	516851.4706	0.13	65	4.5	3254441.12
97	C096	12/11/2022	Google	LAG	Returning	16	617775	278584.6875	0.23	47	2.1	3214228.167
98	C097	11/23/2022	Tecno	OYO	New	48	608325	274055.625	0.26	57	1.9	3137536.062
99	C098	1/9/2022	Google	FCT	New	51	664185	481782.3529	0.16	28	4.4	3187999.222
100	C099	12/10/2022	Oppo	FCT	Returning	39	527280	405848.4615	0.23	38	4.3	3214228.167