EDU TERIA Logo
Unit2

Data Processing

2

12101CH02
12101CH02

You have learnt in previous chapter that organising and presenting data makes them comprehensible. It facilitates data processing. A number of statistical techniques are used to analyse the data e.g.

•
Measures of Central Tendency
•
Measures of Dispersion
•
Measures of Relationship

While measures of central tendency provide the value that is an ideal representative of a set of observations, the measures of dispersion take into account the internal variations of the data, often around a measure of central tendency. The measures of relationship, on the other hand, provide the degree of association between any two or more related phenomena, like rainfall and incidence of flood or fertiliser consumption and yield of crops. In this chapter, you will learn the measures of central tendency.

Measures of Central Tendency

The measurable characteristics such as rainfall, elevation, density of population, levels of educational attainment or age groups vary. If we want to understand them, how would we do? We may, perhaps, require a single value or number that best represents all the observations. This single value usually lies near the centre of a distribution rather than at either extreme. The statistical techniques used to find out the centre of distributions are referred as measures of central tendency. The number denoting the central tendency is the representative figure for the entire data set because it is the point about which items have a tendency to cluster.

Measures of central tendency are also known as statistical averages. There are a number of the measures of central tendency, such as the mean, median and the mode.

Mean

The mean is the value which is derived by summing all the values and dividing it by the number of observations.

Median

The median is the value of the rank, which divides the arranged series into two equal numbers. It is independent of the actual value. Arranging the data in ascending or descending order and then finding the value of the middle ranking number is the most significant in calculating the median. In case of the even numbers the average of the two middle ranking values will be the median.

Mode

Mode is the maximum occurrence or frequency at a particular point or value. You may notice that each one of these measures is a different method of determining a single representative number suited to different types of the data sets.

Mean

Mean is the simple arithmetic average of the different values of a variable. For ungrouped and grouped data, the methods for calculating mean are necessarily different. Mean can be calculated by direct or indirect methods, for both grouped and ungrouped data.

Computing Mean from Ungrouped Data

Direct Method

While calculating mean from ungrouped data using the direct method, the values for each observation are added and the total number of occurrences are divided by the sum of all observations. The mean is calculated using the following formula:

X‾=∑xN\overline {{\mathrm{X}}} = \frac {\sum x}{\mathrm{N}}

Where,

X‾=Mean\overline{\mathbf{X}} = \text{Mean}
∑=Sum of a series of measures\begin{array}{r l} \sum & = \text {Sum of a series of measures} \end{array}
x=A raw score in a series of measures\begin{array}{r l} x \quad & = \text {A raw score in a series of measures} \end{array}
∑x=The sum of all themeasures\sum \mathrm{x} = \begin{array}{l} \text {The sum of all the} \\ \text {measures} \end{array}
N=Number ofmeasures\begin{array}{r l} \mathrm{N} & = \text {Number of} \\ & \text {measures} \end{array}

Example 2.1 : Calculate the mean rainfall for Malwa Plateau in Madhya Pradesh from the rainfall of the districts of the region given in Table 2.1:

Districts in Malwa PlateauNormal Rainfall in mmsIndirect Method
x Direct Method d=x−800∗d = x-800^*
Indore979179
Dewas1083283
Dhar83333
Ratlam89696
Ujjain89191
Mandsaur82525
Shajapur977177
∑x and ∑d\sum x \text{ and } \sum d 6484884
∑xN and ∑dN\frac{\sum x}{N} \text{ and } \frac{\sum d}{N} 926.29126.29
Unsupported block type: page_aside_text

The mean for the data given in Table 2.1 is computed as under:

X‾=∑xN=6,4847=926.29\begin{array}{l} \overline {{X}} = \frac {\sum x}{N} \\ = \frac {6 , 4 8 4}{7} \\ = 9 2 6. 2 9 \\ \end{array}

It could be noted from the computation of the mean that the raw rainfall data have been added directly and the sum is divided by the number of observations i. e., districts. Therefore, it is known as direct method.

Indirect Method

For a large number of observations, the indirect method is normally used to compute the mean. It helps in reducing the values of the observations to smaller numbers by subtracting a constant value from them. For example, as shown in Table 2.1, the rainfall values lie between 800 and 1100 mm. We can reduce these values by selecting ‘assumed mean’ and subtracting the chosen number from each value. In the present case, we have taken 800 as assumed mean. Such an operation is known as coding. The mean is then worked out from these reduced numbers (Column 3 of Table 2.1).

The following formula is used in computing the mean using indirect method:

