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.
1. Measures of Central Tendency: Mean, Median, and Mode
Mean: The mean is arrived by adding up the above numbers and diving the sum of those
numbers. It is the average of the above numbers. In the excel format: add an equal sign, = then
, Start typing average on the box, the select the boxes of the numbers you intend to calculate then
enter.
Mean for American Indian/Alaska =AVERAGE (B3:B18) is 43.2125. (Rate per 100,000)
Mean for Asian/ Pacific Islander =AVERAGE (C3:C18) is 38.1. (Rate per 100,000)
Mean for Black =AVERAGE (D3:D18) is 70.06875. (Rate per 100,000)
Mean for Hispanic =AVERAGE (E3:E18) is 31.49375. (Rate per 100,000)
Median: Median is the middle value in a group of numbers. If the median comes in between
even numbers, then it is arrived at by finding the average of the two values. In Excel format, it is
arrived at by using the Median function. Start by typing the median function in the box after an
equal sign, select the values then enter.
Median for American Indian/Alaska =MEDIAN (B3:B18) is. 43.85. (Rate per 100,000)
Median for Asian/Pacific Islander =MEDIAN (C3:C18) is 38.9. (Rate per 100,000)
Median for Black =MEDIAN (D3:D18) is 71.4. (Rate per 100,000)
Median for Hispanic =MEDIAN (E3:E18) is 32.1. (Rate per 100,000)
Mode: Mode is the most frequently occurring value in the dataset. In the excel format after an
equal sign, type Mode, select the values then enter. However, if the mode two or more modes
occur, the Excel mode will select the lowest mode.
Mode for American Indian/Alaska =MODE (B3:B18). #N/A. There is no frequently occurring
value in this Race/Ethnic group.
Mode for Asian/Pacific Islander =MODE (C3:C18) is 36.6. (Rate per 100,000)
Mode for Black =MODE (D3:D18). #N/A. There is no frequently occurring value in this
Race/Ethnic group.
Mode for Hispanic =MODE (E3:E18) is 34.1. (Rate per 100,000)
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.
1. Measures of Central Tendency: Mean, Median, and Mode
Mean: The mean is arrived by adding up the above numbers and diving the sum of those
numbers. It is the average of the above numbers. In the excel format: add an equal sign, = then
, Start typing average on the box, the select the boxes of the numbers you intend to calculate then
enter.
Mean for American Indian/Alaska =AVERAGE (B3:B18) is 43.2125. (Rate per 100,000)
Mean for Asian/ Pacific Islander =AVERAGE (C3:C18) is 38.1. (Rate per 100,000)
Mean for Black =AVERAGE (D3:D18) is 70.06875. (Rate per 100,000)
Mean for Hispanic =AVERAGE (E3:E18) is 31.49375. (Rate per 100,000)
Median: Median is the middle value in a group of numbers. If the median comes in between
even numbers, then it is arrived at by finding the average of the two values. In Excel format, it is
arrived at by using the Median function. Start by typing the median function in the box after an
equal sign, select the values then enter.
Median for American Indian/Alaska =MEDIAN (B3:B18) is. 43.85. (Rate per 100,000)
Median for Asian/Pacific Islander =MEDIAN (C3:C18) is 38.9. (Rate per 100,000)
Median for Black =MEDIAN (D3:D18) is 71.4. (Rate per 100,000)
Median for Hispanic =MEDIAN (E3:E18) is 32.1. (Rate per 100,000)
Mode: Mode is the most frequently occurring value in the dataset. In the excel format after an
equal sign, type Mode, select the values then enter. However, if the mode two or more modes
occur, the Excel mode will select the lowest mode.
Mode for American Indian/Alaska =MODE (B3:B18). #N/A. There is no frequently occurring
value in this Race/Ethnic group.
Mode for Asian/Pacific Islander =MODE (C3:C18) is 36.6. (Rate per 100,000)
Mode for Black =MODE (D3:D18). #N/A. There is no frequently occurring value in this
Race/Ethnic group.
Mode for Hispanic =MODE (E3:E18) is 34.1. (Rate per 100,000)
