© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2021
D. SarkaAdvanced Analytics with Transact-SQLhttps://doi.org/10.1007/978-1-4842-7173-5_1

1. Descriptive Statistics

Dejan Sarka1  
(1)
Ljubjana, Slovenia
 

Descriptive statistics summarize or quantitatively describe variables from a dataset. In a SQL Server table, a dataset is a set of the rows, or a rowset, that comes from a SQL Server table, view, or tabular expression. A variable is stored in a column of the rowset. In statistics, a variable is frequently called a feature .

When you analyze a variable, you first want to understand the distribution of its values. You can get a better understanding through graphical representation and descriptive statistics. Both ...

Get Advanced Analytics with Transact-SQL: Exploring Hidden Patterns and Rules in Your Data now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.