R-C2 Assign
Sheet1
| Correlations | ||||||||||||||||||||
| Age | Yearsindept | Roleambiguity | Roleconflict | Taskconflict | Relationshipconflict | Politicalperceptions | Rank | Sex | salary | level | tch_rating | minority | admin_resp | Science | degree_tier | pub_prestige | fault | |||
| Yearsindept | 0.78 | |||||||||||||||||||
| Roleambiguity | -0.08 | -0.05 | ||||||||||||||||||
| Roleconflict | -0.05 | -0.00 | 0.50 | |||||||||||||||||
| Taskconflict | -0.06 | -0.02 | 0.25 | 0.44 | ||||||||||||||||
| Relationshipconflict | -0.04 | 0.01 | 0.35 | 0.41 | 0.70 | |||||||||||||||
| Politicalperceptions | -0.10 | -0.11 | 0.34 | 0.50 | 0.54 | 0.63 | ||||||||||||||
| Rank | 0.51 | 0.48 | -0.12 | -0.01 | -0.04 | -0.01 | -0.10 | |||||||||||||
| Sex | -0.13 | -0.17 | 0.02 | -0.04 | 0.02 | 0.05 | 0.01 | -0.16 | ||||||||||||
| salary | 0.54 | 0.63 | -0.08 | 0.00 | -0.02 | 0.01 | -0.10 | 0.68 | -0.19 | |||||||||||
| level | 0.61 | 0.67 | -0.10 | -0.01 | -0.06 | -0.02 | -0.11 | 0.81 | -0.17 | 0.68 | ||||||||||
| tch_rating | -0.07 | -0.08 | -0.03 | -0.01 | 0.01 | -0.00 | 0.02 | -0.08 | -0.02 | -0.16 | -0.01 | |||||||||
| minority | 0.01 | -0.00 | -0.04 | -0.04 | 0.04 | 0.02 | 0.02 | -0.02 | -0.03 | 0.16 | -0.01 | -0.01 | ||||||||
| admin_resp | 0.31 | 0.38 | -0.05 | 0.02 | 0.06 | 0.03 | -0.10 | 0.40 | -0.14 | 0.38 | 0.37 | 0.02 | -0.13 | |||||||
| Science | -0.15 | -0.17 | 0.01 | -0.01 | -0.07 | -0.04 | -0.01 | -0.18 | 0.09 | -0.16 | -0.22 | -0.03 | 0.20 | -0.16 | ||||||
| degree_tier | -0.03 | 0.04 | -0.02 | 0.01 | -0.01 | 0.01 | 0.04 | -0.19 | -0.03 | 0.13 | -0.22 | -0.02 | 0.14 | 0.06 | 0.14 | |||||
| pub_prestige | 0.49 | 0.58 | -0.09 | 0.02 | 0.00 | 0.01 | -0.06 | 0.67 | -0.16 | 0.77 | 0.49 | -0.01 | 0.06 | 0.49 | -0.18 | 0.13 | ||||
| fault | 0.03 | 0.03 | 0.02 | 0.01 | 0.03 | 0.02 | -0.02 | -0.00 | -0.07 | 0.07 | 0.04 | 0.01 | 0.01 | 0.04 | -0.00 | 0.02 | 0.04 | |||
| blame | 0.01 | 0.04 | 0.05 | 0.04 | 0.04 | 0.01 | 0.05 | 0.05 | -0.06 | 0.05 | 0.06 | -0.01 | 0.08 | 0.06 | -0.02 | -0.03 | 0.04 | 0.09 | ||
Sheet2
| Variable | Scale | Measure |
| Age | interval | years |
| Years in dept | interval | years |
| Role ambiguity | interval | Six items, adapted from Rizzo, House, and Lirtzman (1970), were used to measure role ambiguity. Respondents were required to indicate the extent to which they agreed with each statement, using a 7-point Likert-type scale ranging from 1 = disagree strongly to 7 = agree strongly. |
| Role conflict | interval | Role conflict was also measured using eight items from Rizzo et al. (1970), |
| Task conflict | interval | Rahim’s (1983) eight-item intragroup organizational conflict scale. four items (e.g., “there is friendliness among members of my department,” reverse coded) were found to load on a factor which we labeled relationship conflict |
| Relationship conflict | interval | Rahim’s (1983) eight-item intragroup organizational conflict scale. three items (e.g., “there is difference of opinion among members of department”) loaded on a second factor labeled task conflict, |
| Political perceptions | interval | A 13-item measure of political activity within a respondent’s academic department was used...designed to capture the context-specific nature of academic politics (cf. Johns 2001; Rousseau & Fried, 2001). |
| Rank | ordinal | 1= low; 2= medium; 3=high |
| Sex | dummy | 0=male; 1=female |
| salary | interval | dollars |
| level | ordinal | 1=assistant professor; 2=associate professor; 3=full professor; 4= chaired professor |
| tch_rating | interval | average rating across classes, low to high |
| minority | dummy | 0=minority; 1=non-minority |
| admin_resp | dummy | 0=no administrative responsibilities; 1=some administrative responsibilities |
| Science | dummy | 0=in sciences; 1=not in sciences |
| degree_tier | dummy | 0=degree is not from top-tier university; 1=degree is from top-tier university |
| pub_prestige | interval | index of prestige of publication record, low to high |
| fault | interval | degree to which respondent is regarded to be at fault in recent crisis |
| blame | interval | degree to which respondent was actively blamed for recent crisis |
descriptives
| Descriptive Statistics | |||||||
| N | Range | Minimum | Maximum | Mean | Std. Deviation | ||
| Statistic | Statistic | Statistic | Statistic | Statistic | Std. Error | Statistic | |
| Age | 620.00 | 45.26 | 26.01 | 71.27 | 48.28 | 0.34 | 8.52 |
| Yearsindept | 620.00 | 41.43 | 1.00 | 42.43 | 16.32 | 0.32 | 7.88 |
| salary | 619.00 | 186350.00 | 25916.00 | 212266.00 | 61955.79 | 1240.29 | 30858.05 |
| tch_rating | 619.00 | 5.08 | 5.58 | 10.66 | 9.74 | 0.03 | 0.67 |
| pub_prestige | 619.00 | 4.40 | 1.60 | 6.00 | 3.31 | 0.05 | 1.14 |
| Valid N (listwise) | 619.00 |
frequencies
| Sex | |||||
| Frequency | Percent | Valid Percent | Cumulative Percent | ||
| Valid | 0 | 262 | 40.6 | 42.3 | 42.3 |
| 1 | 358 | 55.5 | 57.7 | 100 | |
| Total | 620 | 96.1 | 100 | ||
| Missing | System | 25 | 3.9 | ||
| Total | 645 | 100 | |||
| level | |||||
| Frequency | Percent | Valid Percent | Cumulative Percent | ||
| Valid | 1 | 320 | 49.6 | 51.7 | 51.7 |
| 2 | 139 | 21.6 | 22.5 | 74.2 | |
| 3 | 80 | 12.4 | 12.9 | 87.1 | |
| 4 | 80 | 12.4 | 12.9 | 100 | |
| Total | 619 | 96 | 100 | ||
| Missing | System | 26 | 4 | ||
| Total | 645 | 100 | |||
| Minority | |||||
| Frequency | Percent | Valid Percent | Cumulative Percent | ||
| Valid | 0 | 155 | 24 | 25 | 25 |
| 1 | 464 | 71.9 | 75 | 100 | |
| Total | 619 | 96 | 100 | ||
| Missing | System | 26 | 4 | ||
| Total | 645 | 100 | |||
| admin_resp | |||||
| Frequency | Percent | Valid Percent | Cumulative Percent | ||
| Valid | 0 | 159 | 24.7 | 25.7 | 25.7 |
| 1 | 460 | 71.3 | 74.3 | 100 | |
| Total | 619 | 96 | 100 | ||
| Missing | System | 26 | 4 | ||
| Total | 645 | 100 | |||
| Science | |||||
| Frequency | Percent | Valid Percent | Cumulative Percent | ||
| Valid | 0 | 171 | 26.5 | 27.6 | 27.6 |
| 1 | 448 | 69.5 | 72.4 | 100 | |
| Total | 619 | 96 | 100 | ||
| Missing | System | 26 | 4 | ||
| Total | 645 | 100 | |||
| degree_tier | |||||
| Frequency | Percent | Valid Percent | Cumulative Percent | ||
| Valid | 0 | 480 | 74.4 | 77.4 | 77.4 |
| 1 | 140 | 21.7 | 22.6 | 100 | |
| Total | 620 | 96.1 | 100 | ||
| Missing | System | 25 | 3.9 | ||
| Total | 645 | 100 | |||
multiple linear
| Coefficientsa | ||||||||||
| Model | Unstandardized Coefficients | Standardized Coefficients | t | Sig. | 95.0% Confidence Interval for B | Collinearity Statistics | ||||
| B | Std. Error | Beta | Lower Bound | Upper Bound | Tolerance | VIF | ||||
| 1 | (Constant) | 55618.412 | 10063.462 | 5.527 | 0 | 35855.047 | 75381.778 | |||
| Age | -53.673 | 113.521 | -0.015 | -0.473 | 0.637 | -276.613 | 169.267 | 0.383 | 2.613 | |
| Yearsindept | 77.973 | 139.666 | 0.02 | 0.558 | 0.577 | -196.313 | 352.26 | 0.299 | 3.35 | |
| Sex | -1929.021 | 1236.022 | -0.031 | -1.561 | 0.119 | -4356.413 | 498.371 | 0.953 | 1.05 | |
| level | 13213.781 | 838.391 | 0.459 | 15.761 | 0 | 11567.288 | 14860.274 | 0.44 | 2.271 | |
| tch_rating | -7016.031 | 902.403 | -0.151 | -7.775 | 0 | -8788.236 | -5243.825 | 0.984 | 1.016 | |
| minority | 7428.059 | 1447.509 | 0.104 | 5.132 | 0 | 4585.335 | 10270.784 | 0.902 | 1.108 | |
| admin_resp | -3864.562 | 1632.358 | -0.055 | -2.367 | 0.018 | -7070.307 | -658.817 | 0.698 | 1.433 | |
| Science | -932.651 | 1412.487 | -0.014 | -0.66 | 0.509 | -3706.596 | 1841.294 | 0.89 | 1.124 | |
| degree_tier | 10797.654 | 1576.196 | 0.147 | 6.85 | 0 | 7702.206 | 13893.103 | 0.816 | 1.225 | |
| pub_prestige | 14475.222 | 717.333 | 0.533 | 20.179 | 0 | 13066.471 | 15883.973 | 0.534 | 1.872 | |
| a. Dependent Variable: salary |
stepwise regression
| Coefficientsa | ||||||||||
| Model | Unstandardized Coefficients | Standardized Coefficients | t | Sig. | 95.0% Confidence Interval for B | Collinearity Statistics | ||||
| B | Std. Error | Beta | Lower Bound | Upper Bound | Tolerance | VIF | ||||
| 1 | (Constant) | -7092.459 | 2445.930 | -2.900 | .004 | -11895.815 | -2289.103 | |||
| pub_prestige | 20857.341 | 698.823 | .769 | 29.846 | .000 | 19484.981 | 22229.700 | 1.000 | 1.000 | |
| 2 | (Constant) | -11155.955 | 2071.690 | -5.385 | .000 | -15224.386 | -7087.524 | |||
| pub_prestige | 15622.185 | 672.084 | .576 | 23.244 | .000 | 14302.332 | 16942.038 | .764 | 1.309 | |
| level | 11436.257 | 713.216 | .397 | 16.035 | .000 | 10035.628 | 12836.886 | .764 | 1.309 | |
| 3 | (Constant) | 59404.027 | 9581.587 | 6.200 | .000 | 40587.429 | 78220.624 | |||
| pub_prestige | 15586.934 | 643.651 | .574 | 24.216 | .000 | 14322.913 | 16850.955 | .764 | 1.309 | |
| level | 11421.488 | 683.028 | .397 | 16.722 | .000 | 10080.138 | 12762.837 | .764 | 1.309 | |
| tch_rating | -7230.154 | 960.530 | -.156 | -7.527 | .000 | -9116.471 | -5343.838 | 1.000 | 1.000 | |
| 4 | (Constant) | 56894.372 | 9184.953 | 6.194 | .000 | 38856.639 | 74932.104 | |||
| pub_prestige | 14213.666 | 643.254 | .524 | 22.097 | .000 | 12950.421 | 15476.911 | .702 | 1.425 | |
| level | 13154.225 | 693.974 | .457 | 18.955 | .000 | 11791.374 | 14517.075 | .679 | 1.472 | |
| tch_rating | -7110.893 | 920.294 | -.153 | -7.727 | .000 | -8918.198 | -5303.589 | 1.000 | 1.000 | |
| degree_tier | 11748.232 | 1567.782 | .159 | 7.494 | .000 | 8669.366 | 14827.098 | .873 | 1.146 | |
| 5 | (Constant) | 51185.897 | 9016.864 | 5.677 | .000 | 33478.206 | 68893.588 | |||
| pub_prestige | 14065.630 | 628.076 | .518 | 22.395 | .000 | 12832.188 | 15299.073 | .701 | 1.427 | |
| level | 13179.534 | 677.028 | .458 | 19.467 | .000 | 11849.957 | 14509.111 | .679 | 1.472 | |
| tch_rating | -7062.405 | 897.843 | -.152 | -7.866 | .000 | -8825.626 | -5299.184 | 1.000 | 1.000 | |
| degree_tier | 10645.263 | 1541.788 | .144 | 6.904 | .000 | 7617.435 | 13673.090 | .859 | 1.164 | |
| minority | 7908.283 | 1394.769 | .111 | 5.670 | .000 | 5169.178 | 10647.388 | .977 | 1.023 | |
| 6 | (Constant) | 51215.602 | 8987.231 | 5.699 | .000 | 33566.048 | 68865.156 | |||
| pub_prestige | 14628.716 | 674.293 | .539 | 21.695 | .000 | 13304.506 | 15952.925 | .604 | 1.656 | |
| level | 13470.290 | 687.094 | .468 | 19.605 | .000 | 12120.942 | 14819.638 | .655 | 1.527 | |
| tch_rating | -6992.587 | 895.431 | -.151 | -7.809 | .000 | -8751.076 | -5234.098 | .998 | 1.002 | |
| degree_tier | 10934.901 | 1542.115 | .148 | 7.091 | .000 | 7906.423 | 13963.380 | .853 | 1.173 | |
| minority | 7288.134 | 1417.307 | .102 | 5.142 | .000 | 4504.757 | 10071.510 | .940 | 1.063 | |
| admin_resp | -3657.811 | 1627.647 | -.052 | -2.247 | .025 | -6854.262 | -461.359 | .701 | 1.426 | |
| a. Dependent Variable: salary |
stepwise last iteration
| Coefficientsa | ||||||||||
| Model | Unstandardized Coefficients | Standardized Coefficients | t | Sig. | 95.0% Confidence Interval for B | Collinearity Statistics | ||||
| B | Std. Error | Beta | Lower Bound | Upper Bound | Tolerance | VIF | ||||
| 6 | (Constant) | 51215.602 | 8987.231 | 5.699 | .000 | 33566.048 | 68865.156 | |||
| pub_prestige | 14628.716 | 674.293 | .539 | 21.695 | .000 | 13304.506 | 15952.925 | .604 | 1.656 | |
| level | 13470.290 | 687.094 | .468 | 19.605 | .000 | 12120.942 | 14819.638 | .655 | 1.527 | |
| tch_rating | -6992.587 | 895.431 | -.151 | -7.809 | .000 | -8751.076 | -5234.098 | .998 | 1.002 | |
| degree_tier | 10934.901 | 1542.115 | .148 | 7.091 | .000 | 7906.423 | 13963.380 | .853 | 1.173 | |
| minority | 7288.134 | 1417.307 | .102 | 5.142 | .000 | 4504.757 | 10071.510 | .940 | 1.063 | |
| admin_resp | -3657.811 | 1627.647 | -.052 | -2.247 | .025 | -6854.262 | -461.359 | .701 | 1.426 | |
| a. Dependent Variable: salary |