The dataset displays information about rate of lung and bronchus cancer diagnosis. The rate is per 100,000 people of different races and spans a duration of 15 years from 2000 to 2015. The dataset incorporates a total of 5 races which include American Indian/Alaska natives, Asian/Pacific Islanders, Blacks, Hispanics and Whites. An analysis is done that aims to derive crucial information from this dataset. Measures of central tendency; mean, median and mode as well as measures of dispersion or variation; variance, standard deviation and range are all calculated.
From the calculations done on the excel sheet, the means for the rate of diagnosis among Alaska natives, Asians, Blacks, Hispanics and whites were found to be 43.28, 38.51, 70.07, 31.49 and 62.73 respectively. The medians, on the other hand were 43.85, 38.90, 71.40, 32.1 and 64.55. Only Asians, Hispanics and Whites had modes which were 36.6, 34.1 and 65.8. From these calculations, we see that blacks had a higher average rate of diagnosis while the Hispanics had the lowest average rate for the 15-year period. Moreover, some races had instances where the rate of diagnosis was same in different years these races are Asian Islanders, Hispanics and Whites.
Delegate your assignment to our experts and they will do the rest.
When it comes to measures of variation, the variance, standard deviation and range were measured for all the races. The variance is the mean of the square of differences between the individual rates and the mean rates of each variable. The standard deviation is the square root of the variances while the range is the difference between the maximum and the minimum rate of each race variable. The measures of variation are shown on excel sheet. Blacks have the highest variance at 45.43 indicating that the individual variables are distant to the mean rate while Asians have the lowest variance at 5.68 indicating that the individual yearly rates are close to each other and to the mean. The standard deviation is the square root of each variance and therefore is directly proportional to the variance. Lastly, Asians had the lowest range of 7.8 further supporting the variance and indicating closeness between the highest and lowest rates while the blacks had the highest range of 21.6 indicating how distant the highest and the lowest rates are from each other.
