The Data on the Percentage of Visitors in the Previous

The data on the percentage of visitors in the previous and current years at 12 well-known national parks of Unites States are given below:

a. Sort the parks in descending order by their current year's visitor percentage. Which park has the highest number of visitors in the current year? Which park has the lowest number of visitors in the current year?
b. Calculate the change in visitor percentage from the previous to the current year for each park. Use Excel's conditional formatting to highlight the park whose visitor percentage decreased from the previous year to the current year.
c. Use Excel's conditional formatting tool to create data bars for the change in visitor percentage from the previous year to the current year for each park calculated in part b.

Correct Answer:

Verified

a. The sorted list of parks for the curr...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

View Full Answer For Free