Reproducible Research
Brandon Gravett
8/27/2019
Analysis of Water Quality Data, Rice Rivers Center 2014
Introduction
This dataset is comprised of over 8200 records stored within a .csv file. In early 2014 for three months, measurements used to determine water quality were captured at fifteen minute intervals at the Rice River center. More than just water quality, the tidal forces acting on the river during this period can be gleaned using the elevation data which was also captured.
Telling you about the dataset is just as fascinating as viewing the .csv file in excel (its not). Instead through RStudio, this analysis will create usable information to make conclusions concerning water quality at Rice Rivers Center.
Methods
## Loading required package: RCurl## Loading required package: bitops## DateTime RecordID PAR
## 1/1/2014 1:00:00 AM: 1 Min. :43816 Min. : 0.000
## 1/1/2014 1:00:00 PM: 1 1st Qu.:45866 1st Qu.: 0.000
## 1/1/2014 1:15:00 AM: 1 Median :47915 Median : 0.046
## 1/1/2014 1:15:00 PM: 1 Mean :47915 Mean : 241.984
## 1/1/2014 1:30:00 AM: 1 3rd Qu.:49965 3rd Qu.: 337.900
## 1/1/2014 1:30:00 PM: 1 Max. :52014 Max. :1957.000
## (Other) :8193
## WindSpeed_mph WindDir AirTempF RelHumidity
## Min. : 0.000 Min. : 0.00 Min. : 3.749 Min. :15.37
## 1st Qu.: 2.467 1st Qu.: 37.31 1st Qu.:31.545 1st Qu.:42.25
## Median : 4.090 Median :137.30 Median :37.440 Median :56.40
## Mean : 5.446 Mean :146.20 Mean :38.795 Mean :58.37
## 3rd Qu.: 7.292 3rd Qu.:249.95 3rd Qu.:46.410 3rd Qu.:76.59
## Max. :30.650 Max. :360.00 Max. :74.870 Max. :93.00
##
## BP_HG Rain_in H2O_TempC SpCond_mScm
## Min. :29.11 Min. :0.0000000 Min. :-0.140 Min. :0.0110
## 1st Qu.:29.87 1st Qu.:0.0000000 1st Qu.: 3.930 1st Qu.:0.1430
## Median :30.01 Median :0.0000000 Median : 5.450 Median :0.1650
## Mean :30.02 Mean :0.0008412 Mean : 5.529 Mean :0.1611
## 3rd Qu.:30.21 3rd Qu.:0.0000000 3rd Qu.: 7.410 3rd Qu.:0.1760
## Max. :30.58 Max. :0.3470000 Max. :13.300 Max. :0.2110
## NA's :1 NA's :1
## Salinity_ppt PH PH_mv Turbidity_ntu
## Min. :0.0000 Min. :6.43 Min. :-113.8 Min. : 6.20
## 1st Qu.:0.0700 1st Qu.:7.50 1st Qu.: -47.8 1st Qu.: 15.50
## Median :0.0800 Median :7.58 Median : -43.8 Median : 21.80
## Mean :0.0759 Mean :7.60 Mean : -44.5 Mean : 24.54
## 3rd Qu.:0.0800 3rd Qu.:7.69 3rd Qu.: -38.9 3rd Qu.: 30.30
## Max. :0.1000 Max. :9.00 Max. : 28.5 Max. :187.70
## NA's :1 NA's :1 NA's :1 NA's :1
## Chla_ugl BGAPC_CML BGAPC_rfu ODO_sat
## Min. : 1.3 Min. : 188 Min. : 0.10 Min. : 87.5
## 1st Qu.: 3.7 1st Qu.: 971 1st Qu.: 0.50 1st Qu.: 99.2
## Median : 6.7 Median : 1369 Median : 0.70 Median :101.8
## Mean :137.3 Mean :153571 Mean : 72.91 Mean :102.0
## 3rd Qu.:302.6 3rd Qu.:345211 3rd Qu.:163.60 3rd Qu.:104.1
## Max. :330.1 Max. :345471 Max. :163.70 Max. :120.8
## NA's :1 NA's :1 NA's :1 NA's :1
## ODO_mgl Depth_ft Depth_m
## Min. :10.34 Min. :12.15 Min. :3.705
## 1st Qu.:12.34 1st Qu.:14.60 1st Qu.:4.451
## Median :12.88 Median :15.37 Median :4.684
## Mean :12.88 Mean :15.34 Mean :4.677
## 3rd Qu.:13.34 3rd Qu.:16.12 3rd Qu.:4.913
## Max. :14.99 Max. :17.89 Max. :5.454
## NA's :1
## SurfaceWaterElev_m_levelNad83m
## Min. :-32.53
## 1st Qu.:-31.78
## Median :-31.55
## Mean :-31.55
## 3rd Qu.:-31.32
## Max. :-30.78
## Here are the first 10 records from the dataset.
The first 10 records occurred early on January 1, 2014 and the measurements include PAR, wind speed, air temperature, rainfall, water temperature, pH, turbidity and depth just to name a few.
## DateTime RecordID PAR WindSpeed_mph WindDir AirTempF
## 1 1/1/2014 12:00:00 AM 43816 0 3.870 14.58 30.99
## 2 1/1/2014 12:15:00 AM 43817 0 4.787 18.53 30.72
## 3 1/1/2014 12:30:00 AM 43818 0 3.614 16.16 31.22
## 4 1/1/2014 12:45:00 AM 43819 0 2.986 11.47 30.54
## 5 1/1/2014 1:00:00 AM 43820 0 3.522 11.31 30.93
## 6 1/1/2014 1:15:00 AM 43821 0 3.827 20.02 30.61
## 7 1/1/2014 1:30:00 AM 43822 0 4.234 12.53 30.20
## 8 1/1/2014 1:45:00 AM 43823 0 4.379 16.28 30.33
## 9 1/1/2014 2:00:00 AM 43824 0 4.037 19.04 30.87
## 10 1/1/2014 2:15:00 AM 43825 0 3.637 29.40 31.94
## RelHumidity BP_HG Rain_in H2O_TempC SpCond_mScm Salinity_ppt PH PH_mv
## 1 80.50 30.30 0 6.44 0.130 0.06 7.22 -10.9
## 2 82.10 30.30 0 6.49 0.137 0.06 7.52 -26.8
## 3 81.90 30.29 0 6.38 0.134 0.06 7.53 -27.4
## 4 83.00 30.30 0 6.42 0.136 0.06 7.53 -27.4
## 5 81.80 30.30 0 6.35 0.132 0.06 7.55 -28.3
## 6 82.80 30.30 0 6.31 0.130 0.06 7.56 -29.1
## 7 82.20 30.30 0 6.35 0.130 0.06 7.56 -28.7
## 8 81.10 30.30 0 6.29 0.129 0.06 7.57 -29.7
## 9 76.00 30.30 0 6.47 0.136 0.06 7.57 -29.2
## 10 70.02 30.30 0 6.52 0.137 0.06 7.56 -28.9
## Turbidity_ntu Chla_ugl BGAPC_CML BGAPC_rfu ODO_sat ODO_mgl Depth_ft
## 1 20.3 3.7 717 0.4 96.3 11.85 15.324
## 2 21.8 3.2 736 0.4 99.9 12.28 15.512
## 3 21.8 3.6 565 0.3 100.6 12.40 15.695
## 4 21.4 3.5 894 0.5 100.3 12.35 15.844
## 5 22.0 3.4 861 0.4 101.4 12.51 15.981
## 6 21.9 3.5 625 0.3 102.1 12.61 16.099
## 7 22.2 3.3 781 0.4 101.8 12.56 16.219
## 8 22.9 3.5 786 0.4 102.5 12.66 16.318
## 9 21.0 3.7 895 0.5 100.5 12.36 16.404
## 10 21.4 3.2 682 0.3 100.2 12.31 16.478
## Depth_m SurfaceWaterElev_m_levelNad83m
## 1 4.670755 -31.55924
## 2 4.728058 -31.50194
## 3 4.783836 -31.44616
## 4 4.829251 -31.40075
## 5 4.871009 -31.35899
## 6 4.906976 -31.32302
## 7 4.943551 -31.28645
## 8 4.973727 -31.25627
## 9 4.999939 -31.23006
## 10 5.022495 -31.20750The table below shows the first variable (Wind Speed) in the dataset for the first ten measurements from least to greatest. Wind speed was measured in miles per hour.
## Wind Speed (mph)
## 2.986 3.522 3.614 3.637 3.827 3.87 4.037 4.234 4.379 4.787
## 1 1 1 1 1 1 1 1 1 1Plots
Histogram
Histograms are great because we can identify features (i.e max, min, outliers, etc.) of our data readily:
Scatterplot
A simple chart showing the measurements for pH helps visualize the fluctuations experienced at the center:
