The below link is the dataset (Excel) that contains data from the 2017 CDC Behavioral Risk Factor Surveillance Survey (BRFSS). There is a row for each state. The dataset has the following variables in columns:

 

• State: Name of state. This is the unit of analysis.
• Fair or Poor Health: Crude Prevalence of 'Reported Fair or Poor Health'
• Depression: Crude Prevalence of 'Ever been told you have depression'
• Physical Activity: Crude Prevalence of 'Participated in 150 minutes or more of Aerobic Physical Activity per week'
• Unable to Work: Crude Prevalence of 'Unable to Work'
• No Health Care: Crude Prevalence of 'No health care coverage'
• Days Clear: Number of clear days per year
• Expanded Medicaid: Whether the state has expanded its Medicaid program. 1=Yes; 2=No.

Complete the following:

2. Conduct an exploratory (descriptive) analysis of the data and create a table to show your descriptive analysis results. This should include the following:
   2. Continuous variables
      2. Maximum, minimum, and range
      4. Mean and median
      6. Standard deviation
      8. Measures of normality
   5. For the categorical variable
      1. Counts and percentages
5. Conduct analyses to determine whether 'Reported Fair or Poor Health' is associated with at least two other variables using appropriate statistical tests in SAS. Analytic techniques to consider include Pearson's correlation and 2-sample t-test.
   1. Use a visual to illustrate one of these relationships using one of the 'Graph' Tasks.
8. Draft and submit the following:
   2. The research question and hypothesis
   4. Summary of the methods
   6. Summary of the results of the descriptive and analytic analyses
   8. Interpretation, limitations, and public health application of the results.
   10. Include your results tables.

Please number your answers, explanations and tables clearly.

https://lmscontent.embanet.com/RC/MPH/PBH616/Docs/RC_PBH_616_Week_01_Dataset_Ecological_Study.xlsx