December 13, 2015

National Science Foundation: Education Research Grants

Group Project

Adv. Quantitative Methods

November 14, 2015

Presented by (.smaller)

Sahar Alhassan, Kaitlyn Lynes, Deepa Mehta, Ilya Perepelitsa

About the Data

something about NSF Grant allocations

Project Background

  • NSF Grant Allocations
  • Duration of Grants
  • Grants by State
  • Grants by Subject
  • Grants by Institutions

2014-2015 NSF Monthly Grant Dollar Allocation by Month

## Warning in log(costmon): NaNs produced
## Warning in log(costmon): NaNs produced
## Warning: Removed 249 rows containing missing values (geom_point).

2013 - 2015 NSF Grant Dollars Allocated by Month over a two-year period (2013-2015)

## Warning in log(costmon): NaNs produced
## Warning in log(costmon): NaNs produced
## Warning: Removed 734 rows containing missing values (geom_point).

NSF Grant Dollrs Allocated by Month from 2002 - 2015

## Warning in log(costmon): NaNs produced
## Warning in log(costmon): NaNs produced
## Warning: Removed 734 rows containing missing values (geom_point).

Two Hypotheses

Three Separate Types of NSF Grants 1999-2015

ggplot(newdata4, aes(y=log(costmon), x=starting_date)) + geom_point(aes(color = action_type))+ facet_wrap(~action_type)
## Warning in log(costmon): NaNs produced
## Warning in log(costmon): NaNs produced
## Warning: Removed 25 rows containing missing values (geom_point).
## Warning: Removed 4 rows containing missing values (geom_point).
## Warning: Removed 6501 rows containing missing values (geom_point).

NSF Grant Dollars Allocated Per Month As a Function of Research Duration

notes: will a project with a longer duration be allocated more grant dollars?
ggplot(schoolsall, aes(y=res_duration, x=log(costmon))) + geom_point(aes(color = action_type))
## Warning in log(costmon): NaNs produced
## Warning in log(costmon): NaNs produced
## Warning: Removed 6772 rows containing missing values (geom_point).

NSF Grant Dollars Allocated Per Month As a Function of Research Duration - Separated by Type

ggplot(schoolsall, aes(y=res_duration, x=log(costmon))) + geom_point(aes(color = action_type))+ facet_wrap(~action_type)
## Warning in log(costmon): NaNs produced
## Warning in log(costmon): NaNs produced
## Warning: Removed 8 rows containing missing values (geom_point).
## Warning: Removed 28 rows containing missing values (geom_point).
## Warning: Removed 4 rows containing missing values (geom_point).
## Warning: Removed 6732 rows containing missing values (geom_point).

new are shorter?

What accounts for the gap in data in 2004?

Was this due to the Government shut down? 2004 - only 200 observations versus 20,000;

ggplot(schoolsall,aes(x=obligation_action_date, y = log(costmon))) + geom_point(aes(color= action_type )) 
## Warning in log(costmon): NaNs produced
## Warning in log(costmon): NaNs produced
## Warning: Removed 6772 rows containing missing values (geom_point).

Density of Grant Types

ggplot(schoolsall, aes(x=log(costmon), fill=action_type)) + geom_density(alpha = 0.6)
## Warning in log(costmon): NaNs produced
## Warning in log(costmon): NaNs produced
## Warning: Removed 8 rows containing non-finite values (stat_density).
## Warning: Removed 310 rows containing non-finite values (stat_density).
## Warning: Removed 180 rows containing non-finite values (stat_density).
## Warning: Removed 6751 rows containing non-finite values (stat_density).

notes: division is bimodal (new, continuation)

density of grant dollars by subject -

ggplot(schoolsall, aes(x=log(costmon), fill=cfda_program_title)) + geom_density(alpha = 0.6) + facet_wrap(~cfda_program_title)
## Warning in log(costmon): NaNs produced
## Warning in log(costmon): NaNs produced
## Warning: Removed 988 rows containing non-finite values (stat_density).
## Warning: Removed 1040 rows containing non-finite values (stat_density).
## Warning: Removed 481 rows containing non-finite values (stat_density).
## Warning: Removed 1237 rows containing non-finite values (stat_density).
## Warning: Removed 935 rows containing non-finite values (stat_density).
## Warning: Removed 1348 rows containing non-finite values (stat_density).
## Warning: Removed 280 rows containing non-finite values (stat_density).
## Warning: Removed 582 rows containing non-finite values (stat_density).
## Warning: Removed 111 rows containing non-finite values (stat_density).
## Warning: Removed 76 rows containing non-finite values (stat_density).
## Warning: Removed 45 rows containing non-finite values (stat_density).
## Warning: Removed 98 rows containing non-finite values (stat_density).
## Warning: Removed 26 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).

density of grants by recipient type

