Instruction for Week&nbsp8&nbspHomeworkThere are two deliverables

Instruction for Week 8 HomeworkThere are two deliverables for this week’s homework.1. An Excel file with the Design of Experiment (DOE) analysis.2. A Microsoft Word file contains the write-up of the analysis and answers to the questions.The DOE Analysis• To help you do the DOE analysis, you have been provided with an Excel file “MAT510 Homework Assignment 7_calculation template v1”. Use this template to complete the analysis.  This template uses the algorithm from page 297 of your textbook.• We will have a Live Help session to explain how to use the template. Please go to Instructor Insights to register.• This Excel file accounts for 20 points of your homework grade.The Write-up• The write-up should include the DOE analysis and answers to the questions. • The write-up must be in Microsoft Word.• You are provided with a reference answer.• The write-up accounts for 10 points of your homework grade.   MAT 510 – Homework Assignment  Homework Assignment 7 Due in Week 8 and worth 30 points The experiment data in below table was to evaluate the effects of three variables on invoice errors for a company. Invoice errors had been a major contributor to lengthening the time that customers took to pay their invoices and increasing the accounts receivables for a major chemical company. It was conjectured that the errors might be due to the size of the customer (larger customers have more complex orders), the customer location (foreign orders are more complicated), and the type of product. A subset of the data is summarized in the following Table.  Table: Invoice Experiment ErrorCustomer SizeCustomer LocationProduct TypeNumber of Errors—15+–18-+-6++-2–+19+-+23-++16+++21Customer Size: Small (-), Large (+)Customer Location: Foreign (-), Domestic (+)Product Type: Commodity (-), Specialty (=) Reference: Moen, Nolan, and Provost (R. D. Moen, T. W. Nolan and L. P. Provost. Improving Quality through Planned Experimentation. New York: McGraw-Hill, 1991) Use the date in table above and answer the following questions in the space provided below:1. What is the nature of the effects of the factors studied in this experiment? 2. What strategy would you use to reduce invoice errors, given the results of this experiment?  Type your answers below and submit this file in Week 8 of the online course shell: