Anonymous wrote:Seriously, how long did this take you? Were you able to use AI to put this together?
Also, why are you putting this together?
Anonymous wrote:Anonymous wrote:Anonymous wrote:Anonymous wrote:Anonymous wrote:Most clusters are huge! Elementary schools?
Detailed census data isn't available for small areas. I'm not sure how much I'd trust the binning and interpolation that would have to happen at the elementary school level. Especially in the high income areas.
Chevy Chase Village is the wealthiest zip code in the county.
Zip code areas are too big to be able to assign them to high schools. This uses block groups weighted using household numbers at the census block level.
Chevy Chase Village is a place. It is a neighborhood.
Anonymous wrote:Anonymous wrote:Anonymous wrote:Anonymous wrote:Most clusters are huge! Elementary schools?
Detailed census data isn't available for small areas. I'm not sure how much I'd trust the binning and interpolation that would have to happen at the elementary school level. Especially in the high income areas.
Chevy Chase Village is the wealthiest zip code in the county.
Zip code areas are too big to be able to assign them to high schools. This uses block groups weighted using household numbers at the census block level.
Anonymous wrote:Anonymous wrote:Anonymous wrote:Most clusters are huge! Elementary schools?
Detailed census data isn't available for small areas. I'm not sure how much I'd trust the binning and interpolation that would have to happen at the elementary school level. Especially in the high income areas.
Chevy Chase Village is the wealthiest zip code in the county.
Anonymous wrote:Anonymous wrote:Op here. I did this in part because every time wealth inequality comes up it is hard to compare schools to each other. FARMS just gives you the low end, not any indication of the high end. Looking at other data sources and proxies is problematic. Data sources often aren't closely tied to school boundaries, and it is hard to demonstrate you're not cherry picking data.
I double checked the logic and did some consistency checks with zip codes. The data seems to be accurate. But this isn't the median income for families of students- it includes young married couples and married retirees. Even for families with kids, it includes single-parent households and single-earner households. These will drive the median lower than whatever you might intuitively expect. And in some cases, people underestimate how many multi-family homes are in an area- you don't need a lot of space to offset expensive SFHs.
Now that your've done this, does it show anything not already present in FARMs data?
Anonymous wrote:Op here. I did this in part because every time wealth inequality comes up it is hard to compare schools to each other. FARMS just gives you the low end, not any indication of the high end. Looking at other data sources and proxies is problematic. Data sources often aren't closely tied to school boundaries, and it is hard to demonstrate you're not cherry picking data.
I double checked the logic and did some consistency checks with zip codes. The data seems to be accurate. But this isn't the median income for families of students- it includes young married couples and married retirees. Even for families with kids, it includes single-parent households and single-earner households. These will drive the median lower than whatever you might intuitively expect. And in some cases, people underestimate how many multi-family homes are in an area- you don't need a lot of space to offset expensive SFHs.
Anonymous wrote:Anonymous wrote:Op here. I did this in part because every time wealth inequality comes up it is hard to compare schools to each other. FARMS just gives you the low end, not any indication of the high end. Looking at other data sources and proxies is problematic. Data sources often aren't closely tied to school boundaries, and it is hard to demonstrate you're not cherry picking data.
I double checked the logic and did some consistency checks with zip codes. The data seems to be accurate. But this isn't the median income for families of students- it includes young married couples and married retirees. Even for families with kids, it includes single-parent households and single-earner households. These will drive the median lower than whatever you might intuitively expect. And in some cases, people underestimate how many multi-family homes are in an area- you don't need a lot of space to offset expensive SFHs.
But this begs the question
Anonymous wrote:^^oops, my bad. I read "country" not "county." Please ignore.
Anonymous wrote:Anonymous wrote:Anonymous wrote:Most clusters are huge! Elementary schools?
Detailed census data isn't available for small areas. I'm not sure how much I'd trust the binning and interpolation that would have to happen at the elementary school level. Especially in the high income areas.
Chevy Chase Village is the wealthiest zip code in the county.
Anonymous wrote:Anonymous wrote:Most clusters are huge! Elementary schools?
Detailed census data isn't available for small areas. I'm not sure how much I'd trust the binning and interpolation that would have to happen at the elementary school level. Especially in the high income areas.
Anonymous wrote:Op here. I did this in part because every time wealth inequality comes up it is hard to compare schools to each other. FARMS just gives you the low end, not any indication of the high end. Looking at other data sources and proxies is problematic. Data sources often aren't closely tied to school boundaries, and it is hard to demonstrate you're not cherry picking data.
I double checked the logic and did some consistency checks with zip codes. The data seems to be accurate. But this isn't the median income for families of students- it includes young married couples and married retirees. Even for families with kids, it includes single-parent households and single-earner households. These will drive the median lower than whatever you might intuitively expect. And in some cases, people underestimate how many multi-family homes are in an area- you don't need a lot of space to offset expensive SFHs.