Before every flight, the pilot must verify that the total weight of the load is less than the maximum allowable load for

[answerhappygod]

Before every flight, 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 37 passengers, and a flight 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 aircraft will be overloaded if the mean weight of the passengers is greater than 167.6 lb( 6200 / 37 = 167.6 lb). The population body weights for 152 adults are in an Excel file on Sakai – Resources -Written assignments.
a) Use Excel to calculate the population mean weights and standard deviation(stdev.p) for 152 adults. Keep the results in whole number. Submit a screenshot of Excel formula and answer.
b) Use Excel to calculate the probability that the aircraft is overloaded – P( x > 167.6). Submit a screenshot of Excel formula and answer.
c) Based on your result in part b), should the pilot take any action to correct for an overloaded aircraft? Explain.