Assignment $4-$ Process Control$30$ marksPART $1$:In a manufacturing process, you are to measure the thickness $($in inches$)$ of steel plates from a daily sample of $6$ plates from a production line for $20$ consecutive days. An X control chart and an R control chart are required as well as an analysis of the results and problem solving practices.Instructions:Open the Excel file 'Process Control Project $-$ Data', click on 'Enable Editing' and copy and paste the data into another Excel sheet or file. Create a table with column titles as we did in class. Create a formula in Excel to calculate the daily average $($X$)$ and Range $($R$),$ and to calculate X and R For both the X $-$chart and the R$-$chart, create formulas to calculate the UCL and the LCL $($ensure to use the correct control chart factors$)$Using a Scatter Plot with lines, create an X$-$chart and an R$-$chart, showing four lines $($series$)$ on each graph: data points, center line, UCL & LCL$.$ Provide a chart title and axis titles, also label each line in a legend. Analyze the chart and detect any non$-$acceptable data. Provide a fish$-$bone diagram that includes at least four possible causes. Also, include suggestions to solve the problems listed on the diagram. Type this information in a cell on the same sheet. The process should be out of control if not, contact me right away$).$ Open a new sheet and recalculateX, UCL & LCL by omitting any non$-$acceptable data. Also, regraph theX $-$ chart. From the new UCL and LCL$,$ calculate the desired population standard deviation o $($Refer to Lesson $4).$PART $2$: On the same spreadsheet, open a new sheet.Provide a detailed DMADV list to create a new product, service or process. Choose your own idea and be creative. Note: 'Safe Assign' will be used to ensure that your work is authentic and has not been plagiarised. Plagiarised assignments will result in an offence of Academic Integrity.Submit your Excel file in Blackboard.