Null value and incorrect value

[elephant]

Hi, I having two column of data one is income and one is spending on food. For my spending on food column I have data that is null and I had data that look incorrect (number in bold) for null value i using imputation tool to input the average value am i doing it correctly? For the incorrect (number in bold) data any advice of what I should do? Here a sample of data

Income        Spending on food

10900          890

2400            950

17000          1490

9700             9

15900          1310

10700

11400          38

6000            2000

5609            

4050             1

[binuacs]

@elephant something like below? it replaces the NULL to 0

[Qiu]

@elephant 
How do you define "data that look incorrect"?

[elephant]

Like earn 5000 but spend only 8 

[caltang]

Err... how is that incorrect?

[elephant]

like it earn 9700 but spend 8 isnt that consider an incorrect or not accurate data?

[caltang]

What... high income people can''t be frugal on food? Haha!

Let's circle back to your rawest form of data. Can you provide a sample? Let's have a look.

[CoG · Accepted solution]

You have a few options that you can take, all of which require you to define what "looks incorrect" means. As an example, ratio ([food cost]/[Income] < 1%):

1. You can just drop these row entirely using the Filter Tool
2. If possible/feasible, you can contact whoever collected the data in an attempt to correct these seemingly incorrect data points, replacing the values with the correct amounts when proper information is provided.
3. You can use the Formula Tool to set these values to NULL, and treat them like other NULL values replacing with the average.

Which option you choose, depends on how much data you have, what your use case is, and how much data is affected.