Use the Neighborhood Characteristics dataset to answer the following questions. This dataset contains several income and education variables in the U.S. summarized to the neighborhood level (i.e., Census Tract). Filter the dataset to keep 6 midwestern states and place each state's sample data into its own sheet (this will make analysis easier): Iowa (FIPS = 19), Kansas (FIPS = 20), Minnesota (FIPS = 27), Nebraska (FIPS = 31), North Dakota (FIPS = 38), and South Dakota (FIPS = 46). Use the data to create and complete the following table for the variable "Household Income 2014". (One way of doing this is to first complete the table in Excel and Copy & Paste into Word): Table 1: Midwestern Household Income Statistics 2014 Statistic/State IA KS MN NE ND SD

Sample Mean Sample standard deviation Sample size (n)