Data Set Anomalies

Before entering your answers in the worksheet, review the following directions.

1. Carefully study the data set provided in the worksheet.

2. Identify errors or data anomalies. You should look for errors such as blank cells and cells that do not contain numerical data, etc.

3. Identify each anomaly by the cell block it is in and list it in the textbox provided on the worksheet. For example, C12, D21, etc.

4. In one page, describe how anomalies can be avoided. Write your answer in the textbox provided on the worksheet. Be detailed and make sure your answer is free of spelling and grammar errors.

The Quality Improvement Coordinator has enlisted your help in maintaining a dataset of hospitals and the amount of different outpatient procedures performed during the past year. This dataset willbe useful for benchmarking purposes so it is important to you and the quality improvement coordinator that the data set is error free. During your review of the 40-row dataset (shown in the table spanning the next 2 pages), you notice multiple anomalies that would need to be corrected before the data set is used.

In the textbox below, indicate the table cells with the anomalies. Identify the cells using column letter/row number format (e.g., A1, C40, H2).

In one page, describe how anomalies can be avoided? Be detailed and make sure your explanation is free of spelling and grammar errors.

Attachment:- Case_Assignment_Data_Set.rar