Public University of Navarre



Castellano | Academic year: 2011/2012 | Previous academic years:  2010/2011 
Bachelor's degree in Economics at the Universidad Pública de Navarra
Course code: 171202 Subject title: STATISTICS I
Credits: 6 Type of subject: Basic Year: 1 Period: 2º S
Department: Statistics and Operative Research
Lecturers:
PANIELLO ALASTRUEY, IRENE   [Mentoring ]

Partes de este texto:

 

Contents

 An introduction to basic statistical concepts on data analysis, such as Descriptive Analysis of Univariate and Bivariate data real data, Description and Analysis of Temporal Data and Index numbers.

Excel will be the usual framework for data analysis. Moreover students will be briefly introduced to the statistical package R commander.

The use of different statistical packages will be fundamental in data analysis.

MiAulario will provide a communication channel between students and instructors.

  • Chapter 1: Introduction to Statistics for Economy and Business: Statistical applications in Business, types of data, data sources.
  • Chapter 2: Analysis of univariate data: frequency tables, graphical representation of data and measures.
  • Chapter 3 : Analysis of bivariate data: contingency tables and regression analysis.
  • Chapter 4: Index numbers: simple and composite indexes, applications and variation rates.
  • Chapter 5: Time series analysis: Numeric and graphical description of temporal data, time series components.

Up

Descriptors

An introduction to basic statistical concepts on data analysis, stressing on the role of Statistics in Economy and Business.

Topics of interest will cover sources of statistical data, data files management; descriptive analysis of univariate and bivariate data real data; description and analysis of temporal data and Index numbers.

The use of different statistical packages will be fundamental in data analysis.

Up

General proficiencies

A) General competencies:

a1) Make use of information and communication technologies.
a2) Oral and written communication skills and team work.

B) Specific competencies:
b1) Identify relevant economic information sources as well as the provided information.
b2) Accurately interpreting specific information.
b3) Use specific criteria to analyze different situations.

Up

Specific proficiencies

Course competencies:

c1) Apply appropriate descriptive techniques to problem resolution by using statistical software.
c2) Make a proper use of basic statistic concepts and notation and apply them to interpret numerical results.
c3) Develop efficient work habits.

Prerequisites: basic mathematical knowledge and computer skills.

Up

Methodology

From a total of 60 hours, 40 will be devoted to theoretical, problems and computer sessions.

The remaining period will be devoted to check  students' individual progress and to evaluate their work. These sessions will be scheduled along the semester.

Being the aim of this course mainly practical, theoretical and computer sessions will be alternated:
a) Theoretical sessions will consist on the exposition of the contents by the instructor. Students will be asked to participate by asking and answering short questions and solving exercises, so they keep their attention in the development of the lesson.
b) Computer sessions will be guided by the instructor. Students will be asked to look for data and make use of the provided software to carry out statistical analysis by using those notions previously introduced during the theoretical sessions.

MiAulario will be used as the course web page.

Up

Evaluation

Aspect Description Characteristics Weight
Computer Sessions Individual In-term tests. Non-recoverable. 25%
Group project Develop a group project; prepare a slide and an oral presentation.


Non-recoverable.
Groups have to submit a draft version prior to the ninth week of the term.
Mandatory attendance to all group presentations.

15%
Final Exam Written exam to be solved using an appropriate statistical software to provide the required data analysis.

Recoverable.
The final exam will take place in a computer room. The precise time and place will be anounced.
Allowed material: Summary of formulas.
Exam duration: 2 - 3 hours.



60%


It will be positively valued to have an active participation and attendance to the scheduled sessions.

(*) Recoverability requirements: Final exam score over 2,5 points and an average in-term test score over 2,5 points.

Up

Agenda

Chapter 1: Introduction to Statistics for Economy and Business: Statistical applications in Business, types of data, data sources.
1.1.- Statistics. Steps of a statistical study and different statistical areas.
1.2.- Enter data into an Excel spreadsheet and other statistical packages.
1.3.- Types of variables and scales of measurement.

Chapter 2: Analysis of univariate data: frequency tables, graphical representation of data and measures.
2.1.-Frequency tables and graphs.
2.2.- Measures of location.
2.3.- Measures of variability.
2.4.- Standarized scores.
2.5.- Skewness and kurtosis.
2.6.- Box-plots and outliers.
2.7.- Measures of concentration: Gini Index.

Chapter 3: Analysis of bivariate data: contingency tables and regression analysis.
3.1.- Contingency tables.
3.2.- Covariance and correlation.
3.3.- Statistical and Functional dependence.
3.4.- Simple linear regression: Least squares method.
3.5.- Non linear regression models.

Chapter 4: Index numbers: simple and composite indexes, applications and variation rates.
4.1.- Introduction. Simple and composite indexes.
4.2.- Properties. Change in base period. Deflation. Participation rates and repercussions.
4.3.- Consumer Price index and other indexes.
4.4.- Variation rates.

Chapter 5: Time series analysis. Numeric and graphical description of temporal data, time series components.
5.1.- Introduction.
5.2.- Graphical analysis of time series.
5.3.- Time series components and seasonal models.
5.4.- Trend analysis and analysis of seasonality.

Up

Bibliography

Access the bibliography that your professor has requested from the Library.


1.- ARNALDOS, F.; DÍAZ, T.; FAURA, U.; MOLERA, L.; PARRA, I. (2003) "Estadística Descriptiva para Economía y Administración de Empresas. Cuestiones tipo test y ejercicios con Microsoft Excel". 2ª edición revisada. Editorial AC-Thomson.


2.- CARRASCAL ARRANZA, U. (2007) “Estadística descriptiva con Microsoft Excel 2007”. Editorial Rama.


3.- LIND; MARCHAL; WATHEN (2008) “Estadística aplicada a los negocios y la economía”. 3ª edición en español (13ª en inglés). Ed. McGraw-Hill Interamericana.


4.- MARTÍN-PLIEGO, F.J. (2004) “Introducción a la estadística económica y empresarial: teoría y práctica”. 3ª edición revisada. Editorial Thomson.

5.- PANIELLO, I.; RIVERA, R.; PORTILLA, M. (2011) "Statistical tools for socioeconomic data analysis", EDS.

6.- PANIELLO, I.; GARCIA, M.; RIVERA, R.; PORTILLA, M.  "Basic Statistics with Microsoft Excel and R-Commander".  Student manual.


Students will be encouraged to use MiAulario. There students will find material for both theoretical lessons and computing lab sessions, together with data files and any recommended additional material.

Up

Languages

English.

Up