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

Term-End Practical Examination
December, 2016


BCSL-044{P)/S4 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 number of books sold by 20 different publishers in the area of Statistics were recorded in the following table

Number of books sold (in thousands)
510 210 100 190 999
617 911 321 516 412
782 711 692 816 311
212 316 917 392 462

Perform the following tasks for the data given above:

Enter the data in a spreadsheet package and create frequency distribution in 9 equal ranges. You may use array formula for finding the distribution.

Draw the histogram of the data.

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

Find the relative frequency distribution for the frequency distribution

2. Consider the following average temperature for the months January to December in a city:

Month Average temperature in °C
1 16
2 25
3 35
4 40
5 41
6 42
7 38
8 33
9 31
10 27
11 20
12 17

Find the moving averages of length 4 and 6. Plot these moving averages using a spreadsheet software.