MSTL-002 Assignment Solution 2021

MSTL-002 Solved Assignment 2021 

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-03 Download Abstract Classes assignment login app.

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. 

MSTL-002 Solved Assignment 2021 

INSTRUCTIONS TO BUYERS

• Users are requested to respect the copyright of the author.
• The document is in read-only format. You will have no access to print, download and share this document. You can only view this solution in Mobile and tablets easily.
• 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 Sample Solution

MSTL-002 Assignment Question Paper 

MSTL-002: Industrial Statistics Lab                          Download Question Paper 

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.

Q 1      The marketing manager of a transportation network company offering taxi services in a metro city wanted to study the waiting times of customers to get a taxi during the peak hours. A subgroup of 15 customers was selected (one at each ten minutes interval during the hour) and the time in minutes was measured from the point each customer booked the taxi to when he or she began the trip. The results of 40 days period were as under.

The manager of this company needs to construct the suitable control charts for variability as well as average to infer whether the waiting times of customers for getting a taxi is under control or not. If it is out-of-control, also construct the revised control charts.

Q 2      A publisher recorded the total number of pages in 25 published books and also the number of typing errors that have been made in preparing the final print of the books.

The results are given in the following table:

The publisher needs to set up a suitable control chart for the number of errors to check whether the number of errors in a state of control or not. Also computes the revised

             control limits, if necessary.                                                                                                

Q 3  A researcher is interested to check the relationship between the salaries of workers involved in the production process of a company. To accomplish this, she/he has decided to develop a multiple regression model to predict their weekly salaries. For this purpose, he/she has selected a random sample of 50 workers involved in the production process. The information on their current monthly salaries in hundreds (Y), lengths of employment in months (X₁), and job classifications (X₂; 0 for technical job and 1 for clerical job) are summarised in the following table:

1. i) Prepare a scatter plot to get an idea about the relationship among the variables. ii) Fit a linear regression model and its related analysis at 1% level of significance. iii) Does the fitted regression model satisfy the linearity and normality assumptions? 
2. iv)Also, draw both fitted regression lines on the scatter plot.              

Q 4      The marketing manager of a transportation network company offering taxi services in a metro city wishes to improve customer service and taxi scheduling based on the daily levels of customers in the past 10 weeks. The numbers of customers during that period are given below:

1. Determine the seasonal indices for the given data using a 7-day moving averages.
2. Obtain the deseasonalised values.

• Fit the appropriate trend for the deseasonalised data using the least-squares method by matrix approach that best describes the data.

1. Project the number of customers on Wednesday of the 52^th
2. Plot the original data, the de-seasonalised data, and the trend values.

Download Question Paper