0% found this document useful (0 votes)
22 views5 pages

Econometrics Analysis of Wage Data

Uploaded by

blackninjaonyt
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
22 views5 pages

Econometrics Analysis of Wage Data

Uploaded by

blackninjaonyt
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

INTRODUCTORY ECONOMETRICS ASSIGNMENT

Dhairya Mohan
B.A. Hons. (Economics)
Roll No. 155
Kamit Jhajharia
B.A. Hons. (Economics)
Roll No. 357

Submitted to
Abdul Rahim Ansari
[Link]("wooldridge")
[Link]("dplyr")
[Link]("tidyverse")
library(wooldridge)
library(dplyr)
library(tidyverse)

### 1. Simple Regression Model ###


data("wage1")
view(wage1)
attach(wage1)
Y<-cbind(wage)
X<-cbind(educ)

OLS<-lm(Y~X)
summary(OLS)

Call:
lm(formula = Y ~ X)

Residuals:
Min 1Q Median 3Q Max
-5.3396 -2.1501 -0.9674 1.1921 16.6085
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) -0.90485 0.68497 -1.321 0.187
X 0.54136 0.05325 10.167 <2e-16 ***
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 3.378 on 524 degrees of freedom


Multiple R-squared: 0.1648, Adjusted R-squared: 0.1632
F-statistic: 103.4 on 1 and 524 DF, p-value: < 2.2e-16

### 2. Multiple Linear Regression Model ###


attach(wage1)
A<-cbind(wage)
B<-cbind(educ)
C<-cbind(exper)

OLSM<-lm(A~B+C)
summary(OLSM)

Call:
lm(formula = A ~ B + C)

Residuals:
Min 1Q Median 3Q Max
-5.5532 -1.9801 -0.7071 1.2030 15.8370

Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) -3.39054 0.76657 -4.423 1.18e-05 ***
B 0.64427 0.05381 11.974 < 2e-16 ***
C 0.07010 0.01098 6.385 3.78e-10 ***
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 3.257 on 523 degrees of freedom


Multiple R-squared: 0.2252, Adjusted R-squared: 0.2222
F-statistic: 75.99 on 2 and 523 DF, p-value: < 2.2e-16

### 3. Log Log Model ###


attach(ceosal1)

OLS_log_log<-lm(lsalary~lsales)
summary(OLS_log_log)

Call:
lm(formula = lsalary ~ lsales)

Residuals:
Min 1Q Median 3Q Max
-1.01038 -0.28140 -0.02723 0.21222 2.81128
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 4.82200 0.28834 16.723 < 2e-16 ***
lsales 0.25667 0.03452 7.436 2.7e-12 ***
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 0.5044 on 207 degrees of freedom


Multiple R-squared: 0.2108, Adjusted R-squared: 0.207
F-statistic: 55.3 on 1 and 207 DF, p-value: 2.703e-12

### 4. Lin Log Model ###


OLS_lin_log<-lm(salary~lsales)
summary(OLS_lin_log)

Call:
lm(formula = salary ~ lsales)
Residuals:
Min 1Q Median 3Q Max
-1072.1 -447.6 -222.8 41.7 13702.5

Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) -898.93 771.50 -1.165 0.24529
lsales 262.90 92.36 2.847 0.00486 **
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1
Residual standard error: 1349 on 207 degrees of freedom
Multiple R-squared: 0.03767, Adjusted R-squared: 0.03302
F-statistic: 8.103 on 1 and 207 DF, p-value: 0.004863

### 5. Log Lin Model ###


OLS_log_lin<-lm(lsalary~sales)
summary(OLS_log_lin)

Call:
lm(formula = lsalary ~ sales)

Residuals:
Min 1Q Median 3Q Max
-1.44220 -0.29159 -0.02837 0.28323 2.72487
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 6.847e+00 4.500e-02 152.138 < 2e-16 ***
sales 1.498e-05 3.553e-06 4.217 3.7e-05 ***
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 0.5448 on 207 degrees of freedom


