T-test of paired sample mean using Excel

For the same population in different stages of sampling, can be seen from the two population samples, two samples of the same number, you can use the "paired sample mean value of T-Test", to verify that the mean has no significant difference.

This method is widely used in scientific research and is used to test the effectiveness of means.

Example: A manufacturer has developed a slimming tea, claiming to have a significant effect. In order to investigate its actual effect, 21 participants were randomly found, and the following table was used to record the data of weight before and after use.

Assuming this slimming tea has no effect

Using the T-Test:

Results Analysis:

p=0.00011<<0.05 does not support assumptions, so this diet pill may still be effective.

T-test of paired sample mean using Excel