As a travel industry consultant, you have been working for the state of Indiana Department of Tourism. The department manager has asked you to present a report on where Indiana residents travel to and where Indiana visitors come from. The modes of transportation must also be presented. You will also include some information from a survey that your firm has recently completed. The travel survey is located in the workbook named Indiana.xlsx.

Complete the following:

1.Open the workbook named Indiana.xlsx and then save it as Indiana Travel.xlsx.

2.Create two bar charts to illustrate the differences among the travel characteristics of the average Indiana resident, the average U.S. resident, and the average Indiana visitor.

3.Create a bar chart to illustrate a state-by-state comparison of the number of residents from the rest of the nation that visit Indiana to the number of Indiana residents that visit other states. Rank the information in this chart by the states with the most visitors to Indiana.

4. Reason why you choose this chart.

5.Save and close the Indiana Travel.xlsx workbook.

Travel Characteristics for Indiana and the United States: 2006 and 2016 Indiana 2006 2016 Percent change United States Percent 2006 2016 change People who live in area Percent traveling households Trips per household Trips per traveling household 73.8 5 7 86.1 0.166667 5.3 0.06 7.3 0.042857 81.7 4.6 6.5 94.3 0.154223 6.5 0.413043 8.2 0.261538 Trips per capita Trips per traveler Miles per traveler Miles per trip 2.5 2.7 1722.4 478.9 4.6 0.84 4.9 0.814815 3440.7 0.99762 807.7 0.686573 2.8 4.5 3217.9 804.5 4.7 5.7 4649.4 975.2 People who visit area Trips per traveler Miles per traveler Miles per trip 4.3 2226.3 591.2 5.8 0.348837 3300.4 0.48246 675.7 0.14293 4.5 3217.9 804.5 5.7 0.266667 4649.4 0.444855 975.2 0.212181 0.678571 0.266667 0.444855 0.212181 do "enhanced" graphic on 1st part and not why (your words) Origin States of People Who Visit Indiana and Destination States of People Who Live in Indiana (In thousands): 2016 State Illinois Ohio Kentucky Michigan Wisconsin Missouri Tennessee Pennsylvania Florida California Iowa Georgia Texas New York North Carolina New Jersey Minnesota Virginia Maryland West Virginia South Carolina Kansas Alabama Oklahoma Nebraska Arizona Massachusetts Arkansas Colorado Mississippi Connecticut Washington Louisiana New Mexico Oregon Nevada Delaware District of Columbia South Dakota Utah North Dakota Maine New Hampshire Hawaii Wyoming Idaho Montana Vermont Rhode Island Alaska Visiting Indiana From Indiana 3,423 2,781 2,596 2,331 1,576 2,015 1,143 2,416 520 315 434 692 339 831 332 349 286 1176 281 202 213 147 212 171 198 247 164 106 160 139 117 41 116 117 109 128 102 48 97 120 90 186 87 49 86 230 77 65 74 24 51 130 47 83 45 118 45 178 43 40 34 40 26 57 24 58 22 20 16 28 14 209 13 8 13 179 13 21 13 41 12 10 11 15 11 11 10 27 8 27 6 28 5 10 5 4 3 15 2 21 Travel Rates by Trip and Traveler Characteristics for Indiana: 2016 PEOPLE WHO LIVE IN AREA Means of transportation Personal use vehicle Commercial air Intercity bus Train Other Person trips (in Number of travelers Trips per thousands) (in thousands) traveler 23,715 5,732 Miles per Miles Miles (in millions) traveler per trip 4.5 16,869 3,066 748 20,508 2,614 28 32 533 23,714 5,364 1,455 29 24 357 7,229 3.2 2 1 1.4 1.6 9 11,335 5,120 16 29 370 16,870 2,220 3,695 592 1,239 1,091 8,837 581 2,059 615 920 729 4,904 4,523 9,519 6,136 3,538 1,149 3,430 3,015 1,785 4.3 3.1 2.2 2.2 3,355 5,780 5,783 1,951 3,069 1,771 2,016 1,149 779 638 990 580 Income Less than $25,000 $25,000 to $49,999 $50,000 or greater 2,866 7,842 13,007 1006 2,248 2,508 2.1 3.8 5.7 1,843 6,032 8,993 1,925 2,818 3,768 676 808 726 Age Less than 24 25 to 64 65 and over 5,413 16,350 1,953 1,792 3,484 494 3.3 5.1 4.3 3,682 11,382 1,805 2,159 3,432 3,839 716 731 971 Gender Male Female 13,445 10,270 2,950 2,795 4.9 4 9,076 7,792 3,232 2,929 710 797 PEOPLE WHO VISIT AREA 21,043 4,463 5.1 12,540 2,941 625 Means of transportation Personal use vehicle Commercial air Intercity bus Train Other 18,812 1,734 14 12 470 3,708 567 6 5 176 5.6 3.4 2.3 2.3 3 8,641 3,374 10 20 485 2,449 6,260 1,529 3,468 2,896 482 2,045 732 1,663 1085 5,064 8,263 4,029 3,686 1000 1,840 1,278 1004 5.6 4.9 3.5 4 3,215 5,205 2,022 2,087 3,380 2,972 1,662 2,186 667 661 527 595 Income Less than $25,000 $25,000 to $49,999 $50,000 or greater 2,808 6,940 11,292 630 1,526 2,229 4.8 4.9 5.6 1,810 3,844 6,876 3,017 2,646 3,241 677 582 640 Age Less than 24 25 to 64 65 and over 5,183 14,412 1,448 1,208 2,837 340 4.7 5.6 4.6 2,917 8,720 894 2,535 3,229 2,755 591 635 648 Gender Male Female 11,661 9,382 2,308 2,073 5.6 4.9 7,025 5,506 3,198 2,790 633 617 Main purpose Business Visit friends or relatives Leisure Other Main purpose Business Visit friends or relatives Leisure Other