15 May For this discussion, you will plot datasets on a map using Excel. Respond to the following in a minimum of 175 words: Locate datasets available from the CDC ?(https://w
APA format
175 – 265 words
Cite at least two (2) peer reviewed references
Must cite CDC or NIH
Communicating information learned from data is often most effectively done by creating visual representations of the findings. For this discussion, you will plot datasets on a map using Excel.
Respond to the following in a minimum of 175 words:
- Locate datasets available from the CDC (https://www.cdc.gov/) or NIH (https://www.nih.gov/) Ensure your dataset includes location information. Use Microsoft Excel to plot your datasets.
- Review the “Plotting Data onto a Map in Microsoft Excel” (attached) document, as well as any web-based resources for instructions.
- Post your completed map with data points and provide a brief explanation of your analysis. Provide any tips you can share about your process for creating the visualizations that other members of your group can benefit from.
- Share any resources you found helpful to your process.
MHA/507 v3
Copyright 2021 by University of Phoenix. All rights reserved.
Plotting Data onto a Map in Microsoft® Excel® (Office 365) Step 1: Select the entire data set.
Step 2: Select the “3D Maps” icon located in the Insert tab. Select the “Open 3D Maps” option.
Plotting Data onto a Map in Microsoft Excel MHA/507 v3 Page 2 of 2
Copyright 2021 by University of Phoenix. All rights reserved.
Step 3: A new window will open with the data plots displayed on a map.
