Scribd
Upload
229 views

Data Analysis For Managers

This document analyzes categorical, ordinal, binary, and numerical data from a dataset on 34 households in the Philippines. The data includes information on household regions, sources of income, facilities by region, gender of household heads, family sizes, income ranges, and expenditure ranges. The document interprets various charts and concludes that most households' income lies between 60,000-159,999 pesos and expenditures between 73,000-92,999 pesos.

Uploaded by

Medha Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
229 views

Data Analysis For Managers

This document analyzes categorical, ordinal, binary, and numerical data from a dataset on 34 households in the Philippines. The data includes information on household regions, sources of income, facilities by region, gender of household heads, family sizes, income ranges, and expenditure ranges. The document interprets various charts and concludes that most households' income lies between 60,000-159,999 pesos and expenditures between 73,000-92,999 pesos.

Uploaded by

Medha Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 8

DATA ANALYSIS FOR MANAGERS

DATA ANALYSIS OF THE HOUSEHOLD SECTOR OF PHILIPPINES

Categorical Data (Qualitative Data): Categorical Data divides the data into groups. It is
basically of 3 types.

 Nominal Data
 Ordinal Data
 Binary Data

Nominal data: Nominal data is a type of categorical data. Used for labelling variables without
any quantitative value. Nominal data are usually presented by pie chart or a bar graph.

Dataset:

Regions No. of Household


VIII - Eastern Visayas 4
V - Bicol Region 7
XII - Soccsksargen 7
Caraga 8
Car 8
Total 34
.

Regions of household

CAR 8

Caraga 8

XII - SOCCSKSARGEN 7

V - Bicol Region 7

VIII - Eastern Visayas 4


Interpretations: From the above data it can be interpreted that among the 34 household
highest number of households lies in CAR and Caraga region whereas the lowest number
of household are in VIII-Eastern Visayas.

Data set:

Main Source of Income No of Variables


Other Source of Income 7
Entrepreneurial Activities 11
Wages/Salaries 16
Total 34

Main Source of income

Other sources of
Income

Enterpreneurial
Activities

Wage/Salaries

Interpretations: From the above pie chart it can be interpreted that the major source of income
for the households is from Wages/Salaries

Ordinal Data: Ordinal data is a type of categorical data which provides a meaningful order to
the group. It is represented by a bar graph or a pie chart. Nearly 47% of households earn from
wages and salaries.
Dataset:

Regions Bad Excellent Good Satisfactory Total


VIII - Eastern 1 1 2 0 4
Visayas
V - Bicol 2 1 2 2 7
Region
XII - 3 1 1 2 7
Soccsksargen
Caraga 1 2 2 3 8
Car 2 1 3 2 8
Total 9 6 10 9 34

3.5

2.5

2 bad
1.5 excellent
good
1 satisfactory
0.5

0
CAR Caraga V - Bicol Region VIII - Eastern XII -
Visayas SOCCSKSARGEN

Interpretations: From the above bar graph it can be interpreted that different region have
different type of facilities. In CAR more of good facilities are provided whereas in caraga more
of satisfactory facilities are provided in Bicol region the bad, satisfactory and good facilities
provided are same, in eastern Visayas more of good facilities are provided and in soccsksargen
region more of bad facilities are provided.

Binary Data: This data have only two options available. Example positive/negative, Pass/fail
etc

Dataset:
Gender of household head Variable
Male 21
Female 13
Total 24

Gender of household head

female
Male

Interpretations: From the above pie chart it can be interpreted that the number of male
household heads in the given data is more than female household heads.

Numerical data (Quantative Data): Numerical Data is data based on numbers that can be
calculated such as Temperature, dimension, or the number of people in the room. Numerical
Data is of two types.

 Discrete Data
 Continuous Data

Discrete Data: Variables that can take integer values such as number of peoples. Variables
can also be discrete because of rounding.

Dataset:

Range of Number of family members in a frequency


household
2-3 5
4-5 9
6-7 7
8-9 9
10-12 4
Total 34

range of family member in an household

10

6
frequency

0
2-3 4-5 6-7 8-9 10-12

Interpretations: From the above histogram it can be interpreted that the average family size of
the given data lies between 4-5 members and 8-9 members.

Continuous Data: These data are not limited to integers such as distance or temperature.

Data set:

Total Household Income frequency


60000-109999 7
110000-159999 7
160000-209999 4
210000-259999 4
260000-309999 3
310000-359999 1
360000-409999 1
410000-459999 1
460000-509999 2
510000-559999 1
560000-609999 1
610000-659999 1
660000-709999 1
Total 34

Total Income
8
7
6
5
4
3
2
1
0
60000- 110000- 160000- 210000- 260000- 310000- 360000- 410000- 460000- 510000- 560000- 610000- 660000-
109999 159999 209999 259999 309999 359999 409999 459999 509999 559999 609999 659999 709999

Interpretation: From above histogram it can be inferred that the average income of the given
household data lies within the range of 600000-159999.

Data set:

Total Expenditure of frequency


Household
33000-52999 4
53000-72999 4
73000-92999 11
93000-112999 7
113000-132999 3
133000-152999 3
173000-192999 2
Total 34
Total expenditure
12

10

0
33000-52999 53000-72999 73000-92999 93000-112999 113000- 133000- 173000-
132999 152999 192999

Interpretations: From the above data it can be concluded that the average spending
(expenditure) of the given household data lies within the range of 73000-92999.

Source of data

https://www.kaggle.com/datasets

You might also like