Background

            Many human resources professionals, scholars, feminists, and economists tout the addition of women to the U.S. workforce.  Wendell French (2005) speculates in Human Resources Management that the continuous stream of women entering the workforce will explain a 55% increase in total U.S. labor force expansion between the years of 2002 and 2012 (p. 57).  In addition, the percentage of working women continues to increase (French, 2005, p. 57).  As women comprise an increasingly larger share of the labor market, their contributions, education, and effect on the economy warrants discussion.  The aim of this project is to determine the effects of the entrance of larger proportions of increasingly educated women over the age of 25 with 4 years of college on the productivity of non-farm business in the United States, while holding the rate of population growth for this specific class (females over age 25), average number of hours worked, and average salary constant.   This study employs a time-series analysis with observations from 1966 to 2006 included.  Demographic data on education was taken from the U.S. Census Bureau and productivity information from the Bureau of Labor Statistics.    The model (less constants and coefficients is):

OUTPUT = %COLLEGE_FEM + AVG_SAL + AVG_HOURS + POP_GROWTH

            The result or dependent variable, OUTPUT, includes non-farm, seasonally adjusted output per hour.  This variable is calculated using the ratio of the output of goods and services to labor hours required to produce them.  %COLLEGE_FEM, the first independent variable, is the percentage of the female population age 25 and over who have completed 4 years of college and is compiled by the U.S. Census Bureau.   This measure is used because of the established relationship between productivity and higher learning.  If other independent variables are held constant, increases in education should result in a positive change in productivity (Sweetman, 2002 & Saxton, 2000).    AVG_SAL is the real hourly compensation received by employees in non-farming business sectors.  It is seasonally adjusted and indexed to 1992.  This figure is utilized in the formula because wages have become a progressively significant incentive for workers to remain in or become more productive in the workforce.   This being said, a positive relationship between average wages and productivity should exist (Fazzari, 2007).   The average weekly hours spent on the job is another possible predictor of the dependent variable, OUTPUT.  The Census Bureau collects this data from American workers for the Bureau of Labor Statistics.  Many employers make adjustments to the hours which employees work in order to affect changes in productivity (International Labour Office Geneva, 2007).  The additional time spent on the job increases output; essentially this should mean that a positive relationship exists between average hours and productivity, all other independent variables held equal (Skoczylas & Tissot 2004).  Finally, as the population grows so does potential, equilibrium, and per capita output; this should also affect hourly productivity in a positive fashion (Fazzari, 2007).

Discussion of Results

The model was regressed and yielded the following results:

Regression equation is: OUPUT = – 100 + 1.50 %COLLEGE_FEM + 1.27 AVG_SAL + 0.497 AVG_HOURS+ 4.46 POP_GROWTH

DEPENDENT VARIABLE: OUTPUT          ADJUSTED R2 = .9914           n = 41
Independent VariablesCoefficientStudent tSignificance of t
%COLLEGE_FEM1.5009406845.8206335731.20689E-06
AVG_SAL1.26828071812.520262831.1126E-14
AVG_HOURS0.497371683.0528328610.004
POP_GROWTH4.4615960321.1879630820.24262667
Durbin Watson = .802773   

            The focus of this analysis is on the impact of %COLLEGE_FEM on OUTPUT.  As evident above, the Durbin Watson Statistic of .802773 fell into the rejection region, indicating positive autocorrelation.  Autocorrelation occurs when a pattern exists between the error terms due to a variable missing from the analysis.  In this regression, the coefficients of the independent variables are biased to an unknown extent and are not reliable or reportable in a scholarly paper, publication, or report.

            If the Durbin-Watson for this regression had passed, the independent variables %COLLEGE_FEM and AVG_SAL would have been significant at α = .05, .025, .01, .005, and .001.  The variable AVG_HOURS would have shown significance at α = .05, .025, .01, and .005.  However, the independent variable, POP_GROWTH shows inadequate significance with a p value of .2426; this does not meet the criteria of showing significance at the α = .05, or even .10 level; however, it is significant when the sig value is less than or equal to α. 

            The R2 value of 99.2% suggests that the independent variables account for 99.2% of the variation of the outcome; this is often the case in time series regressions, in which one observation builds upon another.  R2 cannot be relied upon since the Durbin-Watson indicates positive autocorrelation.  It is desirable for R2 to be 50% or greater.  The Adj. R2 value of 99.1% is also thought of as a “good” thing, if the Durbin-Watson had passed.  In the case of adjusted R2, this regression indicates that the independent variables explain 99.1% of the variance of the dependent variable.  Both statistics must be less than or equal to one, but greater than or equal to 0.  Often, people rely heavily on the use of R2 and Adj. R2, disregarding the Durbin-Watson test.  Since this analysis is a time series regression, the Durbin-Watson is more valuable to the analyst than the R2 and Adj. R2.  Without a passing Durbin-Watson test for a time-series analysis, both of the preceding are useless, as is the case with this regression.

            Another important consideration when regressing an equation is the presence of multicollinearity.  In this model, there was a complete absence of it.  All pairs of independent variables were regressed, and the resulting R2 from the bivariate regressions compared to the R2 of the entire model.  The results are detailed below:

Regression Statistics % College Females & Avg Salary 
 Multiple R0.960929531  
 R Square0.923385564  
     
Regression Statistics % College Fem & Avg Hours 
 Multiple R0.82176622  
 R Square0.67529972  
     
Regression Statistics for % College Fem & Pop Growth 
 Multiple R0.245677796  
 R Square0.060357579  
     
Regression Statistics for Avg_Sal & Avg_Hours 
 Multiple R0.865413869  
 R Square0.748941165  
     
Regression Statistics Avg_Sal & Pop_Growth 
 Multiple R0.21991564  
 R Square0.048362889  
     
Regression Statistics of Avg_Hours & Pop_Growth 
 Multiple R0.348112319  
 R Square0.121182187  

            As is evident above, the bivariate regressions yield R2 values less than the value of the entire regression.  Multicollinearity happens when two more of the predictors have a linear relationship.  When this occurs, the statistical software package does not know which variable to give the coefficient to.  Often, one coefficient will be near zero while the other coefficient of the collinear variable will be the source of all the affect on the outcome, causing the coefficients to be biased.  The absence of multicollinearity indicates that the coefficients are not biased due to its presence.

            Another useful way to analyze the effect of independent variables on the outcomes is through coefficients.  The coefficients for the model are detailed below:

Independent VariablesCoefficient
%COLLEGE_FEM1.500940684
AVG_SAL1.268280718
AVG_HOURS0.49737168
POP_GROWTH4.461596032
Durbin Watson = .592049 

            The 1.5009 coefficient value for %COLLEGE_FEM indicates that for every one percent increase in the percentage of females who have obtained four years of college, output increases by 1.5009.  1.2682 is the coefficient for the predictor, AVG_SAL and indicates that for every single unit increase in salary, output increases by 1.268.  The .4973 coefficient value for AVG_ HOURS suggests that for 1 hour increase, output is increased by .4973.  POP_GROWTH brings with it a coefficient of 4.4615 indicating that for every 1,000 people that are added to the population, output increases by 4.4616.  While these coefficients indicate a fairly significant relationship there are two things that must first be considered:

  • The Durbin-Watson test failed, which means that the coefficients of the predictors are biased to an unknown extent.
  • In the case of POP_GROWTH, the p value method of hypothesis test indicates that the variable is insignificant. 

Had the Durbin-Watson passed, and the sig value of POP_GROWTH been less than or equal to alpha, the coefficients of the variables would yield the results detailed above.  According to the coefficients, population growth has the most significant effect on the outcome, followed by the percentage of women with 4 years of college, average salary, and finally average hours.   

 

 

Summary

              Unfortunately, the failure of the Durbin-Watson test makes the model biased to an unknown extent.  Unless the missing variable can be found, the results are essentially useless.  If the Durbin-Watson had passed, all variables except POP_GROWTH would be significant predictors of the outcome. This would indicate that as the number of women who have 4 years of college increases, so does output per hour.  In addition, the predictions made in the Background section would prove to be true.   

References

International Labour Office; Geneva, (2007). Working time around the world: Main findings and    policy implications. Retrieved August 29, 2007, from International Labour Office Web    site: http://www.ilo.org/wcmsp5/groups/public/—dgreports/— dcomm/documents/publication/wcms_082838.pdf

Fazzari, (2007, April 17). Retrieved September 2, 2007, from Washington State University, St.             Louis Web site: artsci.wustl.edu/~ec104sf/Lec%20Notes%20104-8.doc

French, W.L. (2005). Human Resources Management. New York: Houghton Mifflin Company.

Saxton, Jim (January 2000). Joint Economic Committee Study. Retrieved September 1, 2007,           from The United States House of Representatives Web site: http://www.house.gov/jec/educ.htm

Skoczylas, L., & B, Tissot (2005). Revisiting Recent Productivity Developments Across OECD Countries. Bank for International Settlements, Retrieved September 2, 2007, from http://www.ifcommittee.org/tissot.pdf.

Sweetman, A. (2002, November 27). Working smarter: Education and productivity. The Review             of Economic Performance and Social Progress, Retrieved September 1, 2007, from http://www.irpp.org/miscpubs/archive/repsp1202/sweetman.pdf

 

Appendix

