Dear Gene,
You need to sum/combine across the 3 age categories that you want. The calculation (including MoE - margin of error) is in https://www.census.gov/content/dam/Census/library/publications/2018/acs/acs_general_handbook_2018_ch08.pdf
For a percent…
I assume that you might want a ratio of the "sub" area and the larger area. For example a county might be the "large "area and the "subset" a single tract. You might want the ratio of the 2 populations (B01003)
In general…
Hi Stas, I use a combination of R and Excel. I'm still sort of a novice at R, so I clean and recode data in R and then export it to Excel. In Excel I use pivot tables to calculate margins of error.
Don't want to go down a rabbit hole on HUD stuff, the table they use is B19113 (took me over an hour to find the webpage that lists which table);
https://www.huduser.gov/portal/datasets/il.html#faq_2023:~:text=The%20basis%20for%20HUD%E2%80%99s%20median…
I'd like to compare some ACS estimates to decennial Census figures and assess the statistical significance of changes. (In this case, population totals for Congressional districts.)
I don't see margins of error for decennial Census figures, presumably…
Thanks Dave for the helpful breakdown. I discovered that the error is probably at the level of geographic selection for NHGIS. When I select all of United States, my totals add up. But when I only select the lower 48 states in the dataset I get different…
ACS Question 7 2018
Does this house, apartment, or mobilehome have– Yes No
a. hot and cold running water?b. a bathtub or shower?c. a sink with a faucet?d. a stove or range?e. a refrigerator?f. telephone service fromwhich you can both makeand receive…
I am afraid that the Bureau actually miss handled there computation of MOE, if one is a frequentist, if one is a Bayesian that approach is even worse. On the frequentist, I had a debate with Bureau a long time ago, where they indicated that they realized…
Here's how I'd put it to a non-expert: 5-year estimates exist because that's the time required to collect a sufficient number of survey responses (particularly in small areas like census tracts, ZCTAs, or small towns). The 5-year estimates in small areas…
I just took a sample table, clicked on Customize, chose Margin of Error box which turns it off, and then clicked on any table cell and chose export to Excel and it came in without MOE column
stan drezek