Data Using Data Visualization For this activity, you are going to continue to use the Population Health Excel File used in Phase 2. Follow the step-by-step instructions below to visually represent the population health data.

Instructions for Presenting Data Using Data Visualization For this activity, you are going to continue to use the Population Health Excel File used in Phase 2. Follow the step-by-step instructions below to visually represent the population health data. BACKGROUND Data visualization refers to techniques used to communicate data or information using visual techniques such as charts, graphs, maps, dashboards and other types of graphical representations. It is a type of data analysis that communicates information clearly and efficiently and provides an accessible way to see and understand trends, outliers, and patterns in data. Just as you learned in your data analysis activity, you must have numerical data to create various types of data visualizations and the data must be in a format that supports the visualization technique you are using. Each type of data visualization has a different purpose, and several commonly used charts that can be created in excel are described below: ●Column Charts- presents the frequency distribution of data using vertical columns. For example, the Primary Care MD availability in a county. ●Bar Charts- presents the frequency distribution of data using horizontal rectangular bars. Bar charts and column charts are very similar, but bar charts are better to use when your labels are long. The bars can be reordered to help present increasing or decreasing frequencies. For example, the frequency of injuries by county. ●Line Charts- used to display continuous data. For example, Access to Exercise by county. ●Scatter Charts – used to display the relationship between two variables, also called a scatter plot. For example, a children’s growth chart shows height vs. weight or the % of Adult smoking & Rural health grant eligibility. ●Pie Charts- displays proportional segments of a whole (100%). Use when you have five or fewer segments and the total adds up to 100%. For example, the % of age groups. ●Treemap Charts-presents the relative size of two or more items and is organized hierarchically. For example, comparison of the population size of different counties. GETTING STARTED Watch the Getting Startedin Data Visualizationvideo for additional support in this section: https://wgu.hosted.panopto.com/Panopto/Pages/Sessions/List.aspx?folderID=574269cd-59ab-4d3d-a74d- b00b00e97553