Análisis de regresión básica con Excel (Basic Regression Analysis with Excel)

34 Pages Posted: 23 Feb 2006 Last revised: 1 Jul 2012

See all articles by Ignacio Velez-Pareja

Ignacio Velez-Pareja

Grupo Consultor CAV Capital Advisory & Valuation

Date Written: July 19, 2009

Abstract

This is a course material for an introductory course in Probability and Statistics for Engineering and Management. It is part of some course notes for my courses in Spanish on that subject. The draft of the book is Apuntes de Probabilidad y Estadística para Ingeniería y Administración (Notes for Probability and Statistic for Engineering and Management) and this part is Análisis de regresión (Basic Regression Analysis).

In this chapter we present the basic tools for regression analysis. With linear regression analysis we can find models that relate variables linked by causal relationships between given variables. The idea is to use this tool to predict the behavior of some independent variable and other dependent variables.

Before performing any statistical analysis we should examine if there is a logical relationship between independent and dependent variables. This effort is of utmost importance. Calculations are easily made using the computing and inexpensive power of software and computers. To find the possible relationships between variables is a delicate work of observation, intelligent, experience and intuition. All these methods are studied using intensively the spreadsheet.

This material is in Spanish

Keywords: Linear Regression analysis, independent variables, dependent variables

JEL Classification: C11,C12,C13, C20

Suggested Citation

Velez-Pareja, Ignacio, Análisis de regresión básica con Excel (Basic Regression Analysis with Excel) (July 19, 2009). Available at SSRN: https://ssrn.com/abstract=885760 or http://dx.doi.org/10.2139/ssrn.885760

Register

Paper statistics 