$1\mathrm{.}3$ Evaluate solutions and implications using appropriate tools and technology

A Dunking franchise in Corpus Christi, Texas is concern because it has low sales when compared with other shop in locations with similar characteristics. The manager conducts a survey on the customers complains that causes them not to return. The following list of complains is compiled.

$\backslash$table$[[,$Complain,Number of complains$],[$A$,$Lack of parking,$36],[$B$,$In shop wait is too long,$162],[$C$,$Drive thru wait is too long,$231],[$D$,$Order in drive thru problematic because employees misheard,$26],[$E$,$Table was not clean,$5],[$F$,$Dirty restroom,$16],[$G$,$Donut variety ordered by client was not available,$22],[$H$,$Coffee variety ordered by client was not available,$75],[$I$,$No table available,$15],[$J$,$Menu was confusing,$21]]$

Use a Pareto chart to identify the "vital few" complains causing customers not to return to this Dunking location Hint. Review Chapter $2.$ Use Excel creating a table with the data provided, order it and then use Insert$/$Charts$/$Recommended Charts to create a Bar chart with cumulative percentage$)$