Please help these all the questions. i havI added everything already.
XYZ manufacturing plant manufactures various metallic screws, nuts, plates and other industrial goods defects. There are 300 employees and 25% are relatively new. Training is imparted once in 2 years. On observing one product- metallic Hexagonal nuts of various sizes like 3/8, 3/4, 9/16 etc., they analyzed the Product's quality statistics for three weeks and gathered some data that shows the following. The data shows the following defects during the run of production for 3 weeks. Some defects were seen and measured like some were not properly polished, not properly shaped, not proper winding spirals, perforations in the screws, cracks, not finished well etc. The data is given in the table below. Kate, an excellent CEO wants to improve on the quality of this product. As Kate's Operations Manager, help Kate draw up conclusions to rectify the defects. The Rubric is posted below. ALL are to be done only on the same Excel file- one sheet or multiple sheets, through the following processing order of Answers 1 to 5: 1.Draw a Pareto Chart and identify the most priority defects to address beneath the graph. Why do you say so?. 5 marks 2.Plot a Line chart for the top 2 defects from your pareto chart and analyze beneath the chart. 4 marks 3. Create/Draw an Ishikawa Diagram, Identify areas that can help rectify quality 4 marks 4.Based on all the above, identify and list out 5 measures in point form that you would advise Mike to adopt to increase quality. 5 marks Kate wants to emulate the Japanese concept of TQM. Help suggest ideas to Kate on how and where to apply TQM (Do not write what TQM is) 4 marks ]]

Days
1 to 21		Not polished	improper shape	Cracks	Improper winding spirals	not finished	Perforations	improper thickness
1		17		13	15	10	4	5
2		10	5	5	13	3	3	6
3		18	4	3	10	1	13	4
4			3	4	11	4	4	6
5		14	5		12	3	1	3
6		4	4	4	2	11	4
7		56	8	7	23	2	4	3
8		10	2	6	2	3	5
9		28		10		4	6	2
10		10	4	6	14	6
11		15	7	5	6	7	7	4
12		2	3	6	7	3	11	3
13		4	5	4	13	4	2	2
14		16	2	5	6	3	4	2
15		16	2	1	3	3		5
16		23	3	5	5	5	3	5
17		11	7	3	4	4	4	3
18				5	5	4	3	2
19		15	5	5	2	4	3	3
20		14	3	3	3	4	2
21		15	4	2	3	3	3	2

FOLLoW httpa//www.senecacollece.ca/about/policies/academiolntegrity-policy. bhucri equaly statiatics for there weeks and gathered some data dial shows tor fobowery. The tra sows ticeis, tueght the fitewing procening ander of Anwers I to 5 . 1) Draw a Pareto Chart and identify the most poionty defects to address benesth the graph. Why do you say ao?, 5 marla 2) Plot a Uie chart lor the top 2 delects from your pareto thart and analyce beneath the chart. 4 marki. 3) Create/Draw an lshilawa Diagram, Identify areas that cen help rectify quality a mark 4) Based on all the above, ldentify and fiat out 5 measure in point form that you would adviie Mike to adopt to increase quality. 5 marka 5) Kate wants to emulate the dapanese concept of TQM. Help sugeest ideas to Kate on how and where to apply TQM (Do not write what roM ia) A maris Before aubmisalon, please ensure your Excal file is named correctly as OpM40o Az (your last, first name) and has anawers to all the 4 queationa. Pleate use geogle chrome or Firefos as reur browar so the attechment goes through wall, Please check your attachment after the submisilan. Based on all the above, Identify and list out 5 measures in point form that you would advise Mike to adopt to increase quality. 5 marks Kate wants to emulate the Japanese concept of TQM. Help suggest ideas to Kate on how and where to apply TQM (Do not write what TQM is) 4 marks Belore submision, please ensure your Excel file is named correctly as OPM400 A 2 (your last, firat name) and has answers to all the 4 questions. Please use google chrome or Firefox as your browser so the attachment goes through well. Please check your attachment after the submission. To submits use Goosle chrome or Fireloxy go to Assignments Exams and Testa 3 Assignment 2> attach your document and submit. Ensure that the document is subm FOLLoW httpa//www.senecacollece.ca/about/policies/academiolntegrity-policy. bhucri equaly statiatics for there weeks and gathered some data dial shows tor fobowery. The tra sows ticeis, tueght the fitewing procening ander of Anwers I to 5 . 1) Draw a Pareto Chart and identify the most poionty defects to address benesth the graph. Why do you say ao?, 5 marla 2) Plot a Uie chart lor the top 2 delects from your pareto thart and analyce beneath the chart. 4 marki. 3) Create/Draw an lshilawa Diagram, Identify areas that cen help rectify quality a mark 4) Based on all the above, ldentify and fiat out 5 measure in point form that you would adviie Mike to adopt to increase quality. 5 marka 5) Kate wants to emulate the dapanese concept of TQM. Help sugeest ideas to Kate on how and where to apply TQM (Do not write what roM ia) A maris Before aubmisalon, please ensure your Excal file is named correctly as OpM40o Az (your last, first name) and has anawers to all the 4 queationa. Pleate use geogle chrome or Firefos as reur browar so the attechment goes through wall, Please check your attachment after the submisilan. Based on all the above, Identify and list out 5 measures in point form that you would advise Mike to adopt to increase quality. 5 marks Kate wants to emulate the Japanese concept of TQM. Help suggest ideas to Kate on how and where to apply TQM (Do not write what TQM is) 4 marks Belore submision, please ensure your Excel file is named correctly as OPM400 A 2 (your last, firat name) and has answers to all the 4 questions. Please use google chrome or Firefox as your browser so the attachment goes through well. Please check your attachment after the submission. To submits use Goosle chrome or Fireloxy go to Assignments Exams and Testa 3 Assignment 2> attach your document and submit. Ensure that the document is subm