One factor in low productivitv is the amount of time wasted bv workers. In a project designed to estimate the problem, an operationsmanagement consultant took a survev of mo workers in companies that were classified as successful [on the basis of their latest annual prots} and another 100 workers from unsuccessful companies. The amount of time {in hours} wasted during a standard 40hour workweek was recorded for each worker. The data are in 611h3_data_20215u.ulsx. a. Use Excel's Data Analysis to get the printouts of the descriptive statistics of wasted time for successful and unsuccessful companies. in. Use the descriptive statistics from part o to estimate with 95% condence how much more time is wasted in unsuccessful firms than in successful ones. c. Based on the descriptive statistics from part o, do these data provide enough evidence at the 1% signicance level to infer that the amount of time wasted in unsuccessful firms exceeds that of successful ones? d. Use Excel's "It-Test: Two-Sample Assuming Equal Variances\" in Doto Anolysis to get the printout for testing if the amount of time wasted in unsuccessful rms exceeds that of successful ones. e. Use the printout from part d conduct the test in part c with the ovalue approach