References (6)



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

Ignacio Velez-Pareja

Grupo Consultor CAV Capital Advisory & Valuation

July 19, 2009

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

Note: Downloadable document is in Spanish.

Number of Pages in PDF File: 34

Keywords: Linear Regression analysis, independent variables, dependent variables

JEL Classification: C11,C12,C13, C20

Open PDF in Browser Download This Paper

Date posted: February 23, 2006 ; Last revised: July 1, 2012

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

Contact Information

Ignacio Velez-Pareja (Contact Author)
Grupo Consultor CAV Capital Advisory & Valuation ( email )
Ave Miramar # 18-93 Apt 6A
+573112333074 (Phone)
HOME PAGE: http://cashflow88.com/decisiones/decisiones.html
Feedback to SSRN

Paper statistics
Abstract Views: 5,585
Downloads: 1,216
Download Rank: 11,973
References:  6