## Topic outline

• Label: 1

Label: 1

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