Use Excel to construct a box plot of the data and compare its values for quartiles, median, outliers, and extreme outliers with your hand calculations. Make sure your boxplot axes are labeled. Use data labels to show the values of the quartiles, median, extent of whisker, and outliers, if any

 

Heat content Observation (btu/lb) 1 11,166 2 11,531 3 11,553 4 11,571 5 11,362 6 10,959 7 9,917 8 11,323 9 11,753 10 10,125 11 11,294 12 11,687 13 11,156 14 11,835 15 11,454 16 11,716 17 13,150 18 11,240 19 11,665 20 11,550 21 11,360 22 10,136 23 9,367 24 11,721 25 11,329 26 12,389 27 11,864 28 10,734 29 11,306 30 10,775 31 13,500 32 10,922 33 10,732 34 10,129 35 10,369