# IGNOU MSTL-002 Assignment Solution 2022

400.00500.00

You will be able to see this e-book for a certain number of days in our app. So select the number of days accordingly.

Special Note: Due to the fact that this is a lab assignment, we will send a pdf solution in our app and screenshots of the excel sheet in your email. After that, download all of the screenshots, print them out, and paste them into your workbook, just like we did with our pdf.

 Days: 30-days Choose an option30 Days45 Days60 DaysClear

400.00500.00

350.00

350.00

350.00

400.00

## IGNOU MSTL-002 Solved Assignment 2022

 Assignment Paper MSTL-002 Solved Assignment 2022 Subject Name Industrial Statistics Lab No.of Pages in Solution 55 Course PGDAST Language ENGLISH Session 2022 Last Date for Submission of Assignment As per dates given in the IGNOU website

MSTL-002 Solved Assignment is an e-book for students who want to specialise in statistics. This completed assignment will allow them to assess their degree of preparation and will be extremely beneficial. All questions and concerns have been addressed and clarified. As a result, students will comprehend the concepts of any question in the assignment.

Abstract Classes gives answers that are completely correct and comprehensive. The solution to this assignment contains the most refined and sophisticated information possible, making it the most dependable and authentic source for students who are unable to get solutions at college or on the internet. You will not find such completed assignment anywhere else on the internet.

We have been developing similar projects for students for the past five years with the help of our knowledgeable personnel. We have given students with papers of superior quality.It has written about a diverse range of themes for a variety of publications.

Remember the submission of assignment is a precondition for appearing in the examination. If you do not submit the assignment on time, you will not be allowed to appear in the examination.

How will you get this document?

Step-01 Complete the order.

Step-02 After receiving your order we will send login credentials to access our Abstract Classes app through email. (While completing your order please provide your WhatsApp number for better communication)

Step-04 Put the credentials in App and get your document.

Please see the sample pages of solution which is solved by the best faculty of Abstract Classes.

## IGNOU MSTL-002 Solved Assignment 2022

• Users are requested to respect the copyright of the author.
• Users are instructed not to take printouts, screenshots, photos etc. of the copyrighted material.
• Users are instructed not to communicate/share by any media and/or mode the copyrighted material of the author with the public for commercial gains without
written permission from the author.
• If any user is found to be infringing, copying and commercially dealing in the copyrighted material in any manner without express written permission from the
author, then strict legal action will be taken against such users.
• Already We have taken legal action against such users.
• Our educational materials are solely available on our website and/or application only. Users and/or student can report the dealing or selling of the copied version of our educational materials by any third party at our email id (abstract4math@gmail.com) and mobile number  (+91-9958288900). In return, such users/students can expect our educational materials free and other benefits as a bonafide gesture which will be completely dependent upon our discretion.

## MSTL-002 Assignment Question Paper

MSTL-002: Industrial Statistics Lab

Note:

1. All questions are compulsory.
2. Solve the following questions in MS Excel 2007.
3. Take the screenshots of the final output/spreadsheet.
4. Paste all screenshots in the assignment booklet with all necessary hypotheses, interpretation, etc.

