As a travel industry consultant, you have been working for the state of Indiana

Question

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 in trips per Traveler and Miles per traveler of the average Indiana resident, the average U.S. resident, and the avarege Indiana visitor. (Hint: create the charts for Indiana and Indiana Visitors first, and then add the data for U.S using the Select Data source dialog box. (Hint: Delete the "=(1)" value in the series values box before selecting the U.S. data) 3. Create a bar chart to illustrate a state-by-state comparison of the number of residents from the rest of the nation who visit Indiana, and the number of Indiana residents who visit other states. Rank the information in this chart by the states with the most visitors to Indiana. 4. The Indiana Department of Tourism is very interested in learning more about how people travel to Indiana. They want to use this information to better target advertising to specific demographic groups and methods of travel. Use the appropriate chart or series of charts illustrate how people travel; the purpose of their travel; and their income levels, age, and gender. This information should be presented for people who live within the state and those visiting the state with a comparison between the two groups. 5. Save and close the Indiana Travel.xlsx workbook. Travel Characteristics Origin States Travel Rates Travel Characteristics for Indiana and the United States: 2006 and 2016 Indiana United States Percent 2006 change Percent change 2006 2016 2016 People who live in area 73.8 Trips per household Trips per traveling household 86.1 5.3 7.3 16.7% 6.0% 4.3% 81.7 4.6 6.5 94.3 6.5 8.2 15.4% 41.3% 26.2% Trips per capita Trips per traveler Miles per traveler Miles per trip 2.5 2.7 1722.4 478.9 4.6 4.9 3,441 807.7 84.0% 81.5% 99.8% 68.7% 2.8 4.5 3,218 804.5 4.7 5.7 4,649 975.2 679% 26.7% 44.5% 21.2% People who visit area Trips per traveler Miles per traveler Miles per trip 4.3 2,226 591.2 5.8 3,300 675.7 34.9% 48.2% 14.3% 4.5 3,218 804.5 5.7 4,649 975.2 26.7% 44.5% 21.2%

Explanation / Answer

Hi,

Request you to kindly upload the attachment (Travel.xlsx).

Regards,

Amit Ojha

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.