Descriptive Tables
Province f
Misamis Occidental 12
Misamis Oriental 12
Gender f
Male 12
Female 12
Ethnicity f
Visayan 12
Subanon 12
Religion f
Protestant 7
Catholic 14
INC 1
None 2
Others 0
Age Group f %
18-20 Late Adolescent 4 0.1666667
21-40 Young Adult 12 0.5
41-60 Middle Adult 5 0.2083333
61-90 Late Adult 3 0.125
Total 24 1
No. of Respondents per Province
14
12
10
0
Misamis Occidental Misamis Oriental
4
0
Misamis Occidental Misamis Oriental
No. of Respondents per Religion
16
14
12
10
8
6
4
2
0
f
Protestant Catholic INC None Others
Instructions:
1. Compute for the requirements as seen o
2. Create graph per table
3. Answer the following queries using fun
a) How many of the respondents are from
b) How many of the respondents that are
c) What percentage of the respondent are
d) What percentage of the respondents are
ts per Province No. No. of Respondents
of Respondents per Ethnicity
per Gender
14
14
12
12
10
10
88
6
6
4
4
2
20
Visayan Subanon
0
Misamis Oriental Male Female
4
0
Misamis Oriental Male Female
dents per Religion No. of Respondents per Age Group
14
12
10
8
6
4
2
0
18-20 Late 21-40 Young Adult 41-60 Middle Adult 61-90 Late Adult
Adolescent
f
INC None Others f %
e for the requirements as seen on the tables
raph per table
the following queries using functions/formula
ny of the respondents are from Misamis Occidental that are male? 5
ny of the respondents that are young adolescent who are Catholic? 0
rcentage of the respondent are Visayan that are from Misamis Oriental? 0.25
rcentage of the respondents are late adults, male and from Misamis Occidental 0.0416667
Legend
province gender ethnicity age religion maeduc
Province
1 1 1 32 1 16 1
1 2 1 37 2 13 2
1 2 2 72 2 20
1 2 1 86 3 12 Gender
1 1 1 30 1 5 1
1 1 1 32 2 10 2
1 2 2 29 1 18
1 1 2 29 1 4 Ethnicity
1 2 2 53 1 6 1
1 1 2 68 1 9 2
1 2 1 19 2 2
1 2 2 43 2 14 Religion
2 2 2 38 4 12 1
2 1 1 45 2 17 2
2 1 2 24 4 1 3
2 1 1 53 2 3 4
2 2 1 20 2 7 5
2 1 1 27 2 11
2 1 1 54 2 8
2 2 2 25 1 15
2 1 2 20 2 1
2 2 2 38 2 7
2 1 1 20 2 5
2 2 2 34 2 10
Misamis Occidental
Misamis Oriental
Male
Female
Visayan
Subanon
Protestant
Catholic
INC
None
Others