Excel2013 How to T Check

The first step is to select the menu: Data Data analysis.

But your excel may not have this menu, so please open the hidden gate like this:

Menu File Options:

Select Add-ons

Select Analysis Toolkit:

OK, okay your hidden menu is out.

The second step is to select the t-test:

There are three kinds of t-tests, I don't know what the difference is, please advise if you know statistics.

- Find a little bit of information ---

There are three types of t-tests: independent-sample t-test, paired-sample t-test, and single-sample t-test, among which the former two are the most widely used in medical research. When performing data analysis, the appropriate t-test should be selected according to the type of experimental design.

If the experimental group and the control group were not paired, the independent sample t-test could be used to compare whether the difference between the two groups was statistically significant, provided that the conditions for the use of the independent sample t-test were met. If the experimental group and the control group are paired, the paired t-test should be used if the conditions for the use of the paired sample t-test are met. **In the process of writing, when explaining the statistical method, you should explain whether you use the independent samples t-test or the paired samples t-test, and should not invariably explain the statistical treatment as "using the t-test to compare two sets of data".

The third step is to determine the analysis parameters.

Step 4: Check the results:

The implementation method and detailed operation steps are as follows:

1. First of all, open Excel to enter data.

For example, the comparison between group A and group B data, as shown in the figure below, and then proceed to the next step.

2. Secondly, after completing the above steps, enter [=] in the space and then insert the function [t-test], as shown in the following figure, and then enter the next step.

3. Then, after completing the above steps, "array1" selects the data of group A, "array2" selects the data of group B, and then enters "2" in "rails" and "type", as shown in the following figure, and then proceeds to the next step.

4. Then, after completing the above steps, click the [OK] button to perform the t-test analysis as shown in the figure below, and then proceed to the next step.

5. Finally, after completing the above steps, analyze the results if p

There is a significant difference, and if p <, there is a very significant difference, as shown in the figure below. In this way, the problem is solved.

1. First of all, we choose to open Excel to input data, such as group A data and group B data for comparison.

2. Select the keyboard to enter [=] in the space and insert the function [t-test]. Hui Chong.

3. Array1 selects group A data, Array2 selects group B data, and tracks and enters input 2.

4. After that, select the [OK] option to perform the t-test analysis function.

5. As a result of the analysis of repentance, if there is a significant difference in p ", then if there is a very significant difference in p ".