PRACTICAL No.
2 Measures of Central Tendency
Note: For each question, mention all the MS Excel functions used (Function – Syntax & Use)
1. Determine the measures of central tendency for the given data:
2 3 5 3 3 5 4 4 5 4
3 4 3 3 4 2 4 2 3 4
4 2 3 5 4 1 4 3 4 2
4 2 3 4 1 5 4 2 5 0
0 0 5 5 3 3 5 2 4 3
2. The following data gives length in cm. of 20 iron bars: 90, 92, 95, 93, 91, 91, 94, 94, 92, 92, 95, 92, 95,
93, 92, 95, 93, 94, 93, 90. Determine the median.
3. The data related to percentage of students is given as follows: 80.1, 78.2, 75.5, 86.1, 80.5, 76.0, 83.7,
95.4, 81.8, 78.1, 90.7, 74.6, 72.6, 81.2, 80.7, 82.9, 79.1, 87.1, 91.1, 83.2, 79, 89.3, 78.9, 78.5, 80.2, 82.2,
83.1, 84.2, 86.5, 81.9, 83.7, 85.2, 85.0, 73.1, 89.0, 80.1, 82.5, 84.3, 80.1, 85.4, 87.4, 80.7, 83.1, 82.9,
87.7, 90.9, 77.8, 83.3, 92.2, 85.7.
Calculate the arithmetic mean and standard deviation.
4. The following data relates to the number of students in different divisions in various classes of a school:
45, 47, 50, 52, 50, 45, 51 47, 42, 43, 45, 46, 50, 46, 45, 42, 45, 43, 45, 44, 45, 50, 45, 45. Determine an
appropriate average.
5. Compute Median, Q1, D7, P64 for the given data: 15.2, 17.3, 23.5, 14.6, 13.1, 19, 15.6, 7.3, 15.5, 12.6,
16.4, 18.5, 21.1, 15.2, 20, 12.2, 9.5, 14.6, 17.7, 16.8, 15.3, 13.5, 22.3, 20.6, 22.5, 17.4, 21.1, 19.9, 18.8,
16.6, 19.7, 11.1, 18.3, 10.
6. Determine the quartiles for the given data: 2250, 2300, 2470, 2595, 2320, 2575, 2786, 3092, 2825,
2908, 2675, 3110, 2300, 2780, 2885, 2656, 2745, 2435, 2770, 2788, 2583, 2830, 2340, 2920, 2532,
2115, 2000, 2205, 2050, 2437.
7. Marks obtained by 100 students are as follows:
72, 61, 63, 65, 62, 68, 69, 64, 65, 67, 69, 56, 60, 66, 62, 57, 72, 67, 65, 70, 64, 66, 71, 73, 67,
65, 64, 63, 61, 58, 64, 62, 69, 66, 65, 63, 63, 59, 61, 64, 65, 57, 66, 71, 68, 70, 67, 66, 60, 62,
65, 58, 63, 68, 64, 61, 62, 65, 66, 59, 62, 65, 65, 60, 64, 61, 64, 69, 62, 64, 62, 63, 68, 67, 65,
62, 65, 68, 61, 63, 62, 72, 62, 66, 66, 65, 63, 67, 66, 63, 63, 66, 65, 63, 62, 62, 66, 64, 62, 62.
Determine the arithmetic mean, standard deviation
8. Consider the following daily closing stock prices (in rupees) for a particular company:
1250, 1300, 1280, 1320, 1290, 1310, 1270, 1330, 1300, 1280, 1320, 1290, 1310, 1270, 1330, 1300,
1280, 1320, 1290, 1310, 1270, 1330, 1300, 1280, 1320, 1290, 1310, 1270, 1330, 1300. Compute all the
measures of central tendency.
9. Consider the following hourly temperature readings (in degrees Celsius) for a specific location: 25, 26,
27, 28, 29, 30, 31, 32, 31, 30, 29, 28, 27, 26, 25, 24, 23, 22, 21, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30.
What is the average temperature? Also determine the standard deviation.
10. Determine the mean and variance for the following set of observations.
45 50 55 35 40 43 60 61 57 44 57 54 33 28 46
60 55 57 40 37 50 57 69 60 45 55 60 45 35 55
65 66 25 52 53 24 26 54 52 51 61 63 55 29 22
69 69 22 50 56 25 30 55 55 52 69 65 61 30 26
PRACTICAL No. 3 Measures of Dispersion
1. The data related to percentage of students is given as follows: 80.1, 78.2, 75.5, 86.1, 80.5, 76.0, 83.7,
95.4, 81.8, 78.1, 90.7, 74.6, 72.6, 81.2, 80.7, 82.9, 79.1, 87.1, 91.1, 83.2, 79, 89.3, 78.9, 78.5, 80.2, 82.2,
83.1, 84.2, 86.5, 81.9, 83.7, 85.2, 85.0, 73.1, 89.0, 80.1, 82.5, 84.3, 80.1, 85.4, 87.4, 80.7, 83.1, 82.9,
87.7, 90.9, 77.8, 83.3, 92.2, 85.7.
Calculate the arithmetic mean and standard deviation.
2. Marks obtained by 100 students are as follows:
72, 61, 63, 65, 62, 68, 69, 64, 65, 67, 69, 56, 60, 66, 62, 57, 72, 67, 65, 70, 64, 66, 71, 73, 67,
65, 64, 63, 61, 58, 64, 62, 69, 66, 65, 63, 63, 59, 61, 64, 65, 57, 66, 71, 68, 70, 67, 66, 60, 62,
65, 58, 63, 68, 64, 61, 62, 65, 66, 59, 62, 65, 65, 60, 64, 61, 64, 69, 62, 64, 62, 63, 68, 67, 65,
62, 65, 68, 61, 63, 62, 72, 62, 66, 66, 65, 63, 67, 66, 63, 63, 66, 65, 63, 62, 62, 66, 64, 62, 62.
Determine the arithmetic mean, standard deviation
3. Consider the following hourly temperature readings (in degrees Celsius) for a specific location: 25, 26,
27, 28, 29, 30, 31, 32, 31, 30, 29, 28, 27, 26, 25, 24, 23, 22, 21, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30.
What is the average temperature? Also determine the standard deviation.
4. Determine the mean and variance for the following set of observations.
45 50 55 35 40 43 60 61 57 44 57 54 33 28 46
60 55 57 40 37 50 57 69 60 45 55 60 45 35 55
65 66 25 52 53 24 26 54 52 51 61 63 55 29 22
69 69 22 50 56 25 30 55 55 52 69 65 61 30 26
5. Determine the skewness for the following data: 65, 64, 63, 61, 58, 64, 62, 69, 66, 65, 63, 63, 59, 61, 64,
65, 57, 66, 71, 68, 70, 67, 66, 60, 62.
6. Identify the shape of the frequency curve for the given data: 65, 64, 63, 61, 58, 64, 62, 69, 66, 65, 63,
63, 59, 61, 64, 65, 57, 66, 71, 68, 70, 67, 66, 60, 62.
7. Compare the peakedness of the following sets:
Set A 10 20 30 40 30 20 10
Set B 10 20 30 70 30 20 10
8. Which of the following is least skewed.
A 2 3 4 5 6 7 8
B 10 17 23 15 17 19 30
C 3 6 7 2 8 3 6
9.