memo, graphs and table, statistic
2021/3/10 Memo 2 Tables/Graphs for Feedback - OPTIONAL
https://seattleu.instructure.com/courses/1595282/assignments/6878050?module_item_id=17171148 1/2
This assignment does not count toward the final grade.
Memo 2 Tables/Graphs for Feedback - OPTIONAL
Due Feb 26 by 11:59pm Points 5 Submitting a file upload
Memo 2 Assignment Overview Statistical Analysis The goal of Memo #2 is to demonstrate your mastery of both descriptive and inferential statistics. You get to choose which dataset you'd like to work with and the variables that you want to explore. This memo (max 3 pages) will ask you to:
Choose one dataset from the following three to explore Choose 2-4 variables from that dataset that interest you (be sure to note the level of measurement of each) and describe them using the appropriate statistics Include at least one descriptive statistics table generated using pivot tables, following the best practices laid out in Week 3's in-class exercise. Create at least one graph to illustrate your findings (can be more if necessary!) Hypothesize a relationship between two of those variables that you have chosen - state your hypothesis in layman's terms very clearly in the piece. Even bold face or italicize it. Test the relationship using the appropriate inferential test and report the findings to a lay audience.
Data Sets Choose one and only one to work with for Memo 2:
Seattle Employee Demographics and Wages Documentation: https://data.seattle.gov/City-Business/City-of-Seattle-Staff- Demographics/5avq-r9hj (https://data.seattle.gov/City-Business/City-of-Seattle-Staff- Demographics/5avq-r9hj) Description: This dataset contains information about the demographics, wages, and employment status of all City of Seattle employees. The data has been anonymized.
Diversity Training Program Survey Revisit Nishishiba et al_Chapter 1 for more context on this (Emily's diversity training program)
California Schools - Academic Performance Index Data Documentation: https://r-survey.r-forge.r-project.org/survey/html/api.html (https://r-survey.r-forge.r-project.org/survey/html/api.html)
2021/3/10 Memo 2 Tables/Graphs for Feedback - OPTIONAL
https://seattleu.instructure.com/courses/1595282/assignments/6878050?module_item_id=17171148 2/2
Note that CA no longer uses the academic performance index to evaluate schools, so anything that you'd say in the memo would need to acknowledge that this is historical data. Still useful for explore certain relationships, though.
Deliverables for this part Word document containing all graphs, tables, and/or the results of your hypothesis tests that you want me to check on. No writing/prose needs to be done at this point, but your tables/graphs should be treated as if they were to go into the final assignment. Excel file used to create the above.