Question: I need help with something. I am taking a class on public health surveillance methods. My professor provided us with a dataset on diabetes in

I need help with something. I am taking a class on public health surveillance methods. My professor provided us with a dataset on diabetes in the bronx and asked us to choose our variables and draft a research question. I have but i do not know what's best to use for the data analysis, whether excel. I do not even know how to do it. Can i post the variables and the chosen research topic. For our analysis on diabetes in the Bronx, the chosen variables are ZIP Code, Insurance, Language and Year. Primary Research Question : Trend-Based Question: How has the prevalence of diabetes among Bronx residents varied across ZIP codes, insurance types, and primary languages spoken from 2020 to 2024? In addition, Compare 2020 data (treat it as baseline) with the rest of 4 years 2021 to 2024. Describe the pattern of changes in these five-year trend. Run frequency tables of the fields (variables) picked to see how clean are the data. I have to include charts and tables. I also want to group the data variables into: zip codes (north,east,west and south), insurance (private and public insurance ), language spoken (english and non-english speakers). Just give me a detailed step by step on how to do this

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!