Visually displaying data is an important part of research. Graphs and charts are often used to visually show how data differs from one another. For this assignment, you will create a data dashboard containing epidemiology data. A data dashboard is a management tool that visually tracks, analyzes, and displays metrics and key data through the use of graphs and diagrams. See the sample of a dashboard below.
For some visual examples of dashboards, follow/click the following link: https://www.pinterest.com/pin/134122895137302166/?lp=true
For this assignment, use the following link to download the Microsoft (MS) Excel file of World Health Statistics Health Status – Mortality:
The data presented shows the mortality rates by gender and country. Select two countries to compare with the United States and create the following in MS Excel:
- A bar graph comparison of the United States and your two selected countries using the Life Expectancy at Birth by gender (columns F & G).
- A pie graph comparison using the Healthy life expectancy by gender (columns H & I).
- A scatter graph comparison using the Probability of dying per 1000 population between 15 and 60 years by gender (columns J & K).
- A 2-D graph comparison using the Probability of dying per 1000 live births by years 2003 and 2000 (columns L & M).
Once you have completed the four graphs, provide a brief explanation (4-6 sentences) of what each graph is depicting. The explanation should not only identify the X- and Y-axis, but also provide a detailed explanation of the data. For example:
“Observed in the Life Expectancy at Birth by gender bar graph, the United States has a significant higher life expectancy for both males and females when compared to Angola and Ghana. This can be attributed to insignificant access to healthcare services in unindustrialized countries, as noted by Robinson (2018).”
For full credit, submit an MS Word file (containing your explanations) and an MS Excel file (containing the dashboard).
Note: The best way to complete this assignment is to “hide/sort” the columns and rows that will not be used in the graphical comparison.
SLP Assignment Expectations
- Conduct additional research to gather sufficient information to support the explanation.
This fear pushed the American government to call a war that lasted more than a decade entitled “The War on Terror” to put a stop to terrorist groups in the Middle East and those responsible for the 9/11 attacks. The war persists today and has now become the longest in U.S. history and also one of the deadliest, as thousands of young men and women have been killed. Although troops were pulled from Iraq, many still reside in Afghanistan and are still fighting in this endless war. Due to the bloody, aimless war commenced by the Bush administration, many people also started to feel distrust towards to U.S. Government and its military. Many people went from feeling patriotic and ready to serve to feeling weary of the Government’s actions in the Middle East. The war has been questioned by many popular films, disturbing documentaries and enlightening articles throughout the years. Michael Moore’s “Fahrenheit 9/11” film is the most notable example of a film dismantling the Bush Administration and its War on Terror. The most memorable sequence in this eye-opening documentary depicts Lila Lipscomb, an incredibly patriotic woman with an American flag hanging in her front-yard and a strong support of the Army. However, when her son is shot down while in a Black Hawk helicopter serving in the war, her entire outlook on the conflict changes. This feeling is heightened when she receives his final letter written before his death stating that Bush’s war is pointless. Lipscomb’s change of heart serves as the emotional core of the film and represents America as a whole turning on Bush and the War on Terror. Another documentary dispelling the war in the Middle East is the disturbing “Dirty Wars” film by Richard Rowley and Jeremy Scahill. The film shows the aftermath of many questionable U.S. army operations that lead to several civilian casualties and the destruction of many homes. The most memorable sequence covers the assassination of Anwar al-Awlaki. After disapproving of America’s attacks on civilians, he became a terrorist. Not only is he assassinated, but so is his innocent 16-year old son. He is not killed because of the crimes he committed, but the crimes he may commit in the future after being raised by a radicalized terrorist. This realization disturbs Scahill and causes him to really question the lengths the American army is willing to go to put a stop to terrorism. The film flips the narrative on the >GET ANSWER