ggplot(schoolsall, aes(x=log(costmon), fill=recipient_type)) + geom_density(alpha = 0.6) + facet_wrap(~recipient_type)
## Warning in log(costmon): NaNs produced
## Warning in log(costmon): NaNs produced
## Warning: Removed 5 rows containing non-finite values (stat_density).
## Warning: Removed 57 rows containing non-finite values (stat_density).
## Warning: Removed 4295 rows containing non-finite values (stat_density).
## Warning: Removed 331 rows containing non-finite values (stat_density).
## Warning: Removed 450 rows containing non-finite values (stat_density).
## Warning: Removed 551 rows containing non-finite values (stat_density).
## Warning: Removed 18 rows containing non-finite values (stat_density).
## Warning: Removed 135 rows containing non-finite values (stat_density).
## Warning: Removed 1407 rows containing non-finite values (stat_density).

density of grants by action type and recipient type

ggplot(schoolsall, aes(x=log(costmon), fill=action_type)) + geom_density(alpha = 0.6) + facet_wrap(~recipient_type)
## Warning in log(costmon): NaNs produced
## Warning in log(costmon): NaNs produced
## Warning: Removed 5 rows containing non-finite values (stat_density).
## Warning: Removed 57 rows containing non-finite values (stat_density).
## Warning: Removed 18 rows containing non-finite values (stat_density).
## Warning: Removed 4 rows containing non-finite values (stat_density).
## Warning: Removed 4273 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 330 rows containing non-finite values (stat_density).
## Warning: Removed 450 rows containing non-finite values (stat_density).
## Warning: Removed 8 rows containing non-finite values (stat_density).
## Warning: Removed 279 rows containing non-finite values (stat_density).
## Warning: Removed 173 rows containing non-finite values (stat_density).
## Warning: Removed 91 rows containing non-finite values (stat_density).
## Warning: Removed 7 rows containing non-finite values (stat_density).
## Warning: Removed 11 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 132 rows containing non-finite values (stat_density).
## Warning: Removed 3 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 1402 rows containing non-finite values (stat_density).

density of grants by action type and by states

ggplot(schoolsall, aes(x=log(costmon), fill=action_type)) + geom_density(alpha = 0.6) + facet_wrap(~principal_place_state_code)
## Warning in log(costmon): NaNs produced
## Warning in log(costmon): NaNs produced
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 31 rows containing non-finite values (stat_density).
## Warning: Removed 76 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 43 rows containing non-finite values (stat_density).
## Warning: Removed 7 rows containing non-finite values (stat_density).
## Warning: Removed 3 rows containing non-finite values (stat_density).
## Warning: Removed 182 rows containing non-finite values (stat_density).
## Warning: Removed 55 rows containing non-finite values (stat_density).
## Warning: Removed 47 rows containing non-finite values (stat_density).
## Warning: Removed 630 rows containing non-finite values (stat_density).
## Warning: Removed 10 rows containing non-finite values (stat_density).
## Warning: Removed 4 rows containing non-finite values (stat_density).
## Warning: Removed 200 rows containing non-finite values (stat_density).
## Warning: Removed 5 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 105 rows containing non-finite values (stat_density).
## Warning: Removed 3 rows containing non-finite values (stat_density).
## Warning: Removed 79 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 37 rows containing non-finite values (stat_density).
## Warning: Removed 9 rows containing non-finite values (stat_density).
## Warning: Removed 5 rows containing non-finite values (stat_density).
## Warning: Removed 242 rows containing non-finite values (stat_density).
## Warning: Removed 4 rows containing non-finite values (stat_density).
## Warning: Removed 5 rows containing non-finite values (stat_density).
## Warning: Removed 170 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 38 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 4 rows containing non-finite values (stat_density).
## Warning: Removed 92 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 22 rows containing non-finite values (stat_density).
## Warning: Removed 8 rows containing non-finite values (stat_density).
## Warning: Removed 5 rows containing non-finite values (stat_density).
## Warning: Removed 326 rows containing non-finite values (stat_density).
## Warning: Removed 8 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 158 rows containing non-finite values (stat_density).
## Warning: Removed 4 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 51 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 58 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 67 rows containing non-finite values (stat_density).
## Warning: Removed 19 rows containing non-finite values (stat_density).
## Warning: Removed 11 rows containing non-finite values (stat_density).
## Warning: Removed 452 rows containing non-finite values (stat_density).
## Warning: Removed 7 rows containing non-finite values (stat_density).
## Warning: Removed 4 rows containing non-finite values (stat_density).
## Warning: Removed 179 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 42 rows containing non-finite values (stat_density).
## Warning: Removed 6 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 231 rows containing non-finite values (stat_density).
## Warning: Removed 5 rows containing non-finite values (stat_density).
## Warning: Removed 63 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 137 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 57 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 26 rows containing non-finite values (stat_density).
## Warning: Removed 13 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 233 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 29 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 30 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 3 rows containing non-finite values (stat_density).
## Warning: Removed 64 rows containing non-finite values (stat_density).
## Warning: Removed 6 rows containing non-finite values (stat_density).
## Warning: Removed 4 rows containing non-finite values (stat_density).
## Warning: Removed 166 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 63 rows containing non-finite values (stat_density).
## Warning: Removed 38 rows containing non-finite values (stat_density).
## Warning: Removed 27 rows containing non-finite values (stat_density).
## Warning: Removed 13 rows containing non-finite values (stat_density).
## Warning: Removed 483 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 4 rows containing non-finite values (stat_density).
## Warning: Removed 137 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 60 rows containing non-finite values (stat_density).
## Warning: Removed 7 rows containing non-finite values (stat_density).
## Warning: Removed 3 rows containing non-finite values (stat_density).
## Warning: Removed 95 rows containing non-finite values (stat_density).
## Warning: Removed 5 rows containing non-finite values (stat_density).
## Warning: Removed 8 rows containing non-finite values (stat_density).
## Warning: Removed 309 rows containing non-finite values (stat_density).
## Warning: Removed 6 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 56 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 99 rows containing non-finite values (stat_density).
## Warning: Removed 17 rows containing non-finite values (stat_density).
## Warning: Removed 7 rows containing non-finite values (stat_density).
## Warning: Removed 4 rows containing non-finite values (stat_density).
## Warning: Removed 81 rows containing non-finite values (stat_density).
## Warning: Removed 21 rows containing non-finite values (stat_density).
## Warning: Removed 9 rows containing non-finite values (stat_density).
## Warning: Removed 412 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 3 rows containing non-finite values (stat_density).
## Warning: Removed 75 rows containing non-finite values (stat_density).
## Warning: Removed 23 rows containing non-finite values (stat_density).
## Warning: Removed 4 rows containing non-finite values (stat_density).
## Warning: Removed 209 rows containing non-finite values (stat_density).
## Warning: Removed 3 rows containing non-finite values (stat_density).
## Warning: Removed 16 rows containing non-finite values (stat_density).
## Warning: Removed 7 rows containing non-finite values (stat_density).
## Warning: Removed 9 rows containing non-finite values (stat_density).
## Warning: Removed 95 rows containing non-finite values (stat_density).
## Warning: Removed 6 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 121 rows containing non-finite values (stat_density).
## Warning: Removed 18 rows containing non-finite values (stat_density).
## Warning: Removed 13 rows containing non-finite values (stat_density).
## Warning: Removed 11 rows containing non-finite values (stat_density).
## Warning: Removed 1 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 8 rows containing non-finite values (stat_density).
## Warning: Removed 3 rows containing non-finite values (stat_density).
## Warning: Removed 30 rows containing non-finite values (stat_density).