1. A Company wants to maintain the quality of bottling process which uses a particular brand of machine to fill 100 ml sanitizer spray bottle. During each shift, a sample of 10 bottles is selected (2 hours apart) and the volume of the each filled sanitizer spray bottle (in ml) is determined. In this regards, total 25 subgroups consisting of a sample of 10 bottles in each subgroup were selected. The following table lists the measurements from 25 consecutive shifts:
 Sample No. Obs. 1 Obs. 2 Obs. 3 Obs. 4 Obs. 5 Obs. 6 Obs. 7 Obs. 8 Obs. 9 Obs. 10 1 99.46 100.12 99.73 99.56 99.46 99.73 99.46 100.12 99.73 99.56 2 100.95 100.00 99.66 100.06 100.95 99.66 100.95 100.00 99.66 100.06 3 99.84 99.43 99.62 99.73 99.84 99.62 99.84 99.43 99.62 99.93 4 99.85 99.26 99.77 99.56 99.85 99.77 99.85 99.86 99.77 99.76 5 99.66 100.12 99.91 100.02 99.66 99.91 99.66 100.12 99.91 100.02 6 99.82 100.06 99.87 100.18 99.82 99.87 99.82 100.06 99.87 100.18 7 99.86 99.66 99.46 99.52 99.86 99.46 99.86 99.66 99.86 99.72 8 99.87 99.62 100.12 99.62 99.87 100.12 99.87 99.62 100.12 99.62 9 99.85 99.67 100.13 100.07 99.85 100.13 99.85 99.67 100.13 100.07 10 99.72 99.52 99.85 99.71 99.72 99.85 99.72 99.52 99.85 99.71 11 99.88 100.00 100.26 99.87 99.88 100.26 99.88 100.00 99.86 99.87 12 99.65 100.06 100.15 99.93 99.65 100.15 99.65 100.06 100.15 99.93 13 99.46 99.70 99.43 99.87 99.86 99.63 99.66 99.70 99.83 99.87 14 99.91 99.60 99.75 100.22 99.91 99.75 99.91 99.60 99.75 100.22 15 100.04 100.06 99.82 99.85 100.04 99.82 100.04 100.06 99.82 99.85 16 100.15 100.10 99.93 99.62 100.15 99.93 100.15 100.10 99.93 99.62 17 100.13 99.56 98.81 99.25 100.13 98.81 100.13 99.56 98.81 99.25 18 99.82 100.05 100.08 99.75 99.82 100.08 99.82 100.05 100.08 99.75 19 99.90 100.10 99.91 100.15 99.90 99.91 99.90 100.10 99.91 100.15 20 99.50 99.76 99.95 99.56 99.50 99.95 99.50 99.76 99.95 99.56 21 99.88 100.12 100.00 100.25 99.88 100.00 99.88 99.92 100.00 100.05 22 99.87 99.67 99.51 99.71 99.87 99.51 99.87 99.67 99.51 99.71 23 100.31 99.91 99.60 99.96 100.31 99.60 100.31 99.91 99.60 99.96 24 99.66 99.46 99.91 99.72 99.66 99.91 99.66 99.46 99.91 99.72 25 99.90 100.02 99.70 100.07 99.90 99.70 99.90 100.02 99.70 100.07

Construct suitable control charts for variability as well as for average to infer whether the process of bottling is under statistical control or not. If it is out-of-control, also plot the revised control charts, if necessary.

2. An automobile manufacturing company examined the cars of a particular model to identify the number of defects during the final inspection stage. The total number of inspected cars were recorded for last 35 days along with the number of defects. The results are given in the following table:
 Days Total Inspected Cars Number of Defects 1 45 6 2 35 2 3 40 1 4 30 2 5 40 5 6 25 1 7 35 3 8 30 4 9 30 6 10 40 2 11 35 11 12 35 1 13 25 3 14 40 7 15 45 2 16 40 6 17 30 5 18 35 2 19 30 7 20 45 3 21 28 1 22 38 4 23 33 11 24 33 1 25 43 4 26 38 2 27 38 5 28 28 4 29 43 6 30 48 1 31 43 3 32 33 4 33 38 3 34 33 2 35 48 5

Construct a suitable control chart for the number of defects to check whether the process is under statistical control or not. Also plot the revised control charts, if necessary.

