You are comparing drug & alcohol programs for two different school districts to see which is more effective. Assume your programs are evaluated with scores of 1-10.
Design the research needed to perform a statistical analysis and perform the correct test (you will need to figure this out) in Excel. Assume you have a data set of 25 in each location. Submit the Excel worksheet and a word document explaining your design, what test you choose and why, and your results of your test. Explain which program you choose based on your results.
The tests you will choose from are t-Test (make sure to know which one if you choose this option), ANOVA, or Chi-square.
There are data generator sites you can find such as https://rlanders.net/dataset-generator/