Question 2 Before every ight, the pilot must verify that the total weight of the load is less than the maximum allowable load for the aircraft. The Bombardier Dash 8 aircraft can carry 3? passengers, and a ight has fuel and baggage that allows for a total passenger load of 6200 lb. The pilot sees that the plane is full and all passengers are Adults. The aircra will be overloaded if the mean weight of the passengers is greater than 6200 lb :- 3? = 16?.6 lb. The population body weights for 152 adults is in an Excel le on Sakai Resources -Written assignments. a) [submit a screenshot of Excel.) Use Excel to calculate the population mean weights and standard deviation for 152 adults. Keep the results in whole numbers. b) [Submit a screenshot of Excel formula and answer.) Use Excel to calculate the probability that the aircraft is overloaded. :2) [Submit a screenshot of your written or typed answer.) Based on your result in part b}, should the pilot take any action to correct for an overloaded aircraft? Explain. d) {Submit a screenshot of Excel.) Aircraft overloading occur at a rate of 1 per 100 ights. Use Excel to calculate at least one overloading on a randomly selected 20 ights. e) [submit a screenshot of Excel.) 95% of people against overloading. Use Excel to calculate the probability of 4 or fewer people against overloading in a randomly selected sample of 30 people