[mkl]

Fair point. Excel's pivot tables can't easily do medians.

Edit: Actually, it's pretty similar with medians (via Python now).

The bottom 10 are: Drama/Theatre Arts and Stagecraft, Library and Archives Assisting, Movement and Mind-Body Therapies and Education, Dance, Alternative and Complementary Medicine and Medical Systems, Theological and Ministerial Studies, Film/Video and Photographic Arts, Personal and Culinary Services, Other, Music, Mason/Masonry

The top 10 are: Advanced/Graduate Dentistry and Oral Sciences, Nuclear Engineering Technologies/Technicians, Biomathematics, Bioinformatics, and Computational Biology, Operations Research, Personal Awareness and Self-Improvement, Naval Architecture and Marine Engineering, Marine Transportation, Systems Engineering, Mining and Mineral Engineering, Computer Engineering.

[RGamma]

One can enable the Power Pivot addin, add the data into a semantic model and define a DAX measure for the median on it.

[maxerickson]

Do you think that graduate dentistry is a bachelor's?

[mkl]

The people who collected the data categorised it that way for some reason.

[maxerickson]

Do you think they included that category in the analysis of bachelor's ROI, which is what you are doing, comparing it to their results for bachelor's.

Like sure, a professional degree in dentistry probably does have a better average return than a 4 year degree in engineering, but that isn't the comparison they made.