The mean is the average that appears in a set of data. The median is the midway point above (below) where 50% of the values in the data occur.

Press "Enter" to complete the formula and the mean of your numbers will appear in the cell. Select cell B2. Enter the following formula, without quotes, into the cell: "=MEDIAN(A:A)".

Mean (average) wealth per adult: $302,783. Median wealth per adult: $151,825. The U.K. ranks 12th in terms of average wealth per adult, but it jumps up to sixth for median wealth per adult.