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

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.