In the past couple of Excel Videos we’ve found and replaced errors in our data. In Excel Video 367, we’ll find and exclude zeros. Instead of using ISERROR like we have in the past couple of Excel Videos, today we’ll use <>, which is Excel-speak for not equal to. We’ll find all of the data that is not equal to zero and then take an average. You could easily use similar logic to find all locations that weren’t in the hospital or exclude all procedure codes that did not begin with 99.
Errors and zeros are nice to find. In the next Excel Video, we’ll look at differences in contractual allowances. I look forward to seeing you then.
