The following free data set options have graphical representations of the data. Download and analyze the dataset below.
Data Set:
Option 1 – https://data.cityofchicago.org/
N.B. From the Chicago Data Portal, you have to select one of the categories in the data catalog and then choose a dataset where you will create a visualization from the data presented using Excel, R, or Tableau to analyze.
Choose Excel, R, or Tableau to analyze your data. Click the link below to access tutorials for each tool from LinkedIn:
Learning Excel: Data Analysis: 2. Visualize Data
https://www.linkedin.com/learning-login/share?forceAccount=false&redirect=https%3A%2F%2Fwww.linkedin.com%2Flearning%2Flearning-excel-data-analysis%3Ftrk%3Dshare_ent_url&account=2245842
Integrating Tableau and R for Data Sciences
https://www.linkedin.com/checkpoint/enterprise/login/2245842?pathWildcard=2245842&application=learning&redirect=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fintegrating-tableau-and-r-for-data-science%3Fu%3D2245842
(free download included)
Write a 4-page paper answering the following questions:
1. What tool did you use to analyze the data and why? Tool options are listed on the websites, including Excel, R, and Tableau. Was the tool appropriate for the analysis of the selected data?
2. Use the software to provide high level views of the data in tabular and graphical form. Use the Help Options on the tool or refer to the Tutorials from Lynda.com
3. Describe the data. Is it structured or unstructured?
4. Apply the results as the organizational data analyst. What does the data tell us? Who should use the data?
5. How would you communicate your findings to your manager?
Writing Guidelines:
Assignment should follow APA guidelines with respect to use of subheadings, 1″ margins, and double-spaced.
Page length requirements for the assignment exclude the title page and the reference page. References need to include 4 credible academic references. All sources used must be referenced; paraphrased and quoted material must have accompanying citations and cited per APA guidelines.