Excel File Edit View Insert Format Tools Data Window Help 8 9 8 0 Wed Sep 14 11:50 AM AutoSave OFF SA_5_data_cdc Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert v Calibri (Body) v 12 A A E ab v General X Delete v Find & Analyze Sensitivity Paste Sort & BIUV DVAv $ ~ % 9 Conditional Format Cell Formatting as Table Styles Format v D Filter Select Data M2 X V fx =CORREL(12:141, L2:L41) A B E G H K M N O P Q R S 1 Sex Race State Ethnicity Age Group First Year Last Year Cause of Death Age in Years Deaths Population Crude Rate 2 Both Sexes All Races United States Both Ages 0 to 3 2010 2014 Homicide Non-Firearm 0 1381 19714696 7 0.16182033+ Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 680 19815208 3.43 0.52479672 4 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 472 20000975 2.36 0.70053639 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 293 20204480 1.45 0.79926433 170 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 20298478 0.84 0.83657464 VOUAWN 7 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 107 20407337 0.52 0.84452897 8 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 76 20517825 0.37 0.84100708 9 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 53 2046239 0.26 0.83207954 10 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 8 63 20409480 0.31 0.81858555 11 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 41 20459636 0.2 0.80319386 12 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 10 48 20544986 0.23 0.78237122 13 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 11 50 20602442 0.24 0.75744387 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 12 39 20668527 0.19 0.7270049 |14 15 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 13 39 20769540 0.19 0.68888968 16 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 14 62 20815748 0.3 0.64149842 17 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 15 90 20859697 0.43 0.5813632 18 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 16 .37 21067413 0.65 0.50164441 9 Both Sexes All Races States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 17 204 21381700 0.95 0.38797015 20 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 18 288 21786540 1.32 0.21400315 21 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 19 353 22254143 1.59 -0.0241961 22 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 20 397 22549614 1.76 -0.292082 23 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 21 432 22655889 1.91 -0.5548318 4 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 22 495 22590147 2.19 - 0.7498845 5 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 23 507 22323190 2.27 -0.7566936 26 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 24 480 22012591 2.18 -0.7255456 27 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 25 457 21693540 2.11 -0.7256217 28 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 26 515 21475775 2.4 -0.7711727 29 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 27 445 21433174 2.08 -0.7036558 30 Both Sexes All Races United State Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 28 448 21401029 2.09 -0.7486291 31 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 29 479 21392114 2.24 - 0.7912786 32 Both Sexes All Races United States Both Ages 0 to 39 2010 2014 Homicide Non-Firearm 30 446 21356127 2.09 -0.7217503 33 Both Sexes All Races United States Both Ages ( to 39 2010 2014 Homicide Non-Firearm 31 478 71162691 2.02 -0.7307967 results-2 100% Pri Ready Count: 40 Student Support am currently grading the literature reviews for this week. Overall, a good job done in the content. That said, I urge you all to look at the website above Tern Resources and see the APA formatting. There were numerous errors in formating (missing page numbers, websites in the in-text citations, reference pages that Show All X results.csvChrome File Edit View History Bookmarks Profiles Tab Window Help G 8 Q Wed Sep 14 11:23 AM Content b Home | bartleby X WISQARS Injury Mortality Repo x + C eku.blackboard.com/ultra/courses/_313753_1/cl/outline GMDA IS Update : Student Support Resources X EKU Library Guide (EMC) CDC Data: Safe Assignment 5 (SA 5) Safe Assignment 5: CDC data on 2010-2014 males and females APA 7th Ed. (web guide) In this assignment, you will use information from the CDC website to obtain information on the following data categories listed below. The SafeAssign Process 1. Go to the CDC website using the link provided. Blackboard Tutorials 2. Indicate you "Agree" to the Data Use Restrictions. (Button is at the bottom of that page.) 8 3. Choose the "Report Options" using the data categories listed below, then choose "Submit Request" to obtain a copy of your report. 4. Submit your report to the Safe Assignment link provided above for Module 5. bartleby Go to this CDC Injury Prevention and Control webiste to access the injury data: http://webappa.cdc.gov/saswebcipc/dataRestriction_inj.html Blackboard Help for . homicide Students . non-firearm . U.S Blackboard Tools (all races, both sexes and all Hispanic; standard output; age groups 0-4 through 35-39) . 2000 as standard year output 1 as ages Download file into EXCEL (Review Chapter 11 presentation on statistics package) . calculate descriptive statistics for crude rate of deaths of the entire group in the download (this is the sample) - paste this to the worksheet that has your data if you created it on a "new worksheet" . select an empty cell on the worksheet that has the data from the CDC and the summary statistics . enter the formula to calculate the correlation between the ages and the crude rates (this will indicate the level of relationship between the two sets of numbers) the formula is =CORREL(arrary1,array1); you will highlight each set of numbers as array 1 (the ages) and array 2 (the crude rates) respectively . Excel will perform the math for you correlations range from 0 (the weakest) to 1 the absolute strongest You will need to upload a single worksheet (and keep a copy for yourself so that you can answer questions about this data later. Submit your report in formats as indicated on the syllabus. Remember to review the Safe Assignment Checklist before submitting. SA_5_Data AV Priva Attached Files: SA_5_data_cdc.xIsx (46.568 KB) Tern The CDC fatal injury site is down today. Below is a pdf of the data. results.csv Show All X