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.

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…

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 mobile
home 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 from
which you can both make
and 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