##### BCA Solved Assignments

# BCSL-044 Solved Assignment 2018-19 IGNOU BCA 4th Semester

BCSL-044 Solved Assignment 2018-19 For IGNOU BCA 5th Semester is now available. This solution is valid For July 2018 and January 2019 Session. Solution is in PDF format. Click on the button below “**Goto Download Page**” to open the download page of Assignment Solution. Following are details of BCSL-044 Assignment:

**Course Code : BCSL044**

**Course Title : Statistical Techniques Lab**

**Assignment Number : BCA(4)/044/Assignment/2018-19**

**Maximum Marks : 50**

**Weightage : 25%**

**Last Dates for Submission : 15th October, 2018 (For July, 2018 Session)**

**15st April, 2019 (For January, 2019 Session)**

- Weights and measures department measured the volume of 30 samples of the milk packets of 1 liter of XYZ milk company. 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:

The Volume of Milk in 1 litre packet (in liters)1.002 0.995 0.999 1.005 0.989 1.025 1.050 0.979 1.030 0.992 1.011 1.095 1.009 1.055 1.071 0.985 0.930 1.009 0.967 0.987 1.021 0.956 1.000 0.965 0.977 1.019 1.010 0.999 1.010 0.975 1.001 1.017 0.961 1.043 0.980 1.017 1.023 0.939 1.000 0.932 1.013 0.995 0.999 1.005 0.989 1.011 0.959 1.029 1.822 0.923 - Find the minimum and maximum volume of milk in 1 liter packing using spreadsheet formula.
- Create 8 classes with suitable class intervals and create the frequency distribution. You must use Array formula.
- Find the percentage of the packets whose milk volume is less than mean volume of milk in the packets.
- Draw the histogram for the data above. Also try to relate it to normal distribution curve.

- Find the value of t for the given value of degree of freedom and significance level (alpha): Degree of freedom SignificancePerform the following tasks using a spreadsheet (you must either use necessary formula that are required to calculate the value or you may use spreadsheet function for the same):

30 0.05

15 0.10 - A company manufactures a Blank CDs having a thickness of 8 mm. A sample of 100 such CDs were taken out of a lot consisting of 10000 CDs. The mean sample width was found to be 8.024 mm having a standard deviation of 0.09 mm. Assuming a confidence level of 95%, will you accept the CDs. Justify your answer. Make suitable assumption, if any.

- Find the value of t for the given value of degree of freedom and significance level (alpha): Degree of freedom SignificancePerform the following tasks using a spreadsheet (you must either use necessary formula that are required to calculate the value or you may use spreadsheet function for the same):
- A Company produces Weights of 5 Kgs. It has four machines that produces these weights namely machine A, B, C and D. Every day four samples from each machine are taken and tested against the standard weights and measure weighing scale. The findings are given in the following table:

**Weights data**Sample Manufacturer A B C D 1 5.004 4.995 4.999 5.050 2 5.021 4.886 5.010 5.040 3 4.991 4.899 5.100 5.030 4 4.995 4.950 5.001 5.025 Perform an ANOVA using any software to test (at 5% level) whether all the four weighing scales are producing correct weights. Make suitable assumptions, if any.

- Water level in a supply tank is recorded every day before making a supply. The following are the reading of first 15 days of July. Use spreadsheet software to find the moving averages for the length of 4 and 6.
**Day****Water Level in meters**1 2

3

4

5

6

7

8

9

10

11

12

13

14

15

20.51 21.21

05.23

20.11

10.99

19.68

10.28

21.21

15.04

22.76

06.89

05.97

06.23

16.77

25.54

- A company packs Sugar in sealed packs of 5 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 the following table:
Sample Days The weight of the Sugar bag (Kgs) 1 2

3

4

5

5.023 4.999 5.512 4.876 5.028 4.893 5.021 5.016 5.011 5.088

4.824 5.111 5.121 4.895 4.933

4.785 5.097 5.222 5.069 5.123

4.888 5.045 5.068 4.921 4.989

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

- A Cotton cloth manufacturing company records the sale of its shirts in different months as given in the following table. Fit a trend line using any statistical software to this sales data. Make suitable assumptions.