UCLA Anderson Post MBA Job Placement and Salary

by Matthew Kuo on May 11, 2013

in MBA

To learn more about Excel, go to the organized listing of all my Excel tutorial posts or review the
 

UCLA Anderson Post MBA Job Placement1

The following aggregated salary data has been pulled for UCLA Anderson’s Class of 2012 from REIS, or the Recruiting and Employment Insights System.  REIS is basically a “salary transparency” service created by an Anderson alumni to empower MBA students during the offer negotiations process.  You can’t look up any one person’s individual salary, but you can look at consolidated views for your own school by industry, function, and company.  REIS used to be called SalaryView, and I assume they had to change the name for legal reasons (because the name REIS is much worse).

UCLA Anderson Post MBA Job Placement2

Looking at the data, you can see that there does appear to be some correlation between the amount of salary offered and how many students end up working for a particular specialization.  This would imply that students in our MBA program are generally recruiting for higher paying jobs.  Real Estate and Public Sector jobs are predictably at the bottom of the scale while Consulting and Technology positions offer the highest base salary.  One interesting data point is Entertainment & Media, which shows a relatively high base salary for given the stories about how difficult it is to recruit for this industry, but many different types of positions can be grouped in this category.

However, there are a number of issues with the data to consider before making any conclusions:

  • No Mandatory Reporting – It’s still a bit odd to me, but Anderson doesn’t really have a mandatory salary reporting rule, even though this metric plays a significant role in our overall rankings.  Therefore, some students haven’t reported their job placement and are therefore not present in this data set.  People with lower salaries tend to be less likely to report their job placement.
  • Recruiting Office Adjustments – Some of this data gets adjusted before it goes to the ranking publications to fix errors and probably fill in some of the aforementioned unreported data points.  I obviously don’t get any feedback on that process until I see it in the rankings.
  • Industry versus Functional Grouping – The grouping I’ve listed is titled “specialization” because it includes both industries and functions.  There’s no real consistent methodology on whether a job is grouped within its industry or its function; at the end of the day, it’s the student who decides how to categorize it.  Therefore, there can be some discrepancies within the group totals.
  • Other Grouping – The original data also included a group called “other” which I’ve excluded because the data was so varied.  This included people who started their own companies, receiving no salary, and a small handful of people with exceptionally high salaries.
  • Bonus Information – The salary information I pulled looked only at base salary and not bonus.  I tried to incorporate the bonus data, but it looked off.  In 2012, REIS was only recently getting off the ground and I believe they may have had some input errors during that year.  Without bonus data, investment bankers, who are grouped under finance, show a significantly lower compensation level than what they actually receive in total.
  • Accepted versus Received Offers – The current data set only tracks accepted offers, not all offers received.  While this has the possibility of skewing the data, it probably wouldn’t have a huge effect.  It’s likely that accepted offers correlate with received offers within any particular industry.
  • Supply versus Demand – For any specialization to have a high number of offers is driven by both student interest as well as recruiter interest.  Therefore, if recruiters only supply a few jobs within a category, the number of students ending up in that role will likely be very low as well.

I’ll run this analysis again for the Class of 2013 and hopefully the data will improve in that iteration.  One key thing missing from this data is how hard it was to get a particular job.  Essentially, the job offers as a percentage of the overall interest level.  While this will be impossible to calculate definitively, I may be able to find a good proxy.

{ 0 comments… add one now }

Leave a Comment

Previous post:

Next post:


Related pages


nested formula definitionexcel range lookupucla business school requirementsdelete duplicate rows in excel 2010excel column graphbell curve templatehow to create a checkmark in excelhow to check duplicate records in exceladd chart title excelexcel chart generatorif vlookup examplecheck excel for duplicatesrandom order generator excelexcel row headingsexcel ticksexcel formula to identify duplicateshow to make a bar graph in excel 2013100 stacked column charthow to add a horizontal line in excel graphhow to create bar graph in excel 2007how do you use vlookup in excel 2010how to write a nested if statement in exceldrag cell in excel not workingexcel replace columnexcel formula percentage formathow to vlookup in excel 2007 with exampleexcel tick markexcel countif formulastypes of referencing in excelms excel vlookupexcel sheet convert to pdf fileron debruinnested vlookup in excelhow to write a macro in exceltranspose formula excelcheck mark symbol in word 2010how to make a bar graph on excel 2010boutique it consulting firmscreate bell curve in exceltutorial excel vlookupnested if vbahlookup formula with examplehow to use iserror with vlookupmatch function excelvba find duplicatesgmat score for uclaexcel random password generatoruses of vlookupnested ifs in excelusing nested if in excelhow to build a bar graph in excelindexing formulasummary of the goal by eliyahu goldrattindex and match function in excelvlookup and match formulaexcel create random numberseliminate duplicates excelthe goal by eliyahu goldratt sparknotesucla accounts payablehow to make a stacked bar graph in excel 2010vlookup and hlookup in excel pdfexcellineexcel intersectionvlookup formula excelexcel symbol shortcutsadvanced excel array formulasvba code to open excel fileexcel vlookuptasks template exceldedupe in excelhow to insert tick in excelucla scedule of classeslookup vba excelhighlight duplicate cells in excelowa uclacumulative graph in excelucla store ackermanvlookup easy stepslokup
\n