Multiple R-squared: 0.07912, Adjusted R-squared: 0.07467
F-statistic: 17.79 on 1 and 207 DF, p-value: 3.696e-05

### 6. Dummy Variable (ANOVA) ###


attach(wage1)

E<-lm(wage~female)
summary(E)
anova(E)

Call:
lm(formula = wage ~ female)

Residuals:
Min 1Q Median 3Q Max
-5.5995 -1.8495 -0.9877 1.4260 17.8805

Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 7.0995 0.2100 33.806 < 2e-16 ***
female -2.5118 0.3034 -8.279 1.04e-15 ***
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1
Residual standard error: 3.476 on 524 degrees of freedom
Multiple R-squared: 0.1157, Adjusted R-squared: 0.114
F-statistic: 68.54 on 1 and 524 DF, p-value: 1.042e-15
> anova(E)
Analysis of Variance Table

Response: wage
Df Sum Sq Mean Sq F value Pr(>F)
female 1 828.2 828.22 68.537 1.042e-15 ***
Residuals 524 6332.2 12.08
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

### 7. Dummy Variable (ANCOVA) ###


attach(wage1)

G<-lm(wage~married+educ+exper)
summary(G)
[Link](G)

Call:
lm(formula = wage ~ married + educ + exper)
Residuals:
Min 1Q Median 3Q Max
-5.7049 -2.0168 -0.5597 1.2077 15.5241

Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) -3.37293 0.75990 -4.439 1.11e-05 ***
married 0.98945 0.30920 3.200 0.00146 **
educ 0.61285 0.05423 11.300 < 2e-16 ***
exper 0.05688 0.01164 4.888 1.36e-06 ***
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 3.229 on 522 degrees of freedom


Multiple R-squared: 0.2401, Adjusted R-squared: 0.2357
F-statistic: 54.97 on 3 and 522 DF, p-value: < 2.2e-16

> [Link](G)
Df Sum Sq Mean Sq F value Pr(>F)
married 1 375 374.9 35.97 3.76e-09 ***
educ 1 1095 1095.1 105.05 < 2e-16 ***
exper 1 249 249.0 23.89 1.36e-06 ***
Residuals 522 5441 10.4
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Common questions

Powered by AI

The p-value in regression analysis measures the probability of observing the given results, assuming the null hypothesis that the predictors have no effect. A low p-value indicates that the predictor is significantly contributing to the model. In the document, small p-values for coefficients in the regression models (e.g., education p-value < 2e-16, experience p-value 3.78e-10) suggest that these predictors have a significant impact on the dependent variable . Assessing p-values allows for evaluating the effectiveness of each predictor in explaining the variability in output, which is vital for refining models to better capture influential predictors and improve explanatory strength in econometric analyses.

Dummy variables transform categorical data into a numerical format suitable for regression analysis, allowing the capture of categorical impacts on the dependent variable. In socio-economic research, such as analyzing wage disparities, dummy variables reveal insights (e.g., females earning $2.51 less than males, significant with p-value 1.04e-15). They allow for nuanced understanding of categorical effects and enable the testing of specific hypotheses related to group differences. This enhances model explanatory power by making implicit comparisons explicit, thus broadening the scope and depth of socio-economic research by quantitatively analyzing categorical impacts.

In a simple linear regression model using only education as a predictor for wage, the coefficient of education (0.54136) represents the marginal effect of one additional year of education on wage, assuming all other factors are constant. The R-squared value of 0.1648 indicates that roughly 16.48% of the variability in wage can be explained by education alone . In contrast, a multiple linear regression model that includes both education and experience provides a clearer picture by accounting for the combined effects of these predictors. Here, education (0.64427) and experience (0.07010) jointly explain more variance in wage with an R-squared value of 0.2252, suggesting that 22.52% of the variability in wage can be explained by education and experience together . This illustrates the ability of multiple regression models to capture more sources of variation compared to simple regression, leading to potentially more accurate and unbiased estimations.

