Topic outline

  • Descriptive Statistics in Social Sciences



    • Fecha última actualización febrero 2023


  • Teaching staff

    Label: 1

  • Introduction

    Label: 1

  • Syllabus

    Label: 1

  • Classroom material

    Part I: Introduction to Descriptive Statistics

        Notes_U1.  Information sources (pdf)

        Notes_U2.  Basic concepts. Scales of measurement (pdf)

    Part II: Describing Univariate Data

        Notes_U3. Univariate Frequency Distributions and Graphic Presentations (pdf)

        Notes_U4. Numerical measures: Location measures (pdf)

        Notes_U5. Numerical measures: Dispersion and Shape measures (pdf)

    Part III: Describing Bivariate Data

        Notes_U6. Bivariate Frequency Distributions and Graphic Presentations (pdf)

        Notes_U7. Correlation and Simple Linear Regression (pdf)

        Notes_U8. Non-linear Regression Models (pdf)


  • Practices and exercises

    Describing Univariate Data

        Exercises Unit 3. Univariate Frequency Distributions and Graphic Presentations

    • Guide computer practice U3 (pdf)
      • Data computer practice U3 (xls)
      • Answer computer practice U3 (xls)
    • Proposed exercises U3 (pdf)
      • Data proposed exercises U3 (xls)

        Exercises Unit 4. Numerical measures: Location measures

    • Guide computer practice U4 (pdf)
      • Data computer practice U4 (xls)
      • Answer computer practice U4 (xls)
    • Proposed exercises U4 (pdf)
      • Data proposed exercises U4 (xls)

        Exercises Unit 5. Numerical measures: Dispersion and Shape measures

    • Guide computer practice U5 (pdf)
      • Data computer practice U5 (xls)
      • Answer computer practice U5 (xls)
    • Proposed exercises U5 (pdf)
      • Data proposed exercises U5 (xls)


    Describing Bivariate Data

        Exercises Unit 6. Bivariate Frequency Distributions and Graphic Presentations

    • Guide computer practice U6 (pdf)
      • Data computer practice U6 (xls)
      • Answer computer practice U6 (xls)
    • Proposed exercises U6 (pdf)
      • Data proposed exercises U6 (xls)

        Exercises Unit 7. Correlation and Simple Linear Regression

    • Guide computer practice U7 (pdf)
      • Data computer practice U7 (xls)
      • Answer computer practice U7 (xls)
    • Proposed exercises U7 (pdf)
      • Data proposed exercises U7 (xls)

        Exercises Unit 8. Non-linear Regression Models

    • Guide computer practice U8 (pdf)
      • Data computer practice U8 (xls)
      • Answer computer practice U8 (xls)
    • Proposed exercises U8 (pdf)
      • Data proposed exercises U8 (xls)


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

  • Self-assessment tests

    Labels: 12Quizzes: 11Files: 16

  • Other resources

    Some important primary information sources
    Help on the use of Excel for descriptive analysis
    Recommended reading
    • Liengme, B.V. (2000): A guide to Microsoft Excel for Business and Management. Ed. Arnold.
    • Lind, D.; Marchal, W.G. and Wathen, S.A. (2013): Basic Statistics for Business & Economics (15th ed.). McGraw-Hill.
    • Metcalfe, A.V. (2000): Statistics in Management Science. Ed. Arnold.
    • Newbold, P.; Carlson, W.L. and Thorne, B. (2013): Statistics for Business and Economics (8th ed.). Pearson.
    • Siegel, A.F. (2012): Practical Business Statistics. Academic Press.

  • Learning guide


    Learning unit

    Classroom material

    Practices and exercises

    Videos

    Self-assessment

    Unit 1

    N_U1

    -

    -

    -

    Unit 2

    N_U2

    -

    -

    SA_1; SA_2

    Unit 3

    N_U3

    G_P_U3 (guide)
      D_P_U3 (data)
      A_P_U3 (answer)

    Pr_ex_U3 (guide)
      D_ex_U3 (data)

    V_U3_A_1
    V_U3_A_2

    V_U3_A_3

    V_U3_A_4

    V_U3_B_1
    V_U3_B_2

    V_U3_B_3

    V_U3_B_4

    SA_3
    SA_4

    SA_5
    SA_6

    Unit 4

    N_U4

    G_P_U4 (guide)
      D_P_U4 (data)
      A_P_U4 (answer)

    Pr_ex_U4 (guide)
      D_ex_U4 (data)
     

    V_U4_A_1
    V_U4_A_2

    V_U4_A_3

    V_U4_B_1
    V_U4_B_2

    Unit 5

    N_U5

    G_P_U5 (guide)
      D_P_U5 (data)
      A_P_U5 (answer)

    Pr_ex_U5 (guide)
      D_ex_U5 (data)
     

    V_U5_A_1
    V_U5_A_2

    V_U5_B_1
    V_U5_B_2

    V_U5_B_3

    Unit 6

    N_U6

    G_P_U6 (guide)
      D_P_U6 (data)
      A_P_U6 (answer)

    Pr_ex_U6 (guide)
      D_ex_U6 (data)
     

    V_U6_1

    V_U6_2

    V_U6_3

    V_U6_4

    V_U6_5

    V_U6_6

    SA_7
    SA_8

    Unit 7

    N_U7

    G_P_U7 (guide)
      D_P_U7 (data)
      A_P_U7 (answer)

    Pr_ex_U7 (guide)
      D_ex_U7 (data)
     

    V_U7_1

    V_U7_2

    V_U7_3

    V_U7_4

    SA_9
    SA_10
    SA_11

    Unit 8

    N_U8

    G_P_U8 (guide)
      D_P_U8 (data)
      A_P_U8 (answer)

    Pr_ex_U8 (guide)
      D_ex_U8 (data)
     

    V_U8_1

    V_U8_2

    V_U8_3