IGNOU MSTL-001 Solved Assignment 2023 | PGDAST Abstract Classes ®

IGNOU MSTL-001 Solved Assignment 2023 | IGNOU PGDAST.gif

Solved By – Narendra Kr. Sharma – M.Sc (Mathematics Honors) – Delhi University

₹401.00

Get Instant Access

Share with your Friends

IGNOU MSTL-001 Assignment Question Paper 2023

Course Code: MSTL-001

Assignment Code: MSTL-001/TMA/2023

Maximum Marks: 100

\section{Note:}

1. All questions are compulsory.

2. Solve the following questions in MS Excel.

3. Take the screenshots of the final output/spreadsheet.

4. Paste all screenshots in the assignment booklets with all necessary interpretation and steps.

Q 1 A cooking oil supplier distributed two types of oils, say Oil A and Oil B to a large numbers of retail stores. The supplier wants to compare the popularity of both oils. For this purpose, he selects a sample of 100 stores and tracks record of the sold oils (in litres) of each type at each store. The data are noted in the following table:

Store No.	Oil A	Oil B	Store No.	Oil A	Oil B
1	161	419	51	478	196
2	285	411	52	284	241
3	219	168	53	488	182
4	321	241	54	447	132
5	435	125	55	384	322
6	325	261	56	267	341
7	463	119	57	390	139
8	319	285	58	270	462
9	108	441	59	381	227
10	328	213	60	252	140
11	479	116	61	245	420
12	285	319	62	196	474
13	489	135	63	201	392
14	448	187	64	227	452
15	385	349	65	181	406
16	268	279	66	441	397
17	391	306	67	130	375
18	271	296	68	213	455
19	382	269	69	373	367
20	253	403	70	190	503
21	246	309	71	280	366
22	197	424	72	236	486
23	202	349	73	297	171
24	228	250	74	421	219
25	182	457	75	340	173
26	442	196	76	380	418
27	131	240	77	308	454
28	214	337	78	361	228
29	374	252	79	183	432
30	191	423	80	121	468
31	281	322	81	162	231
32	237	406	82	286	252
33	298	146	83	220	283
34	422	175	84	322	114
35	341	487	85	436	325
36	381	278	86	326	213
37	309	442	87	464	229
38	362	326	88	320	183
39	184	414	89	120	291
40	122	377	90	329	175
41	160	250	91	480	141
42	284	272	92	286	394
43	218	356	93	490	163
44	320	366	94	449	134
45	434	170	95	386	130
46	324	213	96	134	459
47	462	147	97	392	363
48	318	195	98	272	315
49	118	452	99	383	338
50	327	385	100	254	365

Answer the following:

i) Which type of oil has more average sales?

ii) Which oil shows greater variability in the sales?

iii) Determine the correlation between both types of oils.

iv) Compute suitable width of the class intervals for both oils,

v) Construct the continuous frequency distribution for both oils.

Q 2 The scores (out of 100) secured by 60 employees of three different departments D1, D2 and D3 who participated in a study, are presented in the following table:

Employee No.	Scores of D1	Scores of D2	Scores of D3	Employee No.	Scores of D1	Scores of D2	Scores of D3
1	54	78	56	31	59	76	57
2	49	73	55	32	57	87	66
3	36	72	52	33	46	80	62
4	64	87	67	34	57	82	61
5	47	85	65	35	48	78	59
6	46	75	58	36	65	90	66
7	61	94	70	37	69	94	70
8	56	88	67	38	43	73	54
9	57	81	59	39	36	68	48
10	43	73	56	40	43	66	48
11	60	89	69	41	56	90	66
12	54	92	70	42	52	73	56
13	56	96	75	43	57	83	61
14	55	85	62	44	45	69	51
15	53	89	66	45	46	75	58
16	63	85	64	46	58	88	64
17	50	67	47	47	49	73	53
18	67	96	71	48	60	92	68
19	50	67	49	49	63	81	59
20	54	87	64	50	51	78	57
21	41	69	49	51	53	76	58
22	53	83	60	52	47	76	56
23	55	85	64	53	38	68	52
24	58	76	59	54	46	82	63
25	36	70	54	55	39	66	47
26	49	71	51	56	67	91	71
27	62	95	74	57	61	82	61
28	66	88	65	58	56	83	60
29	53	75	56	59	48	67	50
30	49	88	64	60	35	68	50

i) Compute the correlation coefficient between scores of the employees working in department D1 and the joint effects of scores of the employees of departments D1 and D2.

ii) Compute the correlation coefficient between scores of the employees working in departments D1 and D2 after eliminating the linear effect of the scores of departments D3.

iii) Also represent the scores obtained by departments D1, D2 and D3 using box plot.

Q3 An experiment was conducted to compare two metals: A and B, as bonding agents for an alloy material. Components of the alloy were bonded using the metals as bonding agents, and the pressures required to break the bonds were measured. The data for the pressures required for breaking the metal are given in the following table:

S. No.	Breaking Pressure		S. No.	Breaking Pressure
	Metal A	Metal B		Metal A	Metal B