3. A Mobility-as-a-Service (MaaS) provider company conducted a study to check the relationship of several variables with its weekly commuters. For this purpose, thirty cities were selected and the number of weekly commuters were recorded along with other variables like: the average petrol price (in Rs.), population of the city, monthly income of commuters (in Rs.), average parking rates per month (in Rs.). The data are given in the following table:
 City Number of Weekly Commuters (y) Average Petrol Price (x1) Population of City (in ’000)(x2) Average Monthly Income of Commuters (x3) (in ’00) Average Monthly Parking Rates (x4) (in ₹) y x1 x2 x3 x4 1 17700 75 1900 580 1000 2 17540 75 1890 620 1000 3 17620 75 1880 640 1200 4 16260 77 1878 650 1200 5 16180 77 1850 655 1200 6 16340 77 1840 658 1400 7 16580 77 1825 820 1500 8 16020 82 1825 860 1500 9 15940 82 1820 880 1500 10 15892 82 1805 920 1600 11 15780 85 1810 963 1600 12 14820 95 1800 1057 1600 13 14660 95 1795 1133 1700 14 14660 96 1795 1160 2000 15 14580 96 1790 1180 2100 16 14420 96 1730 1183 2100 17 13380 97 1740 1265 2100 18 10070 120 1735 1300 2200 19 13220 102 1730 1325 2500 20 13540 102 1720 1380 2600 21 13700 102 1715 1401 3000 22 12100 107 1705 1450 3100 23 11124 113 1690 1500 3300 24 10900 125 1695 1520 3500 25 11108 114 1690 1560 3500 26 13668 104 1700 1600 3800 27 13780 90 1710 1620 4000 28 12108 118 1790 1590 3700 29 14668 108 1800 1630 4000 30 14780 94 1810 1650 4200

Now determine the most appropriate regression model for the number of weekly commuters using stepwise approach at 5 % level of significance and interpret the results. Does the final regression model satisfy the linearity and normality assumptions?

4. A division of climatic change is interested in analysing the pattern of the CO2 concentrations in the air of a particular state in past years and then forecasting the CO2 concentrations for the upcoming years. The monthly mean CO2 concentrations ppm (parts per million) mixing ratio in dry air from January 2006 through December 2019 were recorded. The following monthly data are given in the following table for past 14 years:
 Year Month 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 January 299.16 299.62 300.60 301.67 303.71 305.00 306.77 308.32 309.90 310.41 312.87 313.88 315.04 316.33 February 299.94 300.40 301.60 302.17 304.23 305.63 307.26 309.41 310.70 311.68 313.59 314.62 315.70 316.82 March 300.41 300.87 302.57 303.86 305.54 306.93 309.10 310.69 311.70 312.04 314.11 316.23 316.38 318.29 April 301.72 302.18 303.72 305.07 306.79 307.95 309.88 311.51 312.65 314.27 316.07 316.62 318.38 319.91 May 302.13 302.92 303.68 305.82 306.95 308.05 310.47 312.02 313.28 314.92 316.38 317.53 318.93 319.41 June 301.09 302.43 303.17 305.12 307.00 308.27 310.31 311.54 312.42 314.40 315.78 316.87 318.26 318.74 July 300.10 300.85 301.96 303.81 305.37 306.64 308.41 309.88 311.02 313.16 313.96 315.00 316.44 316.92 August 298.14 299.01 299.80 301.56 303.47 304.68 306.74 307.75 308.97 311.11 311.71 312.86 314.55 315.03 September 296.36 297.51 297.98 300.30 301.46 302.77 305.07 306.05 306.84 309.11 309.86 311.55 313.21 313.69 October 296.29 297.41 297.57 300.22 301.29 303.09 305.07 306.13 307.00 309.15 310.13 311.57 312.67 313.15 November 297.23 298.25 299.20 301.37 302.76 304.29 306.22 307.45 308.20 310.38 311.84 313.11 314.09 314.57 December 298.55 299.97 300.58 302.49 303.80 305.76 307.38 308.85 309.63 312.02 313.32 314.49 315.27 315.75

a)  Compute the seasonal indices using ratio to moving average method.

b)  Obtain the deseasonalised values and then fit a linear trend line to the average annual CO2 concentrations using least squares method.

c)  Convert the annual least-squared trend equation to a monthly trend equation.

d)  Use the monthly trend equation and seasonal indices to forecast the CO2 concentrations for all twelve months of 2021.

e) Plot the original data, deseasonalised data and trend values.

Insert math as
$${}$$