X‾=A+∑dN\overline {{\mathrm{X}}} = A + \frac {\sum d}{N}

Where,

A= Subtracted constant A = \text { Subtracted constant }
∑d=Sum of the coded scores\sum d = \text {Sum of the coded scores}
N= Number of individual observations in a series N = \text { Number of individual observations in a series }

Mean for the data as shown in Table 2.1 can be computed using the indirect method in the following manner :

X‾=800+8847=800+8847X‾=926.29mm\begin{array}{l} \overline {{\mathrm{X}}} = 8 0 0 + \frac {8 8 4}{7} \\ = 800 + \frac{884}{7} \\ \overline {{\mathrm{X}}} = 9 2 6. 2 9 \mathrm{mm} \\ \end{array}

Note that the mean value comes the same when computed either of the two methods.

Computing Mean from Grouped Data

The mean is also computed for the grouped data using either direct or indirect method.

Direct Method

When scores are grouped into a frequency distribution, the individual values lose their identity. These values are represented by the midpoints of the class intervals in which they are located. While computing the mean from grouped data using direct method, the midpoint of each class interval is multiplied with its corresponding frequency (f)(f) ; all values of fx (the X are the midpoints) are added to obtain ∑fx\sum fx that is finally divided by the number of observations i. e., N. Hence, mean is calculated using the following formula :

Unsupported block type: page_aside_text

X‾=∑fxN\overline {{X}} = \frac {\sum f x}{N}

Where :

X‾=Meanf=Frequenciesx= Midpoints of class intervals N=Number of observations (it may also be defined as ∑f)\begin{array}{l} \overline {{\mathrm{X}}} = \text {Mean} \\ f \quad = \quad \text {Frequencies} \\ x = \text { Midpoints of class intervals } \\ { N } { = } { \text {Number of observations (it may also be defined as } \sum f ) } \\ \end{array}

Example 2.2 : Compute the average wage rate of factory workers using data given in Table 2.2:

Wage Rate (Rs./day)Number of workers (f)
Classesf
50 - 7010
70 - 9020
90 - 11025
110 - 13035
130 - 1509
ClassesFrequency (f)Mid-points (x)fxd=x-100fdU = (x-100)/20fu
50-701060600-40-400-2-20
70-9020801,600-20-400-1-20
90-110251002,5000000
110-130351204,20020700135
130-15091401,26040360218
∑fx\sum fx and ∑fx\sum fx ∑f=99\sum f = 99 ∑fx=10,160\sum fx = 10,160 ∑fd=260\sum fd = 260 ∑fu=13\sum fu = 13

Where N=∑f=99N = \sum f = 99

Table 2.3 provides the procedure for calculating the mean for grouped data. In the given frequency distribution, ninety-nine workers have been grouped into five classes of wage rates. The midpoints of these groups are listed in the third column. To find the mean, each midpoint (X) has been multiplied by the frequency (f) and their sum ( ∑fx\sum fx ) divided by N.

Unsupported block type: page_aside_text

The mean may be computed as under using the given formula :

X‾=∑fxN=10,16099=102.6\begin{array}{l} \overline {{X}} = \frac {\sum f x}{N} \\ = \frac {1 0 , 1 6 0}{9 9} \\ = 1 0 2. 6 \\ \end{array}

Indirect Method

The following formula can be used for the indirect method for grouped data. The principles of this formula are similar to that of the indirect method given for ungrouped data. It is expressed as under

x‾=A±∑fdN\overline {{\boldsymbol {x}}} = \boldsymbol {A} \pm \frac {\sum f d}{N}

Where,

A=A = Midpoint of the assumed mean group

(The assumed mean group in Table 2.3 is 90 - 110 with 100 as midpoint.)

f=f = Frequency

d=d = Deviation from the assumed mean group (A)

N=N = Sum of cases or ∑f\sum f

i=i = Interval width (in this case, it is 20)

From Table 2.3 the following steps involved in computing mean using the direct method can be deduced :

•
(i) Mean has been assumed in the group of 90 - 110. It is preferably assumed from the class as near to the middle of the series as possible. This procedure minimises the magnitude of computation. In Table 2.3, A (assumed mean) is 100, the midpoint of the class 90 - 110.
•
(ii) The fifth column (u)(u) lists the deviations of midpoint of each class from the midpoint of the assumed mean group (90 - 110).
•
(iii) The sixth column shows the multiplied values of each ff by its corresponding dd to give fdfd. Then, positive and negative values of fdfd are added separately and their absolute difference is found ( ∑fd\sum fd). Note that the sign attached to ∑fd\sum fd is replaced in the formula following A, where ±\pm is given.

