Docstoc

Startup Equity Spreadsheet

Document Sample
Startup Equity Spreadsheet Powered By Docstoc
					c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                           printed on 8/19/2011


Table 1. Number and Percent of STEM Women Faculty by Department, 2003-2004

          Division/Department

          Natural Sciences                             Women        Men        Total % Women
                    Biological Sciences                     7             13        20    35
                    Chemistry                               7             13        20    35
                    Computer Science                        3              7        10    30
                    Mathematics and Statistics              4             14        18    22
                    Physics and Astronomy                   1             10        11     9
                    All Natural Sciences                   22             57        79    28


          Social Sciences                              Women        Men        Total % Women
                     Anthropology                           5             12        17    29
                     Economics                              5             11        16    31
                     Geography                              7              6        13    54
                     Political Science                      7              8        15    47
                     Psychology                            14             13        27    52
                     Sociology                              6             11        17    35
                     All Social Sciences                   44             61      105     42


          All Science Faculty                                 66       118        184         36


Note: These tables were created using data retrieved from the City University Personnel System
(CUPS) database by Gowrie Kamintzky in Hunter College's Department of Human Resources on 1
December 2004. The data include all promotions and hires through 1 December 2004. Only full-time
tenured or tenure-track faculty who were employed at Hunter 01 July 2003 - 30 June 2004 were
included in the analyses. Distinguished Professors were added to the Full Professor category for
analysis.




HR-IR 1                                                                                                         1 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                                                               printed on 8/19/2011


Table 2. Number and Percent of STEM Women in Tenure-line Positions by Rank and
Department, 2003-2004

          Division/Department

                                                          Women                                Men                               % Women
          Natural Sciences                     Assistant Associate     Full        Assistant Associate     Full        Assistant Associate      Full
                  Biological Sciences                  0         3             4           3         3             7           0       50              36
                  Chemistry                            3         1             3           2         2             9          60       33              25
                  Computer Science                     0         0             3           2         3             2           0         0             60
                  Mathematics and Statistics           0         1             3           1         5             8           0       17              27
                  Physics and Astronomy                1         0             0           1         2             7          50         0              0
                  All Natural Sciences                 4         5            13           9        15            33          31       25              28


                                                            Women                                Men                               % Women
          Social Sciences                      Assistant   Associate   Full        Assistant   Associate   Full        Assistant   Associate    Full
                  Anthropology                         2           1           2           3           2           7          40         33            22
                  Economics                            3           0           2           3           3           5          50           0           29
                  Geography                            5           2           0           2           0           4          71        100             0
                  Political Science                    2           3           2           0           4           4        100          43            33
                  Psychology                           2           6           6           5           1           7          29         86            46
                  Sociology                            1           2           3           1           4           6          50         33            33
                  All Social Sciences                 15          14          15          14          14          33          52         50            31

          All Science Faculty                        19          19           28         23          29           66         45         40             30


Note: These tables were created using data retrieved from the City University Personnel System
(CUPS) database by Gowrie Kamintzky in Hunter College's Department of Human Resources on 1
December 2004. The data include all promotions and hires through 1 December 2004. Only full-time
tenured or tenure-track faculty who were employed at Hunter 01 July 2003 - 30 June 2004 were
included in the analyses. Distinguished Professors were added to the Full Professor category for
analysis.




HR-IR 2                                                                                                                                                2 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                              printed on 8/19/2011


