5 10 12 15 13 11 7 5 6 7
11 12 13 18 25 30 32 33 34 21
29 24 23 21 30
Step 1 Range
Step 2 No. classesk = 1+3.222*(Log N)
Step 3 Width = Range/No. classes
Create a Frequency Table and Chart for the data
8 13 15 10 16 Step 1
11 14 11 14 20 Step 2
15 16 12 15 13 Step 3
12 13 16 17 17
14 14 14 18 15
Range
No. classes k = 1+3.322*(Log N) 5.643957 5.643957
Width = Range/No. classes
The data shows the weekly sales of a product in a region over the past
year. Create a frequency distribution from the data and depict it using
appropriate chart
52 61 59 55 63 70 59 77 81 83 69 91 73
83 90 81 77 77 74 65 33 77 64 49 49 52
50 45 42 46 39 29 38 41 43 23 26 27 22
29 31 29 31 30 30 29 40 44 45 46 47 53
Step 1 Range
Step 2 No. classes k = 1+3.222*(Log N)
Step 3 Width = Range/No. classes
Class intervalFrequencyRelative frequencUpper boundary
5-10 5 20
10-15 7 28
15-20 2 8
20-25 4 16
25-30 2 8
30-35 5 20
TOTAL 25 100
Less than Cumulative Frequen Lower boundaryMore than Cumulative Frequency
Frequency
IMPROVE PRESENTATION OF THIS TABLE
Tier # of Accounts% AccountsRevenue (Lakhs)% Revenue
A 77 7.08 4.68 25 % of TOTAL
A+ 19 1.75 3.93 21
B 338 31.07 5.98 32
0 5 10 1
C 425 39.06 2.81 15
D 24 2.21 0.37 2 A 7.08
Others 204.8403351 18.83 0.935263157895 5
A+ 1.75
TOTAL 1087.84034 100 18.705263158 100
B
Tier % Accounts % Revenue
A 7.08 25 C
A+ 1.75 21
D 2.21
B 31.07 32 2
C 39.06 15
Others 5
D 2.21 2
Others 18.83 5
% of TOTAL REVENUE vs. TOTAL
ACCOUNTS
0 5 10 15 20 25 30 35 40 45
A 7.08
25
A+ 1.75
21
B 31.07
32
C 39.06
15
D 2.21
2
ers 18.83
5
Present this data in all the possible ways
Campaign Year Meals served
2010 40139
2011 127020
2012 168193
2013 153115
2014 202102
2015 232897
2016 277912
2017 205350
2018 233389
2019 232797
Capacity Demand Unmet Demand
April 29263 46193 16930
May 28037 49131 21094
June 21596 50124 28528
July 25895 48850 22955
August 25813 47602 21789
September 22427 43697 21270
October 23605 41058 17453
November 24263 37364 13101
December 24243 34364 10121
Category Amount
Starting Revenue 50,000
Online Sales Growth 15,000
Store Sales Decline -8,000
New Product Launch 10,000
Marketing Expenses -5,000
Logistics Costs -3,000
Ending Revenue 59,000
Complaint Type FrequencyPercentage
Cumulative Percentage
Late Delivery 45 34 34
Damaged Products 30 23 56
Wrong Item Delivered 20 15 71
Poor Customer Service 15 11 83
Billing Errors 10 8 90
Website Issues 8 6 96
Others 5 4 100
TOTAL 133 100
Boundary Safe LimitCurrent Value
Climate Change 1 1.5
Biosphere Integrity 1 1.2
Land-System Change 1 0.8
Freshwater Use 1 0.7
Biochemical Flows 1 1.8
Ocean Acidification 1 0.9
Atmospheric Aerosols 1 0.6
Novel Entities 1 1.3
Region Country Category Sales This chart isn't availabl
Asia India Electronics 12000
Clothing 8000 Editing this shape or sa
China Electronics 15000 chart.
Furniture 6000
Europe Germany Electronics 10000
Furniture 4000
France Clothing 7000
Furniture 5000
America USA Electronics 20000
Clothing 12000
Brazil Furniture 3000
Clothing 4000
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.
Arithmetic mean Geometric mean
1.1 1.1
1.5 1.5
1.3 1.3
#NAME? 1.28966159022
Se. Class A Class B
1 25 25
2 23 23
3 25 25
4 100 40
Harmonic Mean 29.9674267101 26.94
Arithmetic Mean 43.25 28.25
X f fx (x-X
