we have a project we have to do it only in Excel. i write down what we decide to do.

We decided to make an excel project that explains each part for the price, destinations, and time for each and every city in the USA. Were planning to show how to do a schedule for the Delta air line company that shows the prices and the destinations. We will also tell them about discounts for old people, disabled, military and children under 10 years of age.
There are many functions that we are going to use. The same as we learned in classes so far. We will do our best to use them in our project.
The function we are going to use (IF,VLOOKUP, MATCH, INDEX, CONCATENTE,) and we will try to use also LEFT and RIGHT, that will help us to make the word short.

**you can use your own information and numbers

We want to investigate the demographics of FSE 200. Create the following graphs or charts using the S14 demo.xls dataset. Remember to include titles, labels, and a source, and that you will likely have to create a table first for the categorical variables. Remember to use fill if necessary when printing in black and white. Copy your graphs and charts into this word document and submit a hard copy on the due date listed in the syllabus.

1. Create a pie chart for gender.
2. Create a histogram for age.
3. Create a column graph for marital status.
4. Create a graph or chart of your choice for home (you can categorize this variable any way you choose.)
5. Create a column graph for grade by major.
Section Gender What was your age as of January 1, 2016? What is your current status? Where are you from? Grade classification Major Second Major
TR 11 am Male 25 Single, never married Saudi arbic Sophomore Fire, Arson and Explosion Investigation
TR 11 am Male 26 Single, never married Saudi Sophomore Fire, Arson and Explosion Investigation
TR 11 am Male 21 Single, never married Rochester,NY Junior Fire Protection Administration Fire, Arson and Explosion Investigation
TR 11 am Male 20 Single, never married Hampstead, MD Sophomore Fire, Arson and Explosion Investigation
TR 11 am Male 21 Single, never married Barbourville, KY Junior Fire, Arson and Explosion Investigation
TR 11 am Male 19 Single, never married Rochester, MN Sophomore Fire, Arson and Explosion Investigation
TR 11 am Male 23 Single, never married Latrobe Pa Senior Fire, Arson and Explosion Investigation
TR 11 am Male 21 Single, never married Abingdon, Virgnia Junior Fire, Arson and Explosion Investigation
TR 11 am Male 24 Single, never married Stafford, Virginia Junior Emergency Medical Care
TR 11 am Male 21 Living w/ partner Leesburg, VA Junior Fire, Arson and Explosion Investigation
TR 11 am Male 21 Single, never married Covington, Kentucky Senior Emergency Medical Care
TR 11 am Female 19 Single, never married Brodhead, KY Sophomore Fire Protection and Safety Engineering Technology Occupational Safety
TR 11 am Male 20 Single, never married Erlanger, Kentucky Sophomore Occupational Safety
TR 11 am Male 20 Living w/ partner Iowa Junior Fire Protection Administration
TR 11 am Male 19 Single, never married Saudi Sophomore Fire, Arson and Explosion Investigation
TR 11 am Male 25 Seperated saudia arabia Junior Occupational Safety
TR 11 am Female 21 Single, never married Somerset, KY Senior Occupational Safety
TR 11 am Male 19 Single, never married Cynthiana KY Sophomore Occupational Safety
TR 11 am Male 21 Single, never married Brodhead, KY Junior Fire Protection and Safety Engineering Technology
TR 11 am Male 23 Single, never married Paintsville, Ky Junior Emergency Medical Care
TR 2 pm Male 24 Single, never married Richmond KY Occupational Safety
TR 2 pm Male 21 Single, never married Saudi arabia Freshman Occupational Safety
TR 2 pm Male 22 Saudi arabia Sophomore Fire, Arson and Explosion Investigation
TR 2 pm Male Single, never married Saudi Arabia Junior Occupational Safety
TR 2 pm Male 21 Living w/ partner Decatur, IL Senior Fire Protection Administration
TR 2 pm Male 21 Single, never married Dayton, Ohio Senior Other
TR 2 pm Female 21 Single, never married Independence, ky Junior Occupational Safety Emergency Medical Care
TR 2 pm Male 35 Married with children Kingdom of Saudi Arabia Senior Occupational Safety
MW 10:10 am Male 22 Single, never married Saudi Arabia Junior Occupational Safety
MW 10:10 am Male 26 Single, never married Orlando, Florida Junior Occupational Safety
MW 10:10 am Male 20 Single, never married Chicago, IL Junior Fire, Arson and Explosion Investigation
MW 10:10 am Male 21 Single, never married Pikeville, KY Junior Occupational Safety
MW 10:10 am Male 22 Single, never married Greensburg KY Senior Occupational Safety
MW 10:10 am Male 21 Single, never married Richmond, KY Junior Occupational Safety
MW 10:10 am Male 21 Single, never married Morning View, KY Senior Occupational Safety
MW 10:10 am Male 24 Single, never married Richmond, KY Senior Occupational Safety
MW 10:10 am Male 26 Single, never married Lancaster, KY Junior Occupational Safety
MW 10:10 am Male 23 Single, never married West Liberty, KY Senior Occupational Safety
MW 10:10 am Female 25 Single, never married Salyersville, KY Senior Other
MW 10:10 am Male 24 Single, never married saudi arabia Senior Fire Protection and Safety Engineering Technology Occupational Safety
MW 10:10 am Male 23 Single, never married Danville, Kentucky Senior Occupational Safety
MW 10:10 am Male 21 Single, never married trafalgar Indiana Sophomore Occupational Safety
MW 10:10 am Male 19 Single, never married Rochester , NY Sophomore Fire Protection Administration
MW 10:10 am Male 22 Single, never married Saudi Arabia Senior Emergency Medical Care
MW 10:10 am Male 21 Single, never married Gore, VA Junior Fire Protection Administration
MW 10:10 am Female 20 Single, never married Detroit, MI Junior Fire, Arson and Explosion Investigation
MW 10:10 am Male 22 Single, never married saudi arabia Sophomore Emergency Medical Care
MW 10:10 am Male 21 Single, never married Ashland Ky Junior Occupational Safety
TR 2 pm Male 30 Single, never married Saudi Arabia Junior Occupational Safety
TR 2 pm Male 24 Single, never married kingdom of Saudi Arabia Sophomore Occupational Safety
TR 11 am Male 26 Single, never married Saudi Arabia Senior Occupational Safety
TR 11 am Male 26 Single, never married Saudi Arabia Senior Occupational Safety
TR 2 pm Male 20 Single, never married Nicholasville, KY Sophomore Emergency Medical Care
TR 2 pm Male 22 Single, never married Effingham IL Senior Fire Protection Administration Emergency Medical Care
TR 2 pm Male 27 Single, never married Phionx, Arizona Senior Occupational Safety
Male 20 Single, never married Lexington,ky Sophomore Occupational Safety
TR 2 pm Male 19 Single, never married Grayson, KY Freshman Occupational Safety
MW 10:10 am Male 26 Single, never married Saudi Arabia Senior Occupational Safety
MW 10:10 am Male 21 Single, never married Winchester KY Junior Occupational Safety

