CIVIL

NO. SEX AGE

STATUS
1 SINGLE MALE 17 CIVIL ST Counts % of Total
2 MARRIED MALE 16 MARRIED 13 43.3
3 MARRIED FEMALE 15 SINGLE 10 33.3
4 WIDOWED MALE 19 WIDOWE 7 23.3
5 SINGLE MALE 16
6 WIDOWED MALE 15
7 MARRIED FEMALE 15
8 MARRIED FEMALE 17
9 SINGLE FEMALE 17
10 SINGLE FEMALE 18
11 MARRIED FEMALE 16
12 MARRIED FEMALE 16
13 MARRIED FEMALE 19
14 MARRIED MALE 20
15 SINGLE MALE 22
16 WIDOWED MALE 20
17 SINGLE MALE 24
18 MARRIED MALE 16
19 WIDOWED FEMALE 17
20 SINGLE MALE 18
Counts
21 SINGLE FEMALE 19 14
22 MARRIED MALE 21
12
23 MARRIED FEMALE 21
24 MARRIED FEMALE 24 10
25 MARRIED MALE 23
8
26 WIDOWED MALE 16
27 SINGLE MALE 15 6
28 SINGLE FEMALE 19
4
29 WIDOWED MALE 17
30 WIDOWED FEMALE 21 2

0
MARRIED SINGLE WIDOWED

Frequencies

Frequencies of CIVIL STATUS

CIVIL ST SEX Counts % of Total
MARRIEDFEMALE 8 26.7 %
MALE 5 16.7 %
SINGLE FEMALE 4 13.3 %
MALE 6 20.0 %
% of Total
100%
90%
80%
WIDOWEFEMALE 2 6.7 % % of Total
MALE
100% 5 16.7 %
90%
80%
CIVIL ST SEX70% % of Total
MARRIEDFEMALE
60% 26.7
MALE
50%
16.7
SINGLE FEMALE
40%
13.3
MALE
30%
20
WIDOWEFEMALE20%
6.7
MALE
10%
16.7
0%
FEMALE MALE FEMALE MAL
MARRIED SINGLE
 CIVIL ST % of Total
% of Total
MARRIED 0.433
SINGLE 0.33
WIDOWE 0.23
CIVIL STATUS

MARRIED SINGLE WIDOWED

WIDOWED

Counts
8
% of Total 6
4
2
0
FEMALE

FEMALE

FEMALE
MALE

MALE

MALE

% of Total
MARRIED SINGLE WIDOWED
 4
2
0

FEMALE

FEMALE

FEMALE
MALE

MALE

MALE
% of Total
MARRIED SINGLE WIDOWED

MALE FEMALE MALE FEMALE MALE

RIED SINGLE WIDOWED
The table shows the daily expenses of Ms. A in one month.
DAILY EXPENSES
NO.
OF Ms. A.
1 5000
2 3000
3 3500 1. What is the average daily expenses of Ms. A?
4 2500 2. What is the Range of the daily expenses of Ms. A?
5 9000 3. Compute the variance & standard deviation of the daily expenses of Ms. A.
6 10000
7 20000
8 2000
9 2500
10 6000
11 4000
12 200
13 6000 DAILY EXPENSES OF Ms
14 600
25000
15 500
16 400
17 300 20000
18 8000
19 2000
15000
20 4000
21 5000
22 15000 10000
23 300
24 4000
5000
25 400
26 600
27 200 0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
28 200
29 4000
30 500
expenses of Ms. A.

EXPENSES OF Ms. A.

1 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
 MONTHLY SALARY MONTHLY SALARY
NO. OF EMPLOYEES IN OF EMPLOYEES IN
COMPANY A COMPANY B
1 20000 22000 1. What is the average monthly salary of Company A? Company
2 15000 23000 2. What is the middle monthly salary of Company A? Company
3 9000 8000 3. What is the most occuring montly salary in Company A? Com
4 8000 13000 Chart Title
4. Which company has larger variability in monthly salary?
5 15000 6000 30000
6 12000 25000
25000
7 13000 4000
8 12000 5000 20000
9 7000 8000 15000
10 5000 12000
10000
11 8000 15000
12 12000 17000 5000
13 9000 6000 0
14 8000 5000 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
15 15000 5000
MONTHLY SALARY OF EMPLOYEES IN COMPA
16 12000 6000
MONTHLY SALARY OF EMPLOYEES IN COMPA
17 12000 4000
18 7000 9000
19 5000 10000
20 6000 7000
ary of Company A? Company B?
ry of Company A? Company B?
y salary in Company A? Company B?
art
bilityTitle
in monthly salary?

