\"The Pavement Research group is investigating the durability of brick pavers subject to high volume pedestrian traffic. Under experimental conditions. holes are gouged in fixed pavers subject to the vibrating head of a tip-hardened nail punch. The volume of the hole (as assessed by the liquid displacement) is a measure of the durability of the pavers. In a test of the durability of brick paversg 20 pavers made from two types of brick (Control type and Experimental type) gave the following liquid displacement (ml): n Contnu Experhnental 1 380 361 2 321 448 3 366 402 4 356 376 5 285 435 6 349 406 7 402 392 8 468 426 5 356 406 10 410 318 1D) Using Excel to determine the sample mean, median, mode, standard deviation, variance, Kurtosis and skewness for each of the Control and Experimental data: Data > Data Analysis > Descriptive Statistics > Summary statistics Hint: You may refer to Chapter 3 Lecture slides #33 & slide #34 for Excel instructions. (1 mark) 1E) Comment on the distributions of the two datasets, in terms of central tendency, variation and shapes of the distribution. (0.5 marks)11 ".2 13 14 ".5 16 17 ".8 ".9 20 320 398 365 384 315 274 345 456 360 432 468 409 42? 430 478 392 430 339 410 326 1A) Use Excel to order the Control and Experimental datasets from the smallest value to the largest value, respectively. Present the ordered data in the report and then calculate Q1, Q2, and Q3 and present your calculations for the 5- number summary in the report for both data groups. Hmt: Yon may refer to Chapter 3 Lecture Sttn'es #36 - #38for the calentnttons ( 1 mark) 18) Using Excel to produce the box 8: Whisker plots for the Control and Experimental data groups, respectively. (0.5 marks] 1C) Discuss the presence of outliers in these data sets and provide the reason to justify your answer. (1 mark) 1D) Using Excel to determine the sample mean, median, mode, standard deviation, variance, Kurtosis and skewness for each of the Control and Experimental data