Take a moment to review the details of this assignment below and gather any necessary files. Once you\’re ready to submit your assignment, move on to Step 2.
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 Resources, as needed, for assistance in 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 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.
Expert Answer and Explanation
|American Indian / Alaska Native (includes Hispanic)||Asian / Pacific Islander (includes Hispanic)||Black (includes Hispanic)||Hispanic (any race)||White (includes Hispanic)|
|Rate per 100,000||Rate per 100,000||Rate per 100,000||Rate per 100,000||Rate per 100,000|
|Measures of central tendency||Mean||43.275||38.5125||70.06875||31.49375||62.725|
|Measures of variance||Variance||25.986875||5.32484375||42.58964844||7.874335938||24.526875|
|Summary of data|
|The descriptive analysis presented was done on data collected by the National Cancer Institute indicating the revalance of lung and bronchus cancer in the United States. The data was collected from 2000 to 2015. The analysis is presented in summary as follows; The first analysis was measures of central tendency. There were three measures that were used, that is mean, mode and median. The analysis indicated that Blacks (include Hispanics) had the highest mean in terms of the number of lung and bronchus cancer with a mean of 70.06875. They were followed by Whites (includes Hispanics) with a mean of 62.725. The group with the lowest mean of lung and bronchus cancer were Hispanics who had an average of 31.49375. The calculated median for lung and bronchus cancer for the indicated period for each population groups were as follows; American Indian / Alaska Native (includes Hispanic) 43.85, Asian / Pacific Islander (includes Hispanic) 38.9. For Blacks (includes Hispanic), the median was 71.4, Hispanic (any race) had a median of 32.1, and the Whites (includes Hispanic) had a median of 64.55.
In the analysis of variance, Blacks (includes Hispanics) were noted to have the highest variance of 42.58965, followed by American Indian / Alaska Native (includes Hispanic) with a variance of 25.986875. The lowest variance was from the Asian / Pacific Islander (includes Hispanic) with a variance of 5.32484375. Since standard deviation (SD) represents the squre root of variance, the trend was similar as was in variance across the different racial/ethnic groups. The widest range was also noted from Black population (includes Hispanics) at 22.4. The smallest range was recorded among the Asian / Pacific Islanders (Includes Hispanics) with a range of 7.8.
Other Answered Questions: