Question: 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

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 (2 marks) b) Plot a histogram of the data.. (6 marks) c) Calculate the statistics below for the given items: i. Range ii. The mean iii. The median iv. The mode v. The standard deviation (5 marks) 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. (4 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Question 3 A survey was carried out to find out the highest qualification held by men and women, aged 16 - 75, in the UK. Below are the results. Male Female Total No qualifications 55 48 103 Level 1...

London School of Science & Technology Qualification Unit number and title BTEC Level 5 HND Diploma Business UNIT 6: Business Decision Making Student name and ID number Assessor name Al Hassan Barrie...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

I have attached the case study and the rubric for this. can I get help here to organzie an answer? CATERPILLAR, INC: THE IMPACT OF DECISION BIASES AND RISK ON CAPITAL BUDGETING Timothy D. West...

I have a Project I am working on for Portfolio Management. I finished most of the data entry and creating of tabs, but I still have about 30% of the project that I need help on. I expect it to take...

ALL DATA RELATES TO THE PERIOD UNDER CONSIDERATION IN THIS REVIEW, AND ACTUAL AND STANDARD COSTS PER UNIT ARE UNCHANGED FROM THE PREVIOUS PERIOD AYB225 ASSIGNMENT SEMESTER 1 2015 ALL DATA RELATES TO...

Case 2: The Nickel Experiment The Thomas Jefferson Nickel was first produced in 1938. The United States Mint produces all U.S. coins at their Philadelphia, Pennsylvania, and Denver, Colorado,...

Math 533. Question 1: A national standard requires that public bridge over 200 feet in length must be inspected and rated every 2 years. The rating scale ranges from 0 (poorest rating to 0 (highest...

i just need an abswer to task 4. Task I: Based on the information in the case study, develop a Project Charter for this project. Please use the template shown in the MKT 4333 Project Data.xls Excel...

Need help with Management Accounting assignment (need excel part completed)!!! AYB225 ASSIGNMENT SEMESTER 1 2015 ALL DATA RELATES TO THE PERIOD UNDER CONSIDERATION IN THIS REVIEW, AND ACTUAL AND...

The intensity of the triangular load carried by the T-section varies from zero at the free end to wo at the support. Find the maximum safe value of wo given that the working stresses are 4000 psi in...

A train travels 101.2 kmE, then 225.9 kmW, and finally 144.2 km E. The train takes 23.11 hours to make the entire trip. What is the train's average velocity?

Income Statement Income Gross sales 5750000 Sales returns and allowances 200000 Net sales 5550000 Cost of goods sold 2300000 Gross profit 3250000 Dividends received from stock investments in...

The case of Ahmad the liver maker Julia and John JJ are going to give a dinner party on Friday evening at 07.00pm. Their two children, Jimmy and Jessy, are going to help them get ready. The JJs will...

10. Imagine that the goal has been reached. Now think about the path you have to take to reach the goal. How did you influence other people to achieve your goal? Imagine walking along the path you...

2. How do I perform this role?

6. List one and only one societal role that you wish you had performed better in. Spend the next month on a small push to improve your personal performance within this role. At the end of the month,...