Mth231 R2 Scavenger Hunt

Food Environment Atlas Scavenger Hunt

The purpose of this scavenger hunt is to help you become familiar with the Food Environment Atlas and ready to use the data in the MTH/231 statistical project, due in Week 5.

About the Food Environment Atlas and Data Download

The Food Environment Atlas contains over 211 indicators of the food environment that may influence the selection of healthy food choices such as accessibility to fresh produce, food assistance programs, health indicators, and general socioeconomic characteristics of communities. This information is collected regularly at state and county level by the United States Department of Agriculture, Economic Research Service. To learn more about the Food Environment Atlas, please visit the USDA website at

http://www.ers.usda.gov/data-products/food-environment-atlas/about-the-atlas.aspx

Please download the most current data set of the Food Environment Atlas at

http://www.ers.usda.gov/data-products/food-environment-atlas/data-access-and-documentation-downloads.aspx#33770

You should download the Excel file “Data Download” and the Documentation (click on the pdf symbol). The documentation has a detailed explanation about how the different variables were collected and their significance.

Instructions for the Scavenger Hunt

Answer all of the following questions for Part I and Part II of the Scavenger Hunt.
Save the file, and attach it to the Assignment files for this assignment in New Classroom.

Scavenger Hunt Part I: Navigating the Atlas Excel File

1. What can you find in the “Supplemental Data – County” worksheet?

2. What are the names of the 10 worksheets that include all the Food Environment Atlas categories of variables?

3. In which worksheet can you find the full name of variables?

4. What are the names of the following variables from the category ACCESS, and their unit of measurement?
a. LACCESS_SENIORS10:
b. PCT_LACCESS_HHNV10:

5. What are the names of the following variables from the