Ten Business People Who Fly Frequently from Melbourne to Sydney $\quad$

Short Answer

Ten business people who fly frequently from Melbourne to Sydney were asked to rank four airlines in terms of the quality of service. The people assigned scores using a 5-point Likert scale where: 1 = bad, 2 = poor, 3 = average, 4 = good, and 5 = excellent. The results are shown below. $\quad$ $\quad$ $\quad$ $\quad$ $\quad$ $\quad$$\text { Airline }$
$\begin{array} { | c | c | c | c | c | } \hline \text { Person } & \text { A } & \text { B } & \text { C } & \text { D } \\\hline 1 & 5 & 5 & 2 & 1 \\\hline 2 & 3 & 3 & 4 & 2 \\\hline 3 & 2 & 3 & 4 & 3 \\\hline 4 & 1 & 1 & 4 & 3 \\\hline 5 & 4 & 1 & 5 & 3 \\\hline 6 & 2 & 3 & 4 & 2 \\\hline 7 & 1 & 3 & 5 & 2 \\\hline 8 & 3 & 3 & 5 & 1 \\\hline 9 & 1 & 3 & 5 & 2 \\\hline 10 & 2 & 4 & 3 & 1 \\\hline\end{array}$ Use Excel to find the exact p-value for this test.