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 6 Recall the nonunion/union wage ratio. Next, separately calculate average wages for unionized and nonunion...

1 answer below »
PowerPoint Presentation
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 6
Recall the nonunion/union wage ratio.
Next, separately calculate average wages for unionized and nonunion workers in the northeast, midwest, south, and west. Then, recalculate the nonunion/union wage ratio for unionized and nonunion workers in the same region.
Also, separately calculate average wages for unionized and nonunion workers in the manufacturing, trade, and healthcare industries. Then, recalculate the nonunion/union wage ratio for unionized and nonunion workers in the same industry.
How does the nonunion/union wage ratio change when you compare workers in the same region and workers in the same industry?
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 6
The nonunion/union wage ratio in the oversampled data set is about 87 percent.
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 6
To get separately the average wages for unionized workers and nonunionized workers by region, first create new wage variables for each type of worker in each region and then calculate the sample average for each worker category.
Since there are four regions, this will be a total of 8 new wage variables.
The nonunion average wage divided by the average wage for unionized workers will be the nonunion/union wage ratio.
 
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 6
Here is one example: the wage variable is in column A, the union dummy variable is in column B, and the northeast variable is in column N, so the new wage variable for workers in unions in the northeast is calculated as (type—or cut and paste—this command in each row of a new column)
=if(B2=1,if(N2=1,A2,false)).
 
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 6
Here is another example: the wage variable is in column A, the union dummy variable is in column B, the northeast variable is in column N, the south variable is in column O, and the west variable is in column P, so the new wage variable for nonunionized workers in the midwest is calculated as
=if(B2=0,if(N2=0,if(O2=0,if(P2=0,A2,false)))).
 
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 6
Here are the answers using my data:
 
    Variable    Average    Minimum    Maximum
    NortheastUnionWage    24.87    3.00    100.00
    NortheastNonunionWage    21.73    3.00    100.00
    MidwestUnionWage    21.38    3.00    100.00
    MidwestNonunionWage    19.75    3.00    100.00
    SouthUnionWage    21.09    3.00    100.00
    SouthNonunionWage    18.93    3.00    100.00
    WestUnionWage    25.50    3.00    78.52
    WestNonunionWage    22.42    3.00    100.00
    ManufacturingUnionWage    20.41    3.00    44.71
    ManufacturingNonunionWage    21.44    3.00    100.00
    TradeUnionWage    17.41    7.25    45.67
    TradeNonunionWage    17.59    3.00    100.00
    HealthcareUnionWage    20.77    3.00    78.52
    HealthcareNonunionWage    20.19    3.00    100.00
                
    Northeast Nonunion/Union Wage Ratio        0.87    
    Midwest Nonunion/Union Wage Ratio        0.92    
    South Nonunion/Union Wage Ratio        0.90    
    West Nonunion/Union Wage Ratio        0.88    
    Manufacturing Nonunion/Union Wage Ratio        1.05    
    Trade Nonunion/Union Wage Ratio        1.01    
    Healthcare Nonunion/Union Wage Ratio        0.97    
ECON 4510/5510 Unions and Collective Bargaining:
Data Assignment 6
One reason why union workers earn more than nonunion workers on average is that workers in the northeast and west are more likely to be in unions and workers in those areas earn higher wages. Workers in the south are less likely to be in unions and earn lower wages.
So, when comparing union and nonunion workers in the same region, the nonunion/union wage ratio increases (the wage differences decrease) because regional differences in wages are held constant.
The same is true for industry. Some industries with relatively high wages have relatively high rates of unionization. When comparing union and nonunion workers in the same industry, the nonunion/union wage ratio increases (wage differences decrease) because industry differences in pay are held constant.
Answered Same Day Jun 10, 2021

Solution

Komalavalli answered on Jun 10 2021
146 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             NortheastUnionWage     NortheastNonunionWage     MidwestUnionWage     MidwestNonunionWage     SouthUnionWage     SouthNonunionWage     WestUnionWage     WestNonunionWage     ManufacturingUnionWage    ManufacturingNonunionWage     TradeUnionWage     TradeNonunionWage     HealthcareUnionWage     HealthcareNonunionWage         Variables    Average    min    max
    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            FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    19.1    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        NortheastUnionWage     28.84    9.13    100.00
    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            FALSE    FALSE    FALSE    56.25    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        NortheastNonunionWage     30.06    3.00    100.00
    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            FALSE    24.03    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        MidwestUnionWage     24.18    7.83    53.84
    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            FALSE    40.69    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        MidwestNonunionWage     24.86    3.00    100.00
    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            37.95    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        SouthUnionWage     25.57    7.21    96.15
    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            FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    65.93    FALSE    FALSE    FALSE    65.93    FALSE    FALSE        SouthNonunionWage     24.33    3.00    100.00
    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            FALSE    61.05    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        WestUnionWage     30.73    6.97    100.00
    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            FALSE    30    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    30        WestNonunionWage     27.57    3.00    100.00
    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            FALSE    90    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        ManufacturingUnionWage    24.96    8.25    86.53
    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            FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    12    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        ManufacturingNonunionWage     29.58    3.10    100.00
    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            25.71    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        TradeUnionWage     20.06    9.85    44.88
    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            FALSE    62.5    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        TradeNonunionWage     21.20    3.00    100.00
    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            FALSE    FALSE    FALSE    FALSE    FALSE    23.07    FALSE    FALSE    FALSE    FALSE    FALSE    23.07    FALSE    FALSE        HealthcareUnionWage     20.70    6.97    54.00
    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            FALSE    18.07    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        HealthcareNonunionWage     23.84    3.00    100.00
    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            FALSE    65.38    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    65.38    FALSE    FALSE
    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            20    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    20    FALSE    FALSE    FALSE            ratio
    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            FALSE    21    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        Northeast Nonunion/Union Wage Ratio    1.04
    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            34.96    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    34.96    FALSE    FALSE    FALSE    FALSE    FALSE        Midwest Nonunion/Union Wage Ratio    1.03
    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            36.84    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        South Nonunion/Union Wage Ratio    0.95
    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            FALSE    FALSE    FALSE    FALSE    FALSE    80.12    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        West Nonunion/Union Wage Ratio    0.90
    27.02    1    37    1    0    0    58    10    1    1    38.038461538    7.8461538462    42    1    0    0    1    2.6546344221    0    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0            27.02    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        Manufacturing Nonunion/Union Wage Ratio    1.18
    14.42    0    2    0    0    0    58    12    0    3    32.076923077    2.0769230769    52    1    0    0    1    -11.11736558    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1    0    0    0    0            FALSE    14.42    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        Trade Nonunion/Union Wage Ratio    1.06
    40.1    0    45    0    0    0    60    17    1    3    39.038461538    39.288461538    90    1    0    0    1    52.331658599    0    0    0    0    0    0    0    1    0    0    0    0    0    0    0    0    0    0    0            FALSE    40.1    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE    FALSE        Healthcare Nonunion/Union Wage...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here