YearOUPUT%COLLEGE_FEMAVG_SALAVG_HOURSPOP_GROWTH
196663.5855.373.197113.2861.16
196764.6875.675.15111.4151.09
196866.8936.677.778110.7881
196966.9935.878.773110.0130.98
197067.9885.879.842108.2121.17
197170.7035.981.365107.6781.26
197273.0616.383.953107.8851.07
197375.3366.685.479107.5060.95
197474.2086.884.493105.930.91
197576.2217.185.213104.4350.99
197678.7287.487.37104.5620.95
197779.984888.715103.9561.01
197881.0227.990.25103.6181.06
197980.7398.190.249102.9341.1
198080.5798.989.999101.7790.96
198181.6918.690.211101.3810.98
198280.8318.6291.107100.7640.95
198384.4589.266591.109101.6960.91
198486.1219.742991.121102.4030.87
198587.45610.001692.113102.1890.89
198690.15110.098395.175101.1980.92
198790.60812.794895.523101.4290.89
198892.10610.696.675101.1180.91
198992.78311.157895.064101.6120.94
199094.51511.4896.047100.4651.07
199196.0611.8697.41499.6791.08
199210013.11001001.14
1993100.41113.459699.478100.5561.08
1994101.52413.6799.061100.9270.99
1995102.00914.005298.773100.8320.95
1996104.71515.140399.45100.2570.92
1997106.41515.3831100.352100.9550.96
1998109.35416.95104.89100.8670.92
1999112.50816.1107.542101.2680.9
2000115.68916.3111.56100.5141.01
2001118.58316.8112.84899.171.0102
2002123.47317.1915115.09898.9471.0102
2003128.03417.458117.07698.5051.00927
2004131.54217.606118.16698.511.00977
2005134.09717.8933118.9498.3221.0098
2006135.39318.1343119.66498.5551.00975

Minitab Regression Calculation

Worksheet size: 10000 cells.

Welcome to Minitab, press F1 for help.

Regression Analysis: OUPUT versus %COLLEGE_FEM, AVG_SAL, …

The regression equation is

OUPUT = – 100 + 1.50 %COLLEGE_FEM + 1.27 AVG_SAL + 0.497 AVG_HOURS

        + 4.46 POP_GROWTH

Predictor        Coef  SE Coef      T      P

Constant      -100.40    21.17  -4.74  0.000

%COLLEGE_FEM   1.5009   0.2579   5.82  0.000

AVG_SAL        1.2683   0.1013  12.52  0.000

AVG_HOURS      0.4974   0.1629   3.05  0.004

POP_GROWTH      4.462    3.756   1.19  0.243

S = 1.87253   R-Sq = 99.2%   R-Sq(adj) = 99.1%

Analysis of Variance

Source          DF       SS      MS        F      P

Regression       4  16156.6  4039.2  1151.94  0.000

Residual Error  36    126.2     3.5

Total           40  16282.8

Source        DF   Seq SS

%COLLEGE_FEM   1  15517.5

AVG_SAL        1    587.1

AVG_HOURS      1     47.1

POP_GROWTH     1      4.9

Unusual Observations

Obs  %COLLEGE_FEM    OUPUT      Fit  SE Fit  Residual  St Resid

 22          12.8   90.608   94.368   0.617    -3.760     -2.13R

 35          16.3  115.689  120.049   0.587    -4.360     -2.45R

R denotes an observation with a large standardized residual.

Durbin-Watson statistic = 0.802773

Dl = 1.29, which is greater than .802773, signaling the failure of the DW test.    

Test for Multicollinearity   SUMMARY OUTPUT   
    
Regression Statistics % College Females & Avg Salary 
Multiple R0.96092953  
R Square0.92338556  
Adjusted R Square0.92142109  
Standard Error1.18075699  
Observations41  
    
Regression Statistics % College Fem & Avg Hours 
Multiple R0.82176622  
R Square0.67529972  
Adjusted R Square0.66697407  
Standard Error2.43078502  
Observations41  
    
Regression Statistics for % College Fem & Pop Growth 
Multiple R0.2456778  
R Square0.06035758  
Adjusted R Square0.03626418  
Standard Error4.13510486  
Observations41  
    
SUMMARY OUTPUT   
    
Regression Statistics for Avg_Sal & Avg_Hours 
Multiple R0.86541387  
R Square0.74894117  
Adjusted R Square0.74250376  
Standard Error6.26476959  
Observations41  
    
Regression Statistics Avg_Sal & Pop_Growth
Multiple R0.21991564  
R Square0.04836289  
Adjusted R Square0.02396194  
Standard Error12.1970003  
Observations41  
    
Regression Statistics of Avg_Hours & Pop_Growth
Multiple R0.34811232  
R Square0.12118219  
Adjusted R Square0.0986484  
Standard Error3.66430833  
Observations41  

All papers are written by ENL (US, UK, AUSTRALIA) writers with vast experience in the field. We perform a quality assessment on all orders before submitting them.

Do you have an urgent order?  We have more than enough writers who will ensure that your order is delivered on time. 

We provide plagiarism reports for all our custom written papers. All papers are written from scratch.

24/7 Customer Support

Contact us anytime, any day, via any means if you need any help. You can use the Live Chat, email, or our provided phone number anytime.

We will not disclose the nature of our services or any information you provide to a third party.

Assignment Help Services
Money-Back Guarantee

Get your money back if your paper is not delivered on time or if your instructions are not followed.

We Guarantee the Best Grades
Assignment Help Services