write a short note on data filtering in calc
give answer in 150- 200 words
Answers
Answer:
Data filtering is the process of choosing a smaller part of your data set and using that subset for viewing or analysis. Filtering is generally (but not always) temporary – the complete data set is kept, but only part of it is used for the calculation.
Filtering may be used to:
Look at results for a particular period of time.
Calculate results for particular groups of interest.
Exclude erroneous or "bad" observations from an analysis.
Train and validate statistical models.
Filtering requires you to specify a rule or logic to identify the cases you want to included in your analysis. Filtering can also be referred to as “subsetting” data, or a data “drill-down”. In this article we illustrate a filtered data set and discuss how you might use filtering.