Table 3a. Median Years in Rank for STEM Faculty by Sex (All Sciences), 2003-2004

    Degree Year

                                                         Women                              Men
                                            Assistant   Associate    Full     Assistant   Associate     Full
                              Mean                6.9        15.1      23.5         4.1        10.9       25.9
                              Median              8.0        11.0      25.5         4.2         9.0       27.5
                   <= 1964
                              (s.d.)              2.2        11.4         7.2       1.1         7.9          8.9
                              N (Current)       3 (0)       4 (1)     3 (3)       4 (0)       5 (0)      8 (8)
                              Mean                3.8        19.0      13.0         4.1        11.0       21.1
                              Median              3.8        19.0      13.0         4.3         7.5       21.5
                  1965-1969
                              (s.d.)              0.7        11.3         9.2       1.0         8.6          7.2
                              N (Current)       2 (0)       2 (0)     2 (2)      13 (0)      14 (1)    15 (15)
                              Mean                4.6        14.0      16.6         5.4        11.1       16.9
                              Median              4.3         7.3      16.9         4.3         7.5       17.3
                  1970-1974
                              (s.d.)              0.5        12.0         4.9       6.3         8.5          4.8
                              N (Current)       4 (0)       7 (3)     6 (6)      16 (1)      16 (4)    16 (16)
                              Mean                5.4        10.3      11.0         4.5        10.5       11.9
                              Median              4.9        10.5      10.5         4.3         7.2       12.5
                  1975-1979
                              (s.d.)              1.4         5.9         5.6       1.0         6.6          5.6
                              N (Current)      11 (0)      14 (3)   11 (11)      10 (0)      16 (5)    13 (13)
                              Mean                5.2         9.1      10.4         5.0         6.5          8.1
     All Hunter               Median              5.3         6.7      10.5         4.3         6.0          8.5
                  1980-1984
     Sciences                 (s.d.)              0.7         5.2         1.8       1.6         3.2          4.0
                              N (Current)       4 (0)       6 (2)     5 (5)       7 (0)       8 (2)      7 (7)
                              Mean                4.0         7.7         2.5       6.4         7.4          3.8
                              Median              4.3         6.7         2.5       4.3         6.7          4.0
                  1985-1989
                              (s.d.)              1.1         4.1                   5.3         3.0          2.2
                              N (Current)       3 (1)       4 (3)     1 (1)       9 (4)      10 (4)      6 (6)
                              Mean                4.3         4.7                   4.7         3.9          0.8
                              Median              4.3         5.5                   4.3         3.8          0.8
                  1990-1994
                              (s.d.)              2.9         2.3                   2.3         2.6
                              N (Current)       7 (1)       6 (6)                 7 (1)       9 (9)      1 (1)
                              Mean                2.8         0.5                   3.2         1.0
                              Median              2.3         0.5                   3.6         0.5
                  1995-1999
                              (s.d.)              2.0                               1.3         1.0
                              N (Current)     12 (11)       1 (1)               14 (10)       4 (4)
                              Mean                1.5                               2.3
                              Median              0.8                               2.8
                  2000-2004
                              (s.d.)              1.2                               1.4
                              N (Current)       6 (6)                             7 (7)

    Note: These tables were created using data retrieved from the City University Personnel System (CUPS)
    database by Gowrie Kamintzky in Hunter College's Department of Human Resources on 1 December
    2004. Only full-time tenured or tenure-track faculty who were employed at Hunter 01 July 2003 - 30 June
    2004 were included in the analyses. Distinguished Professors were added to the Full Professor category
    for analysis.
    Note: Median years in rank includes the time spent in rank for all current faculty as of 30 June 2004. N
    indicates the number of 2003-2004 science faculty members from that degree range who have ever held
    that particular rank. (Current) indicates the number of faculty members in that rank on 30 June 2004.
    Example: A female Assistant Professor who finished her degree in 1992, was hired 1 September 1992,
    and promoted to Associate Professor on 1 January 1998, would be represented in both the Assistant and
    Associate columns for women in degree year 1990-1994. She would be represented in () for her current
    rank of Associate Professor only. Her full 6.3 years as an Assistant contribute to the median of 4.3 and
    the 6.5 years she has currently been an Associate contribute to the median of 5.5.


HR-IR 3a                                                                                                           3 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                          printed on 8/19/2011


