MBA60 Advanced Quantitative Methods For Managers1

Subject 1:

• The process starts with description of co linearity among  independent variables. The independent variables and correlation between them can be depicted here:

The highlighted correlation is greater then 0.8. Therefore, the variable has to be removed from the dataset and it can be said that the rest of the variables are not dangerously correlated. Regression analysis on the dependent variable and the rest three of the independent variable is given below:

It can be said from the table that the regression fit is good fit but the co-efficient table shows that variable 3  has a p-value higher then 0.01. Therefore, the variabl that is D1 has to deleted from the data table. Regression test with the same dependent variable and with those same independent variables other than D1 is given below:

It can be said from the table that the regression fit is quite good here and the p-values of the co-efficient falls under 0.01. The regression analysis can be interpreted as the ultimate model here with all the variables falling in line. Therefore, the required regression equation is :

Y= (0.75)*KCAPITAL + (146.79)*Labor + (8054.21)*D2.  

• Co-efficient of KCAPITAL is the average increase in the dependent variable with the per unit increase in KCAPITA with Labor keft fixed. Co-efficient of Labor is the average increase in the dependent variable with the per unit increase in Labor keeping KCAPITAL fixed. D1 is categorical variable. Therefore, coefficient of D1 is the average change in y with every category of D1. The coefficient of KCAPITAl can be challenged here since it can be said that capital has a much larger effect in business. Again, the sign can be challenged here regarding Labor since a large number of Labor can have a negative impact.  The coefficient can also be lowered regarding Labor. The model can be challenged in the lights of these arguments and a new model can be proposed like:

Y= (5)*KCAPITAL – (90)*Labor + (8054.21)*D2.

• Co-efficient of determination is defined as the proportion of variation in the dependent variables that is being interpreted from independent variables.  It can be interpreted here that 68% of variation in industrial production can be explained through Labor, KCAPITAL and D1.

Subject 2:

2.1  The process starts with description of co linearity among  independent variables. The independent variables and correlation between them can be depicted here:

The highlighted correlation is greater then 0.8. Therefore, the variable has to be removed from the dataset and it can be said that the rest of the variables are not dangerously correlated. Regression analysis on the dependent variable and the rest three of the independent variable is given below:

It can be said from the table that the regression fit is good fit but the co-efficient table shows that variable 3  has a p-value higher then 0.01. Therefore, the variabl that is D1 has to deleted from the data table. Regression test with the same dependent variable and with those same independent variables other than D1 is given below:

It can be said from the table that the regression fit is quite good here and the p-values of the co-efficient falls under 0.01. The regression analysis can be interpreted as the ultimate model here with all the variables falling in line. Therefore, required regression equation is :

Y = 0.73 + 0.74*KCAPITAL + 0.30*Labor + 0.29*D2.

2.2. Co-efficient of KCAPITAL is the average increase in the dependent variable with the per unit increase in KCAPITA with Labor keft fixed. Co-efficient of Labor is the average increase in the dependent variable with the per unit increase in Labor keeping KCAPITAL fixed. D1 is categorical variable. Therefore, coefficient of D1 is the average change in y with every category of D1. The coefficient of KCAPITAl can be challenged here since it can be said that capital has a much larger effect in business. Again, the sign can be challenged here regarding Labor since a small number of Labor can have a negative impact.  The coefficient can also be increased regarding Labor. The model can be challenged in the lights of these arguments and a new model can be proposed like:

Y= (5)*KCAPITAL – (90)*Labor + (0.29)*D1.

Subject 3.

It can be checked from the residual plot and the normality plot that the necessary assumptions of residual homoscadasticity and independence are not being met here regarding the log linear model but normality condition is being met. The normality and  homoscadasticity is not being met in the linear model but the residuals are independent here.. The residual plot and normality plot is attached below:

Residual plot for the log linear model.

Normality plot for log linear model.

Residual plot for linear model.

Normality plot for linear model.

1. The independent variable should be choosen here.

De Oliveira, A.B., Fischmeister, S., Diwan, A., Hauswirth, M. and Sweeney, P.F., 2017, March. Perphecy: Performance Regression Test Selection Made Simple but Effective. In Software Testing, Verification and Validation (ICST), 2017 IEEE International Conference on (pp. 103-113). IEEE.

Saha, R.K., Zhang, L., Khurshid, S. and Perry, D.E., 2015, May. An information retrieval approach for regression test prioritization based on program changes. In Software Engineering (ICSE), 2015 IEEE/ACM 37th IEEE International Conference on (Vol. 1, pp. 268-279). IEEE.