We want to investigate the demographics of FSE 200. Create the following graphs or charts using the S14 demo.xls dataset. Remember to include titles, labels, and a source, and that you will likely have to create a table first for the categorical variables. Remember to use fill if necessary when printing in black and white. Copy your graphs and charts into this word document and submit a hard copy on the due date listed in the syllabus.

1. Create a pie chart for gender.
2. Create a histogram for age.
3. Create a column graph for marital status.
4. Create a graph or chart of your choice for home (you can categorize this variable any way you choose.)
5. Create a column graph for grade by major.
Section Gender What was your age as of January 1, 2016? What is your current status? Where are you from? Grade classification Major Second Major
TR 11 am Male 25 Single, never married Saudi arbic Sophomore Fire, Arson and Explosion Investigation
TR 11 am Male 26 Single, never married Saudi Sophomore Fire, Arson and Explosion Investigation
TR 11 am Male 21 Single, never married Rochester,NY Junior Fire Protection Administration Fire, Arson and Explosion Investigation
TR 11 am Male 20 Single, never married Hampstead, MD Sophomore Fire, Arson and Explosion Investigation
TR 11 am Male 21 Single, never married Barbourville, KY Junior Fire, Arson and Explosion Investigation
TR 11 am Male 19 Single, never married Rochester, MN Sophomore Fire, Arson and Explosion Investigation
TR 11 am Male 23 Single, never married Latrobe Pa Senior Fire, Arson and Explosion Investigation
TR 11 am Male 21 Single, never married Abingdon, Virgnia Junior Fire, Arson and Explosion Investigation
TR 11 am Male 24 Single, never married Stafford, Virginia Junior Emergency Medical Care
TR 11 am Male 21 Living w/ partner Leesburg, VA Junior Fire, Arson and Explosion Investigation
TR 11 am Male 21 Single, never married Covington, Kentucky Senior Emergency Medical Care
TR 11 am Female 19 Single, never married Brodhead, KY Sophomore Fire Protection and Safety Engineering Technology Occupational Safety
TR 11 am Male 20 Single, never married Erlanger, Kentucky Sophomore Occupational Safety
TR 11 am Male 20 Living w/ partner Iowa Junior Fire Protection Administration
TR 11 am Male 19 Single, never married Saudi Sophomore Fire, Arson and Explosion Investigation
TR 11 am Male 25 Seperated saudia arabia Junior Occupational Safety
TR 11 am Female 21 Single, never married Somerset, KY Senior Occupational Safety
TR 11 am Male 19 Single, never married Cynthiana KY Sophomore Occupational Safety
TR 11 am Male 21 Single, never married Brodhead, KY Junior Fire Protection and Safety Engineering Technology
TR 11 am Male 23 Single, never married Paintsville, Ky Junior Emergency Medical Care
TR 2 pm Male 24 Single, never married Richmond KY Occupational Safety
TR 2 pm Male 21 Single, never married Saudi arabia Freshman Occupational Safety
TR 2 pm Male 22 Saudi arabia Sophomore Fire, Arson and Explosion Investigation
TR 2 pm Male Single, never married Saudi Arabia Junior Occupational Safety
TR 2 pm Male 21 Living w/ partner Decatur, IL Senior Fire Protection Administration
TR 2 pm Male 21 Single, never married Dayton, Ohio Senior Other
TR 2 pm Female 21 Single, never married Independence, ky Junior Occupational Safety Emergency Medical Care
TR 2 pm Male 35 Married with children Kingdom of Saudi Arabia Senior Occupational Safety
MW 10:10 am Male 22 Single, never married Saudi Arabia Junior Occupational Safety
MW 10:10 am Male 26 Single, never married Orlando, Florida Junior Occupational Safety
MW 10:10 am Male 20 Single, never married Chicago, IL Junior Fire, Arson and Explosion Investigation
MW 10:10 am Male 21 Single, never married Pikeville, KY Junior Occupational Safety
MW 10:10 am Male 22 Single, never married Greensburg KY Senior Occupational Safety
MW 10:10 am Male 21 Single, never married Richmond, KY Junior Occupational Safety
MW 10:10 am Male 21 Single, never married Morning View, KY Senior Occupational Safety
MW 10:10 am Male 24 Single, never married Richmond, KY Senior Occupational Safety
MW 10:10 am Male 26 Single, never married Lancaster, KY Junior Occupational Safety
MW 10:10 am Male 23 Single, never married West Liberty, KY Senior Occupational Safety
MW 10:10 am Female 25 Single, never married Salyersville, KY Senior Other
MW 10:10 am Male 24 Single, never married saudi arabia Senior Fire Protection and Safety Engineering Technology Occupational Safety
MW 10:10 am Male 23 Single, never married Danville, Kentucky Senior Occupational Safety
MW 10:10 am Male 21 Single, never married trafalgar Indiana Sophomore Occupational Safety
MW 10:10 am Male 19 Single, never married Rochester , NY Sophomore Fire Protection Administration
MW 10:10 am Male 22 Single, never married Saudi Arabia Senior Emergency Medical Care
MW 10:10 am Male 21 Single, never married Gore, VA Junior Fire Protection Administration
MW 10:10 am Female 20 Single, never married Detroit, MI Junior Fire, Arson and Explosion Investigation
MW 10:10 am Male 22 Single, never married saudi arabia Sophomore Emergency Medical Care
MW 10:10 am Male 21 Single, never married Ashland Ky Junior Occupational Safety
TR 2 pm Male 30 Single, never married Saudi Arabia Junior Occupational Safety
TR 2 pm Male 24 Single, never married kingdom of Saudi Arabia Sophomore Occupational Safety
TR 11 am Male 26 Single, never married Saudi Arabia Senior Occupational Safety
TR 11 am Male 26 Single, never married Saudi Arabia Senior Occupational Safety
TR 2 pm Male 20 Single, never married Nicholasville, KY Sophomore Emergency Medical Care
TR 2 pm Male 22 Single, never married Effingham IL Senior Fire Protection Administration Emergency Medical Care
TR 2 pm Male 27 Single, never married Phionx, Arizona Senior Occupational Safety
Male 20 Single, never married Lexington,ky Sophomore Occupational Safety
TR 2 pm Male 19 Single, never married Grayson, KY Freshman Occupational Safety
MW 10:10 am Male 26 Single, never married Saudi Arabia Senior Occupational Safety
MW 10:10 am Male 21 Single, never married Winchester KY Junior Occupational Safety