No. of Printed Pages: 2 IBCSL-044(P)/S1 I
BACHELOR OF COMPUTER APPLICATIONS (Revised)

Term-End Practical Examination
December, 2016


BCSL-044(P)/S1 STATISTICAL TECHNIQUES LAB
Time: 1 Hour Maximum Marks: 50
Note: There are two compulsory questions in this paper of20 marks each. Rest 10 marks are for viva-voce.
Use any spreadsheet package for implementation. For programming (if asked), you may use any compiler.

1. The concentration of dissolved minerals were recorded in 20 samples of water. The following table shows this data:

Mineral Concentration (in ppm)
250 290 800 715 671
125 1075 1200 300 700
995 1207 691 827 671
1210 405 607 895 670

Perform the following tasks for the data given above:

Enter the data in a spreadsheet and create a frequency distribution. You must create suitable ranges for this distribution. Use array formula for finding the distribution.

Draw the histogram of the data.

Find the relative frequency distribution for the frequency distribution obtained in part

Find the mean and standard deviation of the data using spreadsheet formula.

2. A group of 10 students were given intensive counselling sessions in mathematics subject. The following table shows the marks out of 50 in two equivalent tests, one conducted before the counselling and the second conducted after the counselling sessions:

Marks before counselling 20 27 31 24 45 31 16 15 12 15
Marks after counselling 31 16 37 41 40 27 29 35 19 27

Using t-test with a significance level of can you say that the counselling sessions have helped the students? Clearly write H0 and H1 and explain your result. Make suitable assumptions, if any.