# CalculateMOEs V2

Document Sample

```					                 To calculate if two estimates are statistically significant

Required: The two estimates
The margin of error (MOE) for each of the two estimates

Both of these items can be found in the Census Bureau's American Community Survey data tables.

To use "Calculate" worksheet"

1. Place the estimates into cells B3 and B4 in the Calculate worksheet.
2. Place the corresponding MOEs into cells B6 and B7 in the Calculate worksheet.

It does not matter which estimate is first or second. However, must make sure that the margin of errors
are in the same order as the estimates (I.e. the first margin of error is for what you enter as the first estimate).

The answer is in cell B20.
Yes means that there is a statistically significant difference between the two estimates at the 95 percent confidence interval

No means that there is NOT a statistically significant difference between the two estimates at the 95 percent confidence interva
Survey data tables.

he first estimate).

95 percent confidence interval

the 95 percent confidence interval.
To be Used With ACS When Have MOE                  Data
Value 1 =                                        62,939
Value 2 =                                        63,365
Inputs
Margin of error, value 1                          7,457
Margin of error, value 2                          1,739
Calculations:
Standard error value 1 (calc)                  4,533.13
Standard error value 2 (calc)                  1,057.14

ABS of Actual difference (Value 1 - Value 2)      426.0
Calculations, no need to change
Standard error or the difference               4,654.76

MOE of the difference                          7,657.09

Compare actual and MOE of difference           -7,231.09

Is the difference between the two estimates