Table 3b. Median Years in Rank for STEM Faculty by Sex (by Division), 2003-2004

     Degree Year

                                                     Women                              Men
                                          Assistant Associate      Full     Assistant Associate      Full
                            Mean                6.2      17.5         19.2        3.8      12.5         20.7
                            Median              6.2      14.0         20.5        4.3       5.0         21.4
                  <= 1969
                            (s.d.)              2.2      11.2         10.3        0.8      10.3           8.5
                            N (Current)       4 (0)     6 (1)        4 (4)     10 (0)    11 (1)      13 (13)
                            Mean                4.4       8.6         10.1        6.1      11.6         14.7
                            Median              4.3       8.7           8.5       4.3      12.0         14.2
                1970-1979
                            (s.d.)              0.3       4.6           3.1       6.9       7.9           5.3
      Natural               N (Current)       5 (0)     5 (1)        5 (5)     13 (1)    17 (7)      14 (14)
     Sciences               Mean                4.6       5.4           8.4       3.9       6.4           7.2
                            Median              4.6       5.0           9.7       3.9       5.0           7.5
                1980-1989
                            (s.d.)              0.4       1.3           4.1       0.8       3.4           4.9
                            N (Current)       2 (0)     5 (2)        4 (4)      7 (0)     8 (3)        6 (6)
                            Mean                1.6       5.5                     3.1       2.8
                            Median              0.8       5.5                     3.3       1.2
                1990-1999
                            (s.d.)              1.8                               1.6       3.8
                            N (Current)       4 (3)     1 (1)                   8 (5)     4 (4)
                            Mean                                      19.5                              25.4
                            Median              3.3       11.0        19.5        4.3       8.5         23.5
                  <= 1969
                            (s.d.)                                                1.1       3.7          6.8
                            N (Current)       1 (0)       1 (0)      1 (1)      7 (0)     8 (0)      10 (10)
                            Mean                5.5        12.7       14.2        4.1      10.0         14.6
                            Median              5.3        11.0       15.7        4.3       7.0         15.8
                1970-1979
                            (s.d.)              1.4         9.2         6.4       1.2       7.2          6.2
      Social                N (Current)      10 (0)      15 (5)    12 (12)     13 (0)    15 (2)      15 (15)
     Sciences               Mean                4.8        11.6       10.5        7.3       7.5          5.2
                            Median              5.3        13.5       10.5        5.3       7.2          5.5
                1980-1989
                            (s.d.)              1.2         4.8         2.8       5.0       2.8          2.8
                            N (Current)       5 (1)       5 (3)      2 (2)      9 (4)    10 (3)        7 (7)
                            Mean                3.8         3.8                   4.1       3.1          0.8
                            Median              3.3         4.5                   3.8       2.5          0.8
                1990-1999
                            (s.d.)              2.4         2.8                   1.9       2.1
                            N (Current)      15 (9)       6 (6)                13 (6)     9 (9)         1 (1)

     Note: These tables were created using data retrieved from the City University Personnel System
     (CUPS) database by Gowrie Kamintzky in Hunter College's Department of Human Resources on 1
     December 2004. Only full-time tenured or tenure-track faculty who were employed at Hunter 01 July
     2003 - 30 June 2004 were included in the analyses. Distinguished Professors were added to the Full
     Professor category for analysis.
     Note: Median years in rank includes the time spent in rank for all current faculty as of 30 June 2004. N
     indicates the number of 2003-2004 science faculty members from that degree range who have ever
     held that particular rank. (Current) indicates the number of faculty members in that rank on 30 June
     2004.
     Example: A female Assistant Professor in the Social Sciences who finished her degree in 1982, was
     hired 1 September 1982, and promoted to Associate Professor on 1 January 1988, would be
     represented in both the Assistant and Associate columns for women in degree year 1980-1989. She
     would be represented in () for her current rank of Associate Professor only. Her full 5.3 years as an
     Assistant contribute to the median of 5.3 and the 16.5 years she has currently been an Associate
     contribute to the median of 13.5.



HR-IR 3b                                                                                                        4 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                                                             printed on 8/19/2011


Table 4a. Time at Institution (Median Number of Years) for STEM Faculty by Sex and Rank, 2002-2003


      Division/Department

                                                        Women                             Men                    Women's Median as a % of Men's
      Natural Sciences (years)               Assistant Associate       Full   Assistant Associate         Full   Assistant Associate    Full
              Biological Sciences                  N/A      6.41        25.12       4.5     13.83          25.83      N/A        46           97
              Chemistry                           0.83     12.41        19.83     15.33      5.62          28.83         5      221           69
              Computer Science                     N/A       N/A        22.83      3.33     12.83          22.91      N/A       N/A          100
              Mathematics and Statistics           N/A     39.83        24.83      0.83     21.83          32.33      N/A       182           77
              Physics and Astronomy               0.42       N/A          N/A      1.49     15.33          19.41        28      N/A          N/A
              All Natural Sciences                0.83      9.83        22.83      2.83     13.83          24.83        29       71           92


                                                           Women                              Men                   Women's Median as a % of Men's
      Social Sciences (years)                Assistant    Associate    Full   Assistant     Associate     Full      Assistant Associate    Full
              Anthropology                        1.83        21.83     25.33      0.83          8.29      25.83         220       263           98
              Economics                           1.83          N/A     19.83      3.83          8.83      16.83           48      N/A          118
              Geography                           2.83         7.29       N/A      5.13           N/A      14.83           55      N/A          100
              Political Science                   2.83        11.83     19.42       N/A         11.33      36.83         100       104           53
              Psychology                          5.33        21.83     26.33      2.83          3.83      33.41         188       570           79
              Sociology                           2.83        28.83     25.83     16.83         14.33      24.33           17      201          106
              All Social Sciences                 2.83        19.33     22.83      3.13          9.83      25.83           90      197           88

      All Science Faculty                          1.83      12.41       22.83       2.83       10.83      25.83          65       115            88

Note: Time at Institution takes into account all tenure-line years worked at Hunter College for each professor as
of 30 June 2004. (Some faculty members began working at Hunter College as adjuncts or substitutes before
being hired in a tenure-track position. This time is not included in our calculations.) These data were reported
by Gowrie Kaminsky in Hunter College's Department of Human Resources and retrieved from the CUPS
database.
Example: A female Assistant Professor hired 1 September 1992 and promoted to Associate Professor on 1
January 1998 would be represented in the women Associate column with a total Time at Institution of 11.8 years.




HR-IR 4a                                                                                                                                          5 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                         printed on 8/19/2011


Table 4b. Attrition for STEM Faculty by Sex, 2003-2004

           Division

                                                     Leaving Faculty
                                        Women        Men      Total    % Women
           Natural Science                   2            0          2      100
           Social Science                    0            3          3        0
                      Science Total          2            3          5       40