1	71.9	72.2	21	86.5	70.6
2	68.8	66.4	22	74.3	74.6
3	82.6	74.5	23	71.2	68.8
4	78.1	60.6	24	85	76.9
5	74.2	73.2	25	80.5	63
6	70.8	68.7	26	76.6	75.6
7	84.9	69	27	73.2	71.1
8	72.7	73	28	87.3	71.4
9	69.6	67.2	29	75.1	75.4
10	83.4	75.3	30	72	69.6
11	78.9	61.4	31	85.8	77.3
12	75	74	32	81.3	63.4
13	71.6	69.5	33	77.4	76
14	85.7	69.8	34	74	71.5
15	73.5	73.8	35	88.1	71.8
16	70.4	68	36	75.9	75.8
17	84.2	76.1	37	72.8	70
18	79.7	62.2	38	86.6	77.7
19	75.8	74.8	39	82.1	63.8
20	72.4	70.3	40	78.2	76.4

If the pressure required to break both metals are normally distributed, then answers the following questions:

i) Are the variances of the distributions of the pressure of Metals A and B equal at \(5 \%\) level of significance?

ii) If yes, check whether the average pressure for Metal \(\mathrm{A}\) is more than the Metal \(\mathrm{B}\) at \(5 \%\) level of significance?

Q 4 An investigation was performed to study the impacts of different types of machines on the production of a particular variety of toys. The six machines \((\mathrm{A}, \mathrm{B}, \mathrm{C}, \mathrm{D}, \mathrm{E}\) and F) are assigned at random to 36 cells of the square with the restriction that each machine is used only once by each operator and in each time-period. The following design was obtained in which 6 operators are arranged in “columns” and 6 time-periods are in “rows”:

		Operator
		1	2	3	4	5	6
Time Period	1	A	B	C	D	E	F
	2	B	C	D	E	F	A
	3	C	D	E	F	A	B
	4	D	E	F	A	B	C
	5	E	F	A	B	C	D
	6	F	A	B	C	D	E

The average production in a day is given as follows:

		Operator
		1	2	3	4	5	6
Time Period	1	142	148	149	149	154	147
	2	145	150	152	155	148	151
	3	149	147	151	148	148	150
	4	138	141	146	145	149	147
	5	141	153	152	151	151	149
	6	147	149	150	146	150	148

Assuming that the effect of each operator, time-period and machine are normally distributed with approximately equal variances, analyse the design at \(1 \%\) level of significance. Test whether the effect of the different operators, time periods and machines on the production are significant or not. If significant, do the pair-wise comparison between them.

MSTL-001 Sample Solution 2023

Frequently Asked Questions (FAQs)

How do I access the Complete Solution?

You can access the Complete Solution through our app, which can be downloaded using this link:

App Link

Simply click “Install” to download and install the app, and then follow the instructions to purchase the required assignment solution. Currently, the app is only available for Android devices. We are working on making the app available for iOS in the future, but it is not currently available for iOS devices.

Is this Complete Solution for IGNOU Assignments?

Yes, It is Complete Solution, a comprehensive solution to the assignments for IGNOU. Valid from January 1, 2023 to December 31, 2023.

Is the Complete Solution aligned with the IGNOU requirements?

Yes, the Complete Solution is aligned with the IGNOU requirements and has been solved accordingly.

Is the Complete Solution guaranteed error-free?

Yes, the Complete Solution is guaranteed to be error-free.The solutions are thoroughly researched and verified by subject matter experts to ensure their accuracy.

Can I access the Complete Solution anytime?

As of now, you have access to the Complete Solution for a period of 6 months after the date of purchase, which is sufficient to complete the assignment. However, we can extend the access period upon request. You can access the solution anytime through our app.

What if I need help with a specific assignment question?

The app provides complete solutions for all assignment questions. If you still need help, you can contact the support team for assistance at Whatsapp +91-9958288900

Can I access the educational materials on multiple devices?

No, access to the educational materials is limited to one device only, where you have first logged in. Logging in on multiple devices is not allowed and may result in the revocation of access to the educational materials.

How do I make a payment for accessing the solutions?

Payments can be made through various secure online payment methods available in the app.Your payment information is protected with industry-standard security measures to ensure its confidentiality and safety. You will receive a receipt for your payment through email or within the app, depending on your preference.

What are the instructions for formatting my assignments?

The instructions for formatting your assignments are detailed in the Assignment Booklet, which includes details on paper size, margins, precision, and submission requirements. It is important to strictly follow these instructions to facilitate evaluation and avoid delays.

Terms and Conditions

The educational materials provided in the app are the sole property of the app owner and are protected by copyright laws.
Reproduction, distribution, or sale of the educational materials without prior written consent from the app owner is strictly prohibited and may result in legal consequences.
Any attempt to modify, alter, or use the educational materials for commercial purposes is strictly prohibited.
The app owner reserves the right to revoke access to the educational materials at any time without notice for any violation of these terms and conditions.
The app owner is not responsible for any damages or losses resulting from the use of the educational materials.
The app owner reserves the right to modify these terms and conditions at any time without notice.
By accessing and using the app, you agree to abide by these terms and conditions.
Access to the educational materials is limited to one device only. Logging in to the app on multiple devices is not allowed and may result in the revocation of access to the educational materials.

Our educational materials are solely available on our website and application only. Users and students can report the dealing or selling of the copied version of our educational materials by any third party at our email address (abstract4math@gmail.com) or mobile no. (+91-9958288900).

In return, such users/students can expect free our educational materials/assignments and other benefits as a bonafide gesture which will be completely dependent upon our discretion.