Fill in the mid-point value for the "Estimated Household Income" in the column "MidEHI" (rounded to the nearest dollar). This is useful for answering questions about the average (estimated) income of a sample sub-group. One way to do it is to create a Pivot Table to get the different "income brackets". Then extract the upper and lower dollar bounds of each income bracket and find the mid-point. Note: I have already completed this pre-processing step and created a MidEHI worksheet with the mid-po