# Excel

CompetencyFormulate and evaluate hypothesis tests for population parameters based on sample statistics using both Critical Regions and P-Values, and be able to state results in a non-technical way that can be understood by consumers of the data instead of statisticians.Dealing with Two PopulationsInferential statistics involves forming conclusions about a population parameter. We do so by constructing confidence intervals and testing claims about a population mean and other statistics. Typically, these methods deal with a sample from one population. We can extend the methods to situations involving two populations (and there are many such applications). This deliverable looks at two scenarios.Concept being StudiedYour focus is on hypothesis tests and confidence intervals for two populations using two samples, some of which are independent and some of which are dependent. These concepts are an extension of hypothesis testing and confidence intervals which use statistics from one sample to make conclusions about population parameters.What to SubmitYour research, calculations, and analysis should be presented on thespreadsheet provided.14/05/202015mathematics