-
Book Overview & Buying
-
Table Of Contents
The Applied SQL Data Analytics Workshop - Second Edition
By :
Data analytics is a powerful method through which to understand the world. The ultimate goal for analytics is to turn data into information and knowledge. To accomplish this goal, statistics can be used to better understand data, especially descriptive statistics and statistical significance testing.
One branch of descriptive statistics (univariate analysis) can be utilized to understand a single variable of data. Univariate analysis can be used to find outliers; the distribution of data by utilizing frequency distributions and quantiles; the central tendency of a variable by calculating the mean, median, and mode of data; and the dispersion of data using the range, standard deviation, and IQR.
Bivariate analysis can also be used to understand the relationship between data. Using scatterplots, we can determine trends, changes in trends, periodic behavior, and anomalous points in regard to two variables. We can also use the Pearson correlation coefficient to measure the...