• ### Descriptive Statistics in Social Sciences

• ### 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.

Practices and exercisesSelf-assessment tests