Overview/purpose
The purpose of this assessment is to review the relationship between
building square footage and the number of employees and the outcome
variables of hotel rooms and classroom seats (as a proxy for students).
This assessment is intended to inform the feasibility of utilizing
parcel-based data or employment data by industry for estimating hotel
rooms at lodging businesses and students at educational facilities.
Dataset
This analysis is built on the “2018 CBECS Survey Data,” which
contains detailed site-level details about buildings and associated uses
and characteristics, allowing for direct comparisons between variables.
For this assessment, data is filtered to look at only buildings in the
Census South Atlantic division, which includes: Delaware, Florida,
Georgia, Maryland, North Carolina, South Carolina, Virginia, West
Virginia and District of Columbia.
General Finidings
Square footage data is generally a better at predicting hotel rooms
and classroom seats versus the number of employees. Adding in additional
context, such as the type of school or hotel and the number of
employees, sometimes improves the model. But generally speaking, square
footage is a reasonable starting point.
Hotel / Motel Analysis
Hotel/Motel Data
## Descriptive Statistics
## data_southatlantic
## N: 101
##
## LODGRM NWKER SQFT
## ----------------- --------- -------- -----------
## Mean 257.11 63.73 219556.93
## Std.Dev 193.99 100.94 177844.83
## Min 2.00 2.00 3250.00
## Q1 100.00 15.00 96000.00
## Median 225.00 40.00 170000.00
## Q3 300.00 71.00 310000.00
## Max 1000.00 800.00 700000.00
## MAD 185.32 37.06 148260.00
## IQR 200.00 56.00 214000.00
## CV 0.75 1.58 0.81
## Skewness 1.32 4.54 1.00
## SE.Skewness 0.24 0.24 0.24
## Kurtosis 2.43 27.06 0.14
## N.Valid 101.00 101.00 101.00
## Pct.Valid 100.00 100.00 100.00
Resulting Ratios
Square Feet per Room
|
Category
|
Total Rooms
|
Total Sq. Ft.
|
Sq. Ft. per Room
|
|
Dormitory/fraternity/sorority
|
7571
|
3786000
|
500
|
|
Hotel/resort
|
17327
|
17476250
|
1009
|
|
Motel/inn/bed and breakfast
|
303
|
161000
|
531
|
|
Other lodging
|
767
|
752000
|
980
|
|
Total
|
25968
|
22175250
|
854
|
Workers per Room
|
Category
|
Total Rooms
|
Total Workers
|
Workers per Room
|
|
Dormitory/fraternity/sorority
|
7571
|
526
|
14.4
|
|
Hotel/resort
|
17327
|
5606
|
3.1
|
|
Motel/inn/bed and breakfast
|
303
|
37
|
8.2
|
|
Other lodging
|
767
|
268
|
2.9
|
|
Total
|
25968
|
6437
|
4.0
|
Model perspective
| A | B | C | D | E | F |
| (Intercept) | 93.382 *** | 221.761 *** | 208.406 *** | 340.203 *** | 90.370 *** | 221.074 *** |
| (22.562) | (30.774) | (21.082) | (35.484) | (22.829) | (31.723) |
| SQFT | 0.001 *** | 0.001 *** | | | 0.001 *** | 0.001 *** |
| (0.000) | (0.000) | | | (0.000) | (0.000) |
| cat_descHotel/resort | | -163.913 *** | | -149.473 *** | | -163.439 *** |
| | (32.103) | | (41.552) | | (32.632) |
| cat_descMotel/inn/bed and breakfast | | -196.178 *** | | -301.205 *** | | -195.544 *** |
| | (56.284) | | (70.550) | | (56.947) |
| cat_descOther lodging | | -190.395 ** | | -248.607 ** | | -189.736 ** |
| | (58.461) | | (74.819) | | (59.150) |
| NWKER | | | 0.764 *** | 0.811 *** | -0.169 | -0.016 |
| | | (0.177) | (0.167) | (0.187) | (0.168) |
| N | 101 | 101 | 101 | 101 | 101 | 101 |
| R2 | 0.467 | 0.595 | 0.158 | 0.335 | 0.472 | 0.595 |
| logLik | -643.050 | -629.183 | -666.170 | -654.267 | -642.632 | -629.178 |
| AIC | 1292.100 | 1270.365 | 1338.339 | 1320.533 | 1293.264 | 1272.355 |
| *** p < 0.001; ** p < 0.01; * p < 0.05. |
Schools Analysis
Schools Data
## Descriptive Statistics
## data_southatlantic_school
## N: 136
##
## EDSEAT NWKER SQFT
## ----------------- --------- -------- -----------
## Mean 674.12 61.46 87914.72
## Std.Dev 803.88 80.86 94907.62
## Min 19.00 1.00 1050.00
## Q1 150.00 15.50 13000.00
## Median 450.00 40.00 63000.00
## Q3 800.00 80.50 118000.00
## Max 6000.00 700.00 460000.00
## MAD 463.31 44.48 75612.60
## IQR 650.00 64.50 103500.00
## CV 1.19 1.32 1.08
## Skewness 2.90 4.20 1.49
## SE.Skewness 0.21 0.21 0.21
## Kurtosis 13.18 27.17 1.88
## N.Valid 136.00 136.00 136.00
## Pct.Valid 100.00 100.00 100.00
Resulting Ratios
Square Feet per Classroom Seat
|
Category
|
Schools
|
Total Seats
|
Total Sq. Ft.
|
Sq. Ft. per Seat
|
|
College/university
|
18
|
16400
|
1826501
|
111.37
|
|
Elementary/middle school
|
67
|
38102
|
4758350
|
124.88
|
|
High school
|
25
|
33680
|
4975101
|
147.72
|
|
Other classroom education
|
14
|
2425
|
283850
|
117.05
|
|
Preschool/daycare
|
12
|
1074
|
112600
|
104.84
|
|
Total
|
136
|
91681
|
11956402
|
130.41
|
Classroom Seats per Worker
|
Category
|
Schools
|
Classroom Seats
|
Total Workers
|
Classroom Seats per Worker
|
|
College/university
|
18
|
16400
|
1695
|
9.68
|
|
Elementary/middle school
|
67
|
38102
|
3453
|
11.03
|
|
High school
|
25
|
33680
|
2778
|
12.12
|
|
Other classroom education
|
14
|
2425
|
224
|
10.83
|
|
Preschool/daycare
|
12
|
1074
|
209
|
5.14
|
|
Total
|
136
|
91681
|
8359
|
10.97
|
Model Perspective
| A | B | C | D | E | F |
| (Intercept) | 151.684 ** | 172.212 | 124.784 | 296.222 * | 46.173 | 71.825 |
| (45.131) | (103.906) | (63.780) | (144.441) | (44.451) | (101.306) |
| NWKER | 8.500 *** | 7.847 *** | | | 6.481 *** | 6.542 *** |
| (0.445) | (0.464) | | | (0.531) | (0.544) |
| cat_descElementary/middle school | | -7.924 | | -157.895 | | 3.448 |
| | (108.011) | | (146.901) | | (102.153) |
| cat_descHigh school | | 303.061 * | | -154.922 | | 110.572 |
| | (123.888) | | (180.506) | | (126.378) |
| cat_descOther classroom education | | -124.545 | | -245.868 | | -47.891 |
| | (147.070) | | (202.146) | | (140.321) |
| cat_descPreschool/daycare | | -219.376 | | -263.582 | | -116.906 |
| | (153.254) | | (212.615) | | (147.075) |
| SQFT | | | 0.006 *** | 0.006 *** | 0.003 *** | 0.002 *** |
| | | (0.000) | (0.001) | (0.000) | (0.001) |
| N | 136 | 136 | 136 | 136 | 136 | 136 |
| R2 | 0.731 | 0.762 | 0.544 | 0.552 | 0.785 | 0.789 |
| logLik | -1012.937 | -1004.735 | -1048.807 | -1047.692 | -997.751 | -996.576 |
| AIC | 2031.873 | 2023.470 | 2103.614 | 2109.384 | 2003.502 | 2009.152 |
| *** p < 0.001; ** p < 0.01; * p < 0.05. |
