Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

see the project it's only one page in Excel and one page in word explain how to do it plz follow the instructions Excel and

image text in transcribed

see the project it's only one page in Excel and one page in word explain how to do it plz follow the instructions Excel and world file explain how to do it in Excel XYZ Corporation assembles parts for a local manufacturing firm. They have 200 experienced workers on assembly line. These assemble parts where only 7% parts have a chance to be defective Recently the company received large orders and has to hire another 100 people. They decided to form two groups in the first group they placed 120 experienced workers 7% chance of defective parts who would do hal of the work 50% The second group further d vided into two subgroups First subgroup has 50 exper enced workers and 60 workers with some experience This subgroup can assemble parts where only 20% parts have a chance to be defective. This group is going to assemble 30% of the parts The second subgroup has only 30 experienced workers and 40 inexperienced workers This subgroup is going to assemble the remaining 20% of the parts that have a 30% chance to be defective. What is the probability that 7 out of 30 parts tested and found to be defective, are assembled by first group (all experienced workers) Please submit your spread sheet on Blackboard It may be required to present this in the class on the due date workers typically page in excel this is the project and other page in world to explain how u do the problem in excel see the project it's only one page in Excel and one page in word explain how to do it plz follow the instructions Excel and world file explain how to do it in Excel XYZ Corporation assembles parts for a local manufacturing firm. They have 200 experienced workers on assembly line. These assemble parts where only 7% parts have a chance to be defective Recently the company received large orders and has to hire another 100 people. They decided to form two groups in the first group they placed 120 experienced workers 7% chance of defective parts who would do hal of the work 50% The second group further d vided into two subgroups First subgroup has 50 exper enced workers and 60 workers with some experience This subgroup can assemble parts where only 20% parts have a chance to be defective. This group is going to assemble 30% of the parts The second subgroup has only 30 experienced workers and 40 inexperienced workers This subgroup is going to assemble the remaining 20% of the parts that have a 30% chance to be defective. What is the probability that 7 out of 30 parts tested and found to be defective, are assembled by first group (all experienced workers) Please submit your spread sheet on Blackboard It may be required to present this in the class on the due date workers typically page in excel this is the project and other page in world to explain how u do the problem in excel

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions