Instructions - Use MS Excel to build the control chart in problem 1 and then copy and paste the detailed of the calculations together with the chart into a Word document. Use your Word document to type your answers to the other questions and/or problem(s) and then print a copy for submission in class. Any document submitted by email will not be considered. - The deadline is Monday November 21172022 at 10 am. - Plagiarism and cheating (which includes sharing answers) are prohibited. Any student who cheats and/or plagiarizes will receive a grade of 0.00 for the assignment. Problem 1 The dean of the College of Business at State University wants to monitor the quality of the work performed by the college's secretarial staff. Each completed assignment is returned to the faculty with a check sheet on which the faculty member is asked to list the errors made on the assignment. The assistant dean has randomly collected the following set of observations from 20 three-day work periods: 1. Which control chart must be used in this case and why? 2. Construct the control chart you identified in question 1 using 3 limits and determine if the process was out of control at any point. 3. Using a pattern test, determine if any nonrandom pattem exists. Problem? Mag Tech assembles Blu-Ray players from four major components arranged as follows: The components can be purchased from three different vendors, who have supplied the following reliability data: 1. If Mag Tech has decided to use only one vendor to supply all four components, which vendor should be selected? 2. Would your decision change if all the components were assembled in series? 3. Examine the systems given below. Which system is more reliable, a or b? c or d? Now calculate the reliability of each system. Were your perceptions correct? If it costs $1000 for each 90% reliable component, $1500 for each 93% component, $2000 for each 95% reliable component, and $10,000 to replace a failed system, which system would you choose, a or b? c or d ? Instructions - Use MS Excel to build the control chart in problem 1 and then copy and paste the detailed of the calculations together with the chart into a Word document. Use your Word document to type your answers to the other questions and/or problem(s) and then print a copy for submission in class. Any document submitted by email will not be considered. - The deadline is Monday November 21172022 at 10 am. - Plagiarism and cheating (which includes sharing answers) are prohibited. Any student who cheats and/or plagiarizes will receive a grade of 0.00 for the assignment. Problem 1 The dean of the College of Business at State University wants to monitor the quality of the work performed by the college's secretarial staff. Each completed assignment is returned to the faculty with a check sheet on which the faculty member is asked to list the errors made on the assignment. The assistant dean has randomly collected the following set of observations from 20 three-day work periods: 1. Which control chart must be used in this case and why? 2. Construct the control chart you identified in question 1 using 3 limits and determine if the process was out of control at any point. 3. Using a pattern test, determine if any nonrandom pattem exists. Problem? Mag Tech assembles Blu-Ray players from four major components arranged as follows: The components can be purchased from three different vendors, who have supplied the following reliability data: 1. If Mag Tech has decided to use only one vendor to supply all four components, which vendor should be selected? 2. Would your decision change if all the components were assembled in series? 3. Examine the systems given below. Which system is more reliable, a or b? c or d? Now calculate the reliability of each system. Were your perceptions correct? If it costs $1000 for each 90% reliable component, $1500 for each 93% component, $2000 for each 95% reliable component, and $10,000 to replace a failed system, which system would you choose, a or b? c or d