Including additional variables such as marital status, education, and experience in the regression model increases the model's complexity and explanatory power regarding wage determination. The model's multiple R-squared value increases to 0.2401, indicating that 24.01% of the variability in wages can be explained by these variables collectively . Each variable—married (0.98945), education (0.61285), and experience (0.05688)—has a statistically significant impact on wage, with education being the most influential predictor . This inclusion shifts the model from capturing single-factor impacts to understanding interrelationships and the conjoint influence of multiple factors, leading to more nuanced insights into wage determinants and enhancing the predictive accuracy of the model.

Using a dummy variable to represent gender in the wage equation effectively highlights wage differences between males and females. The coefficient of the dummy variable for female (-2.5118) indicates that, on average, females earn approximately $2.51 less than males, controlling for other factors . The ANOVA approach reveals that this difference is statistically significant, with a p-value of 1.042e-15, suggesting a strong impact of gender on wage differentiation . The R-squared value of 0.1157 indicates that gender explains about 11.57% of the variability in wages. This analysis is crucial to understanding systemic wage disparities and highlights the significance of including gender as a dummy variable to uncover insights in wage determination.

The F-statistic tests whether at least one predictor variable has a significant effect on the dependent variable, beyond what would be expected from random chance. It assesses overall model fit by comparing a model with versus without predictors. In the document, high F-statistics (e.g., 75.99 in multiple regression of wage on education and experience, p-value < 2.2e-16) indicate that the model significantly improves fit compared to a model with no predictors . F-statistics support model selection by highlighting predictive power, making them vital in determining whether to include certain predictors in econometric analyses.

In a lin-log model, the coefficient on the log of sales (262.90) measures the change in the salary for a unit percent change in sales, providing a constant rate of change in the dependent variable . In contrast, a log-lin model uses the coefficient on sales (1.498e-05) to estimate the percentage change in salary for a unit change in sales, offering an elasticity measure that shows how responsive salary is to changes in sales . The choice between these models depends on the research objective: a lin-log model might be preferred if the interest lies in how sensitive salary levels are to percentage changes in sales, which is often insightful for growth trend analyses, whereas a log-lin model is useful when examining relative changes in the context of large datasets where scaling issues must be addressed.

The log-log model is significant in econometric analysis because it estimates elasticity, which measures the percentage change in a dependent variable associated with a percentage change in an independent variable. In the context of the given econometric analysis for estimating salary with respect to sales, the log-log model estimation shows that the elasticity of salary with respect to sales is 0.25667 . This means that a 1% increase in sales is associated with a 0.25667% increase in salary, all else being equal. The log-log model provides a unit-free measure of sensitivity that is often more meaningful than linear coefficients, especially when dealing with growth rates and relative changes .

Interpretation of residuals is crucial as they represent the difference between observed and predicted values, indicating potential model shortcomings. In each model analyzed, residuals provide insights into the model's accuracy and assumptions. For example, the simple regression model shows residuals ranging from -5.34 to 16.61, suggesting significant variance capture gaps . A similar pattern in other models, such as the log-log model with residuals from -1.01 to 2.81, indicates potential non-linearity or heteroscedasticity, meaning that model adjustments or improved specifications might be needed . Analysis of residuals helps diagnose these issues and guides refinements to ensure the model's assumptions are met and improve its predictive capabilities.

R-squared provides a measure of fit by indicating the proportion of variance in the dependent variable explained by the model. Its adequacy lies in being an intuitive summary statistic easily interpretable across models (e.g., R-squared of 0.1648 in the simple regression model of wage using education). However, R-squared has limitations, such as inability to adjust for model complexity or decreasing sensitivity to additional predictors. High values do not necessarily imply causality or the best model choice. Adjusted R-squared compensates for predictor addition, but challenges in overfitting and multicollinearity may still persist in the performed analyses. Thus, while useful, relying solely on R-squared can mislead, and additional diagnostics like residual analysis should guide robust model evaluation.

You might also like