Statistics for Enterprise Data Analysis
Code
400089
Academic unit
NOVA Information Management School
Credits
7.5
Teacher in charge
Ana Cristina Marinho da Costa
Teaching language
Portuguese. If there are Erasmus students, classes will be taught in English
Objectives
This curricular unit aims at supplying to the students the theoretical and practical knowledge about methodologies on summarizing data, and parametric and nonparametric statistical inference. Students will explore the core principles of statistics, from both the conceptual and applied perspectives. The students will acquire competences related to descriptive statistics, random variables, sampling and confidence intervals, and hypothesis testing. The students will clearly understand the conditions of applicability of each procedure. The concepts and principles will be applied and discussed using the environment, functions, and visualizations of Microsoft Excel using real-world concepts applicable to many industries, including medical, business, sports, insurance, etc.
Prerequisites
Basic knowledge of Microsoft Excel functions and graphics.
Subject matter
The curricular unit is organized in seven Learning Units (LU):
LU1. Descriptive statistics
- Introduction to statistics
- Organizing information
- Frequency distributions
- Descriptive statistics
- Outliers detection
LU2. Random variables
- Introduction and concepts
- Probabilistic models
- Discrete random variables
- Continuous random variables
LU3. Probability distributions
- Binomial distribution
- Poisson distribution
- Normal distribution
- Approximation of the Binomial distribution to Normal
LU4. Sampling and sampling distributions
- Introduction and concepts
- Non-probabilistic sampling designs
- Probabilistic sampling designs
- Sampling statistics and sampling distributions
- Distribution of the sampling mean
- Distribution of the sampling proportion
LU5. Interval estimation
- Confidence intervals for the mean
- Confidence intervals for the difference between means
- Confidence intervals for the proportion
- Confidence intervals for the difference between proportions
- Sample size determination
LU6. Hypothesis testing
- Concepts and methodology
- Hypothesis testing for the mean
- Hypothesis testing for the difference between means
- Hypothesis testing for the ration between variances
- Hypothesis testing for the proportion
- Hypothesis testing for the difference between proportions
- Correlation coefficient
LU7. Nonparametric testing
- Introduction to nonparametric testing
- Distribution fitting tests
- Comparing independent samples
- Comparing paired-samples
- Spearman’s rank correlation test
Bibliography
- Carvalho, A. (2015). Exercícios de Excel para Estatística. FCA – Editora de Informática.
- Conover, W. J. (1999). Practical Nonparametric Statistics. 3rd ed., Wiley.
- Hogg, R. V., Tanis, E. A. (2010). Probability and Statistical Inference. 8th Edition, New Jersey: Pearson/Prentice-Hall.
- Newbold, P., Carlson, W. L., Thorne, B. (2012). Statistics for Business and Economics. 8th Edition, Boston: Pearson.
- Pedrosa, A. C. e Gama, S. M. A. (2004). Introdução Computacional à Probabilidade e Estatística. Porto Editora.
Teaching method
The curricular unit is based on theoretical and practical lessons. A variety of instructional strategies will be applied, including lectures, slide show demonstrations, step-by-step applications using Microsoft Excel, questions and answers. The sessions include presentation of concepts and methodologies, solving examples, discussion and interpretation of results. The practical component is geared towards solving problems and exercises, including discussion and interpretation of results. A set of exercises to be completed independently in extra-classroom context is also proposed.
Evaluation method
1st call: Project (25%) + Midterm exam (35%) + End-of-semester exam (40%).
2nd call: Project (25%; not allowed to improve the grade from 1st call) + Exam (75%).