Untitled Quiz

Which of the following is a common method for handling missing data?

• a) Deleting the entire dataset
  

• b) Ignoring the data completely

• c) Imputing with mean/median/mode

• d) Changing data type

2. What function in Excel can be used to identify duplicates?

• a) UNIQUE

• b) ISERROR
  

• c) REMOVE
  

• d) FIND

3. Which of the following is not a type of missing data?

)

• a) MCAR (Missing Completely At Random)
  

• b) MAR (Missing At Random)
  

• c) MNAR (Missing Not At Random

• d) MOUT (Missing Outlier)

4. Which statistical method is commonly used to detect outliers?

• a) mean

• b) Median
  

• c) Standard deviation

• d) Interquartile Range (IQR

5. What happens if you ignore missing data in your dataset?

• a) Better accuracy
  
  

• b) Biased results

• c) Faster processing

6. Which Excel feature helps you highlight duplicates easily?

• a) Data Validation
  
  

• b) Conditional Formatting

• c) Filter
  

• d) Pivot Table

7. Which of the following is NOT a method for handling duplicates?

• a) Removing
  

• b) Summarizing them

• c) Duplicating them further

• d) Merging them

8. The Z-score method for detecting outliers assumes data is:

• a) Uniformly distributed
  
  

• b) Normally distributed

• c) Exponentially distributed
  

• d) Skewed

9. What is a common threshold for identifying outliers using Z-score?

• a) |Z| > 1
  

• b) |Z| > 2
  
  

• c) |Z| > 3

• d) |Z| > 0.5

10. Which library in Python is commonly used for handling missing data?

• a) NumPy
  

• b) Matplotlib
  
  

• c) Pandas

• d) TensorFlow