Note: This table represents the number of faculty who have left in this academic year (01 July
2003 - 30 June 2004) and includes those who retired or resigned. Gowrie Kaminsky in Hunter
College's Department of Human Resources reported this information on 29 June 2004 and 1




HR-IR 4b                                                                                                      6 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                           printed on 8/19/2011


Table 5a. Number of STEM Women Who are in Non-Tenure-Track Positions (Teaching and
Research) by Department, 2003-2004

         Division/Department

         Natural Sciences                          Women        Men        Total   % Women
                  Biological Sciences                  16             22       38        42
                  Chemistry                              8            16       24        33
                  Computer Science                       2             5         7       29
                  Mathematics and Statistics           11             22       33        33
                  Physics and Astronomy                  4            11       15        27
                  All Natural Science                  41             76      117        35


         Social Sciences                           Women        Men        Total    % Women
                  Anthropology                            10           7       17           59
                  Economics                               12          20       32           38
                  Geography                               12          11       23           52
                  Political Science                       11          16       27           41
                  Psychology                              10          18       28           36
                  Sociology                               11          16       27           41
                  All Social Sciences                     66          88      154           43

         All Science Faculty                            107        164        271           39

Note: These tables were created using data retrieved from the City University Personnel System
(CUPS) database by Gowrie Kaminsky in Hunter College's Department of Human Resources on
29 June 2004. The data include all promotions and hires through 29 June 2004. Only faculty with
appointment dates prior to 29 June 2004 were included in the analyses. These tables include non-
tenure track faculty -- both full and part-time. Non-tenure track faculty consist of Lecturers,
Research Associates, Substitute Professors, and Adjunct Professors.




HR-5a                                                                                                           7 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                                                                   printed on 8/19/2011


Table 5b. Number of STEM Women Who are in Non-Tenure-Track                                                 1
Positions (Teaching and Research) by Sex and Rank, 2003-2004

        Division/Department

                                                               Women                               Men                         % Women
        Natural Sciences                           Lecturer R Assoc Sub          Adj Lecturer R Assoc Sub       Adj Lecturer R Assoc Sub              Adj
                  Biological Sciences                     0       0    2           14       0       1     0       21   N/A        0   100               40
                  Chemistry                               0       0    0            8       0       4     0       12   N/A        0   N/A               40
                  Computer Science                        0       0    0            2       2       0     0        3      0     N/A   N/A               40
                  Mathematics and Statistics              1       0    0           10       0       0     0       22    100     N/A   N/A               31
                  Physics and Astronomy                   0       0    0            4       0       0     2        9   N/A      N/A      0              31
                  All Natural Sciences                    1       0    2           38       2       5     2       67     33       0    50               36


                                                                  Women                              Men                             %Women
        Social Sciences                            Lecturer    R Assoc Sub       Adj Lecturer   R Assoc Sub     Adj    Lecturer   R Assoc Sub         Adj
                   Anthropology                           0          0    0        10       0         0     0      7      N/A        N/A   N/A          59
                   Economics                              0          0    0        12       1         0     1     18         0       N/A      0         40
                   Geography                              0          0    0        12       0         1     1      9      N/A          0      0         36
                   Political Science                      0          0    0        11       0         0     1     15      N/A        N/A      0         30
                   Psychology                             0          0    0        10       0         0     0     18      N/A        N/A   N/A          36
                   Sociology                              0          0    1        10       0         0     1     26      N/A        N/A    50          28
                   All Social Sciences                    0          0    1        65       1         1     4     93         0         0    20          41

        All Science Faculty                                1         0       3     103     3         6     6     160        25         0        33       39

Note: These tables were created using data retrieved from the City University
Personnel System (CUPS) database by Gowrie Kaminsky in Hunter College's
Department of Human Resources on 29 June 2004. The data include all
promotions and hires through 29 June 2004. Only faculty with appointment
dates prior to 29 June 2004 were included in the analyses. These tables include
non-tenure track faculty -- both full and part-time.
Note: R Assoc means Research Associate; Sub means Substitute and consists
of all levels of substitute faculty including full, associate, assistant, and lecturer;
Adj means Adjunct and consists of all levels of adjunct faculty including full,
associate, assistant, and lecturer.


HR-5b                                                                                                                                                   8 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                        printed on 8/19/2011


Notes on Regression of Science Faculty Salary, 2003-2004

                   Actual salary (in dollars) used; Data retrieved from the City University Personnel System
                   (CUPS) database by Gowrie Kaminsky in Hunter College's Department of Human
Salary
                   Resources on 1 December 2004. RRI and supplemental salaries were not included in
                   these analyses.
Sex                Female = 1
                   2004 – year of final degree reported on CUPS database; CUPS data retrieved by Gowrie