The mean using indirect method is computed as under :

x‾=A±∑fdN=100+26099=100+2.6=102.6\begin{array}{l} \overline {{\boldsymbol {x}}} = \boldsymbol {A} \pm \frac {\sum f d}{N} \\ = 1 0 0 + \frac {2 6 0}{9 9} \\ = 1 0 0 + 2. 6 \\ = 1 0 2. 6 \\ \end{array}

Note : The Indirect mean method will work for both equal and unequal class intervals.

Unsupported block type: page_aside_text

Median

Median is a positional average. It may be defined “as the point in a distribution with an equal number of cases on each side of it”. The Median is expressed using symbol M.

Computing Median for Ungrouped Data

When the scores are ungrouped, these are arranged in ascending or descending order. Median can be found by locating the central observation or value in the arranged series. The central value may be located from either end of the series arranged in ascending or descending order. The following equation is used to compute the median :

Value of(N+12)th item\text {Value of} \left(\frac {\mathrm{N} + 1}{2}\right) \text {th item}

Example 2.3: Calculate median height of mountain peaks in parts of the Himalayas using the following:

8,126 m, 8,611m, 7,817 m, 8,172 m, 8,076 m, 8,848 m, 8,598 m.

Computation : Median (M) may be calculated in the following steps :

•
(i) Arrange the given data in ascending or descending order.
•
(ii) Apply the formula for locating the central value in the series. Thus :
Value of(N+12)th item\text {Value of} (\frac {\mathrm{N} + 1}{2}) \text {th item}
=(7+12)th item= \left(\frac {7 + 1}{2}\right) \text {th item}
=(82)th item= \left(\frac {8}{2}\right) \text {th item}

4th item in the arranged series will be the Median.

Arrangement of data in ascending order –

7,817;8,076;8,126;8,172;8,598;8,611;8,8484th item\begin{array}{l} 7, 8 1 7; 8, 0 7 6; 8, 1 2 6; 8, 1 7 2; 8, 5 9 8; 8, 6 1 1; 8, 8 4 8 \\ \hline \text {4th item} \end{array}

Hence,

M=8,172m\mathrm{M} = 8, 1 7 2 \mathrm{m}

Computing Median for Grouped Data

When the scores are grouped, we have to find the value of the point where an individual or observation is centrally located in the group. It can be computed using the following formula :

M=l+if(N2−c)\boldsymbol {M} = \boldsymbol {l} + \frac {\boldsymbol {i}}{\boldsymbol {f}} \left(\frac {\boldsymbol {N}}{2} - \boldsymbol {c}\right)
Unsupported block type: page_aside_text

Where,

M = Median for grouped data

l=l = Lower limit of the median class

i=i = Interval

f=f = Frequency of the median class

N=N = Total number of frequencies or number of observations

c=c = Cumulative frequency of the pre-median class.

Example 2.4 : Calculate the median for the following distribution :

class50-6060-7070-8080-9090-100100-110
f37111685
ClassFrequency (f)Cumulative Frequency (F)Calculation of Median Class
50-6033
60-70710
70-801121c
80-90(median group)16f37 M=N2M = \frac{N}{2}
90-100845 =502= \frac{50}{2}
100-110550
∑f or N=50\sum f \ or \ N = 50 =25= 25

The median is computed in the steps given below :

•
(i) The frequency table is set up as in Table 2.4.
•
(ii) Cumulative frequencies (F) are obtained by adding each normal frequency of the successive interval groups, as given in column 3 of Table 2.4.
•
(iii) Median number is obtained by N2\frac{N}{2} i.e. 502=25\frac{50}{2} = 25 in this case, as shown in column 4 of Table 2.4.
•
(iv) Count into the cumulative frequency distribution (F) from the top towards bottom until the value next greater than N2\frac{N}{2} is reached. In this example, N2\frac{N}{2} is 25, which falls in the Class interval of 40-44 with cumulative frequency of 37, thus the cumulative frequency of the pre-median class is 21 and actual frequency of the median class is 16.
•
(v) The median is then computed by substituting all the values determined in the step 4 in the following equation :
M=l+if(m−c)\boldsymbol {M} = \boldsymbol {l} + \frac {\boldsymbol {i}}{\boldsymbol {f}} (\boldsymbol {m} - \boldsymbol {c})
Unsupported block type: page_aside_text
=80+1016(25−21)=80+58×4=80+52=80+2.5\begin{array}{l} = 8 0 + \frac {1 0}{1 6} (2 5 - 2 1) \\ = 8 0 + \frac {5}{8} \times 4 \\ = 8 0 + \frac {5}{2} \\ = 8 0 + 2. 5 \\ \end{array}
M=82.5\mathrm{M} = 8 2. 5

