Problem Statement You are to create a project for a census bureau to obtain and analyze household income survey data within the Cincinnati area (including Northern Ky).

Must Include:

a. modular program using User Defined Functions and Procedures b.Arrays and Parallel Arrays c.String Manipulation techniques Data Collected: Home identification code (4 alphanumeric characters) required Program should generate it using a random number generator (there is a function for this. Date of the survey required (use datetime picker control), must be a valid date County and State (1 input only) they reside in - required Hamilton, Oh Butler, Oh Clermont, Oh Warren, Oh Campbell, Ky Boone, Ky Kenton, Ky Number in Household required, must be numeric, must be greater than 0 The household yearly income required, must be numeric, must be greater than 0. Events: There should be 5 buttons on the screen: 1.Submit: This event will validate all data and save the data to the necessary arrays for processing. 2.Exit: This event will exit the application 3.Total Households Surveyed: This event will process the arrays and display the total households surveyed by state and then by county in a Message box (see below for example). 4.Average Household Income: This event will process the arrays and display the average household income by state and then by county in a Message box (see below for example). 5.Percentage Below Poverty: This event will process the arrays and display the Percentage Below Poverty for each state and their counties in a Message Box. Poverty is based on the table below. Instructions: 1)Create a well designed modular program based on design techniques taught. 2)Use good naming conventions on all objects, variables, procedures, functions, etc. 3)Make sure all functions and procedures are called down. 4)Option Strict and Option Explicit must be on 5)All survey data from the GUI must be saved to parallel arrays (a total of 5) upon submission of each census. No calculations should be done until the following buttons are clicks. 6)When the user clicks the button Total Households Surveyed, do the necessary array processing and display in a Message box the Total Households Surveyed by State and by county for all that were surveyed (see below for example). 7)When the user clicks the button Average Household Income, do the necessary array processing and display in a Message box the Average Household Income by State and by county for all that were surveyed (see below for example). 8)When the user clicks the button Percentage Below Poverty, do the necessary array processing and display in a Message box the Percentage Below Poverty by State and by county for all that were surveyed (see below for example). Average Household Income Ohio: $30,000 Hamilton: $40,000 Butler: $20,000 Clermont: $30,000 Warren: $30,000 Kentucky: $35,000 Boone: $40,000 Campbell: $30,000 Kenton: $35,000 Basis of Poverty: Household of 1 and less than $12,000 Household of 2 and less than $18,000 Household of 3 and less than $25,000 Household of 4 and less than $30,000 Household of 5 or more and less than $40,000