Second, I selected Chronic Disease Indicators <\/a>for my health area of interest.<\/p>\n Third, I selected ALCOHOL<\/a> – which brought me to the screen showing all the columns of data and a bunch of choices.<\/p>\n Fourth, I clicked\u00a0 on FILTER on the right of the screen and then select a column to filter by.<\/p>\n Fifth, since I wanted to compare urban and rural states, I clicked Add a New Filter Condition and then selected California, New York, North Dakota and Wyoming with LocationDesc as the filter condition. Make sure the box next to each condition you want is clicked on.<\/p>\n In case you were wondering,\u00a0 I based my choice on the listing of states by urbanization , <\/a>New Jersey is #2, MA 5 and NY 13 8. I clicked on visualize on the right, selected Column as the type of chart, Location Desc as the label data, DataValueAlt as the data value, and there was my chart<\/p>\n Note: I could not select DataValue. My guess is that was a string variable. I had to select DataValuealt, which was the exact same value<\/p>\n 9.Just to make it more obvious, I went in and sorted on data value, which caused the chart to be recreated automatically.<\/p>\n You can see below the chart it created. It’s pretty clear that in these data there is no relationship between urbanization and alcohol use among youth.<\/p>\n New York and New Jersey where the lowest and highest prevalence, respectively. I was hoping to see a pattern with more rural states higher, but it seemed to be pretty unrelated.<\/p>\n HOW TO DOWNLOAD THE DATA SETS FOR\u00a0 ANALYSIS<\/p>\n Perhaps you would prefer to download the data set for import into some other tool, say, Excel or SAS. The first three steps are the same, into you find the data set you want.<\/p>\n This next step is not required , but the data sets can be pretty big, so I’d suggest filtering on at least one major variable first. For example, you can click the three rows next to any column, say, Question, and then select the question that interests you, say Binge Drinking.<\/p>\n Next, click the EXPORT button at the top right of the screen. Select the format in which you want your file to be downloaded. That’s it!<\/p>\n <\/p>\n![\"select](\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2017\/03\/1SelectFilter.png\")
<\/a>
\nChrome did not give me a scroll bar so the furthest option I could get was Topic. I switched over to Firefox and was able to get this menu where I selected Question and Alcohol use among youth. You have to type in the value that you want. Make sure it is spelled exactly the same as in the data set.<\/p>\n![\"2secondfilter\"](\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2017\/03\/2secondfilter.png\")
<\/a>Sixth, I looked at my data, saw there was no data for California and I was sad. Not every state participates in every data set.<\/p>\n![\"Data](\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2017\/03\/3NoCalifornia.png\")
<\/a>7. So, I decided to compare urban, eastern states wth rural midwest\/west and I selected New York, New Jersey, Massachusetts, Wyoming, North Dakota and Montana\u00a0 All had data so I was good to go.<\/p>\n
\n<\/a>On the other extreme, Wyoming is 39, North Dakota is 42,\u00a0 and Montana 47 so I thought this was a pretty good split.<\/p>\n![\"4graph\"](\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2017\/03\/4graph.png\")
<\/a><\/p>\n![\"Sorting](\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2017\/03\/5Sort.png\")
<\/a><\/p>\n![\"graph\"](\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2017\/03\/6graph.png\")
<\/a><\/p>\n![\"selecting](\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2017\/03\/8otherway1.png\")
<\/a><\/p>\n![\"download](\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2017\/03\/9download.png\")
<\/a><\/p>\n
![\"Buy](\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2016\/09\/BUY-Banner-copy.png\")
<\/a><\/p>\n