Summary and Descriptive Statistics
Analysis of the Descriptive Statistics
| American Indian / Alaska Native (includes Hispanic) | Asian / Pacific Islander (includes Hispanic) | Black (includes Hispanic) | Hispanic (any race) | White (includes Hispanic) | |
| Year of Diagnosis | Rate per 100,000 | Rate per 100,000 | Rate per 100,000 | Rate per 100,000 | Rate per 100,000 |
| 2000 | 45.7 | 41.8 | 77.8 | 34.2 | 68.8 |
| 2001 | 47.9 | 41 | 79 | 34.1 | 68.7 |
| 2002 | 44.6 | 40.4 | 75.8 | 34.1 | 68 |
| 2003 | 50 | 40.9 | 77.3 | 34.5 | 67.1 |
| 2004 | 51.7 | 40.5 | 75.1 | 35 | 65.8 |
| 2005 | 48.7 | 40.2 | 73.7 | 33.8 | 65.9 |
| 2006 | 46.4 | 39.8 | 73.4 | 32 | 65.8 |
| 2007 | 43.1 | 38.8 | 71.2 | 32.7 | 65.2 |
| 2008 | 45 | 38.5 | 70.8 | 32.2 | 63.9 |
| 2009 | 40.1 | 39 | 71.6 | 31.8 | 63.1 |
| 2010 | 42.4 | 37 | 67.8 | 30.3 | 60.4 |
| 2011 | 39.6 | 36.6 | 64.1 | 29.4 | 58.5 |
| 2012 | 36.6 | 36.7 | 64.3 | 28.2 | 57.5 |
| 2013 | 39.9 | 36.6 | 60.5 | 28.8 | 56.3 |
| 2014 | 32 | 34 | 61.3 | 26.8 | 55.4 |
| 2015 | 38.7 | 34.4 | 57.4 | 26 | 53.2 |
| Measures of Central Tendency | |||||
| Mean | 43.275 | 38.5125 | 70.06875 | 31.49375 | 62.725 |
| Median | 43.85 | 38.9 | 71.4 | 32.1 | 64.55 |
| Mode | #N/A | 36.6 | #N/A | 34.1 | 65.8 |
| Measures of Variation | |||||
| Variance | 27.71933333 | 5.679833333 | 45.42895833 | 8.399291667 | 26.162 |
| Standard Deviation | 5.264915321 | 2.383240091 | 6.740100766 | 2.898153148 | 5.114880253 |
| Maximum | 51.7 | 41.8 | 79 | 35 | 68.8 |
| Minimum | 32 | 34 | 57.4 | 26 | 53.2 |
| Range | 19.7 | 7.8 | 21.6 | 9 | 15.6 |
The data shows that between 2000 and 2015, the rate of lung and bronchus cancer per 100,000 individuals was prevalent among Blacks (including Hispanics), with a mean of 70.1% (SD = 6.7) and a median of 71.4%. A high variance for this group (45.4%) also indicates that the risk of African Americans being diagnosed with lung and bronchus cancer is high.
Whites (including Hispanics) at a Mean of 62.7%, a Median of 64.6 and an SD of 5.1 have the second-highest prevalence rate, followed by American Indian/Alaska Natives (Mean = 43.3 %; Median = 43.9 and SD = 5.3), and Asian/Pacific Islander (Mean = 38.5%; Median = 38.9; SD = 2.4). Hispanics have the lowest prevalence rate at a Mean of 31.5 %, a Median of 32.1, and a Standard Deviation of 2.9.
Based on the variance values, it is also clear that the risk of suffering from lung and bronchus cancer is high in the African American population (45.4%), followed by American Indian/Alaska Native (27.7%), whites (26.2%), Hispanics (8.4%), and lowest in the Asian/Pacific Islander (5.7%).
References
National Cancer Institute (2018) Lung and bronchus cancer. Retrieved from January 8, 2019 from https://seer.cancer.gov/explorer/application.php?site=47&data_type=1&graph_type=2&compareBy=race&chk_sex_1=1&chk_race_5=5&chk_race_4=4&chk_race_3=3&chk_race_6=6&chk_race_2=2&chk_age_range_1=1&chk_data_type_1=1&advopt_precision=1&advopt_display=1&showDataFor=sex_1_and_age_range_1_and_data_type_1
ORDER A PLAGIARISM-FREE PAPER HERE
We’ll write everything from scratch
Question 
Summary and Descriptive Statistics
There is often the requirement to evaluate descriptive statistics for data within the organization or for health care information. Every year the National Cancer Institute collects and publishes data based on patient demographics. Understanding differences between the groups based upon the collected data often informs health care professionals towards research, treatment options, or patient education.
Using the data on the “National Cancer Institute Data” Excel spreadsheet, calculate the descriptive statistics indicated below for each of the Race/Ethnicity groups. Refer to your textbook and the Topic Materials, as needed, for assistance in with creating Excel formulas.
Summary and Descriptive Statistics
Provide the following descriptive statistics:
- Measures of Central Tendency: Mean, Median, and Mode
- Measures of Variation: Variance, Standard Deviation, and Range (a formula is not needed for Range).
- Once the data is calculated, provide a 150-250 word analysis of the descriptive statistics on the spreadsheet.
- This should include differences and health outcomes between groups.
APA style is not required, but solid academic writing is expected.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are not required to submit this assignment to LopesWrite.