There is often the requirement to evaluate descriptive statistics for data within the organization...

Question

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:

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 XXXXXXXXXXword 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 LopesWrites

hlt-362v-rs5-nationalcancerinstitutedata-df4hbeki.xlsx

Suraj · Accepted Answer

Descriptive Statistics Analysis
We have the data for “National cancer institute data”. The data is collected from year 2000 to 2015. Our aim is to calculate the descriptive statistics for the different groups of race or ethnicity. In the descriptive statistics we need to calculate both the central tendency and the variability. In central tendency we will calculate the mean, the median and the mode. In the variability we will calculate the variance, the standard deviation and the range.
The mean is calculated by taking sum of all the observations for a particular group and divided by the total number of observations. The median is the middle value for a set of values. The mode is the term which comes most frequently in a set of values.
Here, in the data set there are five groups of the race and those are listed as follows:
1. American Indian / Alaska native
2. Asian / pacific islander
3. Black (includes Hispanic)
4. Hispanic (any race)
5. White (includes Hispanic)
The scale of measurement for each group is 100, 000 per value. That means that for 45 value in a particular variable the value is taken as 45, 00000. The central tendency is calculated for all the different groups by using the help of MS-Excel. The output is given as follows:
	Group
	Mean
	Median
	Mode
	American Indian / Alaska Native (includes Hispanic)
	43.27
	43.85
	NA
	Asian / Pacific Islander (includes Hispanic)
	38.51
	38.9
	36.6
	Black (includes Hispanic)
	70.07
	71.4
	NA
	Hispanic (any race)
	31.49
	32.1
	34.

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...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment