Statistical testing tool question

In the Census Bureau’s Excel Statistical Testing Tool, the sample margins are preceded by “+/-.” Does the tool still calculate statistical significance correctly without the “+/-“ signs? I have to manually enter many of these margins (rather than simply copying from data downloads), and Excel will simply not allow me to enter those characters before numbers. It keeps forcing me to correct them.

www.census.gov/.../statistical-testing-tool.html

I don’t see documentation from the Census Bureau instructions that specifically address this. The “worked example” spreadsheet in the Testing Tool file includes an example with parentheses around the margins, which Excel will allow, but I’d prefer to keep the editing to a minimum – i.e., it would be easier if the +/- is not really necessary to calculate significance.

I’ve also tried copying and removing the +/- symbols and the statistical significance results appear to come out the same for a few examples, but I’d prefer to have some authoritative confirmation of this. Thanks!

Parents
  • I think you leave out the +/- sign. As far as I know, the math equation the tool uses is:
    absolute value of estimate1 - estimate 2 / square root of MOE1^2 + MOE2^2
    Since the margins of error are squared in the equation, whether or not there's a plus or minus sign in front of them is moot!
Reply
  • I think you leave out the +/- sign. As far as I know, the math equation the tool uses is:
    absolute value of estimate1 - estimate 2 / square root of MOE1^2 + MOE2^2
    Since the margins of error are squared in the equation, whether or not there's a plus or minus sign in front of them is moot!
Children
No Data