Current location - Education and Training Encyclopedia - Graduation thesis - Beginners ask how to treat T value and P value, how to know the significance of each variable, and how to pass the T test.
Beginners ask how to treat T value and P value, how to know the significance of each variable, and how to pass the T test.
1. First, open the excel software, enter two groups of data to be compared, select any blank cell as the calculation cell of p value, and click the function fx above.

2. Select "Statistics" in the "Or Select Category" option in the Insert function interface.

3. Find "TTEST" in "Select Function" and click OK.

4. In the Function Parameters dialog box, click the identifier after the first set of data to select the data. After selecting the first set of data, select the parameter function and press Enter.

5. Repeat the above operation and select the second set of values. Choose 2 for mantissa and type, and click OK.

6. thus, the p value is obtained. If P < 0.0 1, there was significant difference between the two groups. If 0.0 1 < P < 0.05, there is significant difference between the two groups. If P > 0.05, there is no significant difference between the two groups.