Like z-tests,Â t-testsÂ are calculations used to test a hypothesis, but they are most useful when we need to determine if there is a statistically significant difference between two independent sample groups.Â In this article we will look at T.TEST in Excel.
A t-test asks whether a difference between the means of two groups is unlikely to have occurred because of random chance. Usually, t-tests are most appropriate when dealing with problems with a limited sample size (nÂ < 30).
Now you might think that comparing the averages are easy, but averages are affected by outliers and can give misleading results. You may also have situations where the sample and population sizes are different. Â Lets say you have a drug for the flu, and patients that take it get better on average in 3 days, and patients that donâ��t get better on average 5 days.Â The T. Test can be used to see if this difference if by fluke or because of the drug.
Another Example would be to test to see if the change in sales are down to a successful marketing campaign or if the change in sales happened by chance.
Our table of data represents the age of
Posted from my blog with SteemPress : http://theexcelclub.com/how-use-excel-t-test-was-a-marketing-campaign-successful/