Task 3

The data in Sheet “Task 3 Data” of the Excel file “MBF Summative data.xls” relates to the weight (in grams) of a sample of 80 items produced by a machine.

You are required to:

a) Aggregate this data into a suitable frequency table using the COUNTIFS function and using an interval of 1.5

b) Plot a histogram of the data..

c) Calculate the statistics below for the given items:

i. Range

ii. The mean

iii. The median

iv. The mode

v. The standard deviation

d) The production manager is concerned that the machine is not working properly as the items of output vary in weight. The item should ideally weigh 25 grams and a variance of 3 grams of each side is acceptable. Comment briefly if the production manager is right to be concerned. Use the statistical data calculated in part ‘c’ above to support your answer.

Final-MBF-Summative-data-for-students