Apologies for using this forum but I figured this might be appropriate. I am trying to get the upper and lower bound at the 90% CI around shares of people who live and work in Palm Beach County and who live in PB County but work outside PB county. I am using 1 year ACS data from 2008 and am using table B08007. I am getting a negative number under the square root term and obviously it cannot calculate SE. Anyone has pointers for a workaround or what you did when faced with something like this? I doubt if it can deal with imaginary numbers and i suppose you can make it zero but if anybody can elaborate on this it that would be helpful. I am attaching the actual XLS file and you can see a screenshot of the file here: http://picasaweb.google.com/krisviswanathan/ACS_STANDARD_ERROR

TIA,
Krishnan