i need help
QUESTION 1
Review the Food Environment Atlas maps for variables that seem to affect your selected state the most. Select a state and variables you consider relevant to represent the food environment in you chosen state. 1) Include at least two food categories from the following list: ? ACCESS ? STORES ? RESTAURANTS ? ASSISTANCE ? INSECURITY ? PRICES_TAXES ? LOCAL 2) Include at least two health variables in each of the selected food categories. Find the name and descriptions of variables in the Food Environment Atlas Resources: Excel Data and Documentation Download.
Link for the resources
http://www.ers.usda.gov/data-products/food-environment-atlas/data-access-and-documentation-downloads.aspx
Write a 200- to 300-word plan that includes ? your selected state (Texas); ? selected food categories and health variables; and ? reasons for selection. Are your variables expressed in numbers or percentages? Optional: Discuss choices in discussion with classmates and instructor. Write a summary of your discussion to include with this assignment.
QUESTION 2
1. Prepare an Excel spreadsheet containing the following: ? Column 1 - selected state counties ? Column 2 - population 2010 ? Columns 3 and beyond - values of selected variables Calculate the state's mean and standard deviation for your selected variables. Construct a frequency table and histogram for your selected variables. Calculate the mode and median for your selected variables. 2. Prepare a Word document in which you explain normality of the distribution and assess the importance. See Assessing Normality, section 6.6 in the textbook for more information on normality of distribution (histogram, looking for outliers) and how to assess its importance. 3. Click the Assignment Files tab to submit the following: ? Excel document with calculations and graphics Word document (2-3 pages) with results in table, graphs, and explanation