TUTORIAL 3b

DATA TYPES

There are two types of data (qualitative and qualitative), that record various kinds of
information.
Quantitative: The information is recorded as numbers and represents an objective
measurement or a count. Temperature, weight, and a count of transactions are all
quantitative data. 

Qualitative: The information represents characteristics that you do not measure with
numbers. Instead, the observations fall within a countable number of groups. In fact, this
type of variable can capture information that isn’t easily measured and can be subjective.
Table 1 is data dictionary that specifies data type for variables in Loan.xls

Table 1. Data dictionary

No Variable name Data type Measurement level
1 ID No Numeric Discrete
2 Gender Categorical Discrete (Binary)
3 Education Categorical Ordinal
4 Marital status Categorical Nominal
5 Age Numeric Continuous
6 Loan outstanding status Categorical Nominal
7 Loan amount Numeric Continuous
8 Amount paid Numeric Continuous
January until June

Figure 1. Chart guidelines

Using dataset provided in Loan dataset.xls, complete the following tasks. Use
the provided tutorial template to submit your answer.

A. Based on guidelines given in Figure 1, plot:

1. a bar chart,
2. a pie chart,
3. a histogram,
4. a scatter plot,
5. a line chart.

B. Plot a suitable chart for each of the following scenarios:

1. Plot a scatter chart for age. From the scatter chart, identify how many clients are
ABOVE 70 years old.

2. Fill in the following table using COUNTIF. Count gender and plot a suitable chart for
it.
Education Level Number of clients
FEMALE
MALE

3. Fill in the following table using COUNTIF. Count marital status and plot a suitable
chart for it. Determine which client category is the LARGEST.
MARITAL STATUS Number of clients
SINGLE
MARRIED
DIRVORCE
OTHERS

4. Fill in the following table using COUNTIF. Determine which education category is the
LARGEST and SMALLEST.
Education Level Number of clients
GRAD SCH
UNI
HIGH SCH
OTHERS

5. Calculate the total of amount paid for every month from January to June. Plot a
suitable chart that shows the pattern. Which month shows the highest and lowest
paid amount?
Month Amount paid
JAN
FEB
MAR
APR
MAY
JUNE
 TUTORIAL 3b
DATA TYPES
Answer template
Name Student no Group

NUR SHAZRINA BT ZAINI 2022822966 CS112C

A. Creating charts

1 Bar chart

ID NUMBER
481
451
421
391
361
331
301
271
241
211
181
151
121
91
61
31
1
0 100 200 300 400 500 600 700

NUMBER OF CLIENTS

OTHERS

DIVORCE

MARRIED

SINGLE

0 50 100 150 200 250 300 350

2 Pie chart

Number of Clients

FEMALE MALE

Number of Clients

GRAD SCH UNI HIGH SCH OTHERS

3 Histogram
4 Scatter plot

5 Line chart
 Amount paid
600000

500000

400000

300000

200000

100000

0
JAN FEB MAR APR MAY JUN

B. Creating charts based on scenarios

1 Scatter chart for age

AGE
12

10

0
0 2 4 6 8 10 12
 How many clients are ABOVE 70 years old? _2__________.

2 Table
Education Level Number of clients
FEMALE 284
MALE 215

Chart

Number of Clients

FEMALE MALE

3 Table
MARITAL STATUS Number of clients
SINGLE 292
MARRIED 199
DIRVORCE 7
OTHERS 1

Chart
 SINGLE MARRIED DIVORCE OTHERS

The largest client category is __SINGLE______.

4 Table
Education Level Number of clients
GRAD SCH 204
UNI 215
HIGH SCH 75
OTHERS 5

Chart
 Number of Clients

OTHERS

HIGH SCH

UNI

GRAD SCH

0 50 100 150 200 250

The LARGEST education level category is _UNI____and the SMALLEST is

_____OTHERS__.

5 Month Amount paid

JAN 318476
FEB 143548
MAR 192446
APR 214331
MAY 511465
JUNE 283449
Table

Chart
 Amount paid
600000

500000

400000

300000

200000

100000

0
JAN FEB MAR APR MAY JUN

The HIGHEST paid amount is in __MAY___and the LOWEST is in ___MARCH____.