Descriptive Statistics in Social Sciences
Fecha última actualización febrero 2023
Videos
DESCRIBING UNIVARIATE DATA
Videos Unit 3
Tabulation and graphic presentations from the frequency distribution- Video U3-A-1 - Calculation of the complete frequency table/distribution for qualitative variables (nominal and ordinal)
- Video U3-A-2 - Calculation of the complete frequency table/distribution for quantitative variables (discrete and grouped)
- Video U3-A-3 - Graphic presentations 1: pie charts and bar charts
- Video U3-A-4 - Graphic presentations 2: histograms and frequency polygons
Determination of the frequency distribution when the complete data set is available- Auxiliary video - Define names for variables (useful tool for the statistical analysis with Excel functions)
- Video U3-B-1 - Calculation of the absolute frequencies using the COUNTIF() function
- Video U3-B-2 - Calculation of the absolute frequencies grouping data (1): How to create the groups
- Video U3-B-3 - Calculation of the absolute frequencies grouping data (2): How to use the FREQUENCY function
- Video U3-B-4 - Calculation of the absolute frequencies grouping data (3): Application of the FREQUENCY() function
Videos Unit 4
Calculation of location measures from the frequency distribution- Video U4-A-1 - Calculation of location measures from the frequency distribution: the mode
- Video U4-A-2 - Calculation of location measures from the frequency distribution: the median and quantiles
- Video U4-A-3 - Calculation of location measures from the frequency distribution: the average
Calculation of location measures when the complete data set is available
- Video U4-B-1 - Calculation of location measures using Excel functions for qualitative and quantitative discrete variables: Functions MODE.SNGL(); MEDIAN(); AVERAGE()
- Video U4-B-2 - Calculation of location measures using Excel functions for quantitative continuous variables: Functions MODE.SNGL(); MEDIAN(); AVERAGE(); QUARTILE.INC() and PERCENTILE.INC()
Videos Unit 5
Calculation of dispersion and shape measures from the frequency distribution- Video U5-A-1 - Calculation of dispersion measures using the frequency distribution
- Video U5-A-2 - Analysis of the shape using the frequency distribution
Calculation of dispersion and shape measures when the complete data set is available. Analysis of outliers
- Video U5-B-1 - Calculation of dispersion measures using Excel functions: Functions VAR.P() and STDEV.P()
- Video U5-B-2 - Analysis of the shape using Excel functions: Functions SKEW.P() and KURT(). Statistic charts: Histogram
- Video U5-B-3 - Detection of outliers. Statistic charts: Box-plot
DESCRIBING BIVARIATE DATA
Videos Unit 6
Describing bivariate data. Frequency distributions and graphic presentations- Video U6-1 - Calculation of the bivariate joint relative frequency distribution and the marginal distributions
- Video U6-2 - Calculation of the conditional distributions: column and row profiles
- Video U6-3 - Analysis of the statistical independence of two variables
- Video U6-4 - Graphical presentations of bivariate data
- Video U6-5 - Calculation of numerical measures from the bivariate joint frequency distribution
Videos Unit 7
Correlation and linear regresion model- Video U7-1 - Correlation analysis: scatter plot, COVARIANCE.P, CORREL and PEARSON functions
- Video U7-2 - Linear regression model. Estimation. INTERCEPT and SLOPE functions
- Video U7-3 - Linear regression model. Goodness of fit. RSQ function. Residuals plot
- Video U7-4 - Linear regression model. Predictions and reliability
Videos Unit 8
Non-linear regression models- Video U8-1 - Non-linear regression models. Logarithmic regression model.
- Video U8-2 - Non-linear regression models. Exponential regression model.
- Video U8-3 - Non-linear regression models. Power regression model.