Per Steps 3-5 of the Signature Assignment guidelines, you are to calculate statistics for your chosen community. For this part of the assignment you are asked to submit an .xlsx file (Excel) that...

Information
    SELECTED HOUSING CHARACTERISTICS
    Note: The table shown may have been modified by user selections. Some information may be missing.
    DATA NOTES    
    TABLE ID:    DP04
    SURVEY/PROGRAM:    American Community Survey
    VINTAGE:    2015
    DATASET:    ACSDP5Y2015
    PRODUCT:    ACS 5-Year Estimates Data Profiles
    UNIVERSE:    None
    FTP URL:    None
    API URL:    https:
api.census.gov/data/2015/acs/acs5/profile
    USER SELECTIONS    
    GEOS    Lowell city, Massachusetts
    TOPICS    Housing
    EXCLUDED COLUMNS    None
    APPLIED FILTERS    None
    APPLIED SORTS    None
    WEB ADDRESS    https:
data.census.gov/cedsci/table?q=General%20Population%20and%20Housing%20Characteristics&g=1600000US2537000&tid=ACSDP5Y2015.DP04&hidePreview=true
    TABLE NOTES    Supporting documentation on code lists, subject definitions, data accuracy, and statistical testing can be found on the American Community Survey website in the Data and Documentation section.
Sample size and data quality measures (including coverage rates, allocation rates, and response rates) can be found on the American Community Survey website in the Methodology section.
        A processing e
or was found in the Year Structure Built estimates since data year 2008. For more information, please see the e
ata note #110.
        Tell us what you think. Provide feedback to help make American Community Survey data more useful for you.
Although the American Community Survey (ACS) produces population, demographic and housing unit estimates, it is the Census Bureau''s Population Estimates Program that produces and disseminates the official estimates of the population for the nation, states, counties, cities and towns and estimates of housing units for states and counties.
        Explanation of Symbols: * An ''**'' entry in the margin of e
or column indicates that either no sample observations or too few sample observations were available to compute a standard e
or and thus the margin of e
or. A statistical test is not appropriate.
* An ''-'' entry in the estimate column indicates that either no sample observations or too few sample observations were available to compute an estimate, or a ratio of medians cannot be calculated because one or both of the median estimates falls in the lowest interval or upper interval of an open-ended distribution.
* An ''-'' following a median estimate means the median falls in the lowest interval of an open-ended distribution.
* An ''+'' following a median estimate means the median falls in the upper interval of an open-ended distribution.
* An ''***'' entry in the margin of e
or column indicates that the median falls in the lowest interval or upper interval of an open-ended distribution. A statistical test is not appropriate.
* An ''*****'' entry in the margin of e
or column indicates that the estimate is controlled. A statistical test for sampling variability is not appropriate.
* An ''N'' entry in the estimate and margin of e
or columns indicates that data for this geographic area cannot be displayed because the number of sample cases is too small.
* An ''(X)'' means that the estimate is not applicable or not available.
        Estimates of u
an and rural population, housing units, and characteristics reflect boundaries of u
an areas defined based on Census 2010 data. As a result, data for u
an and rural areas from the ACS do not necessarily reflect the results of ongoing u
anization.
        While the 2011-2015 American Community Survey (ACS) data generally reflect the Fe
uary 2013 Office of Management and Budget (OMB) definitions of metropolitan and micropolitan statistical areas; in certain instances the names, codes, and boundaries of the principal cities shown in ACS tables may differ from the OMB definitions due to differences in the effective dates of the geographic entities.
        Telephone service data are not available for certain geographic areas due to problems with data collection. See E
ata Note #93 for details.
        Households not paying cash rent are excluded from the calculation of median gross rent.
        Data are based on a sample and are subject to sampling variability. The degree of uncertainty for an estimate arising from sampling variability is represented through the use of a margin of e
