Find at least three potentially problematic data entries (cells) in this table, and decide how you would choose to address them. Would you remove the whole row? Somehow try to guess what the answer "should" be" (aka imputation)

In addition, name some problems or concerns you had when cleaning your data set. What insights did you gain from the project?

Transcribed Image Text:

Calibri (Body) 11 A Paste BIU ||| ab Wrap Text Merge & Center Alignment General $ % Clipboard Font Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? S9 fx A B C D E F G H J K L M N Age 4457 123456789 = Weight 10 102.2 6 61.5 7 71.9 3 32.3 999 42.2 52.4 72.3 10 4 41.9 11 10 102 12 5 51.7 13 8 81.5 14 10 15 10 10.3 102.3 16 10 102.5 17 7 71.8 18 9 91.6 19 3 32.4 20 3 32.1 21 8 81.5 22 5 52.3 23 NA 41.8 24 3 31.8 25 8 82.3 26 9 92.1 27 6 999 28 3 31.5 29 30 31 32 33 34 35 36 4867487A 42.5 82 62.5 71.9 41.9 82 72.2 42.1 37 38 39 40 41 42 43 44 Sheet1 + Number 0 .00 0 Conditional Formatting P Q R S T U Calibri (Body) 11 A Paste BIU ||| ab Wrap Text Merge & Center Alignment General $ % Clipboard Font Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? S9 fx A B C D E F G H J K L M N Age 4457 123456789 = Weight 10 102.2 6 61.5 7 71.9 3 32.3 999 42.2 52.4 72.3 10 4 41.9 11 10 102 12 5 51.7 13 8 81.5 14 10 15 10 10.3 102.3 16 10 102.5 17 7 71.8 18 9 91.6 19 3 32.4 20 3 32.1 21 8 81.5 22 5 52.3 23 NA 41.8 24 3 31.8 25 8 82.3 26 9 92.1 27 6 999 28 3 31.5 29 30 31 32 33 34 35 36 4867487A 42.5 82 62.5 71.9 41.9 82 72.2 42.1 37 38 39 40 41 42 43 44 Sheet1 + Number 0 .00 0 Conditional Formatting P Q R S T U

Answer rating: 100% (QA)

To identify potentially problematic data entries we need to examine the data and look for inconsistencies or values that seem incorrect Based on the g... View the full answer