Years since degree Kaminsky in Hunter College's Department of Human Resources on 1 December 2004

Years since degree To reduce redundancy, this variable was centered by subtracting the mean of the
(centered)           variable from each of the measures of the variable. (YsD - meanYsD)
Time in current rank Number of years in current appointment
                      (rank as of 1 December 2004)
Time in current      To reduce redundancy, this variable was centered by subtracting the mean of the
rank (Centered )     variable from each of the measures of the variable. (TIR - meanTIR)
Sum TiR (Total       Time at Hunter College takes into account all tenure-line years worked at Hunter College
length of            for each professor as of 30 June 2004; CUPS data retrieved by Gowrie Kaminsky in
employment at HC) Hunter College's Department of Human Resources on 1 December 2004
Sum TiR (Total       To reduce redundancy, this variable was centered by subtracting the mean of the
length of            variable from each of the measures of the variable. (Sum - meanSum)
employment at HC)
-- Centered
Rank                 Distinguished Professor = 1; Professor = 1; Associate Professor = 1
                     Departments were grouped into broader discipline categories (natural and social
Department           sciences) instead of using individual departments to ensure that a sufficient number of
                     faculty fell into each category (discipline and rank); Natural Science = 1

Note: The regression output was generated by SPSS 11.5.

Example 1: To predict the salary of a male assistant professor in the social sciences who has had his degree
for 5 years and has been in that rank for 2 years, look first at the constant term, $71295.48, listed in the first
row in the Coefficients table on the first sheet, "Salary a". Since the dummy variables were chosen as they
were, the constant represents the salary for a male assistant professor in the social sciences. Multiply 5
(Years since degree) by 787.27 and 2 (Time in current rank) by -147.04. Add these totals to the constant to
get a more accurate estimate of salary. The outcome using these unstandardized regression coefficients is
$74937.75.

Example 2: To predict the salary of a male assistant professor in the social sciences who has had his degree
for 5 years and has been at Hunter College for 2 years, look first at the constant term, $70887.99, listed in the
first row in the Coefficients table on the second sheet, "Salary b". Since the dummy variables were chosen as
they were, the constant represents the salary for a male assistant professor in the social sciences. Multiply 5
(Years since degree) by 863.55 and 2 (Time at Hunter College in years) by -195.63. Add these totals to the
constant to get a more accurate estimate of salary. The outcome using these unstandardized regression
coefficients is $74814.48.




HR-IR 6 notes                                                                                                  9 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                                                      printed on 8/19/2011


Table 6a. Salary of Science Faculty, 2003-2004 (Controlling for Sex, Years since degree,
Time in current rank, Rank, and Department)

Descriptive Statistics
                                                                            Std.
                                                            Mean         Deviation         N
Salary as of 1 December 2004                              $80,628.38     $15,050.28       184
Sex (Female =1; Male = 0)                                    0.36           0.48          184
Years since degree (centered)                                0.00          12.05          184
Time in current rank (rank as of 1 December 2004)
Centered -- (TiR - Mean of Tir)                              0.00            9.13         184
Rank (Asst Prof = 0; Assoc Prof = 1; Prof =1; Dist =1)       0.77            0.42         184
Department (Nat Sci = 1; Soc Sci = 0)                        0.43            0.50         184

Model Summary (b)
                                                                                       Adjusted Std. Error of
Model                                                           R         R Square     R Square the Estimate
                                                       1 0.823670505       0.6784331       0.6694 8653.576807
a. Predictors: (Constant), Numeric Coding for Science Sections: NAT = 1, SOC = 0, Time in current rank (rank as of
1 December 2004) Centered -- (TiR - Mean of Tir), Numeric Coding for Sex: F = 1, M = 0, Coding for Rank: ASST =
0, ASSOC =1, FULL = 1, DIST = 1, Years since degree Centered -- (YsD - Mean of YsD)

b. Dependent Variable: Current Salary (as of 1 December 2004)

ANOVA (b)
                                                                           Sum of
Model                                                                      Squares         df       Mean Square      F        Sig.
                                                       1 Regression      28122051394            5    5624410279      75.108    .000(a)
                                                         Residual        13329421698          178 74884391.56
                                                         Total           41451473091          183
a. Predictors: (Constant), Numeric Coding for Science Sections: NAT = 1, SOC = 0, Time in current rank (rank as of
1 December 2004) Centered -- (TiR - Mean of Tir), Numeric Coding for Sex: F = 1, M = 0, Coding for Rank: ASST =
0, ASSOC =1, FULL = 1, DIST = 1, Years since degree Centered -- (YsD - Mean of YsD)

b. Dependent Variable: Current Salary (as of 1 December 2004)




HR-IR 6a                                                                                                                                  10 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                                                printed on 8/19/2011


Coefficients (a)
                                                                            Unstandardized      Standardized
                                                                             Coefficients       Coefficients
Model                                                                   B            Std. Error     Beta       t        Sig.
                                                    1 (Constant)            71295.48   1947.27                 36.613     0.000
                                                      Numeric
                                                      Coding for
                                                      Sex: F = 1, M =
                                                      0                       636.32   1353.13         0.020    0.470     0.639
                                                      Years since
                                                      degree
                                                      Centered --
                                                      (YsD - Mean of
                                                      YsD)                    787.27    114.94         0.630    6.849     0.000
                                                      Time in current
                                                      rank (rank as
                                                      of 1 December
                                                      2004)
                                                      Centered --
                                                      (TiR - Mean of
                                                      Tir)                   -147.04    124.20        -0.089   -1.184     0.238
                                                       Coding for
                                                       Rank: ASST =
                                                       0, ASSOC =1,
                                                       FULL = 1,
                                                       DIST = 1             12058.43   2113.98         0.337    5.704     0.000
                                                       Numeric
                                                       Coding for
                                                       Science
                                                       Sections: NAT
                                                       = 1, SOC = 0          -470.32   1332.95        -0.016   -0.353     0.725
a. Dependent Variable: Current Salary (as of 1 December 2004)




HR-IR 6a                                                                                                                            11 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                                               printed on 8/19/2011


Table 6b. Salary of Science Faculty, 2003-2004 (Controlling for Sex, Years
since degree, Time at Hunter College, Rank, and Department)

Descriptive Statistics
                                                            Std.
                                           Mean          Deviation         N