9 10 11 12 13 14 15 16 17 18 19 20

OF EMPLOYEES IN COMPANY A
OF EMPLOYEES IN COMPANY B
Students Math Science
50 70
60 80
90 95
75 70
68 84
80 85
84 75
90 88
99 95
78 77

Books readNon-fuctioFiction
Grade 7 5 12
Chart Title
Grade 8 2 8
Grade 9 9 2 18
Grade 10 7 5 16
14
12
10
8
6
4
2
0
Grade 7 Grade 8 Grade 9

Non-fuction Fiction
Chart Title

e8 Grade 9 Grade 10

on-fuction Fiction
 Pareto Chart
No of Cumulative Cumulative
Support Area Requests % Count
Button Defect 23 19% 23
Pocket Defect 16 33% 39
Collar Defect 10 42% 49
Cuff Defect 7 47% 56
Sleeve Defect 3 50% 59
Total 59 100% 118
100% 118
100% 118
100% 118
Suppose we want to analyse the data of defects on four types of defects complained by the customers, then draw a Pareto chart
Types of Frequency Total Cumulative
Defect Defect Percentage Percentage
This chart isn't available in your version of Excel.

Button
Defect
23 39 39 Editing this shape or saving this workbook into a different file format wil
Pocket permanently break the chart.
16 27.1 66.1
Defect
Collar
10 16.9 83.1
Defect
Cuff Defect 7 11.9 11.9
Sleeve
3 5.1 16.9
Defect
Total 59
 the most frequent type of defect reported by customers is the Button Defect, constituting
39% of the total complaints. Following closely is the Pocket Defect at 27.1%. These two
categories alone encompass approximately two-thirds (66.1%) of all reported issues. The
Collar Defect, although less frequent, still accounts for a significant portion (16.9%) of
the total complaints. Conversely, the Cuff and Sleeve Defects have lower frequencies,
mers, then draw a Pareto contributing
chart from11.9% and
the data 5.1% respectively.
received [Link]'s evident from the Pareto chart that
addressing Button and Pocket Defects should be prioritized to address the majority of
Excel. customer concerns, while attention should also be given to Collar Defects to further
improve customer satisfaction.
into a different file format will
 SCORES SCORES
OF OF
NO. The table shows the scores of two sections in Grade 11 in
SECTION SECTION
A B
1 50 30
2 45 45
3 35 40 This chart isn't available in your version of Excel
4 46 46
Editing this shape or saving this workbook into a
5 47 33 permanently break the chart.
6 34 50
7 45 49
8 46 49
9 33 48
10 32 47
11 34 43
12 35 10
13 37 12
14 50 13
15 49 15
16 49 9
17 48 45
18 47 47
19 43 46
20 45 45
cores of two sections in Grade 11 in a 50-item Statistics quiz.

ailable in your version of Excel.

or saving this workbook into a different file format will

