Difference in the Median Performance

Dan Thompson, the president of CEO Airlines, recently noted an increase in the number of no-shows for flights out of Atlanta. He is particularly interested in determining whether there are a different number of no-shows for flights that originate from Atlanta compared with flights leaving Chicago. Below are the numbers of no-shows for scheduled flights:
Atlanta: 11, 15, 10, 18, 11, 20, 24, 22, 25
Chicago: 13, 14, 10, 8, 16, 9, 17, 21
Is there evidence of a difference in the medianperformance between the two methods? (Use ? = 0.05.)

You may use do by hand or use Excel, but make sure your hypothesis and testing steps are clear. Explain your results.

See the attached file.

First, the hypothesis is as follows:
H0: The population distribution of no-shows is the same or less for Atlanta and Chicago.
H1: The population distribution of no-shows is larger for Atlanta than for Chicago.

Then we rank the observations from both samples as if they were a single group.
Please note that the Chicago flight with only 8 …

The differences in the median performance are examined in the solution.