BCSL044-SOLVED ASSIGNMENT 2016-17 IGNOU BCA 4th SEM

1.

The volume of milk contained in one liter packets (in liters) is given below. Perform the tasks given in (i) to (iv) using a spreadsheet package:

(i) Find the minimum and maximum volume using spreadsheet formula.

(ii) Create 5 classes with suitable class interval and create the frequency distribution for volume using Array formula.

(iii) Find the percentage of packets having volume less than a liter.

(iv) Represent the frequency distribution with the help of a relevant graph.

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):

(i) Given a population of 5000 and a sample size of 20 with a standard deviation of 10; calculate the standard error.

(ii) A company manufactures nails of different lengths. The nails with length 2 inch should have a mean diameter of 3 mm. A sample of 100 nails was taken out of a lot consisting of 10000 such nails. The mean sample diameter was found to be 3.01 mm having a standard deviation of 0.03 mm. Assuming a confidence level of 95%, will you accept the nail lot. Justify your answer. Make suitable assumption, if any.

3.

Measure control department checked the 5 kg weights of four different manufacturers. Four samples of each of these manufacturers were tested. The findings are given in the following table:

Perform an ANOVA using any software to test (at 5% level) whether all the four manufacturers are producing proper weights. Make suitable assumptions, if any.

4.

A Petrol filling station records the details of sales of petrol every day. The following table shows the sale of petrol by the company. Use spreadsheet software to find the moving averages for the length of 4 and 5.

5.

A company manufactures pipes of 1 meter diameter. The company takes five observations of the diameter of the pipe on each day. These observations are taken 5 times during a working 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:

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

6.

A stationery selling company sells stationery items as per the following table. Fit a trend using any statistical software to sales data for this company. Make suitable assumptions.

-----------------------------------------------------------------------------------------
Assignment Solution on process | IGNOU BCA MCA Solved Assignment 2016 2017  Join IGNOU BCA MCA Coaching Class |  Synopsis & Project Support 
Powered by IGNOUFriend | www.ignoufriend.co.in |

ignou bca mca synopsis, ignou class, ignou bca mca project, solved ignou assignment,BCA Coaching Institute in Delhi, MCA Coaching Institute in Delhi, BCA MCA Coaching Institute in Delhi, BCA MCA, Tuation Class in delhi, IGNOU BCA MCA Class, IGNOU BCA MCA Tution,IGNOU Solved Assignment, IGNOU BCA Synopsis , IGNOU MCA Synopsis, ignou bca project, ignou mca project, ignou best coaching in delhi, ignou best coaching in new delhi, ignou best coaching in south delhi, ignou best coaching in north delhi, ignou best coaching in east delhi, ignou best coaching in west delhi

ignou, bca, mca, coaching institute, tution class, bcsp064, mcsp060, cs76, mcs044,bcs011, bcs012, mcs011, mcs012, mcs013, mcs015, bcsl021, bcsl022, mcs014, bcs040, mcs021, mcs023, bcs031, bcsl032, bcsl033, bcsl 034, bcs041, bcs042, mcsl016, bcsl043, bcsl044, bcsl045, bcs051, bcs052, bcs053, bcs054, bcs055, bcsl056, bcsl057, bcsl058, bcs062, mcs022, bcsl063, project

mcsp060, mcse011, mcse004, mcse003, mcsl054, mcs053, mcs052, mcs051, mcsl045, mcs044, mcs043, mcs042, mcs041, mcsl036, mcs035, mcs034, mcs033, mcs032, mcs031, mcsl025, mcs024, mcs023, mcs022, mcs021, mcsl017, mcsl016, mcs015, mcs014, mcs013, mcs012, mcs011

nips institute, nipsar, ignoufriend.in, ignoufriend.co.in, ignouhelp, best coaching institute