You work for a facility that needs some data for a presentation for the board meeting next week. You were given a file containing information on 445 patients treated by the facility last month. The files contains age, gender, marital status, race, zip code, birth month, prin dx, education level and veteran status. The Board needs graphs and frequency tables to get a clear picture of the patient demographics. A graph and frequency table is needed for each of the following reports.

1. Age groups by gender;
2. Marital status by gender;
3. Veteran status by gender;
4. Zip code by gender;
5. Education level by marital status;
6. Education level by veteran status;
7. Marital status by veteran status

Past students have found it easiest to submit this assignment using Excel, and individual worksheet for each table and graph. You must ensure the tables and graphs have appropriate labels and titles. Your grade will be based on the organization of the data in the table, and how it correlates to the graph, presentation and type of data within the graph