Identify patients that have diabetes in the above database. Calculate the average cost of each diagnosis sorted from most expensive to least expensive. Exclude all bills with negative or 0 values.

Import data from the following files into four tables. ptid.xls► claims.xls► icd.xls► cpt.xls►

Identify patients that have diabetes in the above database.

Calculate the average cost of each diagnosis sorted from most expensive to least expensive. Exclude all bills with negative or 0 values.
Show if men are more likely to have diabetes than women. s. Calculate which month is most likely to have a diagnosis reported.
IDownload•I

6. Download the attached file of ICD9 codes and descriptions and find the seven errors in the data, where the same ICD9 code has been assigned different descriptions.
copy screen captures into a word file and submit the file.