Here is something that the California State Data Center shared with the SDC listserv. I have permission from Nancy to share with CTPP! Elaine Subject: ACS Median Calculator We thought we would share our article on calculating a median from aggregated range data and the Excel calculator. This example uses household income but the concepts could be used for any range data. The formula for calculating the MOE comes from the ACS PUMS Accuracy statement which would also be the source for the Design factor which you should check for your state or any other variable. Nancy Gemignani California State Data Center Demographic Research Unit (916) 327-0103 ext 2550