3.2 Tabular Method

3.2 Tabular Method

Data can also be presented by using tables. Important features and significant values are easily observed when data are presented in a tabular form. Moreover, comparisons are also easily made.

Parts of a Table:

  1. Table number - for easy reference to the table
  2. Table title - briefly explains the content of the table
  3. Column header - describes the data in each column
  4. Row classifier - shows the classes or categories
  5. Body - main part of the table
  6. Source note - placed below the table when the data presented are not original

Example:

Table 1 ← Table Number
Number of High School Text Books According to Subject←Table Title

Subject Number of Books
Math
450
Science
375
English
525
Filipino
350
AP
450

Source: PWC Library ← Souce Note

Row classifiers: Math, Science, English, Filipino, AP

~ O ~

Frequency distribution table - shows the data arranged into different classes and the frequency of each class

note: frequency - number of times a value or class occurs

Example:

Table 2
Grouped Data of the Statistics Grades of 50 students

Grades Frequency
66 - 70
6
71 - 75
6
76 - 80
6
81 - 85
10
86 - 90
11
91 - 95
7
96 - 100
4

The row classifiers 66 - 70, 71 - 75, 76 - 80… 96 - 100 are called class intervals. The minimum values in each class (66, 71, 76, …96) are called lower limits (LL). The highest values in each class are called upper limits (UL).

The class interval size or class width (i) is the number of values within a class. In the example, i = 5 (66, 67, 68, 69, 70; 71, 72, 73, 74, 75). This is obtained by manually counting the number of values within a class or by using the following formula:

i = (UL + LL) + 1.

The example above is a simple frequency distribution table because it consists one the class interval and its frequencies.

On the other hand, a complete frequency distribution table also contains a column with the class marks or midpoint (X) and class boundaries (cb).

class_mark1.jpg

Example:

class_mark2.jpg

The succeeding class marks may be obtained by adding i to the first class mark.

Example:

class_mark3.jpg

The class boundaries are always one decimal value more than the recorded values. So for whole number values (like in the Examples), the class boundaries are up to the tenths place. Class boundaries are always one-half unit less than the LL and one-half unit more than the LL.

Example: One-half unit of a whole number is 0.5, thus…

the cb of the first class (66 - 70) are (66 - 0.5 =) 65.5 and (70 + 0.5 =) 70.5,
the cb of 71 - 75 are 70.5 and 75.5,
the cb of 76 - 80 are 75.5 and 80.5,…
and the cb of 95-100 are 94.4 and 100.5.

When constructing a frequency distributiontable, the number of data should be treated as the guide. The following are some steps to follow:

  1. Decide on the number of classes.
  2. Determine the class width (i): frequency_dist_table1.jpg
    note: i should have decimal places as the data
  3. Always start with the lowest values and the lowest class.
  4. Tally the frequencies for each class, until the highest value is reached.
  5. The last call interval may exceed the highest value, as long as the i is followed.

Example:
Contruct a frequency distribution table with 7 classes for the data given in the Textual Method Example.

  1. Decide on the number of classes: 7 (instruction)
  2. Determine the class width (i):
    frequency_dist_table2.jpg
  3. Always start with the lowest values and the lowest class:
    class_mark3.jpg
  4. Tally the frequencies for each class, until the highest value is reached

Table 3
Frequency Distribution Table of the Statistics Grades of 50 students

Class Interval
Class Marks (X)
Class Boundaries (cb)
Frequency
66 - 70
68
65.5 - 70.5
6
71 - 75
73
70.5 - 75.5
6
76 - 80
78
75.5 - 80.5
6
81 - 85
83
80.5 - 85.5
10
86 - 90
88
85.5 - 90.5
11
91 - 95
93
90.5 - 95.5
7
96 - 100
98
95.5 - 100.5
4

~ O ~

Relative Frequency distribution table - lists the relative frequencies (rf) of the classes

rel_frequency_table1.jpg

where:
rf = relative frequency
f = frequency
N = total frequency

Example: for class 66 - 70…

rel_frequency_table2.jpg

Table 4
Relative Frequency Distribution Table of the Statistics Grades of 50 students

Class Interval
Class Mark
Frequency Relative Frequency (rf)
66 - 70
68
6
0.12
71 - 75
73
6
0.12
76 - 80
78
6
0.12
81 - 85
83
10
0.20
86 - 90
88
11
0.22
91 - 95
93
7
0.14
96 - 100
98
4
0.08

~ O ~

Cumulative Frequency distribution table - shows the number of cases falling below (cf) a particular value

The Less Than Cumulative Frequency < cf of the first (lowest) class is its frequency. The < cf of the next class is the sum of < cf of the preceding class and the class' frequency. The < cf of the last class is always equal to the total frequency.

Example: for Table 3…

< cf of 66 - 70 (f = 6) is 6
< cf of 71 - 75 (f = 6) = 6 + 6 = 12
< cf of 76 - 80 (f = 6) = 12 + 6 = 18
< cf of 81 - 85 (f = 10) = 18 + 10 = 28...
< cf of 96 - 100 (f = 4) = 46 + 4 = 50

The Greater Than Cumulative Frequency > cf of the first (lowest) class is the total frequency. The > cf of the next class is the difference between >cf of the preceding class and the preceding class’ frequency. The > cf of the last class is always equal to the frequency of the last (greatest/highest) class.

Example: for Table 3…

> cf of 66 - 70 (f = 6) is 50
> cf of 71 - 75 (f = 6) = 50 - 6 = 44
> cf of 76 - 80 (f = 6) = 44 - 6 = 38
> cf of 81 - 85 (f = 10) = 38 - 6 = 32…
>cf of 96 - 100 (f = 4) = 11 - 7 = 4

Table 6
Less Than Cumulative Frequency (>cf) Distribution Table of the Statistics Grades of 50 students

Class Interval
Class Mark
Frequency Less than Cumulative Frequency (< cf) Greater than Cumulative Frequency (> cf)
66 - 70
68
6
6
50
71 - 75
73
6
12
44
76 - 80
78
6
18
38
81 - 85
83
10
28
32
86 - 90
88
11
39
22
91 - 95
93
7
46
11
96 - 100
98
4
50
4

Leave a Reply