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 with creating Excel formulas.
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 160 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.
|American Indian / Alaska Native (includes Hispanic)||Asian / Pacific Islander (includes Hispanic)||Black (includes Hispanic)||Hispanic (any race)||White (includes Hispanic)||National Cancer Institute (2018) Lung and bronchus cancer. Retrieved from Janary 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|
|Year of Diagnosis||Rate per 100,000||Rate per 100,000||Rate per 100,000||Rate per 100,000||Rate per 100,000|