PLEASE SHOW THE WORK IN AN EXCEL SHEET

You are in charge of quality control for Laptops at Dell. You have data on twenty$-$five batches of Laptops, tracking five types of Laptop defects: Screen, Motherboard, Camera, Touchpad, and Keyboard. These data are given in the table below.

For each defect type, find the average number of defects per batch. So$,$ you should have an average defect rate for displays, another for color, and so on$.(2$pts$)$

For each batch, find the total number of defects $($the sum of all five types$).$ So$,$ you should have one number for batch $1,$ another for batch $2,$ and so on$.(2$pts$)$

Sort the five columns of defects by descending average defect rate. The lowest rate should be on the right. $(4$pts$)$

Sort the batches by descending total defects. The batch with the highest total should be at the top. This will not affect the column sorting from the part $3$ above. $(4$pts$)$

Create a Pareto chart showing the average defect rate for each of the five defect types. This will be a column chart, in descending left$-$to$-$right order, with each column and the axes labeled. $(8$pts$)$

$\backslash$table$[[,,,$fects,,$],[$Batch$,$Screen,Motherboard,Camera,Touchpad,Keyboard$],[1,5,3,3,1,3],[2,2,4,1,1,2],[3,3,2,2,2,6],[4,3,2,1,3,1],[5,2,3,2,3,2],[6,1,4,3,1,1],[7,4,3,2,4,4],[8,2,1,1,1,2],[9,1,2,1,2,1],[10,2,1,3,2,1],[11,4,2,1,1,2],[12,3,4,3,2,3],[13,1,1,4,1,2],[14,4,1,1,2,2],[15,2,3,2,2,2],[16,3,1,1,3,2],[17,1,1,1,1,2],[18,3,2,2,2,3],[19,2,3,4,1,1],[20,2,1,2,1,2],[21,1,2,1,2,3],[22,2,1,1,1,4],[23,2,4,3,2,3],[24,1,1,2,1,3],[25,3,2,2,2,5]]$