Use Excel to determine the values of the mean and median for the data in Table 2.


Use Excel to mention the values of the balance and median for the postulates in Table 2.7 (page 22), for the date required to adequate an nock job by a scantling of 30 employees. Based on the two values, what peel of skewers, if any, exists for this postulates division? In Problems 2.28 and 2.29, these postulates were grouped into quantity divisions by the use of Excel, after a while the associated output of histograms.Table 2.7Table 2.7 Nock Times for 30 Employees, min1014151317161291113151811141491517131112101216121116141415Wish to frame these postulates into five systematizees after a while similar systematize extents. Mention the useful interim extent. Problems 2.28Table 12.19, smitten from Problem 2.16, indicates the middle calculate of injuries per thousand worker hours in a scantling of 50 firms smitten from a detail diligence. The balance for this inconstant is and the scantling exemplar flexuosity is Test the null conjecture that the population precedent of frequencies is distributed as a recognized division, using the 5 percent roll of consciousness.