Assignment
MariyamSaeed
2024-03-14
library(readxl)## Warning: package 'readxl' was built under R version 4.3.3my_data<- read.csv("C:/Users/DELL/Desktop/6th/computer Networks/bikes.csv")
my_data## date season holiday weekday weather temperature realfeel humidity
## 1 2011-01-01 1 0 6 2 46.71653 46.39865 0.805833
## 2 2011-01-02 1 0 0 2 48.35024 45.22419 0.696087
## 3 2011-01-03 1 0 1 1 34.21239 25.70131 0.437273
## 4 2011-01-04 1 0 2 1 34.52000 28.40009 0.590435
## 5 2011-01-05 1 0 3 1 36.80056 30.43728 0.436957
## 6 2011-01-06 1 0 4 1 34.88784 30.90523 0.518261
## 7 2011-01-07 1 0 5 2 34.22576 28.01007 0.498696
## 8 2011-01-08 1 0 6 2 31.55900 22.47578 0.535833
## 9 2011-01-09 1 0 0 1 29.30297 17.00159 0.434167
## 10 2011-01-10 1 0 1 1 30.36047 21.12549 0.482917
## 11 2011-01-11 1 0 2 2 31.90510 25.94592 0.686364
## 12 2011-01-12 1 0 3 1 32.21270 22.26419 0.599545
## 13 2011-01-13 1 0 4 1 31.55900 21.12490 0.470417
## 14 2011-01-14 1 0 5 1 31.20960 25.58346 0.537826
## 15 2011-01-15 1 0 6 2 37.33997 32.67571 0.498750
## 16 2011-01-16 1 0 0 1 37.19903 31.02498 0.483750
## 17 2011-01-17 1 1 1 2 32.47547 24.20039 0.537500
## 18 2011-01-18 1 0 2 2 35.93003 30.80116 0.861667
## 19 2011-01-19 1 0 3 2 42.31792 38.65253 0.741739
## 20 2011-01-20 1 0 4 2 39.73703 33.49994 0.538333
## 21 2011-01-21 1 0 5 1 32.61650 21.95056 0.457083
## 22 2011-01-22 1 0 6 1 22.60243 12.59347 0.400000
## 23 2011-01-23 1 0 0 1 25.76574 14.94209 0.436522
## 24 2011-01-24 1 0 1 1 25.83930 17.21008 0.491739
## 25 2011-01-25 1 0 2 2 36.50624 31.06169 0.616957
## 26 2011-01-26 1 0 3 3 36.00050 27.38768 0.862500
## 27 2011-01-27 1 0 4 1 34.09700 29.30036 0.687500
## 28 2011-01-28 1 0 5 2 34.81424 29.73006 0.793043
## 29 2011-01-29 1 0 6 1 34.22576 28.40057 0.651739
## 30 2011-01-30 1 0 0 1 35.91776 32.93825 0.722174
## 31 2011-01-31 1 0 1 2 32.89847 25.32650 0.603750
## 32 2011-02-01 1 0 2 2 33.85792 31.06216 0.829565
## 33 2011-02-02 1 0 3 2 39.59600 33.42474 0.775417
## 34 2011-02-03 1 0 4 1 33.41656 24.33191 0.437826
## 35 2011-02-04 1 0 5 2 35.47632 30.35614 0.585217
## 36 2011-02-05 1 0 6 2 37.33997 32.07529 0.929167
## 37 2011-02-06 1 0 0 1 41.78147 37.85051 0.568333
## 38 2011-02-07 1 0 1 1 40.58303 39.27457 0.738333
## 39 2011-02-08 1 0 2 1 36.28247 26.75162 0.537917
## 40 2011-02-09 1 0 3 2 29.00264 20.34082 0.494783
## 41 2011-02-10 1 0 4 1 29.81184 20.96630 0.437391
## 42 2011-02-11 1 0 5 1 33.59710 28.56487 0.506364
## 43 2011-02-12 1 0 6 1 36.42350 30.87494 0.544167
## 44 2011-02-13 1 0 0 1 44.37776 41.70462 0.457391
## 45 2011-02-14 1 0 1 1 52.70900 50.52398 0.375833
## 46 2011-02-15 1 0 2 1 40.11096 33.40775 0.314348
## 47 2011-02-16 1 0 3 1 44.52488 40.76456 0.423478
## 48 2011-02-17 1 0 4 1 54.47147 54.12457 0.505000
## 49 2011-02-18 1 0 5 1 61.73303 64.02358 0.516667
## 50 2011-02-19 1 0 6 1 51.36953 49.69880 0.187917
## 51 2011-02-20 1 0 0 1 41.72936 36.14680 0.407826
## 52 2011-02-21 1 1 1 2 43.26197 36.94811 0.605000
## 53 2011-02-22 1 0 2 1 33.01598 25.30072 0.577778
## 54 2011-02-23 1 0 3 1 36.35912 32.39118 0.423043
## 55 2011-02-24 1 0 4 2 42.61216 37.55589 0.697391
## 56 2011-02-25 1 0 5 2 48.42384 44.83477 0.712174
## 57 2011-02-26 1 0 6 1 41.49950 36.72441 0.537917
## 58 2011-02-27 1 0 0 1 46.65824 44.91175 0.680000
## 59 2011-02-28 1 0 1 2 52.05530 50.73402 0.876364
## 60 2011-03-01 1 0 2 1 40.16003 34.54883 0.535000
## 61 2011-03-02 1 0 3 1 45.94100 41.22443 0.449583
## 62 2011-03-03 1 0 4 1 34.37897 26.97580 0.318333
## 63 2011-03-04 1 0 5 2 39.73703 33.57467 0.610417
## 64 2011-03-05 1 0 6 2 50.10053 48.19895 0.789167
## 65 2011-03-06 1 0 0 2 49.45376 46.71074 0.948261
## 66 2011-03-07 1 0 1 1 39.74312 31.52917 0.551304
## 67 2011-03-08 1 0 2 1 42.34550 39.12512 0.420833
## 68 2011-03-09 1 0 3 2 42.62747 37.24903 0.775417
## 69 2011-03-10 1 0 4 3 50.51710 49.01736 0.000000
## 70 2011-03-11 1 0 5 2 44.37776 39.43400 0.649565
## 71 2011-03-12 1 0 6 1 45.44753 41.89910 0.594583
## 72 2011-03-13 1 0 0 1 50.11584 48.35481 0.527391
## 73 2011-03-14 1 0 1 1 45.11336 42.64160 0.496957
## 74 2011-03-15 1 0 2 2 44.45128 40.99955 0.655652
## 75 2011-03-16 1 0 3 2 48.49736 46.79128 0.776522
## 76 2011-03-17 1 0 4 1 52.70900 51.94756 0.602917
## 77 2011-03-18 1 0 5 1 63.28400 65.80867 0.525217
## 78 2011-03-19 1 0 6 1 57.57350 58.62317 0.379167
## 79 2011-03-20 1 0 0 1 45.72950 41.89910 0.473750
## 80 2011-03-21 2 0 1 2 54.01480 51.87652 0.737391
## 81 2011-03-22 2 0 2 1 54.96503 55.54827 0.624583
## 82 2011-03-23 2 0 3 2 46.95256 43.34715 0.839565
## 83 2011-03-24 2 0 4 2 41.71100 35.37496 0.805833
## 84 2011-03-25 2 0 5 1 39.94853 33.64987 0.495000
## 85 2011-03-26 2 0 6 1 40.08947 33.79943 0.394167
## 86 2011-03-27 2 0 0 2 39.00744 32.94027 0.493913
## 87 2011-03-28 2 0 1 1 39.96384 33.79979 0.302174
## 88 2011-03-29 2 0 2 1 43.19150 37.99747 0.314167
## 89 2011-03-30 2 0 3 2 42.98000 38.52518 0.646667
## 90 2011-03-31 2 0 4 3 40.30097 33.79991 0.918333
## 91 2011-04-01 2 0 5 2 42.98000 36.87434 0.686250
## 92 2011-04-02 2 0 6 2 44.24900 40.69768 0.653750
## 93 2011-04-03 2 0 0 1 49.60697 48.19752 0.480000
## 94 2011-04-04 2 0 1 1 66.10397 67.69997 0.426250
## 95 2011-04-05 2 0 2 2 52.63853 50.52398 0.642083
## 96 2011-04-06 2 0 3 1 50.66447 49.24783 0.470833
## 97 2011-04-07 2 0 4 1 54.61250 54.72308 0.602917
## 98 2011-04-08 2 0 5 2 46.01147 41.74811 0.836250
## 99 2011-04-09 2 0 6 2 46.57550 43.77365 0.877500
## 100 2011-04-10 2 0 0 2 53.69603 53.89636 0.857500
## 101 2011-04-11 2 0 1 2 67.99216 70.34778 0.716956
## 102 2011-04-12 2 0 2 2 60.11150 61.77482 0.739167
## 103 2011-04-13 2 0 3 2 52.49750 52.77322 0.819167
## 104 2011-04-14 2 0 4 1 57.15050 58.17375 0.540417
## 105 2011-04-15 2 1 5 1 55.38803 55.69926 0.671250
## 106 2011-04-16 2 0 6 3 54.04847 53.74845 0.888333
## 107 2011-04-17 2 0 0 1 56.23403 56.14868 0.479583
## 108 2011-04-18 2 0 1 1 60.95750 62.97374 0.542500
## 109 2011-04-19 2 0 2 2 60.39347 61.32385 0.665833
## 110 2011-04-20 2 0 3 1 67.93700 70.24977 0.614167
## 111 2011-04-21 2 0 4 1 56.44553 57.12237 0.407083
## 112 2011-04-22 2 0 5 2 46.08203 41.44814 0.729583
## 113 2011-04-23 2 0 6 2 56.51600 56.67437 0.887917
## 114 2011-04-24 2 0 0 2 66.80903 68.74944 0.810833
## 115 2011-04-25 2 0 1 1 68.92403 71.45060 0.776667
## 116 2011-04-26 2 0 2 1 71.03903 73.77706 0.729167
## 117 2011-04-27 2 0 3 2 70.05200 71.52687 0.835417
## 118 2011-04-28 2 0 4 2 69.84050 71.97677 0.700833
## 119 2011-04-29 2 0 5 1 60.74600 62.29860 0.457083
## 120 2011-04-30 2 0 6 1 57.57350 58.32569 0.503333
## 121 2011-05-01 2 0 0 2 55.81103 56.44664 0.762083
## 122 2011-05-02 2 0 1 2 64.05953 66.50056 0.730000
## 123 2011-05-03 2 0 2 2 69.77003 72.35099 0.697083
## 124 2011-05-04 2 0 3 2 52.63853 51.27242 0.737083
## 125 2011-05-05 2 0 4 1 56.44553 55.69974 0.444167
## 126 2011-05-06 2 0 5 1 58.13753 59.52510 0.590000
## 127 2011-05-07 2 0 6 1 61.59200 64.09937 0.541250
## 128 2011-05-08 2 0 0 1 62.29697 64.84924 0.631667
## 129 2011-05-09 2 0 1 1 62.64950 65.59922 0.588750
## 130 2011-05-10 2 0 2 1 62.64950 65.29925 0.489167
## 131 2011-05-11 2 0 3 1 63.49550 65.97392 0.632917
## 132 2011-05-12 2 0 4 1 62.86100 65.37552 0.747500
## 133 2011-05-13 2 0 5 2 60.95750 61.92284 0.863333
## 134 2011-05-14 2 0 6 2 61.66247 62.67473 0.922500
## 135 2011-05-15 2 0 0 2 65.18750 66.87680 0.867083
## 136 2011-05-16 2 0 1 1 66.45650 68.60083 0.787917
## 137 2011-05-17 2 0 2 2 65.11703 67.17725 0.837917
## 138 2011-05-18 2 0 3 2 64.13000 65.82637 0.870000
## 139 2011-05-19 2 0 4 2 62.50847 63.87615 0.829583
## 140 2011-05-20 2 0 5 1 63.00203 66.05019 0.719583
## 141 2011-05-21 2 0 6 1 68.57150 71.15063 0.626667
## 142 2011-05-22 2 0 0 1 68.71253 71.45060 0.749583
## 143 2011-05-23 2 0 1 2 71.03903 73.32716 0.810000
## 144 2011-05-24 2 0 2 2 73.43600 75.05178 0.740833
## 145 2011-05-25 2 0 3 1 73.50647 76.32639 0.696250
## 146 2011-05-26 2 0 4 1 77.52497 80.97693 0.677500
## 147 2011-05-27 2 0 5 1 75.26903 78.87655 0.653750
## 148 2011-05-28 2 0 6 1 73.08347 75.95063 0.729583
## 149 2011-05-29 2 0 0 1 74.07050 76.32734 0.818750
## 150 2011-05-30 2 1 1 1 79.63997 82.92573 0.685000
## 151 2011-05-31 2 0 2 1 83.16500 89.37550 0.636667
## 152 2011-06-01 2 0 3 2 82.24853 88.85088 0.677083
## 153 2011-06-02 2 0 4 1 78.08900 79.70031 0.305000
## 154 2011-06-03 2 0 5 1 70.05200 72.95140 0.354167
## 155 2011-06-04 2 0 6 1 71.32100 73.84988 0.456250
## 156 2011-06-05 2 0 0 2 72.44897 76.47632 0.652500
## 157 2011-06-06 2 0 1 1 74.98697 77.07673 0.600000
## 158 2011-06-07 2 0 2 1 77.45450 81.12686 0.597917
## 159 2011-06-08 2 0 3 1 83.23547 89.60075 0.622083
## 160 2011-06-09 2 0 4 2 85.98497 93.20039 0.568333
## 161 2011-06-10 2 0 5 1 81.47300 86.75109 0.605000
## 162 2011-06-11 2 0 6 1 78.93500 83.75091 0.654583
## 163 2011-06-12 2 0 0 1 76.18550 79.62701 0.747917
## 164 2011-06-13 2 0 1 1 71.32100 74.67650 0.494583
## 165 2011-06-14 2 0 2 1 68.71253 73.47566 0.507083
## 166 2011-06-15 2 0 3 1 70.61603 73.02518 0.471667
## 167 2011-06-16 2 0 4 2 70.75697 73.92710 0.688333
## 168 2011-06-17 2 0 5 1 72.51953 74.52550 0.735833
## 169 2011-06-18 2 0 6 1 76.53803 79.70174 0.670417
## 170 2011-06-19 2 0 0 2 76.74953 79.92650 0.666667
## 171 2011-06-20 2 0 1 2 71.32100 73.92710 0.746250
## 172 2011-06-21 3 0 2 2 75.19847 78.95234 0.770417
## 173 2011-06-22 3 0 3 1 79.63997 85.62689 0.707500
## 174 2011-06-23 3 0 4 2 79.21697 85.62736 0.703333
## 175 2011-06-24 3 0 5 1 78.86453 81.20206 0.573333
## 176 2011-06-25 3 0 6 1 76.39700 79.62558 0.483333
## 177 2011-06-26 3 0 0 1 75.12800 78.95033 0.513333
## 178 2011-06-27 3 0 1 2 75.33950 78.87608 0.658333
## 179 2011-06-28 3 0 2 1 80.55653 85.47589 0.634167
## 180 2011-06-29 3 0 3 1 79.21697 80.97693 0.497917
## 181 2011-06-30 3 0 4 1 76.53803 78.87655 0.434167
## 182 2011-07-01 3 0 5 1 78.72350 80.67685 0.396250
## 183 2011-07-02 3 0 6 1 80.06297 82.47619 0.444583
## 184 2011-07-03 3 0 0 2 78.23003 82.62671 0.682500
## 185 2011-07-04 3 1 1 2 79.07603 82.25154 0.637917
## 186 2011-07-05 3 0 2 1 80.76803 85.92495 0.590417
## 187 2011-07-06 3 0 3 1 78.51200 84.65320 0.743333
## 188 2011-07-07 3 0 4 1 81.05000 84.80027 0.651250
## 189 2011-07-08 3 0 5 2 77.59553 82.85338 0.757917
## 190 2011-07-09 3 0 6 1 79.63997 82.10197 0.609167
## 191 2011-07-10 3 0 0 1 80.83850 85.17497 0.578333
## 192 2011-07-11 3 0 1 1 82.10750 89.90072 0.635833
## 193 2011-07-12 3 0 2 1 84.78653 91.02587 0.559167
## 194 2011-07-13 3 0 3 1 80.76803 85.10120 0.631667
## 195 2011-07-14 3 0 4 1 75.19847 78.65036 0.476250
## 196 2011-07-15 3 0 5 1 73.71797 77.37527 0.591250
## 197 2011-07-16 3 0 6 1 75.69203 79.02564 0.585000
## 198 2011-07-17 3 0 0 1 78.44153 82.77616 0.604167
## 199 2011-07-18 3 0 1 1 80.76803 86.82629 0.651250
## 200 2011-07-19 3 0 2 1 83.30603 92.00051 0.650417
## 201 2011-07-20 3 0 3 1 82.60097 91.92578 0.707083
## 202 2011-07-21 3 0 4 2 86.54900 101.37287 0.691250
## 203 2011-07-22 3 0 5 1 89.36897 103.09844 0.580417
## 204 2011-07-23 3 0 6 1 89.43953 98.74930 0.500000
## 205 2011-07-24 3 0 0 1 87.81800 97.62569 0.550833
## 206 2011-07-25 3 0 1 1 80.48597 88.84981 0.757083
## 207 2011-07-26 3 0 2 1 82.88303 86.00111 0.540833
## 208 2011-07-27 3 0 3 1 83.16500 85.25124 0.402917
## 209 2011-07-28 3 0 4 1 83.51753 91.10012 0.583333
## 210 2011-07-29 3 0 5 1 88.52297 96.57288 0.542500
## 211 2011-07-30 3 0 6 1 85.63253 89.75020 0.465833
## 212 2011-07-31 3 0 0 1 85.77347 89.89976 0.480833
## 213 2011-08-01 3 0 1 1 82.88303 86.75109 0.550833
## 214 2011-08-02 3 0 2 1 83.86997 87.20003 0.491250
## 215 2011-08-03 3 0 3 2 79.49903 83.97652 0.657500
## 216 2011-08-04 3 0 4 2 77.66600 82.17681 0.757500
## 217 2011-08-05 3 0 5 1 77.73647 81.20016 0.630833
## 218 2011-08-06 3 0 6 2 78.23003 83.52710 0.755000
## 219 2011-08-07 3 0 0 1 80.41550 88.17669 0.752917
## 220 2011-08-08 3 0 1 1 82.31900 86.75002 0.592083
## 221 2011-08-09 3 0 2 1 83.16500 89.22557 0.570417
## 222 2011-08-10 3 0 3 1 82.46003 84.57598 0.424167
## 223 2011-08-11 3 0 4 1 78.30050 80.60069 0.423750
## 224 2011-08-12 3 0 5 1 77.52497 80.90019 0.415000
## 225 2011-08-13 3 0 6 2 75.62147 79.92793 0.729583
## 226 2011-08-14 3 0 0 2 74.84603 77.37729 0.817500
## 227 2011-08-15 3 0 1 1 73.92947 76.40064 0.712083
## 228 2011-08-16 3 0 2 1 76.89047 79.92544 0.578333
## 229 2011-08-17 3 0 3 1 78.79397 82.40051 0.575417
## 230 2011-08-18 3 0 4 1 77.80703 81.87625 0.654583
## 231 2011-08-19 3 0 5 2 75.55100 78.42665 0.722917
## 232 2011-08-20 3 0 6 1 76.60850 80.30072 0.674167
## 233 2011-08-21 3 0 0 1 77.73647 83.45237 0.770000
## 234 2011-08-22 3 0 1 1 76.11503 79.02458 0.470000
## 235 2011-08-23 3 0 2 1 71.81447 75.20076 0.455417
## 236 2011-08-24 3 0 3 1 74.56397 78.12621 0.605000
## 237 2011-08-25 3 0 4 2 75.48053 79.92746 0.771667
## 238 2011-08-26 3 0 5 1 76.82000 81.57628 0.761250
## 239 2011-08-27 3 0 6 2 75.12800 78.70405 0.850000
## 240 2011-08-28 3 0 0 1 77.41719 80.17753 0.561765
## 241 2011-08-29 3 0 1 1 71.46203 75.42541 0.554583
## 242 2011-08-30 3 0 2 1 71.67353 73.85084 0.548333
## 243 2011-08-31 3 0 3 1 73.15403 75.80117 0.597917
## 244 2011-09-01 3 0 4 1 73.01300 76.25261 0.639167
## 245 2011-09-02 3 0 5 2 72.02597 75.05119 0.727083
## 246 2011-09-03 3 0 6 1 74.21153 78.42570 0.716667
## 247 2011-09-04 3 0 0 1 77.59553 82.25297 0.742083
## 248 2011-09-05 3 1 1 2 74.56397 77.52674 0.790417
## 249 2011-09-06 3 0 2 3 63.28400 64.40576 0.886957
## 250 2011-09-07 3 0 3 3 68.28953 67.85441 0.917083
## 251 2011-09-08 3 0 4 3 71.22904 69.17689 0.939565
## 252 2011-09-09 3 0 5 2 72.59000 71.97878 0.897917
## 253 2011-09-10 3 0 6 1 73.43600 75.42589 0.753750
## 254 2011-09-11 3 0 0 1 72.87197 75.57641 0.713750
## 255 2011-09-12 3 0 1 1 72.11184 74.73304 0.692174
## 256 2011-09-13 3 0 2 1 72.66047 74.90222 0.712500
## 257 2011-09-14 3 0 3 1 74.56397 77.67572 0.697083
## 258 2011-09-15 3 0 4 2 66.45650 68.97611 0.709167
## 259 2011-09-16 3 0 5 2 57.29153 58.02323 0.590417
## 260 2011-09-17 3 0 6 2 59.19503 60.04723 0.718333
## 261 2011-09-18 3 0 0 1 60.53450 61.47580 0.695000
## 262 2011-09-19 3 0 1 2 64.05953 66.12539 0.690000
## 263 2011-09-20 3 0 2 2 65.11703 66.42738 0.881250
## 264 2011-09-21 3 0 3 2 67.93700 68.60332 0.900000
## 265 2011-09-22 3 0 4 2 70.75697 69.12960 0.902083
## 266 2011-09-23 4 0 5 2 69.13553 65.22845 0.972500
## 267 2011-09-24 4 0 6 2 68.92403 70.25215 0.862500
## 268 2011-09-25 4 0 0 2 71.25053 71.22928 0.845000
## 269 2011-09-26 4 0 1 2 72.51953 73.17819 0.848333
## 270 2011-09-27 4 0 2 2 71.46203 71.45357 0.885417
## 271 2011-09-28 4 0 3 2 71.32100 71.52877 0.848750
## 272 2011-09-29 4 0 4 1 69.77003 71.45203 0.699167
## 273 2011-09-30 4 0 5 1 65.32853 67.92569 0.647500
## 274 2011-10-01 4 0 6 2 52.28600 52.24812 0.753750
## 275 2011-10-02 4 0 0 2 47.77403 44.22366 0.791667
## 276 2011-10-03 4 0 1 2 50.10053 49.77506 0.760833
## 277 2011-10-04 4 0 2 1 58.56053 59.37553 0.710000
## 278 2011-10-05 4 0 3 1 63.14297 65.82399 0.647917
## 279 2011-10-06 4 0 4 1 59.40653 60.27449 0.620833
## 280 2011-10-07 4 0 5 1 60.81647 63.12320 0.684167
## 281 2011-10-08 4 0 6 1 61.73303 64.17315 0.701250
## 282 2011-10-09 4 0 0 1 63.35447 65.44918 0.727500
## 283 2011-10-10 4 1 1 1 65.89247 67.69949 0.733750
## 284 2011-10-11 4 0 2 2 65.54003 68.07620 0.808750
## 285 2011-10-12 4 0 3 3 63.56597 64.70478 0.906250
## 286 2011-10-13 4 0 4 2 67.44353 68.75432 0.896667
## 287 2011-10-14 4 0 5 2 64.20047 66.12539 0.716250
## 288 2011-10-15 4 0 6 1 60.46403 62.44853 0.483333
## 289 2011-10-16 4 0 0 1 60.88703 62.97470 0.486667
## 290 2011-10-17 4 0 1 1 62.79053 63.87413 0.579583
## 291 2011-10-18 4 0 2 2 62.64950 65.29925 0.701667
## 292 2011-10-19 4 0 3 3 63.43112 64.24514 0.895217
## 293 2011-10-20 4 0 4 1 57.85547 58.62317 0.636250
## 294 2011-10-21 4 0 5 1 53.76650 53.52320 0.574167
## 295 2011-10-22 4 0 6 1 53.34350 53.74845 0.629167
## 296 2011-10-23 4 0 0 1 53.27303 53.37316 0.741250
## 297 2011-10-24 4 0 1 1 56.79797 57.49956 0.772083
## 298 2011-10-25 4 0 2 1 57.50303 58.24895 0.622917
## 299 2011-10-26 4 0 3 2 58.56053 59.37410 0.720417
## 300 2011-10-27 4 0 4 2 57.36200 57.49706 0.812917
## 301 2011-10-28 4 0 5 2 45.58847 41.07487 0.585833
## 302 2011-10-29 4 0 6 3 39.10253 30.27606 0.882500
## 303 2011-10-30 4 0 0 1 44.60153 41.37389 0.623750
## 304 2011-10-31 4 0 1 1 46.36400 45.50028 0.703333
## 305 2011-11-01 4 0 2 1 51.51047 50.37405 0.683750
## 306 2011-11-02 4 0 3 1 49.53650 49.54780 0.718750
## 307 2011-11-03 4 0 4 1 52.14497 51.42341 0.702083
## 308 2011-11-04 4 0 5 2 51.72197 51.12297 0.622500
## 309 2011-11-05 4 0 6 1 45.23603 41.67386 0.519167
## 310 2011-11-06 4 0 0 1 47.06897 46.24813 0.734583
## 311 2011-11-07 4 0 1 1 51.01700 50.82347 0.758750
## 312 2011-11-08 4 0 2 1 52.14497 52.17482 0.721667
## 313 2011-11-09 4 0 3 1 51.44000 51.79859 0.758333
## 314 2011-11-10 4 0 4 2 49.74800 47.59805 0.813333
## 315 2011-11-11 4 1 5 1 45.02453 39.64986 0.446250
## 316 2011-11-12 4 0 6 1 47.77403 45.72351 0.552917
## 317 2011-11-13 4 0 0 1 54.89447 54.34934 0.458333
## 318 2011-11-14 4 0 1 1 62.43800 65.52391 0.587083
## 319 2011-11-15 4 0 2 2 62.43800 63.50039 0.688750
## 320 2011-11-16 4 0 3 3 56.23403 56.89617 0.930000
## 321 2011-11-17 4 0 4 2 46.50503 41.59865 0.575833
## 322 2011-11-18 4 0 5 1 40.79453 35.59925 0.410000
## 323 2011-11-19 4 0 6 1 45.44753 41.74858 0.502083
## 324 2011-11-20 4 0 0 2 56.79797 57.49849 0.684583
## 325 2011-11-21 4 0 1 3 55.45850 56.07337 0.910000
## 326 2011-11-22 4 0 2 3 52.85003 53.29748 0.962500
## 327 2011-11-23 4 0 3 2 54.89447 54.34780 0.757917
## 328 2011-11-24 4 1 4 1 49.18397 47.44955 0.549167
## 329 2011-11-25 4 0 5 1 49.32500 48.42371 0.643750
## 330 2011-11-26 4 0 6 1 49.39547 48.94834 0.681667
## 331 2011-11-27 4 0 0 1 56.44553 57.34904 0.698333
## 332 2011-11-28 4 0 1 1 60.19424 61.42649 0.743043
## 333 2011-11-29 4 0 2 2 56.37497 56.82335 0.830833
## 334 2011-11-30 4 0 3 1 45.09500 40.17305 0.613333
## 335 2011-12-01 4 0 4 1 44.03750 39.49982 0.524583
## 336 2011-12-02 4 0 5 1 44.17853 42.57424 0.625833
## 337 2011-12-03 4 0 6 1 42.90953 40.09976 0.612917
## 338 2011-12-04 4 0 0 1 45.58847 44.67308 0.775833
## 339 2011-12-05 4 0 1 2 50.24147 49.99829 0.827083
## 340 2011-12-06 4 0 2 3 56.72750 57.42032 0.949583
## 341 2011-12-07 4 0 3 3 52.28600 50.74922 0.970417
## 342 2011-12-08 4 0 4 1 40.08947 33.72423 0.580000
## 343 2011-12-09 4 0 5 1 42.20447 40.92399 0.695833
## 344 2011-12-10 4 0 6 1 40.86500 34.84975 0.507500
## 345 2011-12-11 4 0 0 1 36.28247 33.27470 0.490000
## 346 2011-12-12 4 0 1 1 37.76297 35.29928 0.670833
## 347 2011-12-13 4 0 2 1 41.49950 38.97519 0.590000
## 348 2011-12-14 4 0 3 2 44.46050 43.39741 0.663750
## 349 2011-12-15 4 0 4 2 53.34350 52.17376 0.634167
## 350 2011-12-16 4 0 5 2 49.32500 45.94721 0.500417
## 351 2011-12-17 4 0 6 2 39.45497 32.82527 0.560833
## 352 2011-12-18 4 0 0 1 37.76297 32.37479 0.586250
## 353 2011-12-19 4 0 1 1 41.00603 36.57484 0.637500
## 354 2011-12-20 4 0 2 2 50.24147 50.29874 0.595417
## 355 2011-12-21 1 0 3 2 53.83697 54.04842 0.858333
## 356 2011-12-22 1 0 4 2 53.41397 53.82317 0.757500
## 357 2011-12-23 1 0 5 1 49.18397 48.04854 0.686250
## 358 2011-12-24 1 0 6 1 43.19150 38.74995 0.542500
## 359 2011-12-25 1 0 0 1 40.84664 36.45937 0.681304
## 360 2011-12-26 1 1 1 1 44.81912 40.68556 0.506957
## 361 2011-12-27 1 0 2 2 45.09500 42.12280 0.762500
## 362 2011-12-28 1 0 3 1 42.90640 36.46091 0.503913
## 363 2011-12-29 1 0 4 1 38.60897 34.55037 0.574167
## 364 2011-12-30 1 0 5 1 43.96703 41.07487 0.636667
## 365 2011-12-31 1 0 6 1 52.28600 52.39757 0.615833
## 366 2012-01-01 1 0 0 1 48.90200 47.82377 0.692500
## 367 2012-01-02 1 1 1 1 40.69944 33.17372 0.381304
## 368 2012-01-03 1 0 2 1 30.29000 18.20147 0.441250
## 369 2012-01-04 1 0 3 2 26.69450 17.37724 0.414583
## 370 2012-01-05 1 0 4 1 40.08947 36.27535 0.524167
## 371 2012-01-06 1 0 5 1 45.87053 43.62372 0.542083
## 372 2012-01-07 1 0 6 1 50.87597 49.62455 0.531667
## 373 2012-01-08 1 0 0 1 46.15250 43.62265 0.465000
## 374 2012-01-09 1 0 1 2 36.56453 32.60051 0.701667
## 375 2012-01-10 1 0 2 1 43.71568 41.07653 0.646522
## 376 2012-01-11 1 0 3 2 40.79453 36.79913 0.847500
## 377 2012-01-12 1 0 4 2 49.95950 48.57423 0.802917
## 378 2012-01-13 1 0 5 1 40.79453 32.82421 0.507500
## 379 2012-01-14 1 0 6 1 32.82800 24.95074 0.457500
## 380 2012-01-15 1 0 0 1 31.70003 22.40105 0.419167
## 381 2012-01-16 1 1 1 1 33.67400 25.85076 0.522500
## 382 2012-01-17 1 0 2 2 49.15944 46.47623 0.716087
## 383 2012-01-18 1 0 3 1 43.26197 35.90018 0.443333
## 384 2012-01-19 1 0 4 1 33.67400 25.77651 0.497500
## 385 2012-01-20 1 0 5 2 36.00050 29.44981 0.450000
## 386 2012-01-21 1 0 6 2 32.26397 23.97515 0.831250
## 387 2012-01-22 1 0 0 2 31.34750 22.47530 0.796250
## 388 2012-01-23 1 0 1 2 36.07097 32.07529 0.911250
## 389 2012-01-24 1 0 2 1 46.57550 44.67403 0.835833
## 390 2012-01-25 1 0 3 1 42.48653 38.22473 0.643750
## 391 2012-01-26 1 0 4 2 46.50503 45.49874 0.769583
## 392 2012-01-27 1 0 5 2 53.55500 52.54750 0.741250
## 393 2012-01-28 1 0 6 1 44.31947 41.97383 0.543333
## 394 2012-01-29 1 0 0 1 41.49950 35.59925 0.311250
## 395 2012-01-30 1 0 1 1 40.37153 34.39985 0.400833
## 396 2012-01-31 1 0 2 1 50.59400 48.50046 0.416667
## 397 2012-02-01 1 0 3 1 57.29153 58.62471 0.507917
## 398 2012-02-02 1 0 4 2 51.36953 50.59775 0.672917
## 399 2012-02-03 1 0 5 1 44.10797 39.95030 0.526667
## 400 2012-02-04 1 0 6 2 39.94853 35.59973 0.779583
## 401 2012-02-05 1 0 0 2 40.08947 34.62509 0.687917
## 402 2012-02-06 1 0 1 1 41.50872 38.41541 0.622174
## 403 2012-02-07 1 0 2 1 47.56253 46.09916 0.496250
## 404 2012-02-08 1 0 3 2 39.31403 34.85081 0.722917
## 405 2012-02-09 1 0 4 1 40.01900 34.32417 0.562083
## 406 2012-02-10 1 0 5 2 41.35847 38.07469 0.540000
## 407 2012-02-11 1 0 6 3 36.56453 28.25100 0.731250
## 408 2012-02-12 1 0 0 1 28.38650 15.27697 0.464583
## 409 2012-02-13 1 0 1 1 36.42350 30.27606 0.411250
## 410 2012-02-14 1 0 2 2 44.60153 42.87278 0.508750
## 411 2012-02-15 1 0 3 1 47.06897 44.97353 0.531250
## 412 2012-02-16 1 0 4 2 44.39003 42.42325 0.752917
## 413 2012-02-17 1 0 5 1 46.64597 44.97353 0.634583
## 414 2012-02-18 1 0 6 1 46.92803 45.42449 0.534583
## 415 2012-02-19 1 0 0 2 41.28800 34.77561 0.515833
## 416 2012-02-20 1 1 1 1 41.28800 35.67885 0.507826
## 417 2012-02-21 1 0 2 1 41.95008 38.25942 0.594348
## 418 2012-02-22 1 0 3 1 51.08747 49.84884 0.567917
## 419 2012-02-23 1 0 4 1 56.02253 56.00018 0.554583
## 420 2012-02-24 1 0 5 2 52.07450 52.02335 0.737500
## 421 2012-02-25 1 0 6 1 42.20447 33.57419 0.395833
## 422 2012-02-26 1 0 0 1 41.21753 35.07499 0.410000
## 423 2012-02-27 1 0 1 1 48.62003 45.72494 0.490833
## 424 2012-02-28 1 0 2 1 47.98553 45.19877 0.395833
## 425 2012-02-29 1 0 3 2 46.73184 44.59824 0.804783
## 426 2012-03-01 1 0 4 1 58.70147 59.67407 0.615417
## 427 2012-03-02 1 0 5 2 47.49197 45.94923 0.657083
## 428 2012-03-03 1 0 6 2 52.63853 52.32285 0.621250
## 429 2012-03-04 1 0 0 1 45.16547 39.19889 0.403333
## 430 2012-03-05 1 0 1 1 38.18597 31.85111 0.506250
## 431 2012-03-06 1 0 2 1 39.45497 33.49899 0.456667
## 432 2012-03-07 1 0 3 1 51.79253 48.94988 0.513333
## 433 2012-03-08 1 0 4 1 62.22650 65.52296 0.567500
## 434 2012-03-09 1 0 5 2 52.35647 50.37346 0.407083
## 435 2012-03-10 1 0 6 1 41.92250 36.19872 0.350417
## 436 2012-03-11 1 0 0 1 48.20312 45.92880 0.476957
## 437 2012-03-12 1 0 1 1 57.08003 57.79953 0.489167
## 438 2012-03-13 1 0 2 1 65.39900 67.69997 0.617500
## 439 2012-03-14 1 0 3 1 66.03350 68.37570 0.507083
## 440 2012-03-15 1 0 4 1 64.76450 66.49961 0.579583
## 441 2012-03-16 1 0 5 2 54.47147 55.02401 0.842083
## 442 2012-03-17 1 0 6 2 61.09853 63.19946 0.755833
## 443 2012-03-18 1 0 0 2 57.57350 58.32320 0.810000
## 444 2012-03-19 1 0 1 1 63.70700 66.49913 0.728750
## 445 2012-03-20 1 0 2 1 65.04647 67.17772 0.807917
## 446 2012-03-21 2 0 3 2 62.57903 64.17505 0.821250
## 447 2012-03-22 2 0 4 1 64.48253 66.35016 0.831250
## 448 2012-03-23 2 0 5 2 68.50103 70.92396 0.694167
## 449 2012-03-24 2 0 6 2 60.11150 61.02388 0.885417
## 450 2012-03-25 2 0 0 2 54.61250 55.17357 0.880833
## 451 2012-03-26 2 0 1 1 55.31747 55.32350 0.477917
## 452 2012-03-27 2 0 2 1 44.95397 40.69970 0.290000
## 453 2012-03-28 2 0 3 1 58.56053 59.14886 0.481250
## 454 2012-03-29 2 0 4 1 59.40653 60.49772 0.439167
## 455 2012-03-30 2 0 5 2 48.90200 47.82377 0.580833
## 456 2012-03-31 2 0 6 2 53.48453 53.29891 0.738333
## 457 2012-04-01 2 0 0 2 53.62547 52.77370 0.676250
## 458 2012-04-02 2 0 1 1 54.30904 53.98854 0.504348
## 459 2012-04-03 2 0 2 1 57.08003 58.02418 0.396667
## 460 2012-04-04 2 0 3 1 63.42503 66.57386 0.469583
## 461 2012-04-05 2 0 4 1 54.40100 54.42216 0.374167
## 462 2012-04-06 2 0 5 1 51.72197 49.62312 0.377083
## 463 2012-04-07 2 0 6 1 54.61250 53.82413 0.254167
## 464 2012-04-08 2 0 0 1 59.90000 61.70009 0.275833
## 465 2012-04-09 2 0 1 1 58.98353 59.82459 0.317500
## 466 2012-04-10 2 0 2 1 55.38803 55.02448 0.435000
## 467 2012-04-11 2 0 3 1 47.09968 43.26815 0.469565
## 468 2012-04-12 2 0 4 1 51.22850 49.24736 0.466250
## 469 2012-04-13 2 0 5 1 55.03550 54.49879 0.408333
## 470 2012-04-14 2 0 6 1 59.47700 61.17392 0.502917
## 471 2012-04-15 2 0 0 1 68.92403 71.37635 0.507917
## 472 2012-04-16 2 1 1 1 73.78853 76.25309 0.561667
## 473 2012-04-17 2 0 2 1 69.06497 74.30026 0.390417
## 474 2012-04-18 2 0 3 2 56.79797 57.49611 0.569167
## 475 2012-04-19 2 0 4 1 59.75897 61.77386 0.612500
## 476 2012-04-20 2 0 5 1 62.15603 64.47407 0.694583
## 477 2012-04-21 2 0 6 1 65.82200 67.69901 0.682917
## 478 2012-04-22 2 0 0 3 51.15803 49.47308 0.835417
## 479 2012-04-23 2 0 1 2 44.81303 38.97365 0.766667
## 480 2012-04-24 2 0 2 1 52.56797 51.34762 0.454167
## 481 2012-04-25 2 0 3 1 57.92603 59.07366 0.427917
## 482 2012-04-26 2 0 4 2 59.75897 60.64966 0.756667
## 483 2012-04-27 2 0 5 1 56.30450 56.97328 0.400833
## 484 2012-04-28 2 0 6 2 49.46603 48.04748 0.489583
## 485 2012-04-29 2 0 0 1 56.37497 56.67437 0.587083
## 486 2012-04-30 2 0 1 2 56.86853 57.57428 0.570000
## 487 2012-05-01 2 0 2 2 69.48797 71.75009 0.659583
## 488 2012-05-02 2 0 3 1 65.32853 67.10204 0.797083
## 489 2012-05-03 2 0 4 2 64.97600 67.02435 0.768333
## 490 2012-05-04 2 0 5 1 70.68650 73.40094 0.735417
## 491 2012-05-05 2 0 6 2 70.19303 72.65143 0.756667
## 492 2012-05-06 2 0 0 2 65.18750 68.15236 0.740000
## 493 2012-05-07 2 0 1 2 63.07250 65.82447 0.664167
## 494 2012-05-08 2 0 2 2 66.80903 69.42755 0.685833
## 495 2012-05-09 2 0 3 2 66.24500 68.89937 0.744167
## 496 2012-05-10 2 0 4 1 60.39347 61.62382 0.552083
## 497 2012-05-11 2 0 5 1 62.71997 65.07496 0.360417
## 498 2012-05-12 2 0 6 1 65.32853 67.92426 0.480417
## 499 2012-05-13 2 0 0 1 69.41750 72.72627 0.576250
## 500 2012-05-14 2 0 1 2 66.10397 68.52812 0.789583
## 501 2012-05-15 2 0 2 2 69.34703 71.67680 0.794583
## 502 2012-05-16 2 0 3 1 71.46203 74.00183 0.697917
## 503 2012-05-17 2 0 4 1 67.79597 71.22642 0.520000
## 504 2012-05-18 2 0 5 1 65.32853 68.67317 0.523333
## 505 2012-05-19 2 0 6 1 68.36000 70.54867 0.456250
## 506 2012-05-20 2 0 0 1 70.12247 72.57528 0.530417
## 507 2012-05-21 2 0 1 2 68.21897 70.40124 0.811250
## 508 2012-05-22 2 0 2 2 69.62900 72.20201 0.765833
## 509 2012-05-23 2 0 3 2 70.19303 72.65191 0.774583
## 510 2012-05-24 2 0 4 1 73.01300 75.27596 0.716667
## 511 2012-05-25 2 0 5 1 75.12800 77.75045 0.747083
## 512 2012-05-26 2 0 6 1 76.18550 79.55228 0.732500
## 513 2012-05-27 2 0 0 1 75.97400 79.40129 0.697083
## 514 2012-05-28 2 1 1 1 77.87750 83.90084 0.676250
## 515 2012-05-29 2 0 2 1 78.72350 83.15145 0.684583
## 516 2012-05-30 2 0 3 2 73.15403 75.80213 0.670000
## 517 2012-05-31 2 0 4 1 75.12800 78.20189 0.492917
## 518 2012-06-01 2 0 5 2 72.94253 75.42589 0.755417
## 519 2012-06-02 2 0 6 1 66.94997 70.47501 0.549167
## 520 2012-06-03 2 0 0 1 68.57150 71.52580 0.493333
## 521 2012-06-04 2 0 1 1 68.14850 71.90002 0.487083
## 522 2012-06-05 2 0 2 2 63.35447 65.67597 0.613333
## 523 2012-06-06 2 0 3 1 64.48253 67.62429 0.611250
## 524 2012-06-07 2 0 4 1 68.57150 70.84971 0.567083
## 525 2012-06-08 2 0 5 1 72.51953 74.22601 0.467917
## 526 2012-06-09 2 0 6 1 77.73647 80.22600 0.437083
## 527 2012-06-10 2 0 0 1 79.07603 82.02582 0.538333
## 528 2012-06-11 2 0 1 2 78.58247 81.57485 0.587917
## 529 2012-06-12 2 0 2 2 72.87197 74.22755 0.833333
## 530 2012-06-13 2 0 3 1 73.08347 75.80070 0.582083
## 531 2012-06-14 2 0 4 1 72.44897 77.37670 0.569583
## 532 2012-06-15 2 0 5 1 71.67353 74.45078 0.589583
## 533 2012-06-16 2 0 6 1 71.03903 73.85131 0.504167
## 534 2012-06-17 2 0 0 1 67.72550 71.15063 0.598750
## 535 2012-06-18 2 0 1 2 65.68097 67.92723 0.777917
## 536 2012-06-19 2 0 2 1 75.83297 80.97741 0.690000
## 537 2012-06-20 2 0 3 1 83.79950 88.85183 0.592083
## 538 2012-06-21 3 0 4 1 85.77347 92.60199 0.567917
## 539 2012-06-22 3 0 5 1 83.37650 89.22557 0.573750
## 540 2012-06-23 3 0 6 1 79.49903 80.75169 0.534583
## 541 2012-06-24 3 0 0 1 80.48597 83.30138 0.479167
## 542 2012-06-25 3 0 1 1 78.15947 80.90019 0.504167
## 543 2012-06-26 3 0 2 1 70.96847 73.85084 0.373333
## 544 2012-06-27 3 0 3 1 76.60850 79.32609 0.360000
## 545 2012-06-28 3 0 4 1 80.97953 83.45083 0.422500
## 546 2012-06-29 3 0 5 1 88.17053 96.64962 0.488750
## 547 2012-06-30 3 0 6 1 82.31900 84.87595 0.601250
## 548 2012-07-01 3 0 0 1 86.61947 92.37473 0.518750
## 549 2012-07-02 3 0 1 1 83.72903 86.60211 0.447083
## 550 2012-07-03 3 0 2 1 83.65847 86.67482 0.492083
## 551 2012-07-04 3 1 3 1 84.36353 90.20164 0.538750
## 552 2012-07-05 3 0 4 1 87.60650 93.65040 0.457917
## 553 2012-07-06 3 0 5 1 87.67697 92.60092 0.450833
## 554 2012-07-07 3 0 6 1 90.49703 98.82366 0.492083
## 555 2012-07-08 3 0 0 1 87.18350 97.09904 0.573750
## 556 2012-07-09 3 0 1 2 77.73647 80.90162 0.683333
## 557 2012-07-10 3 0 2 2 78.58247 82.17776 0.667500
## 558 2012-07-11 3 0 3 1 78.23003 80.45219 0.633333
## 559 2012-07-12 3 0 4 1 78.15947 80.97634 0.529583
## 560 2012-07-13 3 0 5 2 79.49903 82.55044 0.485833
## 561 2012-07-14 3 0 6 2 77.10197 82.32579 0.699167
## 562 2012-07-15 3 0 0 1 80.69747 86.97728 0.717917
## 563 2012-07-16 3 0 1 1 82.17797 89.22605 0.645000
## 564 2012-07-17 3 0 2 1 86.83097 92.97514 0.505833
## 565 2012-07-18 3 0 3 1 84.71597 91.77526 0.577083
## 566 2012-07-19 3 0 4 1 82.74200 88.09947 0.600417
## 567 2012-07-20 3 0 5 2 73.92947 76.02737 0.844167
## 568 2012-07-21 3 0 6 3 68.00747 68.52955 0.865417
## 569 2012-07-22 3 0 0 2 74.07050 77.22725 0.762500
## 570 2012-07-23 3 0 1 1 80.34503 85.17402 0.694167
## 571 2012-07-24 3 0 2 1 81.12047 87.12626 0.655000
## 572 2012-07-25 3 0 3 1 78.86453 80.90162 0.450000
## 573 2012-07-26 3 0 4 1 83.30603 91.02444 0.596667
## 574 2012-07-27 3 0 5 1 83.72903 90.42498 0.594583
## 575 2012-07-28 3 0 6 1 81.54347 86.07536 0.613333
## 576 2012-07-29 3 0 0 1 78.65303 82.55044 0.623750
## 577 2012-07-30 3 0 1 1 79.42847 84.57646 0.668750
## 578 2012-07-31 3 0 2 1 77.94797 81.95204 0.704167
## 579 2012-08-01 3 0 3 1 78.30050 82.47619 0.677500
## 580 2012-08-02 3 0 4 1 81.26150 87.20205 0.659583
## 581 2012-08-03 3 0 5 2 82.38947 89.07660 0.642500
## 582 2012-08-04 3 0 6 1 84.71597 92.45052 0.613333
## 583 2012-08-05 3 0 0 1 82.67153 90.05219 0.652500
## 584 2012-08-06 3 0 1 2 81.26150 87.57722 0.654167
## 585 2012-08-07 3 0 2 2 79.85147 86.07737 0.703750
## 586 2012-08-08 3 0 3 2 81.05000 87.27678 0.672917
## 587 2012-08-09 3 0 4 1 81.54347 86.30155 0.620417
## 588 2012-08-10 3 0 5 2 78.15947 82.55151 0.715833
## 589 2012-08-11 3 0 6 2 76.18550 79.02612 0.732917
## 590 2012-08-12 3 0 0 1 76.89047 79.77599 0.530417
## 591 2012-08-13 3 0 1 1 78.58247 81.87578 0.545417
## 592 2012-08-14 3 0 2 1 79.07603 83.60135 0.686667
## 593 2012-08-15 3 0 3 1 77.38403 80.89960 0.619583
## 594 2012-08-16 3 0 4 1 78.44153 80.97693 0.519167
## 595 2012-08-17 3 0 5 1 78.79397 31.99712 0.570833
## 596 2012-08-18 3 0 6 1 74.98697 76.62683 0.603333
## 597 2012-08-19 3 0 0 2 71.39147 74.90222 0.711667
## 598 2012-08-20 3 0 1 2 71.39147 74.00088 0.734167
## 599 2012-08-21 3 0 2 1 72.51953 74.60177 0.673750
## 600 2012-08-22 3 0 3 1 74.07050 77.07626 0.677083
## 601 2012-08-23 3 0 4 1 76.46747 78.87655 0.635833
## 602 2012-08-24 3 0 5 2 77.03150 80.07548 0.615000
## 603 2012-08-25 3 0 6 2 73.57703 76.70108 0.712917
## 604 2012-08-26 3 0 0 2 72.87197 74.00432 0.845833
## 605 2012-08-27 3 0 1 1 77.10197 80.97693 0.730417
## 606 2012-08-28 3 0 2 1 79.21697 82.32674 0.620000
## 607 2012-08-29 3 0 3 1 75.55100 78.72508 0.552083
## 608 2012-08-30 3 0 4 1 77.38403 80.75015 0.590417
## 609 2012-08-31 3 0 5 1 82.24853 85.10072 0.587500
## 610 2012-09-01 3 0 6 2 81.33197 86.67530 0.638333
## 611 2012-09-02 3 0 0 2 76.53803 80.30120 0.815000
## 612 2012-09-03 3 1 1 1 77.45450 81.80153 0.790833
## 613 2012-09-04 3 0 2 1 79.00547 84.80229 0.755000
## 614 2012-09-05 3 0 3 1 79.92203 87.42718 0.741250
## 615 2012-09-06 3 0 4 2 76.53803 81.05309 0.810417
## 616 2012-09-07 3 0 5 1 77.10197 81.27584 0.736250
## 617 2012-09-08 3 0 6 2 73.36553 75.80117 0.799167
## 618 2012-09-09 3 0 0 1 69.20600 71.97629 0.547500
## 619 2012-09-10 3 0 1 1 66.94997 70.39970 0.503750
## 620 2012-09-11 3 0 2 1 66.45650 69.04989 0.520000
## 621 2012-09-12 3 0 3 1 68.28953 70.92491 0.577083
## 622 2012-09-13 3 0 4 1 69.41750 72.05149 0.637083
## 623 2012-09-14 3 0 5 1 71.17997 73.77706 0.672500
## 624 2012-09-15 3 0 6 1 69.06497 72.80100 0.501667
## 625 2012-09-16 3 0 0 1 66.66800 70.09925 0.570000
## 626 2012-09-17 3 0 1 2 66.73847 68.90234 0.734583
## 627 2012-09-18 3 0 2 2 70.33397 70.32996 0.872500
## 628 2012-09-19 3 0 3 1 64.34150 67.40000 0.536667
## 629 2012-09-20 3 0 4 1 63.84803 66.42441 0.618333
## 630 2012-09-21 3 0 5 1 68.28953 71.15015 0.668750
## 631 2012-09-22 3 0 6 1 72.59000 75.72597 0.646667
## 632 2012-09-23 4 0 0 1 62.36753 64.84924 0.467083
## 633 2012-09-24 4 0 1 1 61.09853 62.89854 0.492917
## 634 2012-09-25 4 0 2 1 64.13000 67.84847 0.570000
## 635 2012-09-26 4 0 3 1 71.32100 74.07762 0.630833
## 636 2012-09-27 4 0 4 2 72.59000 75.42743 0.690833
## 637 2012-09-28 4 0 5 2 69.98153 72.80052 0.690000
## 638 2012-09-29 4 0 6 1 63.49550 66.19916 0.542917
## 639 2012-09-30 4 0 0 1 62.15603 64.69836 0.583333
## 640 2012-10-01 4 0 1 2 61.66247 64.02560 0.649167
## 641 2012-10-02 4 0 2 3 67.58447 67.62916 0.871667
## 642 2012-10-03 4 0 3 2 73.22450 74.37700 0.793750
## 643 2012-10-04 4 0 4 2 73.22450 75.42743 0.722917
## 644 2012-10-05 4 0 5 1 69.62900 72.12622 0.627500
## 645 2012-10-06 4 0 6 1 64.48253 67.17629 0.664167
## 646 2012-10-07 4 0 0 2 52.77947 53.07378 0.708333
## 647 2012-10-08 4 1 1 2 50.02997 49.24783 0.709583
## 648 2012-10-09 4 0 2 2 55.38803 55.24771 0.761667
## 649 2012-10-10 4 0 3 1 61.09853 62.97327 0.630833
## 650 2012-10-11 4 0 4 1 54.40100 54.42264 0.463333
## 651 2012-10-12 4 0 5 1 54.61250 54.64883 0.539167
## 652 2012-10-13 4 0 6 1 50.87597 49.69784 0.494583
## 653 2012-10-14 4 0 0 1 61.73303 63.57464 0.640417
## 654 2012-10-15 4 0 1 2 65.11703 67.25102 0.707500
## 655 2012-10-16 4 0 2 1 57.22097 57.94850 0.558333
## 656 2012-10-17 4 0 3 1 56.16347 56.67283 0.692917
## 657 2012-10-18 4 0 4 2 61.80350 64.09985 0.728333
## 658 2012-10-19 4 0 5 2 65.25797 67.10204 0.815000
## 659 2012-10-20 4 0 6 1 58.56053 59.37363 0.572917
## 660 2012-10-21 4 0 0 1 56.86853 57.42377 0.510000
## 661 2012-10-22 4 0 1 1 58.84250 60.57351 0.568333
## 662 2012-10-23 4 0 2 1 63.63653 66.20012 0.641667
## 663 2012-10-24 4 0 3 1 67.30250 69.57605 0.636250
## 664 2012-10-25 4 0 4 2 64.13000 66.12693 0.800417
## 665 2012-10-26 4 0 5 2 63.77747 65.30270 0.807083
## 666 2012-10-27 4 0 6 2 62.43800 64.39780 0.720000
## 667 2012-10-28 4 0 0 2 57.99650 58.77119 0.694583
## 668 2012-10-29 4 0 1 3 54.82400 55.40072 0.880000
## 669 2012-10-30 4 0 2 2 44.51820 40.01719 0.825455
## 670 2012-10-31 4 0 3 2 47.84450 46.09868 0.666667
## 671 2012-11-01 4 0 4 2 48.54947 47.14911 0.581667
## 672 2012-11-02 4 0 5 1 47.63300 45.49779 0.522083
## 673 2012-11-03 4 0 6 2 46.64597 41.67290 0.491250
## 674 2012-11-04 4 0 0 1 45.16547 42.34911 0.532917
## 675 2012-11-05 4 0 1 1 44.60153 39.79931 0.494167
## 676 2012-11-06 4 0 2 1 41.35847 36.65016 0.567083
## 677 2012-11-07 4 0 3 2 42.62747 35.82497 0.547500
## 678 2012-11-08 4 0 4 1 47.39392 43.81665 0.333478
## 679 2012-11-09 4 0 5 1 48.19703 45.42306 0.540833
## 680 2012-11-10 4 0 6 1 50.52353 49.99972 0.645417
## 681 2012-11-11 4 0 0 1 53.20247 53.29950 0.659167
## 682 2012-11-12 4 1 1 1 58.63100 59.67550 0.741667
## 683 2012-11-13 4 0 2 2 46.64597 41.59913 0.662917
## 684 2012-11-14 4 0 3 1 42.06353 36.64968 0.552083
## 685 2012-11-15 4 0 4 2 44.81303 41.74965 0.620417
## 686 2012-11-16 4 0 5 1 46.78700 44.44784 0.524583
## 687 2012-11-17 4 0 6 1 45.09500 41.97430 0.545417
## 688 2012-11-18 4 0 0 1 46.57550 43.32422 0.692917
## 689 2012-11-19 4 0 1 2 49.81847 47.82377 0.623333
## 690 2012-11-20 4 0 2 2 49.25453 48.42324 0.685000
## 691 2012-11-21 4 0 3 1 47.49197 46.54917 0.613750
## 692 2012-11-22 4 1 4 1 46.36400 44.82407 0.580417
## 693 2012-11-23 4 0 5 1 48.76097 48.19895 0.568750
## 694 2012-11-24 4 0 6 1 41.14697 32.75055 0.404583
## 695 2012-11-25 4 0 0 1 38.39747 33.80086 0.468333
## 696 2012-11-26 4 0 1 1 44.10797 43.47368 0.535417
## 697 2012-11-27 4 0 2 2 42.27503 36.64909 0.786667
## 698 2012-11-28 4 0 3 1 42.69803 37.62373 0.506250
## 699 2012-11-29 4 0 4 1 41.36160 38.65253 0.555652
## 700 2012-11-30 4 0 5 1 42.83897 41.67540 0.649583
## 701 2012-12-01 4 0 6 2 42.83897 40.84820 0.806667
## 702 2012-12-02 4 0 0 2 46.99850 45.87391 0.823333
## 703 2012-12-03 4 0 1 1 55.88150 57.34856 0.767500
## 704 2012-12-04 4 0 2 1 57.85547 58.92362 0.733750
## 705 2012-12-05 4 0 3 1 54.68297 54.04783 0.485000
## 706 2012-12-06 4 0 4 1 39.24347 33.87464 0.508750
## 707 2012-12-07 4 0 5 2 44.74247 41.44861 0.764167
## 708 2012-12-08 4 0 6 2 49.88903 49.47355 0.911250
## 709 2012-12-09 4 0 0 2 50.10053 49.54934 0.905417
## 710 2012-12-10 4 0 1 2 54.47147 54.94631 0.925000
## 711 2012-12-11 4 0 2 2 47.49197 43.39752 0.596667
## 712 2012-12-12 4 0 3 2 42.76850 38.52375 0.538333
## 713 2012-12-13 4 0 4 1 42.62747 38.14953 0.485833
## 714 2012-12-14 4 0 5 1 41.42903 38.15001 0.642917
## 715 2012-12-15 4 0 6 1 45.02453 43.39990 0.650417
## 716 2012-12-16 4 0 0 2 48.26750 47.14863 0.838750
## 717 2012-12-17 4 0 1 2 50.87597 50.89820 0.907083
## 718 2012-12-18 4 0 2 1 52.35647 51.87331 0.666250
## 719 2012-12-19 4 0 3 1 45.72950 43.84885 0.625417
## 720 2012-12-20 4 0 4 2 45.51800 43.02378 0.667917
## 721 2012-12-21 1 0 5 2 45.23603 39.04992 0.556667
## 722 2012-12-22 1 0 6 1 40.08947 31.25022 0.441250
## 723 2012-12-23 1 0 0 1 38.39747 34.02515 0.515417
## 724 2012-12-24 1 0 1 2 37.16832 33.95732 0.791304
## 725 2012-12-25 1 1 2 2 42.24432 38.18244 0.734783
## 726 2012-12-26 1 0 3 3 38.18597 29.37556 0.823333
## 727 2012-12-27 1 0 4 2 39.10253 30.12507 0.652917
## 728 2012-12-28 1 0 5 2 39.03197 33.49946 0.590000
## 729 2012-12-29 1 0 6 2 39.03197 31.99712 0.752917
## 730 2012-12-30 1 0 0 1 39.24347 30.72596 0.483333
## 731 2012-12-31 1 0 1 2 35.85947 29.75026 0.577500
## windspeed rentals
## 1 6.6796649 985
## 2 10.3471401 801
## 3 10.3375648 1349
## 4 6.6734201 1562
## 5 7.7809941 1600
## 6 3.7287656 1606
## 7 7.0243767 1510
## 8 11.1075460 959
## 9 15.0686506 822
## 10 9.2950198 1321
## 11 5.0845820 1263
## 12 12.6821877 1162
## 13 12.5311890 1406
## 14 5.2684282 1421
## 15 6.5762930 1248
## 16 7.8448157 1204
## 17 8.0772880 1000
## 18 6.1105158 683
## 19 8.6726236 1650
## 20 8.1558473 1927
## 21 14.7061204 1543
## 22 7.1594304 981
## 23 10.2664159 986
## 24 6.5915719 1416
## 25 5.4036485 1985
## 26 12.2335212 506
## 27 4.7392457 431
## 28 5.1332080 1167
## 29 6.0518149 1098
## 30 3.0800330 1096
## 31 7.7931506 1501
## 32 2.2153560 1360
## 33 11.0036329 1526
## 34 11.5633315 1550
## 35 5.3221750 1708
## 36 6.7060179 1005
## 37 5.9033973 1623
## 38 1.8904319 1712
## 39 15.0686506 1530
## 40 7.8617182 1605
## 41 9.2395662 1538
## 42 4.5191381 1746
## 43 8.4665459 1472
## 44 10.8610437 1589
## 45 17.3982861 1913
## 46 12.1304407 1815
## 47 10.4825269 2115
## 48 9.5796568 2475
## 49 11.0293197 2927
## 50 21.1266270 1635
## 51 9.2936876 1812
## 52 12.8162007 1107
## 53 8.1466467 1450
## 54 3.9180990 1917
## 55 10.4286137 1807
## 56 14.4270621 1461
## 57 7.7672972 1969
## 58 5.2143068 2402
## 59 12.0601661 1446
## 60 9.0101747 1851
## 61 12.8156594 2134
## 62 9.3985582 1685
## 63 8.4656716 1944
## 64 10.4858575 2077
## 65 14.2916753 605
## 66 14.2111177 1872
## 67 5.0228835 2133
## 68 9.1652533 1891
## 69 10.9024258 623
## 70 9.6989737 1977
## 71 9.1912732 2132
## 72 11.2657470 2417
## 73 5.7004837 2046
## 74 7.6731259 2056
## 75 8.4561379 2192
## 76 8.7251630 2744
## 77 9.6176667 3239
## 78 15.3274759 3117
## 79 8.6478110 2471
## 80 12.0225726 2077
## 81 9.3983917 2703
## 82 9.7527205 2121
## 83 10.1493055 1865
## 84 9.6055102 2210
## 85 8.7248299 2496
## 86 7.6727512 1693
## 87 8.8344466 2028
## 88 9.4502650 2425
## 89 7.1976485 1536
## 90 9.0610071 1685
## 91 10.7704945 2227
## 92 8.2075541 2252
## 93 7.5858656 3249
## 94 16.0520367 3115
## 95 16.1559499 1795
## 96 10.9518012 2808
## 97 6.7573500 3141
## 98 9.4500985 1471
## 99 5.5404924 2455
## 100 6.1101828 2895
## 101 13.5084552 3348
## 102 11.4437232 2034
## 103 10.4336511 2162
## 104 4.6086466 3267
## 105 9.4244116 3126
## 106 14.1884699 795
## 107 12.6351021 3744
## 108 6.8095980 3429
## 109 6.5766261 3204
## 110 10.0717870 3944
## 111 13.5410945 4189
## 112 9.1390669 1683
## 113 9.6055102 4036
## 114 8.0006021 4191
## 115 7.7157570 4073
## 116 13.5928013 4400
## 117 12.9974658 3872
## 118 13.3599960 4058
## 119 9.9942685 4595
## 120 9.7866088 5312
## 121 4.4277145 3351
## 122 7.6375307 4401
## 123 14.2658635 4451
## 124 13.6967144 2633
## 125 12.2977175 4433
## 126 9.5023048 4608
## 127 6.6798315 4714
## 128 3.1072977 4333
## 129 7.3272068 4362
## 130 4.8155985 4803
## 131 5.0225505 4182
## 132 7.8961894 4864
## 133 7.4822855 4105
## 134 5.6182191 3409
## 135 6.3687999 4553
## 136 5.2818753 3958
## 137 11.5467621 4123
## 138 8.3884861 3855
## 139 4.5051081 4575
## 140 5.2045233 4917
## 141 5.0228835 5805
## 142 6.1618479 4660
## 143 9.7352767 4274
## 144 8.6216245 4492
## 145 6.4210062 4978
## 146 8.3114672 4677
## 147 10.0199137 4679
## 148 9.5791572 4758
## 149 8.9066362 4788
## 150 5.4631404 4098
## 151 4.6348330 3982
## 152 8.6216245 3974
## 153 12.1684506 4968
## 154 10.5378973 5312
## 155 5.1266301 5342
## 156 5.7740055 4906
## 157 5.0747568 4548
## 158 7.8187958 4833
## 159 5.6959458 4401
## 160 6.2399076 3915
## 161 5.8515240 4586
## 162 6.4466931 4966
## 163 6.8095980 4460
## 164 12.7122875 5020
## 165 11.2107513 4891
## 166 6.9904884 5180
## 167 8.5957711 3767
## 168 5.9545629 4844
## 169 4.9711768 5119
## 170 4.2464494 4744
## 171 6.4727130 4010
## 172 7.1200883 4835
## 173 7.1715870 4507
## 174 9.9418540 4790
## 175 9.2433131 4991
## 176 8.7248299 5202
## 177 3.9355968 5305
## 178 4.4790882 4708
## 179 6.0067692 4648
## 180 10.9000944 5225
## 181 7.7148827 5515
## 182 4.2717616 5362
## 183 4.7902447 5119
## 184 9.5277835 4649
## 185 3.3921304 6043
## 186 5.2563550 4665
## 187 6.2399076 4629
## 188 6.6277916 4592
## 189 9.3725383 4040
## 190 6.9904884 5336
## 191 7.6382384 4881
## 192 11.7542136 4086
## 193 8.3369459 4258
## 194 6.0837882 4342
## 195 10.0194141 5084
## 196 7.6116773 5538
## 197 8.6736644 5923
## 198 10.2011788 5302
## 199 8.9843213 4458
## 200 5.4371205 4541
## 201 4.7384131 4332
## 202 9.2431465 3784
## 203 5.5412002 3387
## 204 5.4629739 3285
## 205 7.0429029 3606
## 206 3.7805182 3840
## 207 8.3371124 4590
## 208 7.6379054 4656
## 209 7.4304122 4390
## 210 7.2496883 3846
## 211 7.0165083 4475
## 212 6.8614712 4302
## 213 6.5244197 4266
## 214 8.5699178 4845
## 215 5.6445721 3574
## 216 8.2077206 4576
## 217 7.6892375 4866
## 218 9.5024714 4294
## 219 8.3882780 3785
## 220 8.0006021 4326
## 221 6.2914479 4602
## 222 8.3371124 4780
## 223 6.8607635 4792
## 224 5.2298355 4905
## 225 8.8032227 4150
## 226 9.2686252 3820
## 227 8.6991430 4338
## 228 9.8388151 4725
## 229 5.9811240 4694
## 230 9.7088821 3805
## 231 5.7996507 4153
## 232 4.3491552 5191
## 233 10.3560910 3873
## 234 11.5216164 4758
## 235 6.1100162 5895
## 236 10.5373561 5130
## 237 8.7773693 3542
## 238 3.4955148 4661
## 239 15.6376332 1115
## 240 12.6835199 4334
## 241 6.6538115 4634
## 242 5.2043152 5204
## 243 3.4693200 5058
## 244 5.9032308 5115
## 245 5.8255041 4727
## 246 7.7154239 4484
## 247 8.5956046 4940
## 248 8.8549295 3351
## 249 14.3189858 2710
## 250 4.0391561 1996
## 251 8.0244572 1842
## 252 5.1781287 3544
## 253 6.3949863 5345
## 254 4.7899117 5046
## 255 3.7016133 4713
## 256 5.9035639 4763
## 257 6.9650097 4785
## 258 11.2883115 3659
## 259 6.8352432 4760
## 260 7.8965225 4511
## 261 7.4305787 4274
## 262 6.3173012 4539
## 263 5.6183856 3641
## 264 4.0134859 4352
## 265 5.3340817 4795
## 266 3.2625512 2395
## 267 3.2632423 5423
## 268 2.0973797 5010
## 269 4.6086466 4630
## 270 4.9196782 4120
## 271 6.1877013 3907
## 272 7.1974403 4839
## 273 8.5959377 5202
## 274 12.1688253 2429
## 275 9.2428135 2918
## 276 3.4698404 3570
## 277 8.5700843 4456
## 278 7.3792467 4826
## 279 5.6183856 4765
## 280 0.9322081 4985
## 281 1.8902612 5409
## 282 2.6415413 5511
## 283 1.7612024 5117
## 284 5.9551041 4563
## 285 10.3309453 2416
## 286 5.9028561 2913
## 287 9.3206650 3644
## 288 10.7444746 5217
## 289 11.7284019 5041
## 290 7.3013534 4570
## 291 4.5831262 4748
## 292 10.1306545 2424
## 293 17.5800924 4195
## 294 9.2171266 4304
## 295 3.8578868 4308
## 296 4.1428902 4381
## 297 4.9455316 4187
## 298 6.9382820 4687
## 299 6.1882425 3894
## 300 8.2332409 2659
## 301 9.5536369 3747
## 302 14.6282272 627
## 303 7.3528937 3331
## 304 4.4275480 3669
## 305 5.6440725 4068
## 306 3.4176299 4186
## 307 5.6959458 3974
## 308 11.3146645 4046
## 309 7.8710021 3926
## 310 3.8323873 3649
## 311 2.3823830 4035
## 312 2.8741593 4205
## 313 2.5893267 4109
## 314 7.8712103 2933
## 315 13.1005046 3368
## 316 8.8285349 4067
## 317 11.7285684 3717
## 318 12.7641608 4486
## 319 8.3110925 4195
## 320 5.6964454 1817
## 321 12.7127871 3053
## 322 7.0163418 3392
## 323 9.3461854 3663
## 324 7.7414438 3520
## 325 5.7474444 2765
## 326 4.9455316 1607
## 327 13.9810184 2566
## 328 6.9651762 1495
## 329 4.1172158 2792
## 330 2.8484850 3068
## 331 8.6991430 3071
## 332 5.9168028 3867
## 333 10.7448492 2914
## 334 11.2888111 3613
## 335 9.1655864 3727
## 336 4.1945761 3940
## 337 3.9876366 3614
## 338 3.4953399 3485
## 339 2.5898470 3811
## 340 9.6828622 2594
## 341 11.0813595 705
## 342 9.9940603 3322
## 343 3.4436498 3620
## 344 9.7094233 3190
## 345 2.7702545 2743
## 346 2.6415413 3310
## 347 5.8513575 3523
## 348 2.5378072 3740
## 349 11.1590862 3709
## 350 10.8482211 3577
## 351 10.1234938 2739
## 352 7.0682150 2431
## 353 7.1979815 3403
## 354 2.5633067 3750
## 355 9.2172931 2660
## 356 1.9681460 3068
## 357 11.4173703 2209
## 358 7.9227089 1011
## 359 6.4567263 754
## 360 9.9693726 1317
## 361 7.8455235 1162
## 362 12.2381423 2302
## 363 4.9713433 2423
## 364 5.5926988 2999
## 365 9.1654198 2485
## 366 8.0002691 2294
## 367 13.7245661 1951
## 368 15.2235628 2236
## 369 7.6894040 2368
## 370 5.4116002 3272
## 371 6.9903218 4098
## 372 7.2755001 4521
## 373 7.9742492 3425
## 374 4.1173907 2376
## 375 7.8081380 3598
## 376 5.4629739 2177
## 377 7.5339923 4097
## 378 15.7413382 3214
## 379 7.7927759 2493
## 380 10.4603371 2311
## 381 9.6318632 2298
## 382 14.5349302 2935
## 383 17.2950807 3376
## 384 9.1655864 3292
## 385 8.4408590 3163
## 386 9.2689999 1301
## 387 8.3113007 1977
## 388 4.6089796 2432
## 389 5.1526500 4339
## 390 6.7056848 4270
## 391 3.0556035 4075
## 392 14.2658635 3456
## 393 8.7772028 4023
## 394 9.9937273 3243
## 395 8.9838217 3624
## 396 10.8999279 4509
## 397 7.8712103 4579
## 398 7.7929424 3761
## 399 7.4311199 4151
## 400 5.0747568 2832
## 401 7.3270403 2947
## 402 6.4029796 3784
## 403 6.1356615 4375
## 404 5.5670535 2802
## 405 8.0781206 3830
## 406 4.8679714 3831
## 407 12.0647456 2169
## 408 17.0362555 1529
## 409 6.9643019 3422
## 410 5.8775439 3922
## 411 7.5603452 4169
## 412 3.8061925 3005
## 413 8.5697512 4154
## 414 7.9487288 4318
## 415 10.5375226 2689
## 416 9.5371507 3129
## 417 8.5643807 3777
## 418 9.7614631 4773
## 419 7.9480627 5062
## 420 9.8903554 3487
## 421 17.5537394 2732
## 422 8.5440644 3389
## 423 11.1587115 4322
## 424 8.0523089 4363
## 425 7.4569733 1834
## 426 9.4498903 4990
## 427 6.0326226 3194
## 428 6.7060179 4066
## 429 13.9288120 3423
## 430 9.5277835 3333
## 431 8.3627993 3956
## 432 14.3954219 4916
## 433 18.3830877 5382
## 434 17.2688943 4569
## 435 9.3983917 4118
## 436 9.2667102 4911
## 437 8.6474779 5298
## 438 9.8646685 5847
## 439 4.7902447 6312
## 440 6.2399076 6192
## 441 4.7123932 4378
## 442 4.6088131 7836
## 443 5.2823749 5892
## 444 6.7575581 6153
## 445 5.0487369 6093
## 446 3.7284783 6230
## 447 4.8943244 6871
## 448 4.8417850 8362
## 449 8.0259143 3372
## 450 9.1912732 4996
## 451 16.1040766 5558
## 452 7.7931506 5102
## 453 12.1428054 5698
## 454 13.3076231 6133
## 455 5.7479856 5459
## 456 10.4336511 6235
## 457 7.1717951 6041
## 458 12.9949262 5936
## 459 4.1687227 6772
## 460 7.5343253 6436
## 461 9.1393999 6457
## 462 12.5057103 6460
## 463 11.4433902 6857
## 464 9.6834034 5169
## 465 14.9123646 5585
## 466 10.3819443 5918
## 467 12.2928049 4862
## 468 12.0910986 5409
## 469 6.4725464 6398
## 470 7.9482292 7460
## 471 9.3725383 7132
## 472 11.8579602 6370
## 473 11.3916834 6691
## 474 6.9904884 4367
## 475 2.7447550 6565
## 476 6.2394080 7290
## 477 11.8062534 6624
## 478 14.3440898 1027
## 479 12.6351021 3214
## 480 10.3822774 5633
## 481 4.9455316 6196
## 482 7.3532267 5026
## 483 14.4726073 6233
## 484 5.4111006 4220
## 485 4.8670971 6304
## 486 7.1456087 5572
## 487 6.4985664 5740
## 488 5.7476109 6169
## 489 5.5660128 6421
## 490 6.7834115 6296
## 491 6.3693411 6883
## 492 6.2397411 6359
## 493 9.6053437 6273
## 494 12.3242370 5728
## 495 9.0096334 4717
## 496 13.0750259 6572
## 497 9.8641273 7030
## 498 5.1262554 7429
## 499 9.3720388 6118
## 500 8.8547629 2843
## 501 6.1362027 5115
## 502 5.1004021 7424
## 503 9.5534704 7384
## 504 5.6959458 7639
## 505 3.4960352 8294
## 506 10.5897706 7129
## 507 9.7087156 4359
## 508 4.9195116 6073
## 509 4.2464494 5260
## 510 7.1979815 6770
## 511 5.8513575 6734
## 512 8.2844065 6536
## 513 8.9579683 6591
## 514 8.1815342 6043
## 515 12.2980506 5743
## 516 5.5923657 6855
## 517 8.1298274 7338
## 518 9.8901888 4127
## 519 7.7669225 8120
## 520 7.6638837 7641
## 521 11.8581267 6998
## 522 8.7249964 7001
## 523 3.2108570 7055
## 524 6.5507727 7494
## 525 7.3015200 7736
## 526 6.0069358 7498
## 527 5.5670535 6598
## 528 8.6474779 6664
## 529 8.9319484 4972
## 530 14.2913422 7421
## 531 10.5633760 7363
## 532 7.3528937 7665
## 533 6.9386567 7702
## 534 6.0326226 6978
## 535 7.2750005 5099
## 536 6.1622226 6825
## 537 4.7382049 6211
## 538 4.9453234 5905
## 539 7.6120520 5823
## 540 7.4821190 7458
## 541 6.0584760 6891
## 542 12.5055021 6779
## 543 14.4729820 7442
## 544 11.3144979 7335
## 545 7.1461083 6879
## 546 6.8866169 5463
## 547 6.7056848 5687
## 548 7.0161752 5531
## 549 8.1293278 6227
## 550 5.2554807 6660
## 551 5.6182191 7403
## 552 8.0777876 6241
## 553 6.0841628 6207
## 554 6.8090567 4840
## 555 5.2301686 4672
## 556 7.5343253 6569
## 557 6.3170931 6290
## 558 6.3169266 7264
## 559 6.1105158 7446
## 560 3.3659356 7499
## 561 5.9816236 6969
## 562 6.9386567 6031
## 563 6.8354097 6830
## 564 4.7638918 6786
## 565 5.7219657 5713
## 566 6.8871165 6591
## 567 8.6996843 5870
## 568 8.8800751 4459
## 569 3.9100973 7410
## 570 5.7736308 6966
## 571 8.8032227 7592
## 572 6.8609300 8173
## 573 11.8572941 6861
## 574 6.3693411 6904
## 575 6.5507727 6685
## 576 7.0939019 6597
## 577 6.3953610 7105
## 578 6.8869499 7216
## 579 5.8775439 7580
## 580 5.3852472 7261
## 581 8.9838217 7175
## 582 10.7184546 6824
## 583 12.0907655 5464
## 584 5.3852472 7013
## 585 4.8670971 7273
## 586 4.6086466 7534
## 587 6.4987329 7286
## 588 9.9422287 5786
## 589 8.5961042 6299
## 590 5.1004021 6544
## 591 5.6707585 6883
## 592 7.0423617 6784
## 593 7.0678820 7347
## 594 5.9032308 7605
## 595 9.6316966 7148
## 596 7.4049335 7865
## 597 3.5990740 4549
## 598 5.4112671 6530
## 599 3.0295835 7006
## 600 2.9260243 7375
## 601 3.5218802 7765
## 602 3.0035636 7582
## 603 10.1751589 6053
## 604 9.5277835 5255
## 605 5.3593938 6917
## 606 7.9485623 7040
## 607 4.6861651 7697
## 608 3.2105114 7713
## 609 7.0163418 7350
## 610 4.7121850 6140
## 611 2.6673864 5810
## 612 6.2914479 6034
## 613 9.8384821 6864
## 614 7.8187958 7112
## 615 5.9292507 6203
## 616 7.1459417 7504
## 617 11.7028815 5976
## 618 9.3461854 8227
## 619 10.7707026 7525
## 620 3.8323873 7767
## 621 5.4889938 7870
## 622 3.4438205 7804
## 623 4.3240096 8009
## 624 10.3047589 8714
## 625 3.7544982 7333
## 626 6.3173012 6869
## 627 14.8870108 4073
## 628 8.9581348 7591
## 629 4.9195116 7720
## 630 6.4208397 8167
## 631 11.8060869 8395
## 632 9.2946451 7907
## 633 5.9285430 7436
## 634 9.8384821 7538
## 635 10.1748259 7733
## 636 5.5929069 7393
## 637 6.8350767 7415
## 638 9.4755772 8555
## 639 5.6185522 6889
## 640 3.7803475 6778
## 641 4.3494883 4639
## 642 2.7704252 7572
## 643 4.8936583 7328
## 644 4.4275480 8156
## 645 11.1583785 7965
## 646 5.8768362 3510
## 647 7.8966890 5478
## 648 7.9225424 6392
## 649 7.8193370 7691
## 650 7.5601787 7570
## 651 9.7873165 7282
## 652 6.0841628 7109
## 653 11.5991349 6639
## 654 12.3245701 5875
## 655 7.5861986 7534
## 656 4.2202630 7461
## 657 9.8641273 7509
## 658 5.6183856 5424
## 659 4.8932836 8090
## 660 6.9131364 6824
## 661 3.3923011 7058
## 662 3.9361172 7466
## 663 3.0299332 7693
## 664 5.1779622 7359
## 665 5.5148472 7444
## 666 9.8122956 7852
## 667 16.5698121 4459
## 668 14.9125312 22
## 669 8.8679602 1096
## 670 6.9386567 5566
## 671 6.5506062 5986
## 672 11.0813595 5847
## 673 11.2626246 5138
## 674 7.4565986 5107
## 675 9.8386486 5259
## 676 7.2236684 5686
## 677 12.6605808 5035
## 678 14.4810170 5315
## 679 8.9324480 5992
## 680 2.4082281 6536
## 681 5.3080618 6852
## 682 7.2238349 6269
## 683 14.2400102 4094
## 684 8.3107595 5495
## 685 6.3691329 5445
## 686 7.1200883 5698
## 687 7.4824520 5629
## 688 9.4759102 4669
## 689 9.7862757 5499
## 690 3.4439954 5634
## 691 4.2983227 5146
## 692 2.2011096 2425
## 693 6.1623891 3910
## 694 15.6898396 2277
## 695 6.2655945 2424
## 696 1.9421261 5087
## 697 9.8901472 3959
## 698 8.7768697 5260
## 699 4.8093954 5323
## 700 2.4342480 5668
## 701 2.4855967 5191
## 702 5.1781287 4649
## 703 3.4438205 6234
## 704 7.2493136 6606
## 705 13.4895959 5729
## 706 7.2753335 5375
## 707 5.4371205 5008
## 708 4.2205960 5582
## 709 6.5767926 3228
## 710 7.9228754 5170
## 711 12.3245701 5501
## 712 6.7833699 5319
## 713 7.2493136 5532
## 714 5.4633070 5611
## 715 4.4275480 5047
## 716 4.1940765 3786
## 717 4.0906755 4585
## 718 9.2174597 5557
## 719 7.6640918 5267
## 720 5.5146807 4128
## 721 15.5862595 3623
## 722 16.9585704 1749
## 723 5.5404924 1787
## 724 3.2152450 920
## 725 7.0243767 1013
## 726 13.1783978 441
## 727 14.5766870 2114
## 728 6.4725464 3095
## 729 5.1782953 1341
## 730 14.6025404 1796
## 731 6.4465265 2729##Q: Is there a relationship between the number of bike rentals and any of the other variables?
library('ggplot2')
ggplot(data =my_data, aes(x=rentals, y=temperature)) + geom_point()
cor <- cor(my_data[, -1])
round(cor, 2)## season holiday weekday weather temperature realfeel humidity
## season 1.00 -0.01 0.00 0.02 0.33 0.34 0.21
## holiday -0.01 1.00 -0.10 -0.03 -0.03 -0.03 -0.02
## weekday 0.00 -0.10 1.00 0.03 0.00 -0.01 -0.05
## weather 0.02 -0.03 0.03 1.00 -0.12 -0.12 0.59
## temperature 0.33 -0.03 0.00 -0.12 1.00 0.99 0.13
## realfeel 0.34 -0.03 -0.01 -0.12 0.99 1.00 0.14
## humidity 0.21 -0.02 -0.05 0.59 0.13 0.14 1.00
## windspeed -0.23 0.01 0.01 0.04 -0.16 -0.18 -0.25
## rentals 0.41 -0.07 0.07 -0.30 0.63 0.63 -0.10
## windspeed rentals
## season -0.23 0.41
## holiday 0.01 -0.07
## weekday 0.01 0.07
## weather 0.04 -0.30
## temperature -0.16 0.63
## realfeel -0.18 0.63
## humidity -0.25 -0.10
## windspeed 1.00 -0.23
## rentals -0.23 1.00There is is relationship between renatals and all other except holiday and weakday.
##Q: If there is a relationship, how strong is it? Is the relationship linear? (Now we need to check either its linear or not, for that reason we can apply hypothesis)
filteredCol <- c("temperature", "realfeel", "rentals")
pairs(my_data[filteredCol])
Relationship is linear except season and weather because the data is randomly spread in these both.
##Q: If the relationship is linear, how well can we quantify the effect of a variable on the number of bike rentals?
linearRegression <- lm(rentals ~ temperature + realfeel, data = my_data)
linearRegression##
## Call:
## lm(formula = rentals ~ temperature + realfeel, data = my_data)
##
## Coefficients:
## (Intercept) temperature realfeel
## 589.15 12.60 53.15summary(linearRegression)##
## Call:
## lm(formula = rentals ~ temperature + realfeel, data = my_data)
##
## Residuals:
## Min 1Q Median 3Q Max
## -4604 -1089 -92 1069 3865
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 589.15 387.54 1.520 0.1289
## temperature 12.60 27.97 0.451 0.6524
## realfeel 53.15 22.37 2.375 0.0178 *
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1505 on 728 degrees of freedom
## Multiple R-squared: 0.3984, Adjusted R-squared: 0.3968
## F-statistic: 241.1 on 2 and 728 DF, p-value: < 2.2e-16Temprature and realfeel has effect on rentals as it has positive slope. We can check effect if correlation is positive or by checking scatter visualization, if it is in its positive position.
##Q: How accurately can we predict the number of bike rentals given future values for each of the relevant variables?
plot(linearRegression$residuals)
The linear regression model indicates low accuracy in predicting bike rentals.
Logistic regression:
# Load the iris dataset
data(iris)View the structure of the dataset
str(iris)## 'data.frame': 150 obs. of 5 variables:
## $ Sepal.Length: num 5.1 4.9 4.7 4.6 5 5.4 4.6 5 4.4 4.9 ...
## $ Sepal.Width : num 3.5 3 3.2 3.1 3.6 3.9 3.4 3.4 2.9 3.1 ...
## $ Petal.Length: num 1.4 1.4 1.3 1.5 1.4 1.7 1.4 1.5 1.4 1.5 ...
## $ Petal.Width : num 0.2 0.2 0.2 0.2 0.2 0.4 0.3 0.2 0.2 0.1 ...
## $ Species : Factor w/ 3 levels "setosa","versicolor",..: 1 1 1 1 1 1 1 1 1 1 ...Check the first few rows of the dataset
head(iris)## Sepal.Length Sepal.Width Petal.Length Petal.Width Species
## 1 5.1 3.5 1.4 0.2 setosa
## 2 4.9 3.0 1.4 0.2 setosa
## 3 4.7 3.2 1.3 0.2 setosa
## 4 4.6 3.1 1.5 0.2 setosa
## 5 5.0 3.6 1.4 0.2 setosa
## 6 5.4 3.9 1.7 0.4 setosaSummary statistics of the dataset
summary(iris)## Sepal.Length Sepal.Width Petal.Length Petal.Width
## Min. :4.300 Min. :2.000 Min. :1.000 Min. :0.100
## 1st Qu.:5.100 1st Qu.:2.800 1st Qu.:1.600 1st Qu.:0.300
## Median :5.800 Median :3.000 Median :4.350 Median :1.300
## Mean :5.843 Mean :3.057 Mean :3.758 Mean :1.199
## 3rd Qu.:6.400 3rd Qu.:3.300 3rd Qu.:5.100 3rd Qu.:1.800
## Max. :7.900 Max. :4.400 Max. :6.900 Max. :2.500
## Species
## setosa :50
## versicolor:50
## virginica :50
##
##
## Visualize the relationship between Sepal Length and Sepal Width based on Species
plot(iris$Sepal.Length, iris$Sepal.Width, col = iris$Species, pch = 19, xlab = "Sepal Length", ylab = "Sepal Width")
legend("topright", legend = levels(iris$Species), col = 1:3, pch = 19, title = "Species")
Fit logistic regression model
model <- glm(Species ~ Sepal.Length + Sepal.Width, data = iris, family = "binomial")## Warning: glm.fit: algorithm did not converge## Warning: glm.fit: fitted probabilities numerically 0 or 1 occurredPrint summary of the model
summary(model)##
## Call:
## glm(formula = Species ~ Sepal.Length + Sepal.Width, family = "binomial",
## data = iris)
##
## Coefficients:
## Estimate Std. Error z value Pr(>|z|)
## (Intercept) -437.2 128737.9 -0.003 0.997
## Sepal.Length 163.4 45394.8 0.004 0.997
## Sepal.Width -137.9 44846.1 -0.003 0.998
##
## (Dispersion parameter for binomial family taken to be 1)
##
## Null deviance: 1.9095e+02 on 149 degrees of freedom
## Residual deviance: 2.7060e-08 on 147 degrees of freedom
## AIC: 6
##
## Number of Fisher Scoring iterations: 25#————————————————————