Salary as of 1 December 2004             $80,628.38      $15,050.28       184
Sex (Female =1; Male = 0)                   0.36            0.48          184
Years since degree (centered)               0.00           12.05          184
Sum TiR (Total length of employment
at HC) -- Centered -- (Sum - Mean            0.00           12.21         184
Rank (Asst Prof = 0; Assoc Prof = 1;
Prof =1; Dist =1)                            0.77               0.42      184
Department (Nat Sci = 1; Soc Sci = 0)        0.43               0.50      184

Model Summary (b)
                                                                         Adjusted Std. Error of
Model                                         R             R Square     R Square the Estimate
                                      1             0.825         0.681      0.672 $    8,621.73
a. Predictors: (Constant), Numeric Coding for Science Sections: NAT = 1, SOC = 0, Sum TiR (Total
length of employment at HC) -- Centered -- (Sum - Mean Sum), Numeric Coding for Sex: F = 1, M =
0, Coding for Rank: ASST = 0, ASSOC =1, FULL = 1, DIST = 1, Years since degree Centered --
(YsD - Mean of YsD)
b. Dependent Variable: Current Salary (as of 1 December 2004)

ANOVA (b)
                                                             Sum of
Model                                                        Squares        df      Mean Square    F        Sig.
                                      1 Regression        28219984932             5  5643996986    75.927    .000(a)
                                        Residual          13231488160          178 74334203.14
                                        Total             41451473091          183
a. Predictors: (Constant), Numeric Coding for Science Sections: NAT = 1, SOC = 0, Sum TiR (Total
length of employment at HC) -- Centered -- (Sum - Mean Sum), Numeric Coding for Sex: F = 1, M =
0, Coding for Rank: ASST = 0, ASSOC =1, FULL = 1, DIST = 1, Years since degree Centered --
(YsD - Mean of YsD)
b. Dependent Variable: Current Salary (as of 1 December 2004)



HR-IR 6b                                                                                                                           12 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                                               printed on 8/19/2011



Coefficients (a)
                                                              Unstandardized      Standardized
                                                               Coefficients       Coefficients
Model                                                     B            Std. Error     Beta       t           Sig.
                                    1 (Constant)              70887.99   1887.34                 37.560        0.000
                                      Numeric Coding
                                      for Sex: F = 1, M
                                      =0                        770.24   1349.09         0.025       0.571     0.569
                                      Years since
                                      degree Centered
                                      -- (YsD - Mean of
                                      YsD)                      863.55    131.68         0.691       6.558     0.000
                                        Sum TiR (Total
                                        length of
                                        employment at
                                        HC) -- Centered -
                                        - (Sum - Mean
                                        Sum)                  -195.63     118.41        -0.159   -1.652        0.100
                                        Coding for Rank:
                                        ASST = 0,
                                        ASSOC =1,
                                        FULL = 1, DIST
                                        =1                   12573.07    2049.29         0.352       6.135     0.000
                                        Numeric Coding
                                        for Science
                                        Sections: NAT =
                                        1, SOC = 0            -556.51    1328.88        -0.018   -0.419        0.676
a. Dependent Variable: Current Salary (as of 1 December 2004)




HR-IR 6b                                                                                                                           13 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                                printed on 8/19/2011


Table 6c. Salary by Rank, Sex, and Division, 2003-2004

   Salary

                                                Women                         Men
                                     Assistant Associate  Full    Assistant Associate         Full
   Natural Sciences      Mean         $58,354 $74,318 $92,456 $61,855 $75,053                $92,267
                         Median       $57,286 $73,028 $93,507 $61,111 $77,529                $93,507
                         (s.d.)        $5,131     $1,984  $7,648    $7,271     $5,571         $2,530
                         range        $11,933     $4,501 $32,125 $24,480 $21,515              $8,936
                         min          $53,455 $73,028 $81,382 $50,908 $56,014                $84,571
                         max          $65,388 $77,529 $113,507 $75,388 $77,529               $93,507
                         N                   4         5       12         9        15              33

                                                  Women                             Men
                                     Assistant   Associate    Full    Assistant   Associate  Full
   Social Sciences       Mean         $60,081      $73,850   $90,576 $61,666       $72,594 $90,827
                         Median       $61,111      $74,979   $91,890 $61,111       $73,028 $93,507
                         (s.d.)        $6,196       $5,238    $3,296    $6,266       $9,883  $5,051
                         range        $26,395      $19,145    $8,936 $24,480       $40,597 $21,476
                         min          $48,993      $58,558   $84,571 $50,908       $47,476 $81,382
                         max          $75,388      $77,703   $93,507 $75,388       $88,073 $102,858
                         N                  15          14         12        14          14       32


Note: These tables were created using data retrieved from the City University Personnel System (CUPS)
database by Gowrie Kamintzky in Hunter College's Department of Human Resources on 1 December
2004. The salary data is current salary on 1 December 2004. Only full-time tenured or tenure-track
faculty who were employed at Hunter 01 July 2003 - 30 June 2004 were included in the analyses.
Distinguished Professors were not included in this analysis.




HR-IR 6c                                                                                                            14 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                                                             printed on 8/19/2011



Table 7. Number and Percent of STEM Women in Administrative Positions, 2003-2004

             Division

                                                 Department Chairs                                            Deans
                                    Women        Men      Total    % Women                 Women        Men       Total        % Women

             Natural Science                4           1          5            80                 1          0            1       100
             Social Science                 2           4          6            33                 1          0            1       100
             All Science Faculty            6           5         11            55                 2          0            2       100


                                                Central Administrators                                  Center Directors
                                    Women         Men      Total     % Women               Women        Men       Total        % Women

             Natural Science                0           1          1             0                 0          1            1         0
             Social Science                 0           0          0           N/A                 1          1            2        50
             All Science Faculty            0           1          1             0                 1          2            3        33

Note: Only deans or associate deans in the sciences are included on this table. Vita Rabinowitz
and Virginia Valian, the GEP Co-directors, and Judi Bubnell in Hunter College's Provost's Office
provided information about the deans.
Note: The Hunter web site, Judi Bubnell, Vita Rabinowitz, and Virginia Valian provided information
about the Hunter central administration. Administrators at Hunter do not hold faculty positions while
in administrative ranks. These tables represent those administrators whose backgrounds are in the
sciences (e.g., one administrator holds a JD and has not been a faculty member; this person was
not included in the table above).
Note: Judi Bubnell provided information about center directors on 16 March 2005. Only center
directors that are also Hunter science faculty are included on these tables (e.g., Director of Center
XXX is a Full Professor in a Hunter science department).




In house 7                                                                                                                                       15 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                                 printed on 8/19/2011


Table 8. Number and Percent of STEM Women Faculty on Promotion and Tenure Committees,
2003-2004


             Faculty P & B
             Members                                    Women        Men        Total     % Women

             Natural Sciences                                   4           2         6             67
             Social Sciences                                    3           4         7             43
             Committee Members (science total)                  7           6        13             54


             Department P & B
             Members                                    Women        Men        Total     % Women

             Natural Sciences                                  7           18       25              28
             Social Sciences                                  12           18       30              40
             Committee Members (science total)                19           36       55              35



Note: Information about Department Personnel and Budget (P&B) members provided to the GEP by
each science department.
Note: DP&B committees consist of the elected chair and four elected members.
Note: The FP&B committee includes department chairs, the deans, the provost, the directors of the
school of nursing and health sciences, and the college president. Only those faculty members or
administrators in the 11 Hunter sciences are included here.




In house 8                                                                                                           16 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                                               printed on 8/19/2011


Table 9b. Tenure Outcomes for STEM Faculty by Sex, 2003-2004


              Division/Department

                                                             Women                               Men
                                               # Considered # Approved % Approved # Considered # Approved % Approved
              Natural Sciences                             0         0        N/A             3         3        100
              Social Sciences                              2         2        100             1         1        100
                         All Science Faculty               2         2        100             4         4        100


Note: These tables include data from Tenure Ballots provided by Judi Bubnell in Hunter College's Provost's Office
on 15 March 2005. Tenure decisions were voted on in November 2003. Tenure decisions were effective on 01
September 2004.




In house 9a                                                                                                                        17 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                                               printed on 8/19/2011


Table 9b. Promotion Outcomes for STEM Faculty by Sex, 2003-2004


              Division/Department

                                                             Women                               Men
                                               # Considered # Approved % Approved # Considered # Approved % Approved
              Natural Sciences                             0         0        N/A             3         3        100
              Social Sciences                              3         2         67             4         4        100
                         All Science Faculty               3         2         67             7         7        100


Note: These tables include data from Promotion Ballots provided by Judi Bubnell in Hunter College's Provost's
Office on 15 March 2005. Promotion decisions were voted on in May 2003. Promotion decisions were effective on
01 January 2004.




In house 9b                                                                                                                        18 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                printed on 8/19/2011


Table 10. Startup Packages of Newly Hired STEM Faculty by Sex (Fall 1998 - Fall 2004)


      Item Mentioned in Offer Letter

                                                                         %Women %Men %Total
                                                                            N=23 N=31 N=54
      Letter date                                                             96  100   98
      Rank offered                                                           100  100  100
      Department of appointment                                              100  100  100
      Effective date of appointment                                           78   84   81
      "appointment is subject to approval of the Board of
          Trustees of CUNY and financial ability"                                87         84       85
      "terms and conditions of employment are those of
          CUNY's Bylaws"                                                         70         45       56
      collective bargaining agreement exists between
          University and PSC-CUNY                                               70         48        57
      Start date of tenure clock                                                 0         13         7
      Consideration for early tenure or promotion                                4         23        15
      Effective tenure date                                                      0          6         4
      Who financed appointment (e.g., RCMI, Gene Center)                         4         10         7
      Starting salary                                                          100        100       100
      Length of contract (e.g., 9 month academic year)                          43         52        48
      Appointment length (e.g., 1 year appointments until
          tenured)                                                               22         16       19
      Lab or office space and office equipment specified (e.g.,
        lab with two testing rooms and common area; 10*12                        13         29       22
        office -- all with ethernet and phone)
      Type of teaching                                                           17         19       19
      Teaching assignment or release specified (e.g.,
          reduced teaching load of 3 courses for first two semesters)            30         10       19
      Who financed start up funds (e.g., Dean's Office, GRTI,
           Gene Center)                                                          22         13       17
      When should start-up be used by (e.g., all funds to be
          used by first two academic years)                                      43         32       37
      Start-up funds -- a) only total funds listed (with no other
          breakdown)                                                             17         39       30
      Start-up funds -- b) lab and lab equipment                                  0         19       11
      Start-up funds -- c) computer and computer equipment                       43         35       39
      Start-up funds -- d) software                                               0         13        7
      Start-up funds -- e) relocation                                            39         32       35
      Start-up funds -- f) travel                                                39         23       30
      Start-up funds -- g) matching funds                                        13         13       13
      Start-up funds -- h) technical or research assistance                       4         16       11
      Total of start-up fund items b - h                                         74         71       72
      Total of all start-up funds a - h                                          83         84       83




