Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

PowerPoint Presentation ECON 4510/5510 Unions and Collective Bargaining: Data Assignment 8 Re-run the union wage regression (from data assignment 7) with different combinations of variables until the...

1 answer below »
PowerPoint Presentation
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 8
Re-run the union wage regression (from data assignment 7) with different combinations of variables until the union wage gap is as small as possible.
What factors primarily explain why union and nonunion wages are different?
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 8
See audio instructions for Data Assignment 7 for information about regression analysis, how to install the regression tools in excel, and how to run a regression in excel and interpret the results.
 
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 8
In multivariate regression analysis, when you add an independent variable, you are examining the dependent variable “holding that independent variable constant” (because including that independent variable controls for its effect).

 
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 8
We have reason to believe wages are higher in the northeast and workers in the northeast are more likely to be in unions.
When the independent variables for region of residence are not included in the regression, the unions independent variable picks up the effect of being in a union on wages and some of the effect of region of residence on wages (some of the positive effect of living in the northeast on wages).
When the independent variables for region of residence are included, they pick up the effect of region of residence on wages and the unions independent variable picks up the effect of being in a union on wages (but it does not pick up the effect of region of residence on wages, because the region of residence independent variables pick that up).
 
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 8
In my analysis for this assignment, I adjust the wage regression from assignment 7 by adding independent variables to control for region of residence.
 
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 8
Here are the answers when adding controls for region of residence.
 
         Coefficients    Standard E
or    t Stat    P-value
    Intercept    19.590    0.526    37.233    0.000
    union    2.115    0.578    3.656    0.000
    male    5.502    0.445    12.374    0.000
    black    -6.551    0.534    -12.274    0.000
    hispanic    -4.271    0.633    -6.747    0.000
    northeast    3.542    0.715    4.955    0.000
    south    0.995    0.594    1.675    0.094
    west    3.051    0.719    4.245    0.000
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 8
When holding gender, race/ethnicity, and region of residence constant (e.g., when comparing union and nonunion workers of the same gender and ethnicity in the same region), the union wage premium falls to $2.11.
So, a portion of the reason why union workers earn more than nonunion workers is that union workers are more likely to reside in the regions of the U.S. with higher wages.
 
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 8
Next, I’m going to control for industry of employment in the union wage regression.
 
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 8
Here are the answers when also controlling for industry of employment.
 
         Coefficients    Standard E
or    t Stat    P-value
    Intercept    19.742    0.579    34.109    0.000
    union    1.956    0.581    3.365    0.001
    male    5.736    0.461    12.431    0.000
    black    -6.692    0.534    -12.539    0.000
    hispanic    -4.399    0.632    -6.956    0.000
    northeast    3.621    0.717    5.051    0.000
    south    1.075    0.596    1.805    0.071
    west    3.112    0.722    4.313    0.000
    manufacturing    -0.045    0.681    -0.066    0.948
    trade    -3.245    0.714    -4.543    0.000
    healthcare    1.016    0.652    1.558    0.119
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 8
When holding gender, race/ethnicity, region of residence, and industry constant (e.g., when comparing union and nonunion workers of the same gender and ethnicity in the same region who are in the same industry), the union wage premium falls to $1.95.
So, a portion of the reason why union workers earn more than nonunion workers is that union workers are more likely to work in industries with higher wages.
Answered Same Day Jun 17, 2021

Solution

Komalavalli answered on Jun 18 2021
138 Votes
my Work
    wage    union    hours    male    black    hispanic    age    grade    ma
