4000000
Row Labels Sum of Sales at Actual Price Sum of Sales at List price
Abhinav ₹ 368,000 ₹ 460,000
3500000
Ananya ₹ 682,996 ₹ 853,745
Deepak ₹ 645,500 ₹ 806,875 3000000
Dushyant ₹ 430,000 ₹ 537,500
Sukant ₹ 894,000 ₹ 1,117,500 2500000
Grand Total ₹ 3,020,496 ₹ 3,775,620
2000000
1500000
1000000
500000
0
Abhinav Ananya Deepak Dushyant Sukant
Deepak Dushyant Sukant Grand Total
Date Product SoldBy ListPrice
2-Jan-24 Laptops Abhinav 45,000
8-Jan-24 Watches Deepak 35,000
18-Jan-24 Ipads Dushyant 56,250
5-Feb-24 Watches Deepak 28,125
16-Feb-24 Iphones Ananya 65,000
27-Feb-24 Laptops Sukant 60,000
28-Feb-24 LG Window AC Abhinav 40,000
9-Mar-24 Watches Deepak 31,875
10-Mar-24 Iphones Sukant 78,750
17-Mar-24 IPads Deepak 61,250
22-Mar-24 IPads Ananya 58,958
3-Apr-24 Laptops Sukant 47,500
10-Apr-24 Desktops Dushyant 37,500
15-Apr-24 Ipads Sukant 63,125
22-Apr-24 Iphones Dushyant 68,750
27-Apr-24 Desktops Ananya 40,000
4000000
Product Sum of Sales at List price Sum of Sales at Actual Price 3500000
Desktops ₹ 390,000 ₹ 312,000 3000000
Ipads ₹ 1,338,745 ₹ 1,070,996
2500000
Iphones ₹ 692,500 ₹ 554,000
Laptops ₹ 635,000 ₹ 508,000 2000000
LG Window AC ₹ 280,000 ₹ 224,000 1500000
Watches ₹ 439,375 ₹ 351,500
1000000
Grand Total ₹ 3,775,620 ₹ 3,020,496
500000
0
Desktops Ipads Iphones Laptops LG Watches
Window
AC
500000
0
Desktops Ipads Iphones Laptops LG Watches
Window
AC
Product wise comparison of Sales at List and Sales Price
Row Labels Sum of Sales at List price Sum of Sales at Actual Price 4000000
Abhinav 460000 368000
3500000
Laptops 180000 144000
LG Window AC 280000 224000 3000000
Ananya 853745 682996
Desktops 240000 192000 2500000
Ipads 353745 282996 2000000
Iphones 260000 208000
Deepak 806875 645500 1500000
Ipads 367500 294000
1000000
Watches 439375 351500
Dushyant 537500 430000 500000
Desktops 150000 120000
0
Ipads 112500 90000 t t
in
av ops
t AC nya tops ads nes pak ads hes yan tops ads nes kan ad
s
h p w a k Ip o e Ip tc h k Ip o u Ip
Iphones 275000 220000 Ab La indo A n s Ip
h De a s s Ip
h S
De W Du De
Sukant 1117500 894000 W
LG
Ipads 505000 404000
Iphones 157500 126000
Laptops 455000 364000
Grand Total 3775620 3020496
Comparison of Product sold by by sales person on the basis of List and Actual price
Row Labels Sum of Sales at List price Sum of Sales at Actual Price 4000000
3500000
3000000
4000000
East 866250 693000 3500000
Iphones 157500 126000
Laptops 540000 432000 3000000
Watches 168750 135000
2500000
North 510000 408000
Desktops 240000 192000 2000000
Laptops 95000 76000
1500000
Watches 175000 140000
South 1427500 1142000 1000000
Ipads 872500 698000
500000
Iphones 275000 220000
LG Window AC 280000 224000 0
West 711870 569496 st es ps es th ps ps es th ds es C st ps ds es al
Ea hon pto tch Nor kto pto tch S ou Ipa hon w A We kto Ipa tch Tot
Ip La Wa s a a Ip indo s a d
Desktops 150000 120000 De L W De W ran
W G
Ipads 466245 372996 LG
Watches 95625 76500
Grand Total 3515620 2812496
ActualPrice Quantity Region Sales at List price Sales at Actual Price
36,000 4 East 180000 144000
28,000 5 North 175000 140000
45,000 2 West 112500 90000
22,500 6 East 168750 135000
52,000 4 North 260000 208000
48,000 6 East 360000 288000
32,000 7 South 280000 224000
25,500 3 West 95625 76500
63,000 2 East 157500 126000
49,000 6 South 367500 294000
47,166 6 West 353745 282996
38,000 2 North 95000 76000
30,000 4 West 150000 120000
50,500 8 South 505000 404000
55,000 4 South 275000 220000
32,000 6 North 240000 192000
Row Labels Sum of Sales at List price Sum of Sales at Actual Price
Desktops 390000 312000
Ipads 1338745 1070996
Iphones 692500 554000
Laptops 635000 508000
LG Window AC 280000 224000
Watches 439375 351500
Grand Total 3775620 3020496
Iphones Laptops LG Watches Grand
Window Total
AC
Iphones Laptops LG Watches Grand
Window Total
AC
n of Sales at List and Sales Price
es nt ops ads nes nt ads nes ops al
ch hya kt Ip o uka Ip o pt T ot
s s h S h
Du De Ip Ip La and
Gr
of List and Actual price
t s s s l
es op ad he ta
W skt Ip atc d To
De W ran
G
Ex 5.5
Products A B C D E F G H I J
Rejections 10 7 11 14 14 12 11 7 8 6
Profits
23
25
57
45
44
39
34
32
39
12
Example: 5.7
Juniors 22 43 12 37 29 42 32 38 15 33
Seniors 17 29 21 34 31 27 35 28 30 32
Juniors Seniors Displaying their test scores by visualization Boxplot
22 17
43 29
12 21
37 34
29 31
42 27
32 35
38 28
15 30
33 32
Q Ltd. R Ltd.
46 44
37 57
41 66
57 80
66 46
60 66
69 74
63 53
57 60
68 54
69 74
64 55
53 43
76 89
