Lack of Access to Improved Drinking Water. Improved drinking water sources are defined as drinking water sources that are protected from outside contamination. According to the World Health Organization, 663 million people around the world lack access to sources of improved drinking water, which puts them at high risk for infection and illness. The bar chart below shows the number of people in each region that are estimated by the World Health Organization to lack access to improved drinking water sources.LO 2

1. Source: Data from World Health Organization:https://apps.who.int/iris/bitstream/handle/10665/177752/9789241509145_eng.pdf;jsessionid=D7AEF25BD6C2002814352BD93FCD5607?sequence=1

Which of the following suggestions would improve this chart in terms of helping the audience empathize with the data? (Select all that are appropriate.)

Add a picture showing people who lack access to improved drinking water sources.

Color each bar differently to use more excitement for the audience.

Use a dot matrix chart instead of a bar chart to give the audience a better understanding of the magnitudes of these numerical values.

Use a pie chart instead of a bar chart because pie charts use more empathy than bar charts due to use of preattentive attribute of shape.

Use a three-dimensional (3D) bar chart because the depth dimension of a 3D chart moves an audience to feel more empathy.

Lack of Access to Improved Drinking Water (Revisited). In this problem, we revisit the chart shown inProblem 12showing the number of people without access to improved drinking water sources by region.LO 4,7

Approximately 663 million people do not have access to improved drinking water sources around the world. Add a BAN to the bar chart in the fileDrinkingWaterChartso that the total number of people in the world who do not have access to improved drinking water sources is emphasized in this chart.

To help use empathy with the data for the audience, use a dot matrix chart to represent the data in the fileDrinkingWaterChart. Use= 1 million people for your dot matrix chart. (Hint:To represent 663 million people who lack access to improved drinking water resources, you will need a matrix that contains 663. You can use this by using amatrix and then adding an additional partial row of 13.)

Differentiate the colors of thebased on the region of the world. Include a legend on your modified dot matrix chart.

The population of the United States is approximately 330 million people. To help give the audience an even better sense of scale for the number of people around the world who lack access to improved drinking water, use the Gestalt principle of enclosure by using theFill Colorfunction in Excel to shade the cells containing the number ofthat correspond to the population of the United States and label this on your chart.