تحليل بيانات باستخام الجداول المحورية اكسل.xlsx

	A	B	C	D	E	F	G	H
1	Year	Month	Region	Order Status	Product	Unit price	Units	Sales
2	2023	August	East	Shipped	Pencil	2٫99	95	284٫05
3	2023	March	West	Shipped	Binder	4٫99	50	249٫5
4	2023	January	Central	Shipped	Pencil	2٫99	36	107٫64
5	2022	March	West	Shipped	Binder	4٫99	27	134٫73
6	2022	January	West	Shipped	Pencil	2٫99	56	167٫44
7	2021	September	East	Shipped	Binder	4٫99	60	299٫4
8	2022	March	West	Shipped	Pencil	2٫99	75	224٫25
9	2023	June	Central	Shipped	Pencil	2٫99	90	269٫1
10	2023	July	West	Canceled	Pencil	2٫99	32	95٫68
11	2022	May	Central	Shipped	Pen	1٫99	74	147٫26
12	2021	June	East	Canceled	Binder	4٫99	60	299٫4
13	2022	October	West	Shipped	Desk	275	2	550
14	2021	June	Central	Pending	Pencil	2٫99	90	269٫1
15	2023	May	East	Pending	Desk	275	1	275
16	2023	June	East	Pending	Binder	4٫99	29	144٫71
17	2021	March	West	Backorder	Binder	4٫99	81	404٫19
18	2023	September	Central	Canceled	Pencil	2٫99	25	74٫75
19	2022	October	East	Backorder	Pencil	2٫99	35	104٫65
20	2021	November	East	Backorder	Desk	275	3	825
21	2021	May	Central	Shipped	Desk	275	2	550
22	2023	August	West	Canceled	Pen	1٫99	56	111٫44
23	2021	June	East	Shipped	Pen Set	4٫99	16	79٫84
24	2023	April	East	Backorder	Pencil	2٫99	12	35٫88
25	2023	February	Central	Shipped	Binder	4٫99	28	139٫72
26	2021	November	East	Pending	Pen	1٫99	64	127٫36
27	2023	July	East	Shipped	Pen Set	4٫99	48	239٫52
28	2023	July	East	Pending	Pen	1٫99	15	29٫85
29	2023	August	East	Pending	Binder	4٫99	71	354٫29
30	2022	December	West	Shipped	Pen Set	4٫99	96	479٫04
31	2021	August	West	Shipped	Desk	275	2	550
32	2022	October	Central	Canceled	Pencil	2٫99	67	200٫33
33	2022	January	West	Shipped	Desk	275	5	1375
34	2021	June	East	Shipped	Pen Set	4٫99	74	369٫26
35	2022	July	East	Shipped	Pen	1٫99	41	81٫59
36	2022	January	Central	Pending	Pen Set	4٫99	99	494٫01
37	2023	July	Central	Backorder	Binder		46
38	2023	September	West	Pending	Pen Set	4٫99	62	309٫38
39	2023	October	Central	Shipped	Binder	4٫99	87	434٫13
40	2022	March	Central	Canceled	Desk	275	1	275
41	2021	September	East	Shipped	Binder	4٫99	4	19٫96
42	2021	January	West	Canceled	Binder	4٫99	86	429٫14
43	2021	August	West	Shipped	Binder	4٫99	7	34٫93
44	2023	March	East	Backorder	Pen Set	4٫99	75	374٫25
45	2022	May	Central	Shipped	Pen Set	4٫99	50	249٫5
46	2023	October	West	Pending	Pencil	2٫99	66	197٫34
47	2023	March	East	Shipped	Pen	1٫99	96	191٫04
48	2021	March	Central	Pending	Pencil	2٫99	53	158٫47
49	2021	May	Central	Shipped	Binder	4٫99	80	399٫2
50	2022	February	West	Pending	Pen Set	4٫99	68	339٫32
51	2022	February	West	Backorder	Desk	275	2	550
52	2022	February	East	Backorder	Pen Set	4٫99	62	309٫38
53	2023	April	East	Pending	Pencil	2٫99	68	203٫32
54	2021	April	Central	Pending	Pen Set	4٫99	55	274٫45
55	2022	June	East	Shipped	Pencil	2٫99	16	47٫84
56	2023	May	West	Shipped	Pen Set	4٫99	42	209٫58
57	2022	March	East	Backorder	Desk	275	5	1375
58	2021	April	West	Shipped	Desk	275	2	550
59	2023	August	East	Backorder	Binder	4٫99	70	349٫3
60	2023	January	West	Pending	Desk	275	4	1100
61	2022	March	Central	Shipped	Pencil	2٫99	7	20٫93
62	2022	April	Central	Backorder	Pencil	2٫99	42	125٫58
63	2023	May	West	Shipped	Pen	1٫99	76	151٫24
64	2023	October	West	Shipped	Pen Set	4٫99	29	144٫71
65	2021	June	West	Shipped	Binder	4٫99	57	284٫43
66	2023	May	West	Pending	Pencil	2٫99	14	41٫86
67	2022	December	Central	Shipped	Pen	1٫99	77	153٫23
68	2021	May	Central	Shipped	Binder	4٫99	11	54٫89
69	2021	January	West	Shipped	Pencil	2٫99	20	59٫8
70	2021	August	Central	Shipped	Binder	4٫99	94	469٫06
71	2021	August	West	Shipped	Pen	1٫99	14	27٫86
72	2023	August	West	Pending	Binder	4٫99	28	139٫72
73	2023	January	East	Pending	Binder	4٫99	90	449٫1
74	2022	February	Central	Shipped	Binder	4٫99	54	269٫46
75	2022	October	Central	Shipped	Pen Set	4٫99	54	269٫46
76	2022	April	Central	Shipped	Pen	1٫99	10	19٫9
77	2021	November	West	Shipped	Binder	4٫99	60	299٫4
78	2023	November	Central	Pending	Pencil	2٫99	27	80٫73
79	2021	February	East	Shipped	Pen	1٫99	53	105٫47
80	2021	February	West	Pending	Binder	4٫99	31	154٫69
81	2023	March	West	Shipped	Binder	4٫99	41	204٫59
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100