The NSF Statistical Study SOP

Purpose: To calculate the position of NC State University among all Universities and all Public Universities with respect to Research and Development.

Areas covered: All Research, Federal Research, Industry Research, Other Research.

Types of studies: AllUniversities, AllUniversities with out medical schools, all land grant universities, public universities

Time: Usually the NSF R&D study (includes all sources of externally sponsored R&D) is published for the preceding year in November of the current year.

Background: The NSF data is submitted by Contracts and Grants. The data is only for research and development.

Step / Action
1. / Once you are able to access the next year’s NSF rankings on the web, go to link: and select “Science Statistics”.
2. / Access the R&D expenditures tables – Academic. The link to use is: Academic Research and Development Expenditures: Fiscal Year XXXX, which links to a pdf version of the yearly report.
3. / Then select “Detailed Statistical Tables”.
4. / Open, as an EXCEL version, Tables B-32 (for use w/ Section I), B-33 (for use w/ Section III), B-34 (for use w/ Section IV), B-35 (for use w/ Section V – sorted by State funding), and B-38 (for use w/ Section II).
5. / Take each Excel spreadsheet and save it with the following naming convention: Table # 20XX (yr).
6. / Insert at the beginning of each table three columns for Medical, Land Grant and Public, so you can count each ranked university in the appropriate categories (MedicalSchool, Land Grant, Public) in which they are included. See example in chart below.
Med / LG / Pub. / Table B-38. Industry-sponsored R&D expenditures at universities and colleges,
ranked by fiscal year 2001 industry-sponsored R&D expenditures:
fiscal years 1994-2001
[Dollars in thousands]
Page 1 of 7
Institution and ranking / 1994 / 1995 / 1996 / 1997 / 1998 / 1999 / 2000 / 2001
Total, all institutions / 1,422,170 / 1,488,895 / 1,605,258 / 1,736,668 / 1,888,171 / 2,027,937 / 2,152,389 / 2,233,649
1 / 1 Duke University / 30,241 / 32,560 / 42,797 / 48,178 / 65,114 / 121,630 / 109,791 / 104,063
1 / 2 MA Institute of Tech / 55,500 / 52,757 / 62,699 / 59,204 / 60,538 / 75,444 / 83,082 / 97,256
1 / 1 / 1 / 3 Pennsylvania State U / 45,408 / 50,225 / 52,771 / 56,666 / 63,319 / 65,698 / 64,393 / 67,658
1 / 4 Georgia Institute of Tech / 27,832 / 26,104 / 39,136 / 48,094 / 58,377 / 62,752 / 64,508 / 59,691
1 / 1 / 1 / 5 Ohio State University / 14,883 / 21,827 / 30,870 / 36,685 / 40,401 / 52,034 / 57,075 / 54,736
1 / 1 / 6 U of Washington / 33,199 / 36,892 / 36,180 / 37,744 / 38,370 / 51,319 / 57,405 / 43,312
1 / 7 U of MD Baltimore / 15,411 / 17,797 / 19,450 / 18,581 / 20,783 / 11,572 / 29,892 / 41,226
1 / 1 / 8 NC State University / 22,101 / 26,264 / 26,067 / 26,834 / 31,429 / 31,478 / 32,804 / 37,858
4 / 4 / 6
7. / Figure totals once you have put each university into categories to see where NC State ranks in each. Enter these newest rankings, by total, industry, federal, non-federal and state funding.
8. / Once complete, send updated rankings via email attachment to the Assoc. VC for Research Administration.

Subset Study: NSF Statistical Study of Peers

Step / Action
Pre / Do the NSF Statistical Study.
1. / Using the same method as listed above compare NC State’s NSF total R&D expenditures (Table B-32) to each of our peers.
2. / Sort each year by funding, in descending order and rank by each year’s funding.
3. / Peer order by latest year’s rankings. See example below:
NSF Comparison of Peers 1996-2001
Fiscal Year / 1996-1997 / 1997-1998 / 1998-1999 / 1999-2000 / 2000-2001
Univ. of Wisconsin-Madison / 3 / 4 / 3 / 2 / 3
Univ. of California-San Diego / 9 / 7 / 6 / 6 / 6
Penn State Univ. (Main Campus) / 14 / 13 / 14 / 11 / 11
Univ. of California-Davis / 22 / 21 / 23 / 17 / 15
Texas A & M Univ. / 10 / 10 / 11 / 15 / 16
Univ. of Illinois-Urbana / 18 / 16 / 16 / 16 / 18
DukeUniv. / 25 / 22 / 17 / 20 / 21
Georgia Institute of Technology / 28 / 28 / 30 / 27 / 30
North Carolina State Univ. / 30 / 29 / 29 / 31 / 32
Univ. of Georgia / 31 / 35 / 35 / 34 / 34
PurdueUniv. (Main Campus) / 34 / 37 / 38 / 40 / 41
RutgersUniv. (New Brunswick) / 42 / 41 / 40 / 43 / 44
Virginia Polytechnic Institute / 44 / 48 / 50 / 51 / 49
Case Western Univ. / 47 / 44 / 46 / 50 / 53
Iowa State Univ. / 48 / 51 / 55 / 57 / 61
Carnegie-MellonUniv. / 61 / 67 / 66 / 79 / 84
* NSF Table B-32. Total R&D expenditures at universities and colleges, ranked by fiscal year 2001 total R&D expenditures
+ Figures for 2001-2002 not yet available
Created: 06/24/2004
4. / Once complete, send updated rankings via email attachment to the Assoc. VC for Research Administration.

*Special Note: It was decided years ago that we would not recognize MIT as a Public Institution for the purposes of this report. This decision was made by Drs. L. K. Monteith (Chancellor) and C. Moreland.