Outline for Data Due Diligence Term Paper

Total Length: 311 words ( 1 double-spaced pages)

Total Sources: 0

Diligence

Alphanumeric

HouseholdID

Length of Residence

City

Gender

Occupation

Fields with null values

MSACode

Athletic Dimension

Fields with "Unknown" values

Marital Status

Occupation

Presence of Children

Wealth Score

MailResponder

f. Number-based fields that cannot be used in calculations

Income

LengthofResidence

Region

g. Number-based fields that can be used in calculations

Fields where numbers used to indicate non-text values (e.g. Y/N, etc.)

OwnACat

OwnADog

OwnCellularPhone

Due Diligence

Standardize Y/N fields

Methodology should be the same in all columns

Calculate averages and standard deviations for all number fields after cleanup is completed

Can at least do counts for those fields after cleanup

c. Ensure no duplicate values in HouseholdID

Appears that this should be unique for each record

d. Ensure no misspellings of city names so that there is not more than one field for each city name

i. Example would be that Huntington Beach and Huntington Bch should not be treated as unique values (did not see that ..
. just an example).

e. Ensure no invalid state abbreviations are used

i. E.g. XY used for Wyoming instead of WY (again, just an example)

f. Figure out something to do with "0" as age value (invalid figure)

i. Needs to be changed to "Unknown" or made null out if not known. The latter will probably be necessary to do calculations that are valid.

g. Figure out something to do with "U" (Unknown) in gender….....

     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"Outline For Data Due Diligence" (2016, July 31) Retrieved May 22, 2025, from
https://www.aceyourpaper.com/essays/outline-data-due-diligence-2160812

Latest MLA Format (8th edition)

Copy Reference
"Outline For Data Due Diligence" 31 July 2016. Web.22 May. 2025. <
https://www.aceyourpaper.com/essays/outline-data-due-diligence-2160812>

Latest Chicago Format (16th edition)

Copy Reference
"Outline For Data Due Diligence", 31 July 2016, Accessed.22 May. 2025,
https://www.aceyourpaper.com/essays/outline-data-due-diligence-2160812