Statics process control

This assignment is to be submitted online via Canvas by the due date and time listed on the syllabus. You should submit two files online. One file should be an Excel workbook containing all relevant and completed Excel worksheet(s) (with relevant cells highlighted) associated with the assignment. The second file should be an appropriately formatted PDFdocument containing all the relevant answers to Questions 1A–1D, including charts associated with the assignment, and references to any highlighted cells in the Excel spreadsheet. All charts and the written assignment should be formatted to look professional. Points will be deducted for formatting related issues. In the following questions, whenever x-bar and r-charts are required, use the A₂, D₃, D₄ method of computing the control limits.