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.

Question

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.

Quizplus · Accepted Answer

The Answer of 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.

The Data on the Percentage of Visitors in the Previous