Spreadsheet

Tri$-$State Bank is investigating the processing time for loan applications. Samples were taken for $25$ random days from four branches. These data can be found in the table below.

$\backslash$table$[[$Day$,1,2,3,4,5,6,7,8,9,10,11,12,13],[$Branch $1,18,11,27,21,15,27,17,10,21,24,16,24,10],[$Branch $2,12,18,21,18,15,9,18,25,18,8,10,26,16],[$Branch $3,23,24,24,33,24,27,25,39,29,22,26,26,21],[$Branch $4,21,12,9,7,12,12,10,23,19,7,21,22,20]]$

$\backslash$table$[[$Day$,14,15,16,17,18,19,20,21,22,23,24,25],[$Branch $1,12,9,26,21,7,7,30,26,14,21,23,10],[$Branch $2,24,10,13,12,21,14,24,12,12,13,25,15],[$Branch $3,27,32,16,17,29,23,31,12,31,20,37,44],[$Branch $4,11,21,24,21,8,9,14,22,20,20,21,6]]$

What is the overall mean? Do not round intermediate calculations. Round your answer to three decimal places.

What is the average range? Do not round intermediate calculations. Round your answer to three decimal places. For the $\stackrel{}{x}-$chart:

$LC{L}_{\frac{?}{\text{b}\text{a}\text{r}}(5)}$ :

$UC{l}_{}$ :

For the $R-$chart:

$LC{L}_R$ :

UCL $L_R$ :

Choose the correct graph for the $\stackrel{}{x}-$chart.

The correct graph is