28 ms·
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
by mkl 2y ago
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 2y agoOne can enable the Power Pivot addin, add the data into a semantic model and define a DAX measure for the median on it.
- maxerickson 2y agoDo you think that graduate dentistry is a bachelor's?
- mkl 2y agoThe people who collected the data categorised it that way for some reason.
- maxerickson 2y agoDo 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.