MSTL-001 Assignment Solution 2021

MSTL-001 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-001 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-001 Assignment Sample Solution

MSTL-001 Assignment Question Paper 

MSTL-001: Basic Statistics Lab                          Download Question Paper 

MSTL-001: Basic 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.

Q 1)  A mobile manufacturing company distributed a newly launched mobile to 100 retail stores. These stores also sell another famous brand of mobile having same features. The manager of the company wants to compare the popularity of the newly launched mobile (say, Brand A) with the other popular mobile (say, Brand B). For this purpose, she selects a sample of 100 stores and noted the total number of sold mobiles of each brand. The data are recorded in the following table: 

Answer the following:

1. Which mobile brand has more average sales?
2. Which mobile brand shows greater variability in the sales?

• Compute the skewness and kurtosis for the given data and interpret the results.

1. Determine the correlation between both mobiles.
2. v) Compute suitable width of the class intervals for both brands,
3. vi) Construct the continuous frequency distribution for both brands.

vii) Represent the raw data as well as grouped data using suitable diagram/graph. 

Q 2 (i) Twenty operators are working in a particular department of a call centre. The longserving operators feel that they should have a promotion based on length of service built into their job structure. For assessment of their efficiency, the personnel department produces a score of efficiency based on various parameters. The efficiency scores along with their length of service are given below:

Compute the Spearman’s rank correlation coefficient between the length of service and efficiency scores? Also compare this coefficient with Pearson’s correlation coefficient.

(ii)       A scientist wants to check the yield of wheat from different varieties of wheat. In this regards, the yields of wheat from 16 plots, all of approximately equal fertility, when 4 varieties of wheat (Say, A, B, C and D) were cultivated are recorded in the following table: 

Assuming that the yields of wheat are normally distributed in each variety with approximately equal variances, test the hypothesis that the average yields of wheat in all four varieties of wheat are the same at 1% level of significance. 

Q 3      For the data given in Question 1, the manager also wishes to compare both brands to get the answers of the following questions:  

1. Is there enough evidence that the average sales of mobile of Brand A is more than the average sales of the Brand B at 5 % level of significance?
2. Are the variances of the distributions of mobiles of Brand A and Brand B equal at 5 % level of significance?

Q 4      Suppose that a customer service manager of a mall wants to evaluate the service of the eight food counters in the mall. She/he hires seven evaluators with varied experience in food-service evaluation to act as raters. To reduce the effect of the variability from rater to rater, a randomised block design is applied considering raters serving as the blocks. The seven raters evaluate the service of each of the eight food counters in a random

order. A rating scale from 0 (low) to 100 (high) is used. The following table summarises the results: 

The effect of evaluation of each rater on the service of food counters is normally distributed with approximately equal variances. 

1. Analyse the design at 2% level of significance.
2. Is the average service of the eight food counters significantly different? If the difference between the averages services of the eight restaurants is significant, do the pair-wise comparison between them.

Download Question Paper