y    kids    exp    tenure    nonwage    nthest    south    west    u
an    afqt    agriculture    mining    utilities    construction    manufacturing    trade    transportation    information    finance    realestate    professional    management    education    healthcare    entertainment    food    other    government    military        Model 1
    19.1    0    30    0    0    0    55    12    1    3    21.653846154    8.1538461538    79    0    0    1    1    7.3316585987    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1    0    0        SUMMARY OUTPUT
    56.25    0    40    1    0    0    56    16    1    3    36.057692308    23.769230769    90    0    0    0    1    58.976203155    0    0    0    0    0    0    0    0    0    0    0    0    1    0    0    0    0    0    0
    24.03    0    40    0    0    0    58    14    1    3    36.076923077    11.288461538    47    1    0    0    1    -6.117365578    0    0    0    0    0    0    0    0    1    0    0    0    0    0    0    0    0    0    0        Regression Statistics
    40.69    0    40    0    0    0    53    19    0    0    32.557692308    0.2115384615    72.5    1    0    0    1    54.659955497    0    0    0    0    0    0    0    0    1    0    0    0    0    0    0    0    0    0    0        Multiple R    0.03118
    37.95    1    38    1    0    0    59    13    0    0    37.653846154    12.538461538    73    1    0    0    1    40.331658599    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1    0        R Square    0.00097
    65.93    0    35    1    0    0    58    13    0    3    38.173076923    30.423076923    90    0    0    1    1    49.882634422    0    0    0    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0        Adjusted R Square    0.00072
    61.05    0    40    0    0    0    57    17    1    1    36.384615385    26.173076923    90    1    0    0    1    9.8935296296    0    0    0    0    0    0    0    0    0    0    1    0    0    0    0    0    0    0    0        Standard E
or    18.46498
    30    0    32    0    0    0    57    14    1    2    37.826923077    37.807692308    90    1    0    0    0    15.89352963    0    0    0    0    0    0    0    0    0    0    0    0    0    1    0    0    0    0    0        Observations    3926
    90    0    20    0    0    0    56    16    1    2    21.403846154    9.7307692308    90    1    0    0    1    44.976203155    0    0    0    0    0    0    0    0    0    0    1    0    0    0    0    0    0    0    0
    12    0    43    1    0    1    53    12    1    2    31.769230769    1.5576923077    68    0    0    1    1    -3.862044503    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1    0    0    0        ANOVA
    25.71    1    35    0    0    0    58    12    1    1    31.673076923    19.384615385    90    1    0    0    1    10.882634422    0    0    0    0    0    0    0    0    0    0    0    0    1    0    0    0    0    0    0            df    SS    MS    F    Significance F
    62.5    0    40    0    0    0    54    12    1    0    35.769230769    30.519230769    90    1    0    0    1    -19.30447973    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1    0        Regression    1.00    1301.78    1301.78    3.82    0.05
    23.07    0    50    1    0    0    57    12    1    1    38.019230769    10.942307692    88    0    1    0    1    -14.11736558    0    0    0    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0        Residual    3924.00    1337909.34    340.96
    18.07    0    40    1    0    0    57    14    1    2    27.961538462    2.9423076923    90    1    0    0    0    -6.10647037    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1    0        Total    3925.00    1339211.12
    65.38    0    50    1    0    0    54    15    1    2    36.596153846    29.288461538    90    1    0    0    1    8.6955202658    0    0    0    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0
    20    1    40    1    0    0    53    12    1    2    31.673076923    12.634615385    90    1    0    0    1    -13.3400445    0    0    0    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0            Coefficients    Standard E
or    t Stat    P-value    Lower 95%    Upper 95%
    21    0    40    0    0    0    55    12    1    2    19.923076923    11.884615385    90    1    0    0    0    3.1556929293    0    0    0    0    0    0    0    0    0    0    1    0    0    0    0    0    0    0    0        Intercept    25.8    0.3    79.2    0.0    25.1736965244    26.4522280156
    34.96    1    55    1    0    0    57    12    1    0    37.153846154    13.346153846    90    1    0    0    0    28.882634422    0    0    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0        union    1.5    0.8    2.0    0.1    -0.0050226476    2.982575159
    36.84    1    35    0    0    0    58    12    1    5    36.403846154    11.519230769    90    1    0    0    1    37.882634422    0    0    0    0    0    0    0    0    1    0    0    0    0    0    0    0    0    0    0
    80.12    0    60    1    0    0    58    14    0    2    38.961538462    18.173076923    90    0    1    0    1    39.882634422    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0        Model...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here