UNIVERSIDAD AUTÓNOMA DEL ESTADO DE HIDALGO

1. UNIVERSIDAD AUTÓNOMA DEL ESTADO DE HIDALGO Instituto de Ciencias Económico Administrativas

2. Área Académica:Comercio Exterior • Tema:Análisis de Correlación • Profesor:Ramiro Cadena Uribe • Periodo:Enero – Junio de 2015

3. Tema: Analysis of relationships between variables on the market Abstract: In the market study is required to understand the relationships between the variables that determine the nature and the tendency of commercial activities. Mathematics offers a very practical tool to know the nature of these relationships, magnitude, direction and thus the behavior of a variable is explained with respect to another or others. Keywords:market, variables, relationships.

4. CorrelationAnalysis The behavior of a variable in the market, as sales can be explained by the behavior of other variables such as: Advertising costs, number of sellers Assigned to a geographic area Parity of the peso against the dollar

5. You need to have an instrument to explain the strength of this relationship, the meaning and the degree of explanation with respect to each other. The descriptive statistics provide an instrument known as “Correlation Coefficient“. Its value ranges from -1 to +1. With the above you can obtain the following information. A negative sign implies a negative relationship. The higher the value of a variable value less than the other. A positive sign implies a positive relationship. If it grows the value of a variable so does the value of the other .

6. There may be a weak or no relationship between the variables, this is detected when the correlation coefficient is zero or close to zero. There is a strong relationship when the values ​​of the correlation coefficient is close to -1 or +1.

7. The coefficient of determination R2 explains the behavior of a variable in terms of another, such that 80 % of sales is due to advertising expenses. This will help the market to detect students who are the real factors in the trade and take timely remedial action.

8. Processing in Excel CorrelationCoefficient R 1. Place the pointer in the cell crossing variables where you want Excel to record the correlation coefficient R. 2. In financial formulas click Correlation Coefficient. 3. A dialog box appears, in the space of the first matrix column select the data of the dependent variable. 4. The following matrix select the data column of the independent variable. 5. Click OK.

9. Excel Rendering Determination Coefficient R2 1. Place the pointer in the cell crossing variables where you want Excel to record the coefficient of determination R2. 2. In financial formulas clicking coefficient R2. 3. A dialog box appears, in the space of the first matrix column select the data of the dependent variable. 4. The following matrix select the data column of the independent variable. 5. Click OK.

10. Example

11. Example

12. Interpretation of Results Advertising sales - costs There is a positive relationship between sales and advertising costs, ie to more advertising costs more sales. There is a middle-relationship between these two variables. The 19.85 % of sales are due to advertising expenses.

13. Interpretation of Results Number of sales - sellers There is a positive relationship between sales and the number of assigned vendors, ie more vendors assigned to more sales. There is a middle-relationship between these two variables. The 19.41 % of sales are explained by the number of vendors.

14. BibliographicReferences Matemáticas Aplicadas a la Administración Economía y Ciencias sociales 4ª. Edición Frank S Budrick Septiembre 2013 Estadística Segunda Edición Murray R Spiegel Ed. Mc Graw Hill