Organising and Condensing data
Download PDF of This Page (Size: 204K) ↧
Process of arranging and grouping of data in some orderly from is called organisation of data. To make the collection of data meaningful it is arranged in an orderly or sequence form. Data can be arranged in two forms:
Arrays:
Simply array:

It is the arrangement of data in ascending or descending order.

For ex. Ascending and descending array of the marks obtained by 5 students in a class.
Ascending order  Descending order 
20  89 
25  45 
25  25 
45  25 
89  20 
Frequency array:

It is a series formed on the basis of frequency with which each item is repeated in a series.

Main steps in constructing frequency array are:

For ex. Frequency array of marks obtained by 5 students.
Marks  Tally Sheet  Frequency 
20  /  1 
25  //  2 
45  /  1 
89  /  1 
Total Frequency  5 
Frequency Distribution:
Important concept for constructing frequency distribution.
Class  Class Limits  Class Interval (I)  Class Frequency  MidPoint/MidValue (MV) 
Class is a group of magnitudes having two ends called class limits.  Every class has two boundaries or limits called lower limit and upper limit.  Difference of two limits of a class is called interval.  Total number of items falling in a class that is having the value within and is class frequency.  Average value of two limits of a class. It fall just in the middle of a class. 
Ex. In class 2025, 2530 etc. or 2024, 2529 etc.  Ex. In class (2025)  Ex. In class (2030)
  

Construction of frequency distribution:
Exclusive:

One of the class limits is excluded while making a tally sheet.

Any item having the value equal to the upper limit of a class is counted in the next class.

Ex. In a class of (2025) all items having the value of 20 and more but less than 25 will be counted in this class.
Inclusive:

Lower limit of next class is increased by one over the upper limit of previous class.

Both item have value equal to lower and upper limit of a class are counted or included in the same class.

Ex. class (4044) both 40 and 44 will be included.
Open end classes:

At least one of its ends open.

You will observe that either lower limit of first class or upper limit of class or both are not given in such series.

Ex. Class Below35, 3540, 4045, 45 and above
Unequal classes:

Width of different classes need not be the same.

Ex. Class (3035),(3540),(4050)
Cumulative:

Taking successive totals of given frequencies and total can be done two ways:

From above (Lessthan cumulative frequency distribution): Total numbers of observations having less than a particular value of the variable.

From below (More than cumulative frequency distribution): Total number of observations having more than a particular value of the variable.