k the chart.
NO. CIVIL STATUS SEX AGE Qa1 Qa2 Qa3 Qa4 Qa5
1 SINGLE MALE 17 4 4 1 2 3
2 MARRIED MALE 16 3 5 1 3 3
3 MARRIED FEMALE 15 2 3 1 3 5
4 WIDOWED MALE 19 3 3 1 3 3
5 SINGLE MALE 16 3 5 3 5 5
6 WIDOWED MALE 15 4 4 5 4 5
7 MARRIED FEMALE 15 5 5 5 5 4
8 MARRIED FEMALE 17 2 2 1 3 4
9 SINGLE FEMALE 17 3 4 1 4 5
10 SINGLE FEMALE 18 3 3 2 3 5
11 MARRIED FEMALE 16 1 5 3 2 3
12 MARRIED FEMALE 16 3 1 2 4 5
13 MARRIED FEMALE 19 5 2 3 2 5
14 MARRIED MALE 20 5 5 2 3 5
15 SINGLE MALE 22 4 5 5 5 5
16 WIDOWED MALE 20 3 4 1 5 5
17 SINGLE MALE 24 4 5 5 5 4
18 MARRIED MALE 16 4 3 3 3 4
19 WIDOWED FEMALE 17 4 4 4 4 4
20 SINGLE MALE 18 4 4 4 4 5
21 SINGLE FEMALE 19 4 3 4 5 2
22 MARRIED MALE 21 3 4 4 3 5
23 MARRIED FEMALE 21 4 4 4 4 2
24 MARRIED FEMALE 24 3 4 4 4 5
25 MARRIED MALE 23 3 3 3 3 5
26 WIDOWED MALE 16 4 4 4 4 4
27 SINGLE MALE 15 4 5 4 4 4
28 SINGLE FEMALE 19 2 2 2 2 2
29 WIDOWED MALE 17 4 4 4 4 4
30 WIDOWED FEMALE 21 5 5 2 3 5
Qb1 Qb2 Qb3 Qb4 Qb5 Qb6 Qb7 Qc1 Qc2 Qc3 Qc4
4 4 4 4 5 4 4 4 5 3 2
5 5 4 5 2 5 3 3 4 3 1
5 5 4 5 5 5 5 1 1 4 4
3 4 4 5 3 3 4 2 3 4 4
5 5 5 5 4 5 2 2 1 1 5
5 5 5 5 5 5 5 1 1 1 1
5 4 5 4 4 5 5 2 1 3 1
1 2 4 3 3 2 5 3 5 4 3
5 4 3 4 5 5 5 1 2 3 1
3 4 5 5 4 3 5 3 3 2 5
3 5 5 3 3 5 5 3 3 3 5
2 4 5 3 5 4 5 4 3 3 3
1 3 4 3 3 4 5 3 1 2 3
1 5 5 4 4 4 5 1 2 3 3
4 4 4 5 4 5 4 4 4 5 5
5 4 4 5 3 5 5 3 3 2 5
4 3 5 4 5 5 5 4 5 3 4
2 3 2 3 3 3 3 3 3 3 2
2 4 2 3 3 2 2 2 3 3 3
4 4 4 4 4 3 5 4 4 4 5
4 5 4 5 5 4 5 5 4 4 4
4 3 5 3 2 4 5 2 4 3 5
4 2 3 3 2 2 2 3 3 3 3
3 2 2 2 2 2 3 4 5 5 3
2 2 2 2 2 2 2 4 3 4 3
3 3 5 3 3 3 5 1 3 3 3
2 3 2 3 3 2 2 2 3 3 3
2 4 2 3 3 2 2 3 3 3 3
2 2 4 3 3 2 2 2 4 4 4
5 5 5 5 5 5 5 4 4 1 4
Qc5 Qd1 Qd2 Qd3 Qd4 Qd5 Qe1 Qe2 Qe3 Qe4
4 3 3 3 1 2 3 4 4 4
3 3 3 3 1 3 3 5 5 4
3 5 4 4 1 3 5 5 5 4
3 3 3 3 1 3 3 3 4 4
5 5 1 1 3 5 5 5 5 5
1 4 1 1 5 4 5 5 5 5
1 5 5 5 5 5 4 5 4 5
4 5 5 5 1 3 4 1 2 4
1 4 4 4 1 4 5 5 4 3
1 3 4 5 2 3 5 3 4 5
5 3 3 3 3 2 3 3 5 5
2 5 5 5 2 4 5 2 4 5
4 4 5 5 3 2 5 1 3 4
4 5 5 5 2 3 5 1 5 5
4 4 4 4 5 5 5 4 4 4
5 4 4 5 1 5 5 5 4 4
5 4 5 5 5 5 4 4 3 5
3 2 3 4 3 3 4 2 3 2
3 3 3 3 4 4 4 2 4 2
5 4 5 5 4 4 5 4 4 4
5 4 5 4 4 5 2 4 5 4
5 3 4 5 4 3 5 4 3 5
3 3 3 3 4 4 2 4 2 3
3 3 3 3 4 4 5 3 2 2
3 2 2 2 3 3 5 2 2 2
3 3 2 5 4 4 4 3 3 5
3 3 3 3 4 4 4 2 3 2
3 3 3 3 2 2 2 2 4 2
4 4 4 4 4 4 4 2 2 4
4 5 5 5 2 3 5 5 5 5
Qe5
5
4
1
3
1
1
1
5
2
3
3
3
1
2
4
3
5
3
3
4
4
4
3
5
3
3
3
3
4
4