Graph Aids Exercise

For each of these, first decide what type of graph would best represent it. Then create the graph in either Excel or Word. Excel tends to be easier to work with, and you can copy and paste from it into Word, or you can simply create them in Excel and submit them.

The total prevalence of diabetes in people in the United States by percentage is 2% for people ages 20-39; 10% for ages 40-59; and 18% for those over 60.

The total SEC investor contacts by fiscal year for 2018, 2019, 2020, 2021, and 2022 are broken into three categories: complaints & questions; other contacts and totals. For 2018, the total was 82, 337. About 70, 000 were complaints & questions, and 12,000 were other contacts. For 2019, the total was 70, 574. About 59, 000 were complaints & questions, and 11,000 were other contacts. For 2020, the total was 73481. About 59,000 were complaints & questions, and 13,000 were other contacts. For 2021, the total was 78,221. About 69,000 were complaints & questions, and 8000 were other contacts. For 2022, the total was 77274. About 70,000 were complaints & questions, and 9000 were other contacts.

The seasonal average 8-hour ozone trends in Yosemite National Park, California, were 70, 000 parts per billion for 2017, 60,000 parts per billion for 2018, 75,000 parts per billion for 2019, 59,000 parts per billion for 2020; and 63,000 parts per billion for 2021.

Corporate expenses for 2022 were 44% for salaries; 22% for research; 10% for communication; 8% for administration; and 16% for production.

Create a flow chart to illustrate a simple process. In Excel, click on "Insert." Look for "SmartArt" in the "Illustrations" section. Click to access various templates