For this assignment you will explore different ways to visualize data using the Charts function in Excel.
Step 1: Choose a dataset from the provided resources and open the data file in Excel.
ATTACHED- Publically Availiable Datasets Researcher Guide 2018
DATA & STATISTICS
https://www.fbi.gov/how-we-can-help-you/more-fbi-services-and-information/ucr
https://www.bls.gov/
https://nces.ed.gov/
https://data.census.gov/
https://healthdata.gov/
https://www.cdc.gov/nchs/index.htm
Step 2: Once the dataset is imported into Excel, you will need to create four different charts (for example, a pie chart, bar chart, etc.) from a subset of data. You can choose different subsets of data for the charts, however at least two have to be from the same subset of data with the same variables. So either four from one subset or two each from two subsets of data.
Step 3: Write a paper comparing the four charts you have created. Use a screenshot or copy and paste function within excel to put the chart into your document. Copy and label each chart in a word document and then address the following questions.
- What dataset did you choose?
- Which variables did you choose for your charts?
- Which charts did you choose, and why?
- Which chart best represents the data, and why?
- Are there enough responses to illustrate the results? How do you know?
- Are you getting useful results? What else do you want to know? Is the dataset equipped to answer those followup questions?
- Where else could you get data (in either better quantity or of better quality) to answer the questions
- There are times that you need to make a decision in research that compromises either quality of the data or quantity. Why does this matter and when would one make the decision to sacrifice one or the other? (Use at least one outside source in answering this question as support for your reasons behind compromising data quality or quantity. Be sure to cite using APA formatting.)
Minimum Submission Requirements
- Proper notification of any resubmission, repurposing, or reworking of prior work per the Purdue Global Student Coursework Resubmission, Repurposing, and Reworking Policy Resource.
- Your assignment should be 2-3 pages with a minimum of 300 words (not including the title and reference pages), and should include the following elements:
- Title Page: Provide the assignment title, your name, course and section number, instructor name, and date.
- Body: Include an introductory and a concluding paragraph. Answer all the questions in complete sentences and paragraphs, using appropriate personal and professional insights.
- The assignment must be written in Standard English and demonstrate superior organization, including a highly developed viewpoint and purpose that is clearly established and sustained. The communication of your thoughts must be highly ordered, logical, and unified, displaying exceptional content, organization, style, and mechanics (including the use of correct grammar, punctuation, and sentence structure).
- Your responses should meet professional writing standards, using proper tone and language. The writing and writing style should be correct and accurate and reflect knowledge of environmental justice and sustainability.
- Reference Page: Sources listed in APA format.
- You will need to cite the dataset you use for this assignment.
- Use Arial or Times New Roman 12-point font, double-spaced and left-aligned.
- Use standard 1″ margins on all sides.
- Use current APA formatting and citation style.