or. The value shown here is the 90 percent margin of e
or. The margin of e
or can be interpreted roughly as providing a 90 percent probability that the interval defined by the estimate minus the margin of e
or and the estimate plus the margin of e
or (the lower and upper confidence bounds) contains the true value. In addition to sampling variability, the ACS estimates are subject to nonsampling e
or (for a discussion of nonsampling variability, see Accuracy of the Data). The effect of nonsampling e
or is not represented in these tables.
        Source: U.S. Census Bureau, 2011-2015 American Community Survey 5-Year Estimates
    COLUMN NOTES    None
Table: ACSDP5Y2015.DP04        
Table: ACSDP5Y2015.DP04        
&Bdata.census.gov&B | Measuring America's People, Places, and Economy         &P
&Bdata.census.gov&B | Measuring America's People, Places, and Economy         &P
Data
        Lowell city, Massachusetts
    Label    Estimate    Margin of E
or    Percent    Percent Margin of E
o
    HOUSING OCCUPANCY
    Total housing units    41,448    693    41,448    (X)
    Occupied housing units    38,489    688    92.9%    ±0.9
    Vacant housing units    2,959    376    7.1%    ±0.9
    Homeowner vacancy rate    1.4    0.7    (X)    (X)
    Rental vacancy rate    6.1    1.3    (X)    (X)
    UNITS IN STRUCTURE
    Total housing units    41,448    693    41,448    (X)
    1-unit, detached    13,146    615    31.7%    ±1.3
    1-unit, attached    2,215    317    5.3%    ±0.8
    2 units    6,333    514    15.3%    ±1.2
    3 or 4 units    4,961    404    12.0%    ±0.9
    5 to 9 units    4,202    504    10.1%    ±1.2
    10 to 19 units    3,424    371    8.3%    ±0.9
    20 or more units    7,139    444    17.2%    ±1.1
    Mobile home    9    14    0.0%    ±0.1
    Boat, RV, van, etc.    19    21    0.0%    ±0.1
    YEAR STRUCTURE BUILT
    Total housing units    41,448    693    41,448    (X)
    Built 2014 or later    29    33    0.1%    ±0.1
    Built 2010 to 2013    153    75    0.4%    ±0.2
    Built 2000 to 2009    2,417    342    5.8%    ±0.8
    Built 1990 to 1999    1,513    283    3.7%    ±0.7
    Built 1980 to 1989    3,874    342    9.3%    ±0.8
    Built 1970 to 1979    3,633    388    8.8%    ±1.0
    Built 1960 to 1969    4,040    427    9.7%    ±1.0
    Built 1950 to 1959    3,892    405    9.4%    ±1.0
    Built 1940 to 1949    2,709    366    6.5%    ±0.9
    Built 1939 or earlier    19,188    730    46.3%    ±1.7
    ROOMS
    Total housing units    41,448    693    41,448    (X)
    1 room    1,894    275    4.6%    ±0.7
    2 rooms    1,497    292    3.6%    ±0.7
    3 rooms    4,834    451    11.7%    ±1.0
    4 rooms    9,008    540    21.7%    ±1.3
    5 rooms    9,612    529    23.2%    ±1.3
    6 rooms    5,912    453    14.3%    ±1.1
    7 rooms    4,024    416    9.7%    ±1.0
    8 rooms    2,675    375    6.5%    ±0.9
    9 rooms or more    1,992    282    4.8%    ±0.7
    Median rooms    4.9    0.1    (X)    (X)
    BEDROOMS
    Total housing units    41,448    693    41,448    (X)
    No bedroom    1,953    279    4.7%    ±0.7
    1 bedroom    6,936    545    16.7%    ±1.3
    2 bedrooms    14,428    682    34.8%    ±1.5
    3 bedrooms    12,165    680    29.4%    ±1.6
    4 bedrooms    4,560    451    11.0%    ±1.1
    5 or more bedrooms    1,406    245    3.4%    ±0.6
    HOUSING TENURE
    Occupied housing...