BCSL-044 SOLVED ASSIGNMENT 2017-18 FOR IGNOU BCA 4th SEMESTER

IGNOU BCA 4th Semester Solved Assignment

BCSL-044 STATISTICAL TECHNIQUES LAB

QUESTIONS SOLVED IN ASSIGNMENT

1. A LED light producer tested the life of 30 samples. This data is given in the following table. Perform the tasks given in (i) to (iv) on the data given below using a spreadsheet package:
LED light life (in hrs)
38005400003509333985249873489944955348883390834098
27890230093409845008458982489830002345264100023989
345672345643211541231258436547145693214582547836541
41258254782698735896398514801541101370974120315874
31000245844102336214392013725834589270152965428622
1. Find the minimum and maximum LED light life using spreadsheet formula.
2. Create 10 classes with suitable class intervals and create the frequency distribution. You must use Array formula.
3. Find the percentage of LED lights which have less than mean life.
4. Draw the histogram for the data above. Also try to relate it to normal distribution curve.
2. Perform the following tasks using a spreadsheet (you must either enter necessary formula that are required to calculate the value or you may use spreadsheet function for the same):
1. Find the value of t for the give value of degree of freedom and significance level (alpha):
Degree of freedomalpha value
120.05
100.01
2. A company manufactures a type of USB ports which should be 12 mm wide. A sample of 200 such USB ports were taken out of a lot consisting of 50000 ports. The mean sample width was found to be 11.95 mm having a standard deviation of 0.11 mm. Assuming confidence level of 95%, will you accept the USB lot. Justify your answer. Make suitable assumption, if any.
3. A hypothetical petrol pump is equipped with a test measure of 2 litres. A person can use this measure to verify, if s/he has got the right quantity of petrol. It has four filling machine namely A, B, C and D. Every day four samples are taken from every filling machine. The findings are given in the following table:
Data of filling machines while measuring 2 litres (in litres)
SampleManufacturer
ABCD
12.011.892.111.93
22.021.872.011.93
31.992.022.091.89
41.981.972.012.00

Perform an ANOVA using any software to test (at 5% level) whether all the four filling machines are giving correct amount of petrol. Make suitable assumptions, if any.

4. Rainfall of first 15 days of July is recorded in the following table. Use spreadsheet software to find the moving averages for the length of 3 and 5.
DayRainfall (in mm)
115
225
31
40
510
619
730
82
95
1022
116
125
134
1416
1545
5. A company packs flour in sealed packs of 10 kgs. It measures the weight of 5 bags randomly; this measurement is repeated five times in each day. Calculate the control limits for mean and range, and plot the control charts using any statistical software. Make suitable assumptions, if any.
The Data is given in following tables
Sample DaysThe weight of bag (kgs)
110.0509.99010.17510.08910.005
210.20510.04510.0999.9999.975
310.15310.00110.5009.9799.898
49.9909.99710.05010.06910.075
510.97311.04511.02511.02210.999

(Please take the suitable values of d2 , d3, d4 , A2 and other variables.)

6. An Umbrella manufacturing company records the sale of Umbrella units in different months as given in the following table. Fit a trend line using any statistical software to this sales data. Make suitable assumptions.
MonthMarAprMayJuneJulAugSept
Sales of Umbrella
(Units)
50010003000700050002000400

« BCA 4th SEMESTER SOLVED ASSIGNMENTS

Close

Close