I've been playing the last couple of days with UGA salary data (see here and here). In this analysis I look at the salaries by category. For example, the 2014 data lists 18 deans. The salary ranges from $55,643 to $360,395. That low salary is probably someone who was here only part of a year. We spent just over $4 million in dean salaries last year.
Oh, but how about vice presidents, you ask? I show 12 vice presidents, which is probably about 10 too many, with a salary range from $14,187 to $318,600. Again, assume that small number is someone here for only a month or so. So how much in total did UGA spend on vice presidents? Just over $2.3 million.
Department heads? My data says there are 115 of them, ranging in salary from $21,444 to $377,585. As you'd expect, with so many, the total spent was steep, almost $18 million. But don't forget directors, which are kinda like deans and department heads. There are 210 of them in this data ranging in salary from $10,448 to $264,388 at a total cost of over $21 million.
At UGA we also have a lot of deanlets. You know, those associate and assistant deans. How many is hard to say because they go by different titles, but best I can tell there are at least 48 of them with sslaries ranging from $51,667 to $315,909 at a total cost to UGA of over $7 million.
So what do we have the most of? According to the salary data, that would be "student assistant" (5,536 of them), followed by "graduate assistant" (3,434 of them). Those student assistants rack up a cost of over $13 million and those grad students, $55 million. Wow. I would not have guessed that. Then again, if you multiply even crappy pay by the thousands, the dollars add up.
Weirdest Data
* The minimum salary of a "service/maintenance worker" is $8. Sometimes the data get messy. That may be a per hour pay slipping into the annual pay column. It's hard to say. "Laboratory assistant" is similar, ranging from $17 to $39,520.
* There are only eight jobs listed in which only one person holds it. Obviously president, but a few others including "interior design professional."
* UGA has three "dental professional" folks. No idea where. We also have four "dental technical/paraprofessional." Without looking them up, I'd guess either in Pharmacy or Vet or Public Health.
* The data list 45 as "police officer" with a total salary of just over $1.3 million, ranging from $160 to $46,228.
* All in all, the data list 24,524 different employees or former employees with a total salary of $657,129,237. Wow, $657 million. There were 118 different job categories. What's interesting is the salary data job titles do not match the official UGA job titles, which is much longer, more finely tuned. The salary data lumps a lot of people together.
Wednesday, February 11, 2015
Travel at UGA
An interesting aspect to the 2014 UGA salary data is a column of data on how much was spent on travel by each employee. So who gets the most travel money? The results make sense. I'm going to save myself some time here and not name names, but I did look the top five up to make sure of who they are.
1. A College of Ag and Environmental Science professor, $48.989.84 in travel. No surprise there. Probably grant-funded travel.
2. A research assistant/technician, $40,161.30 in travel. Best I can tell, this person is part of a big grant and the job is to collect data. Get this -- the salary for this person is almost half of the travel money received ($26,720).
3. Another professor, this one in physics, at $37,416.26. Maybe the person travels to other planets.
4. A head of a major place on campus (how's that for vague), and the travel in this case makes perfectly good sense, $36,335.01. If I named the place, it could only be one person.
5. A "public service professional" who received $36,097.31 in travel money. Huh? It makes sense if you look at it, a person who focuses on outreach and training off campus nearly most of the year.
The lowest travel money? Someone had $3.28 in travel. A few people had five bucks. A grad assistant had $9.93.A sandwich, maybe?
And in case you're wondering, there's a pretty good correlation between how much you make (salary) and how much travel money ya get. For you statistically minded out there, it's r = .46. That's a pretty good correlation (1.0 or -1.0 would be perfect, 0.0 would be no relationship).
Yeah yeah, but what was the total of all travel money? Glad you asked. Excel tells me, and this can't be right, more than 15 million bucks was spent on travel last year. Weird. That's gotta be wrong. I've tried the formula two different ways and I get the same unbelievable number. In fairness we're talking 6,842 different people at UGA who received at least some travel money (a whole bunch are zero). If you take all the people who got at least some travel money, the average for 2014 is $2,291.51. I find this amusing, by the way. We're lucky at Grady to scare up $1,000 a year in travel money to present research, etc. Well, some get a lot more. Squeaky wheels, mostly. That's a whole different post.
And yes, I have the names for everyone. I'm just in a rare nice mood. If you really want the names, lemme know. I do also plan on updating this with a deeper dive into the data. Just trying to get ready for class at the same time.
Update
What titles have the average highest travel money? No surprises here, really. It's all about the suits, all about the admins. Money truly does trickle downhill.
1. Deans ($12,090)
2. Vice Presidents ($10,189)
3. Department Heads ($6,216)
4. Assoc/Assist. Deans ($5,863)
5. Directors of Units ($5,037)
6. Alumni Relations ($5,010)
7. Assoc/Asst Dept. Head ($4,465)
8. Assoc/Asst Director ($3,937)
9. Assoc/Asst Provost ($3,616)
10. Professor (finally, dammit, $3,461)
Oh, and I love #22, categorized as "former employee" at an average of $2,257, about double what I get as a current employee in travel money.
1. A College of Ag and Environmental Science professor, $48.989.84 in travel. No surprise there. Probably grant-funded travel.
2. A research assistant/technician, $40,161.30 in travel. Best I can tell, this person is part of a big grant and the job is to collect data. Get this -- the salary for this person is almost half of the travel money received ($26,720).
3. Another professor, this one in physics, at $37,416.26. Maybe the person travels to other planets.
4. A head of a major place on campus (how's that for vague), and the travel in this case makes perfectly good sense, $36,335.01. If I named the place, it could only be one person.
5. A "public service professional" who received $36,097.31 in travel money. Huh? It makes sense if you look at it, a person who focuses on outreach and training off campus nearly most of the year.
The lowest travel money? Someone had $3.28 in travel. A few people had five bucks. A grad assistant had $9.93.A sandwich, maybe?
And in case you're wondering, there's a pretty good correlation between how much you make (salary) and how much travel money ya get. For you statistically minded out there, it's r = .46. That's a pretty good correlation (1.0 or -1.0 would be perfect, 0.0 would be no relationship).
Yeah yeah, but what was the total of all travel money? Glad you asked. Excel tells me, and this can't be right, more than 15 million bucks was spent on travel last year. Weird. That's gotta be wrong. I've tried the formula two different ways and I get the same unbelievable number. In fairness we're talking 6,842 different people at UGA who received at least some travel money (a whole bunch are zero). If you take all the people who got at least some travel money, the average for 2014 is $2,291.51. I find this amusing, by the way. We're lucky at Grady to scare up $1,000 a year in travel money to present research, etc. Well, some get a lot more. Squeaky wheels, mostly. That's a whole different post.
And yes, I have the names for everyone. I'm just in a rare nice mood. If you really want the names, lemme know. I do also plan on updating this with a deeper dive into the data. Just trying to get ready for class at the same time.
Update
What titles have the average highest travel money? No surprises here, really. It's all about the suits, all about the admins. Money truly does trickle downhill.
1. Deans ($12,090)
2. Vice Presidents ($10,189)
3. Department Heads ($6,216)
4. Assoc/Assist. Deans ($5,863)
5. Directors of Units ($5,037)
6. Alumni Relations ($5,010)
7. Assoc/Asst Dept. Head ($4,465)
8. Assoc/Asst Director ($3,937)
9. Assoc/Asst Provost ($3,616)
10. Professor (finally, dammit, $3,461)
Oh, and I love #22, categorized as "former employee" at an average of $2,257, about double what I get as a current employee in travel money.
Tuesday, February 10, 2015
Salaries at UGA
I always find salaries good for potential stories, and just plain fun to mess around with. There's this pdf that includes all of UGA's (where I teach) codes for various jobs and the minimum and maximum salaries. Me being me, I turned this into an Excel spreadsheet and started playing. A first blush:
Highest "Minimum" Salary
This is $91,800 for something called "senior licensing manager II." The maximum this person can make is $207,000. What a burden. Next is "senior associate CIO and tech officer" at $85,000.This unlucky person's maximum is $195,500.
Lowest "Minimum" Salary
This is tougher to do. there are several at $15,138 annually (county secretary, camp counselor, laboratory helper, etc.). Oddly, this also includes "mental health professional" and "TV account executive." Weird.
Mind the Gap
Looking at the gap between the lowest or minimum salary versus the ""annual entry maximum" is simply seeing how low a salary you could have against how much you can possibly make just starting out in the same job class. Our friend the CIO person mentioned above has the biggest gap. The lowest you could make in that job is $85,000, but the most you could make just starting out is $127,500, for a $42,500 difference. Next biggest gap is for IT executive director ($39,625). Some of the gaps are small by comparison, as you'd expect -- $3,413 for lots of different jobs, many similar to those listed above under "minimum" salary. That's your "wiggle room" when negotiating for a salary, I suppose.
I could of course find the actual people who hold those titles and see what they actually make. It'd be interesting to see how many at UGA are near the maximum of their specific job title and class code.
Of course salaries are also depressing. For example, I'm a full professor, yet I make significantly less than all the assistant professors in the business school. WTF.
Highest "Minimum" Salary
This is $91,800 for something called "senior licensing manager II." The maximum this person can make is $207,000. What a burden. Next is "senior associate CIO and tech officer" at $85,000.This unlucky person's maximum is $195,500.
Lowest "Minimum" Salary
This is tougher to do. there are several at $15,138 annually (county secretary, camp counselor, laboratory helper, etc.). Oddly, this also includes "mental health professional" and "TV account executive." Weird.
Mind the Gap
Looking at the gap between the lowest or minimum salary versus the ""annual entry maximum" is simply seeing how low a salary you could have against how much you can possibly make just starting out in the same job class. Our friend the CIO person mentioned above has the biggest gap. The lowest you could make in that job is $85,000, but the most you could make just starting out is $127,500, for a $42,500 difference. Next biggest gap is for IT executive director ($39,625). Some of the gaps are small by comparison, as you'd expect -- $3,413 for lots of different jobs, many similar to those listed above under "minimum" salary. That's your "wiggle room" when negotiating for a salary, I suppose.
I could of course find the actual people who hold those titles and see what they actually make. It'd be interesting to see how many at UGA are near the maximum of their specific job title and class code.
Of course salaries are also depressing. For example, I'm a full professor, yet I make significantly less than all the assistant professors in the business school. WTF.
Monday, February 9, 2015
Those Wacky Political Science Profs
This past weekend lots of folks have been playing with this site, which uses Rate My Professor data to look at gender differences based on keywords.
So I put in the two ideological terms of "liberal" and "conservative" to see if any gender differences emerge (do your own terms, it's fun ... I'll probably do really weird ones later and blog about it. Just because).
First, political science is the top of the heap, which makes sense given it's a field devoted to politics. You'd expect more ideological labeling there than in, say, chemistry. So below is "conservative." Blue is male, so clearly political science is not only more likely to have faculty described as either "liberal" or "conservative," but males are more likely to be identified as "conservative."
Okay, but how about female political science profs? There's a difference, as seen in the graphic below. The scores are flipped, with females more than males likely to be identified as "liberal."
The lesson? Chemists apparently have no ideology.
f
So I put in the two ideological terms of "liberal" and "conservative" to see if any gender differences emerge (do your own terms, it's fun ... I'll probably do really weird ones later and blog about it. Just because).
First, political science is the top of the heap, which makes sense given it's a field devoted to politics. You'd expect more ideological labeling there than in, say, chemistry. So below is "conservative." Blue is male, so clearly political science is not only more likely to have faculty described as either "liberal" or "conservative," but males are more likely to be identified as "conservative."
Okay, but how about female political science profs? There's a difference, as seen in the graphic below. The scores are flipped, with females more than males likely to be identified as "liberal."
The lesson? Chemists apparently have no ideology.
f
Thursday, February 5, 2015
Rent in Athens (Geogia)
I was messing with some Census data today and got curious about how much rent actually is in Athens, Georgia. The results are kinda sorta interesting. According to this page, the median rent in Athens is $774. What's hard to tell is whether UGA dorms are folded into these results, which would seriously skew the numbers.
Okay, but let's look at the fun stuff, the most expensive. According to the data, there are 1,440 households that pay more than $1,500 a month rent. That seems high, but then again we see apartments popping up all over town now that advertise "luxury living" for college students. I'm sorry, if you're in college, you should not be living luxuriously. You should be in a dump. In a student slum.
Okay, but let's look at the fun stuff, the most expensive. According to the data, there are 1,440 households that pay more than $1,500 a month rent. That seems high, but then again we see apartments popping up all over town now that advertise "luxury living" for college students. I'm sorry, if you're in college, you should not be living luxuriously. You should be in a dump. In a student slum.
Wednesday, February 4, 2015
Recruiting Classes
Today is recruiting day. I'm not an expert in this stuff, but I got curious about previous recruiting classes and how well they lined up with how teams finished this past college football season. There's a table below. As you can see, looking at the 2012 and 2013 classes as ranked by Yahoo Sports, the predictive power is at best ... okay. TCU performs far better than you'd expect based on its class rankings (in 2012 it was #37 and in 2013 it was #30). Bama is often the #1 in class, but 2014 didn't turn out as well as Tide fans might have liked. Notre Dame had a top class in 2013 but looked awful this past season. If I had time and the interest, I'd dump a larger data set and try to massively correlate recruiting rankings with final football rankings. Way too much work.
Let's look at Georgia, given I work at UGA. The dawgs finished 9th this past season. They finished, according to Yahoo, with the #12 class in both 2012 and 2013, so I guess you could argue a #9 ranking means they slightly overperformed. The 2014 class was #7, for what that's worth. Call it even.
Using ESPN's data, you can see below how Georgia has done over time, as high as the #4 class in 2006, as low as the #13 class in 2007.
Finally, using a different site, I wondered who had the worst recruiting class this year. The winner (or loser)? UAB, which may be killing its football program. It's ranked #137, just below Western Illinois.
UPDATE
I ran a correlation of the 2013 class rankings (Yahoo Data) versus the 2014-2015 season final rankings. It's not great, r = .42. I had to cook the data a bit as some schools with top classes didn't finish in the top 38 teams. In those four cases (Florida, Michigan, South Carolina, and Vanderbilt), I ranked them all 39th. A scatterplot of the data is below. I didn't bother flipping the data, so low = better.
2012 Recruiting Ranking
|
2013 Recruiting Ranking
|
2014 Final Ranking
|
1. Alabama
|
1. Alabama
|
1. Ohio State
|
2. Texas
|
2. Ohio State
|
2. Oregon
|
3. Florida
|
3. Notre Dame
|
3. TCU
|
4. Ohio State
|
4. Florida
|
4. Alabama
|
5. Stanford
|
5. Michigan
|
5. Florida State
|
6. Florida State
|
6. LSU
|
5. Mich. State
|
7. Michigan
|
7. Mississippi
|
7. Baylor
|
8. USC
|
8. Auburn
|
8. Georgia Tech
|
9. Miami (Fl)
|
8. UCLA
|
9. Georgia
|
10. Auburn
|
10. Florida State
|
10. UCLA
|
Let's look at Georgia, given I work at UGA. The dawgs finished 9th this past season. They finished, according to Yahoo, with the #12 class in both 2012 and 2013, so I guess you could argue a #9 ranking means they slightly overperformed. The 2014 class was #7, for what that's worth. Call it even.
Using ESPN's data, you can see below how Georgia has done over time, as high as the #4 class in 2006, as low as the #13 class in 2007.
Finally, using a different site, I wondered who had the worst recruiting class this year. The winner (or loser)? UAB, which may be killing its football program. It's ranked #137, just below Western Illinois.
UPDATE
I ran a correlation of the 2013 class rankings (Yahoo Data) versus the 2014-2015 season final rankings. It's not great, r = .42. I had to cook the data a bit as some schools with top classes didn't finish in the top 38 teams. In those four cases (Florida, Michigan, South Carolina, and Vanderbilt), I ranked them all 39th. A scatterplot of the data is below. I didn't bother flipping the data, so low = better.
Monday, February 2, 2015
Airports & Firearms
As this site and others note, certain airports are more likely to see guns confiscated. You have to wonder what the hell people are thinking, trying to carry a gun on a flight, but let's set that aside for a moment. As you can tell from the list on the site, southern airports dominate when it comes to trying to get a gun on an airline.
But ... some airports are busier than others and, therefore, might have more gun confiscations simply because they're busy. To do this, I ran the data on ranking airports on their traffic to see if, for example, Atlanta's Hartsfield airport is #2 simply because it's a damn busy airport. Below are the Top 10 on guns and the rank, if available and in the Top 25, on traffic. So some, like Dallas and Atlanta, are near the top in part because of the sheer traffic they get. Others, such as Houston's Hobby (which I just flew out of), Tampa, Nashville, and Ft. Lauderdale, clearly are lower traffic airports that are overrepresented on the gun list.
LAX is #4 on traffic but doesn't make the gun list. Give credit to Denver, which finished #5 on both lists. Reliable, if nothing else. Interesting that Charlotte, also in the South, is #6 on traffic but doesn't make the gun list Top 10.
But ... some airports are busier than others and, therefore, might have more gun confiscations simply because they're busy. To do this, I ran the data on ranking airports on their traffic to see if, for example, Atlanta's Hartsfield airport is #2 simply because it's a damn busy airport. Below are the Top 10 on guns and the rank, if available and in the Top 25, on traffic. So some, like Dallas and Atlanta, are near the top in part because of the sheer traffic they get. Others, such as Houston's Hobby (which I just flew out of), Tampa, Nashville, and Ft. Lauderdale, clearly are lower traffic airports that are overrepresented on the gun list.
|
Rank on Guns
|
Rank on Traffic
|
|
1. Dallas/Fort Worth
|
3
|
|
2. Atlanta
|
2
|
|
3. Phoenix
|
11
|
|
4. Bush Intl (Houston)
|
8
|
|
5. Denver
|
5
|
|
6. Hobby (Houston)
|
NR
|
|
7. Tampa
|
31
|
|
8. Ft. Lauderdale (Fla)
|
25
|
|
9. Nashville
|
NR
|
|
10. Orlando
|
1
|
LAX is #4 on traffic but doesn't make the gun list. Give credit to Denver, which finished #5 on both lists. Reliable, if nothing else. Interesting that Charlotte, also in the South, is #6 on traffic but doesn't make the gun list Top 10.
Subscribe to:
Posts (Atom)