Question: For Assignment 5, make sure to watch the microlectures showing how to perform these steps in Lecture 8. After watching the videos, then go to

For Assignment 5, make sure to watch the microlectures showing how to perform these steps in Lecture 8. After watching the videos, then go to the AskCHIS website (here ) and do the following: 1) After signing in to the system, assign Orange County as the geographic area. 2) Use the variable "Poverty Level" as your Topic, which measures household income as a percent of the Federal Poverty Level. 3) Use the variable "Health Status" as your Compare Topics, which measures self-reported health status. 4) Set data year to 2019 and click on Get Data. 5) Read the notice that pops up about unstable data and notice the red asterisks. To fix this problem, click on "Adjust layout" and combine the groups for the Compare Topic into: 1) Excellent/Very Good; 2) Good; and 3) Fair/Poor. Click ok and notice the red asterisks have disappeared in the new table, showing that the data is now all stable. 6) Click on "Export" to download the data into Excel. In Excel, you'll need to create three charts using the CHIS data. Your final

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 Databases Questions!