The following Excel formulae can be used to calculate the central tendency and variation of each group of Race/Ethnicity:

Medium: =AVERAGE (range), Median:=MEDIAN(range), Mode: =MODE[range] Variance:=VAR.P[range], Standard deviation:=STDEV.P[range] Range: Add the minimum and maximum values to the range.

After you’ve calculated the statistics for each group you can analyse the data and identify differences in the health outcomes. You could, for instance, look at the data and compare them to determine if any differences exist in their distribution. It is possible to also look at the standard deviation and variance in order to determine if certain groups have more or less variation.

Important to remember that descriptive statistics cannot be used alone to determine the causality of any group or give a comprehensive understanding of their health outcomes. To draw definitive conclusions, further research and analysis is required.