Question
Which data cleaning technique is most appropriate for
handling missing data when missing values are randomly distributed across a dataset?Solution
When missing data points are randomly distributed, imputing values using the mean (for continuous data) or median (for skewed distributions) can be an effective technique. This approach maintains the dataset’s overall structure and helps reduce potential bias introduced by missing values. By substituting missing values with central tendencies, analysts can preserve statistical relationships without significantly distorting the data, ensuring a more accurate analysis. Option A is incorrect as removing rows may lead to a significant data loss, especially if many rows contain missing values. Option C is incorrect because dropping columns with missing values reduces feature dimensions, potentially discarding useful information. Option D is incorrect as placeholder values can introduce bias or mislead analysis, especially if the placeholder value skews the distribution. Option E is incorrect because ignoring missing values leaves gaps, making it difficult to perform accurate analysis.
Find the least positive integer N such that N ≡ 3 (mod 7), N ≡ 4 (mod 9), and N ≡ 5 (mod 8).
There are nine consecutive even numbers such that the smallest number is 50% of the largest number. Find the sum of the second lowest and second highest...
Two friends received a bonus of ₹3,000 each in their bank accounts. They already have ₹47,000 and ₹57,000 in their respective bank accounts. The r...
- A room contains three shelves: the 1st, 2nd, and 3rd. The number of books on the 1st and 2nd shelves are in the ratio of 6:11, while the number of books on...
3245.34 + 923.5 + 23.5 =?
The number of females in a company is 20% fewer than the number of males. After 10 males and 16 females join the company, the number of males becomes ha...
Find the remainder when 215 is divided by 7.
A person hired a car for few days. The rent is charged @ Rs 100 per day for first 2 days, Rs 200 per day for next 7 days and Rs 387 per day ther...
- The smallest number 'Q' which when divided by 12, 16, and 20 leaves 5 as the remainder in each case. Find the value of ('6Q' + 15).
Find the third proportion of 24 and 12.