Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the patients first and last name that has the SSN-473-70-8408? Of the possible duplicates, how many patient (s) have the gender listed as

image text in transcribed

image text in transcribed

  1. What is the patients first and last name that has the SSN-473-70-8408?
  2. Of the possible duplicates, how many patient (s) have the gender listed as F. Who is/are these patient(s)?
  3. What percentage of patients of the possible duplicate entries have their birthday in the third quarter(July-September).
  4. What percentage of patients of the possible duplicate entries are missing a middle name?
  5. What percentage of patients of the possible duplicate entriesare males?
  6. What percentage of patients of the possible duplicate entries are females?
  7. Elmer Blake is a potential duplicate. What do you think caused the duplicate entry?
  8. Eunice Montgomery is a potential duplicate. What do you think caused the duplicate entry?
  9. How many patients have a duplicate medical record number because of the MRN being MRXXXXXXX? Who are they?
  10. What is the most common cause of middle name discrepancies?
  11. Who is the patient who has the birthdate of 10/15/1963?
  12. How many of the potential duplicates have gender discrepancies?
  13. What are the causes of the gender discrepancies?
  14. How many of the potential duplicates have mismatches of SSN? Give the number of pairs.

I need help with question 1 -14 please. thanks in advance for your help.

note: I provided the excel spreadsheet to answer the questions. thank you.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions