Districts have access to the summary data for each group (sample size and mean), but not the entire data set of individual observations. The template would include multiple variables (e.g. comparison of groups by ethnicity and gender).

I *think* I can use an independent t-test for two populations for each variable (row in the workbook). I realize that some may suggest using ANOVA since there are multiple variables, but in this instance it is not necessary to compare between variables, just each variable to determine if there is a significant difference between Group B and Group A.

My questions are:

- Is it possible to test for significance only knowing the means and sample size of the two populations?
- If so, what is the best statistic to use for:
- Cases where the sample size will be large and we can assume normal distribution and equal variance; and
- Cases where the sample size will be small (<20) with no expectation of equal variance or normal distribution?

- Is it possible to do this in Excel? If so, could you please share with me how to set it up?