Spreadsheet: 598810d1542726557-finding-formula-per-specific-category-mean-median-and-mode-bonus-histogram-excel_help
Sheet: Sheet1

SiteName | LocationCode | UniqueID | TenantID | TenantName | Lease Date | Date Out | Unit | CurrentRate | LastRentChange | MovedInSR | MovedInRate | DiscountPlan | MoveInDiscount | Duration
Site A | 318 | 88414 | 131929 | Jon Q | 2014-06-03 16:57:51.747000 | 2018-11-15 15:02:52.313000 | 2037 | 160 | 2018-08-01 00:00:00 | 125 | 125 | 50% off 1st full month | 63 | 1626
Site A | 318 | 88256 | 131812 | [NAME] | 2014-02-25 15:11:30.817000 | 2018-08-02 11:26:11.623000 | 3080 | 210 | 2018-04-01 00:00:00 | 160 | 160 | 2nd Month for $1 | 159 | 1619
Site B | 304 | 57297 | 107062 | [NAME] | 2014-01-03 10:10:08.573000 | 2018-06-12 15:02:23.993000 | A134 | 119 | 2018-01-01 00:00:00 | 79 | 79 |  | 0 | 1621
Site C | 319 | 89622 | 136663 | Jon I | 2014-03-26 14:15:13.537000 | 2018-10-15 17:41:20.907000 | 305 | 198 | 2018-04-01 00:00:00 | 150 | 150 |  | 0 | 1664
Site D | 355 | 4838 | 236038 | [NAME] | 2014-02-27 15:53:22.433000 | 2018-09-18 13:18:38.813000 | DD120 | 79 | 2017-12-01 00:00:00 | 65 | 65 | 50% 3mo - After 15th | 97.5 | 1664
Site D | 355 | 4716 | 236114 | Jon T | 2014-03-01 16:59:48.447000 | 2018-08-08 10:55:51.690000 | A032 | 84 | 2017-12-01 00:00:00 | 69 | 69 | 50% 3mo - B4 15th | 103.5 | 1621
Site E | 320 | 92710 | 133469 | [NAME] | 2014-01-24 14:52:50.613000 | 2018-06-30 09:37:20 | D405 | 264 | 2018-02-01 00:00:00 | 190 | 190 | 2nd Month for $1 | 189 | 1618
Site F | 341 | 40170 | 179017 | Jon B | 2014-01-20 00:00:00 | 2018-10-31 10:41:31.193000 | 627 | 61 | 2017-09-01 00:00:00 | 49 | 45 |  | 20 | 1745
Site G | 331 | 28686 | 165975 | [NAME] | 2014-01-23 00:00:00 | 2018-08-01 13:19:54.543000 | CC15 | 83 | 2018-02-01 00:00:00 | 54 | 71 |  | 0 | 1651
Site G | 331 | 29206 | 165824 | Jon P | 2014-02-14 00:00:00 | 2018-08-01 13:18:53.530000 | 1722 | 162 | 2018-07-01 00:00:00 | 127 | 122 |  | 8 | 1629
Site H | 302 | 53470 | 94697 | Jon E | 2014-01-07 10:59:05.050000 | 2018-09-14 10:43:08.707000 | 920 | 175 | 2018-01-01 00:00:00 | 116 | 116 |  | 0 | 1711
Site I | 317 | 87062 | 127039 | [NAME] | 2014-01-06 16:34:15.660000 | 2018-07-02 14:13:01.257000 | 2041 | 100 | 2018-01-22 10:16:52.953000 | 109 | 98.1 |  | 109 | 1638
Site I | 317 | 86792 | 127279 | [NAME] | 2014-04-12 15:54:47.010000 | 2018-09-20 11:12:10.007000 | 2054 | 299 | 2018-09-01 00:00:00 | 289 | 245 |  | 245 | 1622
Site J | 332 | 29915 | 165228 | Jon C | 2014-01-27 00:00:00 | 2018-11-05 12:32:16.230000 | 1717 | 149 | 2018-11-01 00:00:00 | 99 | 113 |  | -3 | 1743
Site J | 332 | 29707 | 165225 | Jon O | 2014-05-15 00:00:00 | 2018-10-31 08:51:59.403000 | 1820 | 115 | 2018-05-01 00:00:00 | 89 | 91 |  | 1 | 1630
Site J | 332 | 29906 | 165024 | Jon V | 2014-04-22 00:00:00 | 2018-09-28 12:40:00.743000 | 2505 | 191 | 2018-04-01 00:00:00 | 149 | 144 |  | -6 | 1620
Site K | 303 | 55100 | 111201 | [NAME] | 2014-02-06 14:30:37.047000 | 2018-09-01 14:30:48.090000 | 131 | 113 | 2018-04-01 00:00:00 | 89 | 89 | Website Special | 89 | 1668
Site K | 303 | 54770 | 109860 | Jon J | 2014-01-18 11:16:48.213000 | 2018-07-31 11:28:06.930000 | 448 | 219 | 2018-04-01 00:00:00 | 149 | 149 |  | 0 | 1655
Site K | 303 | 55231 | 109596 | Jon N | 2014-01-06 15:47:55.213000 | 2018-06-29 16:37:03.627000 | 421 | 164 | 2017-02-01 00:00:00 | 132 | 132 |  | 110.71 | 1635
Site L | 328 | 23234 | 156680 | Jon R | 2014-03-18 16:29:39.980000 | 2018-08-27 11:40:28.767000 | 111 | 210 | 2018-03-01 00:00:00 | 193 | 193 |  | 115.8 | 1623
Site M | 312 | 76005 | 6961 | [NAME] | 2014-01-21 16:08:19.657000 | 2018-08-31 09:53:29.503000 | [NAME] | 140 | 2018-02-01 00:00:00 | 159 | 99 |  | 21.29 | 1683
Site M | 312 | 76006 | 6961 | [NAME] | 2014-01-21 16:11:42.793000 | 2018-08-31 09:53:51.573000 | G81 | 140 | 2018-02-01 00:00:00 | 159 | 99 |  | 21.29 | 1683
Site N | 342 | 40429 | 180676 | [NAME] | 2014-01-15 09:50:30 | 2018-07-16 12:33:21.090000 | C07 | 193 | 2017-08-01 00:00:00 | 155 | 155 |  | 36 | 1643
Site O | 324 | 15208 | 145003 | Jon D | 2014-02-01 00:00:00 | 2018-10-28 09:32:30 | F07 | 193 | 2018-03-01 00:00:00 | 199 | 145 |  | 0 | 1730
Site P | 301 | 51707 | 109676 | Jon A | 2014-01-17 09:44:00.633000 | 2018-10-30 13:25:07.030000 | B027 | 199 | 2018-02-01 00:00:00 | 159 | 159 | Website Only Pricing 10x10 | 195 | 1747