Question
Answered step-by-step
Hello! I need some help here. I need a step-by-step visual aid...
Image transcription text
35 Chapter 5 Assignment 5-1: Compare heating fuel types by US counties According to a recent
study by researchers at Columbia University's Mailman School of Public Health, housing
heating fuel types can influence health conditions such as asthma, obesity, developmental
...[Show More]
Question
Answered step-by-step
Hello! I need some help here. I need a step-by-step visual aid...
Image transcription text
35 Chapter 5 Assignment 5-1: Compare heating fuel types by US counties According to a recent
study by researchers at Columbia University's Mailman School of Public Health, housing
heating fuel types can influence health conditions such as asthma, obesity, developmental delays
and other health conditions. According to their research, residual fuel oil #6 is amongst the
dirtiest type of heating filels. [1] Cost and availability of various heating fuel types contributes to
the decision of what fuel types houses use. [2] The US Census Bureau collects data about the
fuel used to heat houses in the United States. In this problem, you explore what different fuel
types are used throughout the country. To do so, you download the American Community Survey
data from 5-year estimates at the county level, clean and join two data tables together, and
create six choropleth maps comparing fuel heating types by county. While there may be newer
estimates, this assignment uses 5—year estimates for years 2011—2015. Get set up I Rename the
AssignmentS-l folder to AssignmentS-lYourName. I Open the AssignmentS-laprx, insert a new
map, and rename it US Home Heating Fuel by County (2011-2015). I Set the spatial reference
coordinate system for your map to the projected coordinate system USA Contiguous Albers
Equal Area Conic. Download and process tabular data Download American Community Survey
data for US Counties I From the US Census website data.census. gov click Advanced Search. I
Under Browse Filters click Topics > Housing > Physical Characteristics > Heating
and Air Conditioning. I Under Browse Filters click Geography > County > All counties in
the United States > Search. I Select and download the table B25040 (House Heating Fuel) for
2015 5—year estimates and save it to your AssignmentS- lYourNarne folder
[Show Less]