"" Using Data to Improve Care for Children EKG
Home >

Discover the Scope of the Problem

Just because you found some data errors does not necessarily mean that your information cannot be used. Rather, you will need to determine the scope of the problem(s) to help you identify areas that need to be fixed. A great way to assess your data is by creating pivot tables.

Pivot Tables

Producing pivot tables (crosstabs) of each data field is an easy way to determine error rates. This technique works for all field types except for free text fields. Below is an example of a pivot table.

















So what do you learn by creating a pivot table?

When an error rate reaches between 10-20%, the cause should always be investigated. Well, for example, there are two areas of concern with the above table. First, 11.4% of the total count for gender is blank. The second is that 13.6% of respondent's gender is unknown. Either of these items should raise a red flag and prompt the reviewer to investigate the data.

Next Step
Clean the Data Using a Predefined Specification >>





rev. 04-Aug-2022




Investigate the scope of the problem.
Resource Library

How to Analyze Data - Workshop
Review the PowerPoints and the handouts from the most recent workshop on analyzing data; you will find information on creating pivot tables.


Disclaimer | Website Feedback | U of U
© NEDARC 2010

This website is supported by the Health Resources and Services Administration (HRSA) of the U.S. Department of Health and Human Services (HHS) as part of the Emergency Medical Services for Children Data Center award totaling $3,200,000 with 0% financed with non-governmental sources. The contents are those of the author(s) and do not necessarily represent the official views of, nor an endorsement, by HRSA, HHS, or the U.S. Government. For more information, please visit HRSA.gov.

(In accordance with the Americans with Disabilities Act, the information in this site is
available in alternate formats upon request.)