Description
| Course Code : | BCSL-44 |
|---|---|
| Course Title : | Statistical Techniques Lab |
| Assignment Number : | BCA(4)/044/Assignment/2020-21 |
| Maximum Marks : | 50 |
| Weightage : | 25% |
| Last Date of Submission : | 31st October, 2021 (for July 2021 session) 15th April, 2022 (for January 2022 session) |
| Solution Type : | Softcopy (PDF File) |
There are six questions in this assignment, which carries 40 marks. Rest 10 marks are for viva-voce. Answer all the questions. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation.
All the following questions must be performed using a statistical package. You may use any statistical package for this purpose.
Question 1: Height of the students of a class of 40 students was recorded. 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:
| 145 | 157 | 160 | 159 | 142 | 128 | 167 | 133 | 170 | 129 |
| 120 | 165 | 137 | 142 | 141 | 153 | 149 | 167 | 136 | 150 |
| 152 | 144 | 130 | 170 | 158 | 144 | 136 | 139 | 125 | 196 |
| 147 | 153 | 152 | 147 | 139 | 128 | 151 | 141 | 161 | 143 |
(i) Find the minimum and maximum height using the spreadsheet formula.
(ii) Create 6 classes with suitable class intervals and create the frequency distribution. You must use Array formula.
(iii) Find the percentage of the students whose height is less than the mean height. Also find outlier in the data, if any.
(iv) Draw the histogram for the data given in the table above. Is the data distribution normal distribution?
Question 2: Perform the following tasks using spreadsheet software (you may use spreadsheet function for computing the value of t):
(i) Find the value of t for the given value of degree of freedom and significance level (alpha):
| Degree of freedom | Significance |
|---|---|
| 24 | 0.10 |
| 10 | 0.05 |
(ii) A company manufactures flour packets of 5 kg weight. A sample of 20 such flour packets were taken out of a lot consisting of 500 flour packets. The mean sample weight was found to be 5.150 kg having a standard deviation of 0.215 kg. Assuming random sampling and a confidence level of 95%, will you accept the flour packets. Justify your answer. You should perform all computations using a spreadsheet software. Make suitable assumption, if any.
Question 3: A hardware company produces IC chips; the length of each chip is required to be exactly 50 mm. The company has four different machines to produce these IC chips. Each day five samples of each machine are taken and the length of these IC chips is measured. The following tables lists these details:
The length of IC chips (in mm)
| Sample | Machine Identifier | |||
|---|---|---|---|---|
| A | B | C | D | |
| 1 | 50.12 | 50.15 | 50.13 | 50.00 |
| 2 | 49.95 | 49.99 | 50.01 | 50.11 |
| 3 | 50.02 | 49.97 | 49.91 | 49.92 |
| 4 | 50.13 | 50.16 | 49.99 | 50.02 |
| 5 | 50.07 | 49.90 | 50.11 | 50.10 |
Perform an ANOVA using any software to test (at 5% level) whether all the four machines are producing the IC chips with correct length. Justify your findings. Make suitable assumptions, if any.
Question 4: The rainfall in the first 15 days of August, 2021 is shown in the following table. Use spreadsheet software to find the moving averages for the length of 5 and 7. Also draw suitable graphs of these moving averages.
| Day | Rainfall (mm) |
|---|---|
| 1 | 100 |
| 2 | 70 |
| 3 | 50 |
| 4 | 5 |
| 5 | 0 |
| 6 | 0 |
| 7 | 25 |
| 8 | 34 |
| 9 | 21 |
| 10 | 10 |
| 11 | 0 |
| 12 | 5 |
| 13 | 5 |
| 14 | 10 |
| 15 | 30 |
Question 5: A company packs nuts in a packet of 1 kg. The quality of process of producing the packets of nuts is controlled statistically. To do so, sample of five packets is taken at four different times of the 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 id of the day | The weight of the packet of Nuts (in Kgs) | ||||
|---|---|---|---|---|---|
| 1 | 1.052 | 1.025 | 0.995 | 0.999 | 1.008 |
| 2 | 1.093 | 1.002 | 0.998 | 1.001 | 1.009 |
| 3 | 1.044 | 1.011 | 1.001 | 1.050 | 1.060 |
| 4 | 1.055 | 1.014 | 1.030 | 1.037 | 0.991 |
(Please take suitable values of d2 , d3, d4 , A2 and other variables.)
Question 6: The following table shows the increase in the average salary of the employees of an organization. Fit a trend line using any statistical software to this sales data. Make suitable assumptions.
| Month | Jan | Feb | Mar | Apr | May | Jun | July |
|---|---|---|---|---|---|---|---|
| Sales (in No of Units) | 25000 | 21900 | 21950 | 22000 | 23000 | 24000 | 24500 |
All questions are solved in this assignment solution.
Keywords: BCSL-044, BSCL044, BCSL 044, BCSL44, BCSL-44, BCSL 44, IGNOU Solution Guide, Answer Key
Reviews
There are no reviews yet.