$8.($USE EXCEL$)$ Customers call a call center to make room reservations for a small chain of $42$ motels located throughout the southwestern part of the United States. Business analytics is used to determine how and if the following performance metrics are related: time by month, average time on hold $($seconds$)$ before a customer reaches a company customer service representative, percent of time the customer inquiry is solved the first time $($called first pass quality$)$ and customer satisfaction with the overall call center experience.

Month Average Hold Time $($Seconds$)$ Percent Solved First Time Overall Customer Satisfaction Percent

$12085\%92\%$

$23276\%88\%$

$34274\%78\%$

$56581\%80\%$

$63683\%86\%$

$76872\%76\%$

$88463\%70\%$

Answer the following:

a$)$ Illustrate the interlinking relationships by constructing scatter charts of the relationships between all pairs of variables. $(15$ Points$)$

b$)$ What do these charts tell you? $(5$ Points$)$