R Markdown

This is an R Markdown document. This report is preliminary test report from Division of Administrative Services three years from 2018 to 2020: 1. Summary of duration of completed contract certification process 2. Summary of duration of contract certification in pipe line 3. Plots:

summary(mydata_completed$DurationInDays)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##     5.0   180.0   221.0   219.8   269.0   513.0
summary(mydata_open$DurationInDays)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   27.00   74.25  171.00  230.94  254.00  992.00

Plot for Division of Administrative Services

  1. Completed contract count histogram, histogram by funding description
  2. Contract in the piple line count histrogram, histrogram by funding description
## `stat_bin()` using `bins = 30`. Pick better value with `binwidth`.

## `geom_smooth()` using method = 'loess' and formula 'y ~ x'

## `geom_smooth()` using method = 'loess' and formula 'y ~ x'

## `stat_bin()` using `bins = 30`. Pick better value with `binwidth`.

## `stat_bin()` using `bins = 30`. Pick better value with `binwidth`.

Note: Test Report from SQL database.