NOTE:

$1.$ Only Word file or Pdf file will be graded and. Any comment in your output file will be ignored.

$2.$ Word file and Excel files must be embedded in a Zip. Folder to be submitted via Canvas. One Excel sheet for each problem. Name your Zip. Folder and your answer sheets file $($Name$,$ Exam $3,$ ISQA $8206$ or $4200).$

$3.$ Save the sampled data $($for analysis$)$ in a different sheet $($name it sampled data$)$ and keep the original data in case.

$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$1.$ First by using the Rand function in the Excel file $($named Prato$)$ pick a number for each type of error. The first row might be id $8$ or $4$ or $,,,,,$ is the data you want for each type of error. Do the Rand function only once.

a$.$ Do Pareto diagram for Table $1.$ Use table $2$ to show your calculation.

Table $1$