Use the Census Data data file (CensusData.xlsx) in the Cases: Submissions folder on eCampus. Your submission will be a screenshot in the answer section at the bottom of this page. Open IDEA. Import the data file. The 2010 population numbers are in the field Pop_2010.

Required:

Use the AnalysisDirect commands in IDEA followed by clicking on the calculator in the middle of the dialog box and entering an equation in the Equation Editor to identify the six counties in West Virginia (WV) that have population counts of less than 8,000 people according to the 2010 population census. Show a screenshot of your results (county name, population 2010, and any other fields that you wish to add to the table) below:

(return this page together with your IDEA screenshot shown below as your submission)