Live data from Hacker News

No one cared about my spreadsheets

econlib.org

71–80 of 413 posts

Re: No one cared about my spreadsheets

#71
post #34
post #23

This reminds me of people online who construct gigantic walls of bad faith argument text and insist that it's up to everyone else to "debate them" and spend hours deconstructing their argument. Just possibly, dude, your argument isn't worth anyone else's time to debunk.

> Just possibly, dude, your argument isn't worth anyone else's time to debunk. Wow, that's one of the most dismissive remarks I've seen here in quite a while. It also does not seem like you could possibly believe it yourself. Education is a huge chunk of everyone's life, of course it's important to know the upsides and downsides. The returns are one aspect (I haven't read the book, it honestly sounds depressing, but…

> Wow, that's one of the most dismissive remarks I've seen here in quite a while. It also does not seem like you could possibly believe it yourself.

It's a natural thing. If you come up with an implausible sounding thing supported by a very complicated argument then most likely you made a mistake. It is very easy to make mistakes and very hard to find them.

If you have a 1000 page proof that 2*2 is 5 I won't spend my valuable time finding where you slipped up. Now clearly his claim is more nebulous. One has to invest money and time to even understand what the book claims, so then one can invest more time to debunk a spreadsheet?

Re: No one cared about my spreadsheets

#72
post #14

I bet a spreadsheet that thoroughly analyzed the profitability of going out for a run every day would also find a negative ROI.

Actually, I think this is a decent thought experiment. IMHO it would depend a lot of what is included and not included and what definition of profitability we used.

For example, if I spent less money would that also count as more profitable? Does it also take into consider what activity was replaced by running?

Spending 30 min less on HN and replacing it with running, or just moderate walking, could very well result in less expenses if one takes medical spending into consideration.

And I think that's what Caplan is asking people to do. Go over his definitions and what was included and see if it makes sense.

Re: No one cared about my spreadsheets

#73
Well, if you're going to throw down the gauntlet like that Mr. Caplan, how can I resist! I began by actually looking at this authors spreadsheets, then looking at their claims, and ultimately, I downloaded a copy of their book[0] to review what that book says. So here's the info:

The fundamental claim of the book is that currently, the "western education model" is not (really) about skill accumulation or increasing the utility that an individual can provide society. Instead, our current "western education model" is about signalling a workers productivity to potential employers. That is the thesis of the book, as spelled out in the introduction of the book.

I downloaded the spreadsheets[1] that the author talked about.[2] I've reviewed them for about an hour, in between reading, and my take is that no one cares about the spreadsheets because they're INCREDIBLY basic. In short, the spreadsheets are a collection of statistics about the outcomes of students who complete various levels of education. It shows income earned per year of education completed, for a number of different hypothetical students (excellent students, poor students, etc). The numbers aren't particularly shocking on their face, and the spreadsheets don't have anything like a single cell on the first sheet labeled "SMOKING GUN, WOW" to catch your attention. Instead, the general point from the statistics is that we see unusual jumps in the expected compensation of students at various "round numbers", such as jumps at 12 years of education completed (finished high school), and 16 years of education completed (finished undergraduate). The author seems to take these as strong proof for their original point that the value of education is in "signalling", not in increasing a persons ability.

My fundamental issue with this is that this data, as I've read it, could be understood a different way than "education is just a social signal". By my reading, this data could just as well be "western hiring markets are wildly under-valuing the abilities of folks who narrowly miss common landmark achievements". I believe that's also an idea worthy of study, but I don't see it addressed in any of the authors writing, or in the book.

[0] - https://eddierockerz.files.wordpress.com/2020/12/the-case-ag...

[1] - https://econfaculty.gmu.edu/bcaplan/compensationcleanfinal.x...

[2] - https://www.econlib.org/archives/2014/06/embarrass_me_no.htm...

Re: No one cared about my spreadsheets

#74

> Several programmer friends advised me to learn a new programming language like Python to do everything automatically, but I’m 98% sure that would have taken even longer – and introduced numerous additional errors into the results. I did plenty of programming in my youth, and I know my limitations. I'm biased since I don't know spreadsheets at all, but I think Python code would have been far more reviewable.

There are dozens of examples in the wild of python code getting reviewed, corrected, and enhanced. I’m not a spreadsheet expert. Does that even happen for spreadsheets?

Re: No one cared about my spreadsheets

#75
post #61

“ Several programmer friends advised me to learn a new programming language like Python to do everything automatically, but I’m 98% sure that would have taken even longer – and introduced numerous additional errors into the results. I did plenty of programming in my youth, and I know my limitations.” This screams stubbornness and a lack of willingness to push past a small barrier to me. Maybe unwarranted, but that al…

> Maybe unwarranted, but that also makes me less willing to accept his ideas. Who knows what evidence, lead, etc. was met with the same laziness? I think you can only say that you’ve chosen not to engage with this these arguments, not that you’ve rejected them as that would require engaging with them.

I agree with his arguments at a surface level, but I don’t accept that his analysis was rigorous. Especially because his spreadsheet is monolithic and impossible to double-check.

Re: No one cared about my spreadsheets

#76

Earlier quoted context omitted.

I have read the book. He says that engineering degrees are basically the one exception. They're like trade schools. Also, e.g. a social science degree is useful if you're going to be a social science professor/academic, but otherwise none of the skills or knowledge are transferable. He also says that having any degree is "worth it" to an individual, monetarily. It's just not worth it to society to require everyone to…

> otherwise none of the skills or knowledge are transferable. While I understand the source of this statement and why people often say this, I'm not entirely sure I agree with this, at least anecdotally. For example, I have a degree in Theater. Which, on the surface, doesn't transfer well to, say, software engineering or law or accounting or teaching or social work. But is that really true? To pick a popular theatre-…

>To pick a popular theatre-related discipline, consider what an actor does:

Not saying you're wrong about what a good theater student does, but a disproportionately large number of arts students I've met seemed to treat their degree as a three year long bludge that allows them to delay taking on adult responsibilities.

Far fewer people go into mechanical engineering or physics because they want to sit around smoking weed all day.

At least in my line of (admittedly quite "dirty") work, I'd choose someone with experience at McDonalds or Kmart over an arts grad any day of the week.

Re: No one cared about my spreadsheets

#77
In another HN post recently a commenter said something about the stock market, and they invoked an image of people collecting money from Brownian movement.

It struck me that comment was excellent and insightful, and was only possible because both the commenter and myself were once taught something that neither of us uses in our day jobs, and may never have learned through any normal self-driven persuit.

The more I hear about this book the more ignorant it sounds. The benefits of having a significant, as large as possible, portion of everyone being at least somewhat educated on a wide range of basic ideas (not facts so much) isn't quantifiable. It's effects are in countless infinite small thimgs that no one can tally.

It's not good enough that some small percent of people would always be educated, because those people still have to interact with everyone else. We already have a bad enough problem of people simply not even understanding what other people say, and therefor not crediting or respecting it at all and going with their feelings on everything.

Re: No one cared about my spreadsheets

#79
post #63

I love the irony in all the comments here criticizing his spreadsheets and arguments by people who have clearly not read the book or looked at the spreadsheets.

I mean, I did download the spreadsheets and (skim) read the book after reading the parent article. TL;DR is that the spreadsheets are solid and unsurprising, though his interpretation of said spreadsheets seem to be the part that makes me ask "hmmm, I'm not sure if that follows from the evidence."

Full breakdown, with direct links to the spreadsheets: https://news.ycombinator.com/item?id=30368620

Re: No one cared about my spreadsheets

#80
post #9

Just my dumb opinion here, but... there's something extremely implausible on its face about the idea that a sufficiently complex spreadsheet could calculate the difference in value generated from kids going to school versus kids not going to school. If people could be convinced that this was something more than a castle in the sky, maybe it would get more attention. I imagine a bunch of academics put their fingers to…

On a certain level I might agree. On the other hand, I think it's a reasonable point that if we disagree with him, go find the parameter he's chosen wrongly or forgotten, since it must exist somewhere if he's wrong. On the third hand, that's probably unfairly much to ask of your audience, since it requires auditing work that took a year.

Several years ago, I wrote against a local option sales tax for schools with some uncomfortable data.

This particular referendum was lost, but the next prevailed.

We do not allocate money to education intelligently.

As an aside, the comparison engine provided by the Federal Education Budget Project appears to have been taken down.

[My Illinois town's] Schools have again placed a sales tax increase before the voters for the April 7th election. Voters should reject this increase after reviewing the financials below.

In Iowa, the average 2013 teacher salary is $33,226. The Illinois average, however, is $37,166, which is above the national average of $36,141. Illinois teachers are (more than) fairly compensated.

On a local focus, the Federal Education Budget Project lists the [nearby Iowa] Community School District budget for 2012 (which likely includes local option tax funds) as $174,000,000, which served 16,955 students for a per-student cost of $10,262.

[My town's] budget for the same period was $76,568,000 and served 6,622 students, for a per-student cost of $11,562.

[Our neighboring Illinois town's] budget for the same period was $78,817,000 and served 7,429 students, for a per-student cost of $10,609 per student.

[Our nearby Illinois town's] academic performance is solidly ahead of [my town] - [our nearby Iowa town's] scores 70% and 66% proficient in the 2011 "No Child Left Behind" [high school] reading and math tests, while [my nearby Illinois town] respectively scores 46.9% and 53.8%, and [my town] trails the pack at 30.1% and 25.9%. [My nearby Iowa town] achieves performance dominance while spending $347 less per student than [my nearby Illinois town], and $1,300 less per student than [my town].

[My town's] schools should not ask for larger budgets, but instead trim costs and increase performance to match our nearby peers. If [my town's] schools cannot meet these standards, then perhaps we should consider outsourcing the maintenance of [my town's] schools to the [nearby Iowa town], which appears both more capable and thrifty by all measures. [My town's] students deserve better.

Post reply on HN