Quick Data Analysis Lists

You need to make 2 lists in Microsoft Word. They will be filled in as laid out below.

Compile data around the factors in the sources provided at the end. You don’t have to use all the sources, we’ve just provided quite a few so you aren’t wasting time researching, you can just jump straight into the analysis and make the lists. Use a weighted statistical system to determine the Top 10 and Bottom 10 states for public safety as explained here: https://www.fool.com/the-ascent/small-business/project-management/weighted-scoring-model/.

Focus on the three areas of public safety as the ranking factors (emergency response time; # of roadway infrastructure incidents [collapsed bridges or roads etc, traffic accidents]; and # of building infrastructure incidents). Please ensure the criteria for best and worst is consistent across all states.

In each state’s subsection, write only a few sentences to cover specific details and underlying reasons (such as legislation, government spending on infrastructure, etc.) why public safety is so good (or so poor) in that state. Explain your math/statistics for putting each state in each rank, and link to the exact chart/data you pulled info from. Do this for every state listed, because I need to see exactly where every number, rank, percentage, etc. comes from to check your math and accuracy before payment is released. ChatGPT gets the analysis wrong every time, so make sure you follow instructions carefully, show your work, and check your math.

List Layout:
Best States for Public Safety
State 1
State 2
State 3
State 4
State 5
State 6
State 7
State 8
State 9
State 10

Worst States for Public Safety
State 1
State 2
State 3
State 4
State 5
State 6
State 7
State 8
State 9
State 10

Data sources:
Bridge condition by highway system 2023 by the U.S. Dept of Transportation
https://www.fhwa.dot.gov/bridge/nbi/no10/condition23.cfm

FEMA Annual Building Code Adoption Tracking Fact Sheets 2023
https://www.fema.gov/emergency-managers/risk-management/building-science/bcat/fact-sheets?utm_source=gd&utm_medium=march#search

State Fire Loss & Fire Department Profiles through FEMA
https://www.usfa.fema.gov/statistics/states/

Average commute times by state
https://www.census.gov/acs/www/about/why-we-ask-each-question/commuting/

Building codes by state via IBHS
https://ibhs.org/public-policy/building-codes-by-state/

Building code adoption tracking through FEMA
https://www.fema.gov/emergency-managers/risk-management/building-science/bcat

2022 Highway Statistics via the U.S. Dept of Transportation
https://www.fhwa.dot.gov/policyinformation/statistics/2022/

Best states for emergency healthcare via Forbes
https://www.forbes.com/health/medical-alert-systems/best-states-for-emergency-health-care/

Mobile device speedtest for phones
https://www.speedtest.net/global-index/united-states

EIA data on power outages
https://www.eia.gov/electricity/data/eia861/

Broadband internet access/rankings
https://broadbandnow.com/research/best-states-with-internet-coverage-and-speed

US fire death rates by state via the NFPA
https://www.nfpa.org/education-and-research/research/nfpa-research/fire-statistical-reports/fire-deaths-by-state