In house 10                                                                                         19 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                    printed on 8/19/2011


Note: The offer letter analysis includes letters from all 11 Hunter College Sciences for faculty who started
from Fall 1998 through Fall 2004. The analysis comprises 54 letters from 58 total hires in tenure bearing
titles (e.g., Assistant, Associate, or Full Professor). For four faculty members, 1 woman and 3 men, only
internal correspondence regarding appointments to the College were sent to the GEP. Data for these four
people were not included in the analysis.
Note: Redacted offer letters were obtained from the Office of the Dean of Arts and Sciences on 23 April
2004 and 23 February 2005.
Note: b through h may not necessarily add up to the compliment of a because b through h are not mutually
exclusive.
Note: %Women is the percentage of letters to women. %Men is the percentage of letters to men. %Total is
the percentage of total letters.




In house 10                                                                                             20 of 21
c51b17b5-4535-4668-a44c-a2cfd02d5872.xls                                                                    printed on 8/19/2011


Table 11. Number and Percent of STEM Women Faculty in Endowed/Named Chairs, 2003-2004


              Distinguished Professors           Women        Men         Total       % Women

              Natural Science                            1           0            1        100
              Social Science                             3           1            4         75
                         All Science Faculty             4           1            5         80


              Named Chairs or
              Professorships                     Women        Men         Total       % Women

              Natural Science                            2           1            3        67
              Social Science                             0           1            1       N/A
                         All Science Faculty             2           2            4        50

Source: Salute to scholars: The faculty of the City University of New York . This is a publication of the
Office of Academic Affairs and the Office of University Relations of CUNY.




In house 11                                                                                                             21 of 21

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:41
posted:8/19/2011
language:English
pages:21
Description: Startup Equity Spreadsheet document sample