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.

Provide the following descriptive statistics:

1. Measures of Central Tendency: Mean, Median, and Mode
2. Measures of Variation: Variance, Standard Deviation, and Range (a formula is not needed for Range).
3. Once the data is calculated, provide word analysis of the descriptive statistics on the spreadsheet. This should include differences and health outcomes between groups.

Answer:

The Descriptive Data Statistics for the given data table has been calculated by using Excel

Data > Data Analysis > Descriptive Statistics > OK > Select Input Range > Select Output Range > Select Summary Statistics > OK

The Description Data Statistics Includes (Image is attached)

1. Measures of Central Tendency: Mean, Median, and Mode
2. Measures of Variation: Variance, Standard Deviation, and Range (a formula is not needed for Range).

Discussion

The Mean of each data set indicates that the group Black (that's includes Hispanic) are mostly effective with cancer. Their rate per 100,000 individuals is highest almost 70. And the Asians/ Pacific Islander are least effective.

The range of the data in case of the same group Black (including Hispanic) is again largest within different years 2000-2015.

The standard deviation in the case of Asian group is least that shows that for the fifteen years (2000-2015), there was not much difference in the number of reported cases as compared to other groups, where again the group black tops among the other. The similar behavior is detected once we discuss the variance. 

Step-by-step explanation

Data Statistics

Discussion

• The Mean of each data set indicates that the group Black (that's includes Hispanic) are mostly effective with cancer. Their rate per 100,000 individuals is highest almost 70. And the Asians/ Pacific Islander are least effective.

• The range of the data in case of the same group Black (including Hispanic) is again largest within different years 2000-2015.

• The standard deviation in the case of Asian group is least that shows that for the fifteen years (2000-2015), there was not much difference in the number of reported cases as compared to other groups, where again the group black tops among the other. The similar behavior is detected once we discuss the variance.