Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 average 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 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Financial Accounting

Authors: Richard Lewis, David Pendrill

7th Edition

0273658492, 978-0273658498

More Books

Students also viewed these Finance questions

Question

What are some of the topics studied?

Answered: 1 week ago

Question

1. Maintain my own perspective and my opinions

Answered: 1 week ago