Descriptive statistics functions analyze and explore a database.
Descriptive statistical analysis is valuable for the following reasons:
- Provides business insight.
- Uncovers data issues that jeopardize the accuracy of analytic models based on the data if you do not not correct or compensate for the issues.
- Isolates the data used in building analytic models.
If you identify an outlying value, you can include or exclude the value depending on the business problem.
- Helps determine the suitability of data elements for model input and suggests transformations.
Statistical processes used in analytic modeling require a certain type of data distribution.
Descriptive statistics functions handle NULL values with aggregate functions in their generated SQL.