Using the data on the “National Cancer Institute Data” Excel spreadsheet, calculate the descriptive statistics indicated below for each of the Race/Ethnicity groups.
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:
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 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.
Answer:
Formulas for computations are
Here N=16 which is even
Range=Maximum-Minimum
| American/Alaska Native | |
| Mean | 43.275 |
| Standard error | 1.31622883 |
| Median | 43.85 |
| Mode | #N/A |
| Standard Deviation | 5.264915321 |
| Sample Variance | 27.71933333 |
| Kurtosis | -0.136660029 |
| Skewness | -0.383344382 |
| Range | 19.7 |
| Minimum | 32 |
| Maximum | 51.7 |
| Sum | 692.4 |
| Count | 16 |
Interpretation: From descriptive statistics we say that in America/Native Alaska region Mean rate for Lung and bronchus cancer overall the last 16 years is 43.275 per 100 with standard deviation 5.26 per 100 , Variance 27.71 per 100 with maximum number of cases approx. 52
| Asian/Pacific Islander | |
| Mean | 38.5125 |
| Standard Error | 0.595810023 |
| Median | 38.9 |
| Mode | 36.6 |
| Standard Deviation | 2.383240091 |
| Sample Variance | 5.679833333 |
| Kurtosis | -0.712232536 |
| Skewness | -0.555307749 |
| Range | 7.8 |
| Minimum | 34 |
| Maximum | 41.8 |
| Sum | 616.2 |
| Count | 16 |
Interpretation: From descriptive statistics we say that in Asian/Pacific Islander region Mean rate for Lung and bronchus cancer overall the last 16 years is 38.51 per 100 with standard deviation 2.38 per 100 , Variance 5.67 per 100 with maximum number of cases approx. 42.
| Black (Includes Hispanic) | |
| Mean | 70.06875 |
| Standard Error | 1.685025 |
| Median | 71.4 |
| Mode | #N/A |
| Standard Deviation | 6.740101 |
| Sample Variance | 45.42896 |
| Kurtosis | -0.94965 |
| Skewness | -0.50796 |
| Range | 21.6 |
| Minimum | 57.4 |
| Maximum | 79 |
| Sum | 1121.1 |
| Count | 16 |
Interpretation: From descriptive statistics we say that in white (includes Hispanic) region Mean rate for Lung and bronchus cancer overall the last 16 years is 70.06 per 100 with standard deviation 6.74 per 100 , Variance 45.42 per 100 with maximum number of cases approx. 79.
| Hispanic (Any Race) | |
| Mean | 31.49375 |
| Standard Error | 0.724538287 |
| Median | 32.1 |
| Mode | 34.1 |
| Standard Deviation | 2.898153148 |
| Sample Variance | 8.399291667 |
| Kurtosis | -0.88797923 |
| Skewness | -0.611418136 |
| Range | 9 |
| Minimum | 26 |
| Maximum | 35 |
| Sum | 503.9 |
| Count | 16 |
Interpretation: From descriptive statistics we say that in Hispanic(Any Race)region Mean rate for Lung and bronchus cancer overall the last 16 years is 31.49 per 100 with standard deviation 2.89 per 100 , Variance 8.39 per 100 with maximum number of cases approx. 26.
| White (Includes Hispanic) | |
| Mean | 62.725 |
| Standard Error | 1.278720063 |
| Median | 64.55 |
| Mode | 65.8 |
| Standard Error | 5.114880253 |
| Sample Variance | 26.162 |
| Kurtosis | -1.087933179 |
| Skewness | -0.55685628 |
| Range | 15.6 |
| Minimum | 53.2 |
| Maximum | 68.8 |
| Sum | 1003.6 |
| Count | 16 |
Interpretation: From descriptive statistics we say that in white (includes Hispanic) region Mean rate for Lung and bronchus cancer overall the last 16 years is 62.725 per 100 with standard deviation 5.11 per 100 , Variance 26.16 per 100 with maximum number of cases approx. 68.8.
Conclusion: Form the descriptive statistics We can say that the region Black(Includes Hispanic) has highest number of cases over the last 16 years with the greatest mean rates of cases among all regions and white (includes Hispanic) comes on second number then American/Native Alaska, Asian/Pacific Islander and Hispanic (Any Race) in decreasing order has the cases of Lung cancer.
