Part -1:
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.
Part -2:
Steps To Success: Level 2
In these steps, you will work with the same consumer equipment purchasing data used to complete the Pie of Pic chart that Michelle worked on earlier. This data and the Pie of Pie chart are contained in the Excel workbook named Purchase.xlsx. You'll use this data to create a Bar of Pie chart. This same workbook contains detailed purchasing data broken out by age and gender for the following: footwear, camping, fitness, and golf. You'll use this data to create charts that illustrate the relationship between age and gender. The goal is to apply Tufte's principles to effectively present this quantitative information.
Complete the following:
1. Open the workbook named Purchases.xlsx in the Chapter 3 folder, and then save the file as Consumer Purchases.xlsx. Review the data sets on the six worksheets. You need to determine which chart sub-types covered in Level 2 will best illustrate the most important information in each worksheet.
2. The Pie of Pie worksheet contains the consumer purchase data organized by sport that Michelle used to create the Pie of Pie chart earlier. Use this data to create a Pie of Pie chart for the 2015 data. Place this chart on the same worksheet as the source data. Format the chart to look like the chart shown in Figure 3.24. Include the chart title 2015 Consumer Purchases by Sport on your chart.
3. Use the data found on the Purchases by Sport worksheet to create a Bar of Pie chart that illustrates the percentage contribution by each sport to the total purchase amount. Create one Bar of Pie chart for each year. Place the three charts on the same worksheet as the source data. Include a chart title and data labels for each chart that are similar to the ones you included in the Pie of Pie chart in Step 2.
4. The Footwear Purchases worksheet contains percentage data for footwear purchases organized by age groups and gender. The data also includes a breakout of the age and gender of the U.S. population by percentage. Create a clustered column chart, a stacked column chart, and a 100% stacked column chart to compare the purchases by different age groups each year with the U.S. population. Place the three charts on the same worksheet as the source data. Include appropriate titles and a legend in each chart. In a cell below each chart, explain what you think the chart illustrates.
5. The Camping Purchases worksheet contains percentage data for camping purchases organized by age groups and gender. The data also includes a breakout of the age and gender of the U.S. population by percentage. Create an area chart, a stacked area chart, and a 100% stacked area chart to compare the purchases by different age groups each year with the U.S. population. Place the three charts on the same work-sheet as the source data. Include appropriate titles and a legend in each chart. In a cell below each chart, explain what you think the chart illustrates.
6. The Fitness Purchases worksheet contains percentage data for fitness purchases orga-nized by age groups and gender. The data also includes a breakout of the age and gender of the U.S. population by percentage. Create a line chart, a stacked line chart, and a 100% stacked line chart to compare the purchases by different age groups each year with the U.S. population. Place the three charts on the same worksheet as the source data. Include appropriate titles and a legend in each chart. In a cell below each chart, explain what you think the chart illustrates.
7. The Golf Purchases worksheet contains percentage data for golf purchases organized by age groups and gender. The data also includes a breakout of the age and gender of the U.S. population by percentage. Create a doughnut chart and one other chart of your choice to compare the purchases by gender each year with the U.S. population. Place the two charts on the same worksheet as the source data. Include appropriate titles and a legend in each chart. In a cell below each chart, explain what you think the chart illustrates.
8. Save and close the Consumer Purchases.xlsx workbook.
Part -3:
Level 2 - Analyzing Stock Performance for Universal Investments
As an analyst at the Universal Investments financial company, you regularly monitor the performance of your clients' investments. You are preparing for a meeting with one of your investors to discuss how their stocks have performed over the last year and changes they should make to their portfolio. Your client has asked for information on four companies: Intel, AMD, Time Warner, and Wal-Mart. You will find daily stock price and volume information contained in the Invest.xlsx workbook.
Complete the following:
1. Open the workbook named Invest.xlsx located in the Chapter 3 folder, and then save the file as Investment Performance.xlsx.
2. Create a chart for each company using the appropriate stock chart sub-type. Be certain to use each chart sub-type only once.
3. Place each chart on a new sheet in the workbook.
4. On the Stock Comparison worksheet use the appropriate chart to compare the change in stock price for each company over the last year.
5. Using the information on the Portfolio worksheet, prepare the appropriate chart to display the relative contribution of each stock to the value of the portfolio.
6. Create an appropriate Combo chart on the Intel Summary worksheet that shows the daily closing price and volume data. Add a linear and a 30 day moving average trend line to the chart.
7. Save and close the Investment Performance.xlsx workbook.
Question 1:
1. PRACTICE what you learned in the first part by completing the Steps to Success: Level 1 exercise starting on page 176. The starting workbook: Trends.xlsx can be found in attachments
2. APPLY what you have learned to a new business marketing situation by completing the Level 1 Case Problem on page 209 of your textbook. The starting workbook Indiana.xksx can be found in attachments
3. Write a short essay on what you have learned in Level 1 and how you could apply this to other business situations.
Question 2:
1. PRACTICE what you learned in the first part by completing the Steps to Success: Level 2 exercise starting on page 195. The starting workbook: Purchases.xlsx can be found in attachments.
2. APPLY what you have learned to a new business marketing situation by completing the Level 2 Case Problem on page 209. The starting workbook Invest.xksx can be found in attachments
3. Write a short essay on what you have learned in Level 2 and how you could apply this to other business situations
Attachment:- Assignment.rar