Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started