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 but if there are any statisticians who can elaborate that would be helpful. I am attaching a screenshot of the error along with the actual XLS file. <br>


<br>TIA,<br>Krishnan<br><br><br><img title="se_error.jpg" alt="se_error.jpg" src="cid:ii_12a39467b8f411fc"><br clear="all"><br>-- <br>Krishnan Viswanathan<br>1101 High Meadow Dr<br>Tallahassee FL 32311<br><br>