Mode

The value that occurs most frequently in a distribution is referred to as mode. It is symbolised as Z or M0M_{0} . Mode is a measure that is less widely used compared to mean and median. There can be more than one type mode in a given data set.

Computing Mode for Ungrouped Data

While computing mode from the given data sets all measures are first arranged in ascending or descending order. It helps in identifying the most frequently occurring measure easily.

Example 2.5 : Calculate mode for the following test scores in geography for ten students :

61,10,88,37,61,72,55,61,46,226 1, 1 0, 8 8, 3 7, 6 1, 7 2, 5 5, 6 1, 4 6, 2 2

Computation : To find the mode the measures are arranged in ascending order as given below:

10,22,37,46,55,61,61,61,72,88.1 0, 2 2, 3 7, 4 6, 5 5, \mathbf {6 1}, \mathbf {6 1}, \mathbf {6 1}, 7 2, 8 8.

The measure 61 occurring three times in the series is the mode in the given dataset. As no other number is in the similar way in the dataset, it possesses the property of being unimodal.

Example 2.6 : Calculate the mode using a different sample of ten other students, who scored:

82,11,57,82,08,11,82,95,41,11.8 2, 1 1, 5 7, 8 2, 0 8, 1 1, 8 2, 9 5, 4 1, 1 1.

Computation : Arrange the given measures in an ascending order as shown below :

08,11,11,11,41,57,82,82,82,950 8, 1 1, 1 1, 1 1, 4 1, 5 7, 8 2, 8 2, 8 2, 9 5

It can easily be observed that measures of 11 and 82 both are occurring three times in the distribution. The dataset, therefore, is bimodal in appearance. If three values have equal and highest frequency, the series is trimodal. Similarly, a recurrence of many measures in a series makes it multimodal. However, when there is no measure being repeated in a series it is designated as without mode.

Comparison of Mean, Median and Mode

The three measures of the central tendency could easily be compared with the help of normal distribution curve. The normal curve refers to a frequency distribution in which the graph of scores often called a bell-shaped curve. Many human traits such as intelligence, personality scores and student achievements have normal distributions. The bell-shaped curve looks the way it does, as it is symmetrical. In other words, most of the observations lie on and around the middle value. As one approaches the extreme values, the number of observations reduces in a symmetrical manner. A normal curve can have high or low data variability. An example of a normal distribution curve is given in Fig. 2.1.

Unsupported block type: page_aside_text

Fig. 2.1 : Normal Distribution Curve
Fig. 2.1 : Normal Distribution Curve

The normal distribution has an important characteristic. The mean, median and mode are the same score (a score of 100 in Fig. 2.1) because a normal distribution is symmetrical. The score with the highest frequency occurs in the middle of the distribution and exactly half of the scores occur above the middle and half of the scores occur below. Most of the scores occur around the middle of the distribution or the mean. Very high and very low scores do not occur frequently and are, therefore, considered rare.

If the data are skewed or distorted in some way, the mean, median and mode will not coincide and the effect of the skewed data needs to be considered (Fig. 2.2 and 2.3).

Fig. 2.2 : Positive Skew
Fig. 2.2 : Positive Skew
Textbook illustration
Unsupported block type: page_aside_text
Fig. 2.3 : Negative Skew
Fig. 2.3 : Negative Skew

Exercises

1. Choose the correct answer from the four alternatives given below:

(i) The measure of central tendency that does not get affected by extreme values:

(a) Mean

(b) Mean and Mode

(c) Mode

(d) Median

(ii) The measure of central tendency always coinciding with the hump of any distribution is:

(a) Median

(b) Median and Mode

(c) Mean

(d) Mode

2. Answer the following questions in about 30 words:

•
(i) Define the mean.
•
(ii) What are the advantages of using mode?

3. Answer the following questions in about 125 words:

•
(i) Explain relative positions of mean, median and mode in a normal distribution and skewed distribution with the help of diagrams.
•
(ii) Comment on the applicability of mean, median and mode (hint: from their merits and demerits).

Activity

1. Take an imaginary example applicable to geographical analysis and explain direct and indirect methods of calculating mean from ungrouped data.

Unsupported block type: page_aside_text