The data on the percentage of visitors in the previous and current years at 12 well-known national parks of the United States are given below. National Parks Percentage of visitors previous year Percentage of visitors current year
The Smokies 78.2% 84.2%
The Grand Canyon 83.5% 81.6%
Theodore Roosevelt 81.6% 84.8%
Yosemite 74.2% 78.4%
Yellowstone 77.9% 76.2%
Olympic 86.4% 88.6%
The Colorado Rockies 84.3% 85.4%
Zion 76.7% 78.9%
The Grand Tetons 84.6% 87.8%
Cuyahoga Valley 85.1% 86.7%
Acadia 79.2% 82.6%
Shenandoah 72.9% 79.2%
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 parks 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.