density of grant dollars by subject AND action type

ggplot(schoolsall, aes(x=log(costmon), fill=action_type)) + geom_density(alpha = 0.6) + facet_wrap(~cfda_program_title)
## Warning in log(costmon): NaNs produced
## Warning in log(costmon): NaNs produced
## Warning: Removed 3 rows containing non-finite values (stat_density).
## Warning: Removed 28 rows containing non-finite values (stat_density).
## Warning: Removed 32 rows containing non-finite values (stat_density).
## Warning: Removed 925 rows containing non-finite values (stat_density).
## Warning: Removed 8 rows containing non-finite values (stat_density).
## Warning: Removed 1032 rows containing non-finite values (stat_density).
## Warning: Removed 49 rows containing non-finite values (stat_density).
## Warning: Removed 3 rows containing non-finite values (stat_density).
## Warning: Removed 429 rows containing non-finite values (stat_density).
## Warning: Removed 7 rows containing non-finite values (stat_density).
## Warning: Removed 7 rows containing non-finite values (stat_density).
## Warning: Removed 1223 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 61 rows containing non-finite values (stat_density).
## Warning: Removed 57 rows containing non-finite values (stat_density).
## Warning: Removed 815 rows containing non-finite values (stat_density).
## Warning: Removed 3 rows containing non-finite values (stat_density).
## Warning: Removed 43 rows containing non-finite values (stat_density).
## Warning: Removed 25 rows containing non-finite values (stat_density).
## Warning: Removed 1277 rows containing non-finite values (stat_density).
## Warning: Removed 18 rows containing non-finite values (stat_density).
## Warning: Removed 14 rows containing non-finite values (stat_density).
## Warning: Removed 248 rows containing non-finite values (stat_density).
## Warning: Removed 25 rows containing non-finite values (stat_density).
## Warning: Removed 4 rows containing non-finite values (stat_density).
## Warning: Removed 553 rows containing non-finite values (stat_density).
## Warning: Removed 34 rows containing non-finite values (stat_density).
## Warning: Removed 21 rows containing non-finite values (stat_density).
## Warning: Removed 56 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 7 rows containing non-finite values (stat_density).
## Warning: Removed 67 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).
## Warning: Removed 43 rows containing non-finite values (stat_density).
## Warning: Removed 33 rows containing non-finite values (stat_density).
## Warning: Removed 65 rows containing non-finite values (stat_density).
## Warning: Removed 10 rows containing non-finite values (stat_density).
## Warning: Removed 16 rows containing non-finite values (stat_density).
## Warning: Removed 2 rows containing non-finite values (stat_density).

notes: more common to renew or finance the new research