Products A B C D E F G H I
Rejection
s 10 7 11 14 14 12 11 7 8
This chart isn’t available in your version of Excel.
Editing this shape or saving this workbook into a different file format
will permanently break the chart.
J
6
Given - Profits earned by 10 firms in crores of Rupees
Profits 23 25 57 45 44 39 34 32 39
Prepare Box Plot
This chart isn’t available in your version of Excel.
Profits Editing this shape or saving this workbook into a diff
23 will permanently break the chart.
25
57
45
44
39
34
32
39
12
COMPARING MULTIPLE SERIES
Given - 2 groups of 10 each in HR training program. The test performance of each group is as follows:
Juniors 22 43 12 37 29 42 32 38 15
Seniors 17 29 21 34 31 27 35 28 30
This chart isn’t available in your version of Excel.
Juniors Seniors
22 17 Editing this shape or saving this workbook into a different file
43 29 will permanently break the chart.
12 21
37 34
29 31
42 27
32 35
38 28
15 30
33 32
Ex 3
P Ltd. Q Ltd. R Ltd.
59 46 44
56 37 57
35 41 66
68 57 80
39 66 46
52 60 66
51 69 74
42 63 53
59 57 60
56 68 54
44 69 74
51 64 55
50 53 43
66 76 89
12
in your version of Excel.
ing this workbook into a different file format
he chart.
33
32
version of Excel.
workbook into a different file format
given below is the sales data wrt sales persons, pdts sold by them and quantity sold
Sales
Persons Products Quantity
Abhinav Laptops 14
LG
Window
Abhinav AC 21
Abhinav Laptops 16
Ananya Iphones 14
Ananya IPads 26
Ananya Desktops 16
Ananya Desktops 16
Deepak Watches 15
Deepak Watches 16
Deepak Watches 18
Deepak IPads 16
Dushyant Ipads 12
Dushyant Desktops 14
Dushyant Iphones 24
Sukant Laptops 16
Sukant Iphones 18
Sukant Laptops 12
Sukant Ipads 18
This chart isn’t available in your version of Excel.
Editing this shape or saving this workbook into a different file format will permanently break the
chart.
Sales
Region Persons Products Quantity This chart isn’t available in your version of Excel.
South Abhinav Laptops 14
Editing this shape or saving this workbook into a diffe
South Abhinav LG AC 21
South Abhinav DeskTops 16
North Ananya Iphones 14
North Ananya IPads 26
North Ananya Desktops 16
North Ananya LapTops 16
West Deepak Watches 15
West Deepak IPhones 16
West Deepak LapTops 18
West Deepak IPads 16
West Deepak Desktops 14
East Ashish Iphones 24
East Ashish Laptops 16
East Ashish Iphones 18
East Ashish Laptops 12
East Ashish Ipads 18
in your version of Excel.
ng this workbook into a different file format will permanently break the chart.
ActualPric
Date Product SoldBy ListPrice e Quantity
2-Jan-24 Laptops Abhinav 45,000 36,000 4
8-Jan-24 Watches Deepak 35,000 28,000 5
18-Jan-24 Ipads Dushyant 56,250 45,000 2
5-Feb-24 Watches Deepak 28,125 22,500 6
16-Feb-24 Iphones Ananya 65,000 52,000 4
27-Feb-24 Laptops Sukant 60,000 48,000 6
28-Feb-24 LG Window AC Abhinav 40,000 32,000 7
9-Mar-24 Watches Deepak 31,875 25,500 3
10-Mar-24 Iphones Sukant 78,750 63,000 2
17-Mar-24 IPads Deepak 61,250 49,000 6
22-Mar-24 IPads Ananya 58,958 47,166 6
3-Apr-24 Laptops Sukant 47,500 38,000 2
10-Apr-24 Desktops Dushyant 37,500 30,000 4
15-Apr-24 Ipads Sukant 63,125 50,500 8
22-Apr-24 Iphones Dushyant 68,750 55,000 4
27-Apr-24 Desktops Ananya 40,000 32,000 6
Using Excel spreadsheet, create a Pivot Table and Pivot Chart to compare
and depict the sales at list price and sales at actual price by taking
(a) Product (b) Sold by and © both product abd sold by as the basis of
comparison.
Region
East
North
West
East
Noth
East
South
West
East
South
West
North
West
South
South
North