Excel is a member of the Office of the Office, which is developed by Microsoft. It has a good operating interface, especially financial form processing, which is more special. At the same time, Excel also outputs a beautiful statistical graphics and various statistic forms. Under the guidance of the operation wizard, it can make a bar chart, an area map, a line chart, etc., more than 14 kinds. It is also easy to modify if the output graph is not satisfied. It is especially worth mentioning that it has hundreds of functions, while the statistical function has more than 70, and multiple statistical tasks can be completed. And always give an error message to help you complete the correct operation. Excel also comes with an Analysis Tool Library that uses it to better complete data processing (if there is no "Data Analysis" option in the Tools menu, you must install "Analyzware") in Microsoft Excel). The following only for several mean test methods used in medical studies, a brief introduction.
One. T test (application of TTEST function)
One. T test (application of TTEST function)
One. T test (application of TTEST function)
The result of the TTEST function call is to return the probability associated with the Student's-T test. Two samples can be judged from two overalls with the same mean. Includes pairing sample T test and independent sample T test.
1. Function call: Press insert → function to open the Paste Function dialog. Select the statistics in the Function Classification box (left box), and then select the TTEST function in the function name box (right box). In this way, the TTEST dialog box appears in the upper left corner of Excel, you can enter information. (To enter the data in the table) before the function call
2. Option:
1Array1 is the first data set. Array2 is the second data set. Numerical input method is: 1) Select the first dataset (first sample): After selecting data in the table, a flashing dashed line is displayed around the selected area, and as A1: A8 style appears in Array1. Value selection range (reference); 2) Select the second data set (second sample) method.
2tails indicate the mantissa of the distribution curve. If TAILS = 1, the function TTEST uses a single tail distribution. If TAILS = 2, the function TTEST uses a double tail distribution.
3TYPE is Type T test. 1 is a pair T inspection, 2 is an independent sample T test of the variance, and 3 is an independent sample T test.
3TYPE is Type T test. 1 is a pair T inspection, 2 is an independent sample T test of the variance, and 3 is an independent sample T test.
2tails indicate the mantissa of the distribution curve. If TAILS = 1, the function TTEST uses a single tail distribution. If TAILS = 2, the function TTEST uses a double tail distribution.
3TYPE is Type T test. 1 is a pair T inspection, 2 is an independent sample T test of the variance, and 3 is an independent sample T test.
3TYPE is Type T test. 1 is a pair T inspection, 2 is an independent sample T test of the variance, and 3 is an independent sample T test.
2. Option:
1Array1 is the first data set. Array2 is the second data set. Numerical input method is: 1) Select the first dataset (first sample): After selecting data in the table, a flashing dashed line is displayed around the selected area, and as A1: A8 style appears in Array1. Value selection range (reference); 2) Select the second data set (second sample) method. 2tails indicate the mantissa of the distribution curve. If TAILS = 1, the function TTEST uses a single tail distribution. If TAILS = 2, the function TTEST uses a double tail distribution.
3TYPE is Type T test. 1 is a pair T inspection, 2 is an independent sample T test of the variance, and 3 is an independent sample T test.
3TYPE is Type T test. 1 is a pair T inspection, 2 is an independent sample T test of the variance, and 3 is an independent sample T test.
2tails indicate the mantissa of the distribution curve. If TAILS = 1, the function TTEST uses a single tail distribution. If TAILS = 2, the function TTEST uses a double tail distribution.
3TYPE is Type T test. 1 is a pair T inspection, 2 is an independent sample T test of the variance, and 3 is an independent sample T test.
3TYPE is Type T test. 1 is a pair T inspection, 2 is an independent sample T test of the variance, and 3 is an independent sample T test.
2. Option:
1Array1 is the first data set. Array2 is the second data set. Numerical input method is: 1) Select the first dataset (first sample): After selecting data in the table, a flashing dashed line is displayed around the selected area, and as A1: A8 style appears in Array1. Value selection range (reference); 2) Select the second data set (second sample) method.
2tails indicate the mantissa of the distribution curve. If TAILS = 1, the function TTEST uses a single tail distribution. If TAILS = 2, the function TTEST uses a double tail distribution.
3TYPE is Type T test. 1 is a pair T inspection, 2 is an independent sample T test of the variance, and 3 is an independent sample T test.
3TYPE is Type T test. 1 is a pair T inspection, 2 is an independent sample T test of the variance, and 3 is an independent sample T test.
2tails indicate the mantissa of the distribution curve. If TAILS = 1, the function TTEST uses a single tail distribution. If TAILS = 2, the function TTEST uses a double tail distribution.
3TYPE is Type T test. 1 is a pair T inspection, 2 is an independent sample T test of the variance, and 3 is an independent sample T test.
3TYPE is Type T test. 1 is a pair T inspection, 2 is an independent sample T test of the variance, and 3 is an independent sample T test.
2tails indicate the mantissa of the distribution curve. If TAILS = 1, the function TTEST uses a single tail distribution. If TAILS = 2, the function TTEST uses a double tail distribution.
3TYPE is Type T test. 1 is a pair T inspection, 2 is an independent sample T test of the variance, and 3 is an independent sample T test.
3TYPE is Type T test. 1 is a pair T inspection, 2 is an independent sample T test of the variance, and 3 is an independent sample T test.
3TYPE is Type T test. 1 is a pair T inspection, 2 is an independent sample T test of the variance, and 3 is an independent sample T test.
3. Explanation: 1 If the number of data points of Array1 and Array2 is different, TYPE = 1 (pair), the function TTEST returns the error value # n / a. 2 If tails or type is non-numeric, the function TTEST returns the error value #Value! . 3 If TAILS is not 1 or 2, the function TTEST returns the error value #num! . 4. Application examples:
If 3, 4, 5, 8, 9, 1, 2, 4, 5 is input to the A1: A9 table, input 6, 19, 3, 2, 14, 4, 5, 17, 1 in the form of the B1: B9 table After the A10 table is selected, the TTest Function dialog box is called, and the A1: A9 is input in Array1 or select it in the table in the table. In Array 2, enter B1: B9 or use the mouse to select in the table. Enter 2 in tails. After entering 1 after Type, you can see the calculation result of the bottom of the dialog box.
two. variance analysis
Through simple variance analysis (ANOVA), the equal hypothesis test is performed for two or more sample mean (sample space with the same mean). This method is an expansion of a two mean inspection (such as T-test).
Through simple variance analysis (ANOVA), the equal hypothesis test is performed for two or more sample mean (sample space with the same mean). This method is an expansion of a two mean inspection (such as T-test).
two. variance analysis
Through simple variance analysis (ANOVA), the equal hypothesis test is performed for two or more sample mean (sample space with the same mean). This method is an expansion of a two mean inspection (such as T-test).
Through simple variance analysis (ANOVA), the equal hypothesis test is performed for two or more sample mean (sample space with the same mean). This method is an expansion of a two mean inspection (such as T-test).
two. variance analysis
Through simple variance analysis (ANOVA), the equal hypothesis test is performed for two or more sample mean (sample space with the same mean). This method is an expansion of a two mean inspection (such as T-test).
Through simple variance analysis (ANOVA), the equal hypothesis test is performed for two or more sample mean (sample space with the same mean). This method is an expansion of a two mean inspection (such as T-test).
Through simple variance analysis (ANOVA), the equal hypothesis test is performed for two or more sample mean (sample space with the same mean). This method is an expansion of a two mean inspection (such as T-test).
1. Function call: Press Tools → Analysis Tool, call up the Analysis Tools menu, point the difference analysis: Single factor variance analysis, press OK to adjust the single factor variance analysis dialog.
2. Option:
1 Enter area Enter the cell reference to the data area to be analyzed here. This reference must be composed of two or more adjacent data regions, or column or row.
2 Packet mode If you need to point out the data in the input area, it is arranged by the line or by column.
3 Sign is located in the first row / column If the entries in the first line of the input area contains the flag item, the "flag is located in the first line" check box; if the first column of the input area contains the flag item, the sign is located in the first Column check box; if the input area has no flag item, the checkbox will not be selected, Microsoft Excel will generate a suitable data flag in the output table (the first number in each column). 4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right. 7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
3 Sign is located in the first row / column If the entries in the first line of the input area contains the flag item, the "flag is located in the first line" check box; if the first column of the input area contains the flag item, the sign is located in the first Column check box; if the input area has no flag item, the checkbox will not be selected, Microsoft Excel will generate a suitable data flag in the output table (the first number in each column).
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook. 7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
2 Packet mode If you need to point out the data in the input area, it is arranged by the line or by column.
3 Sign is located in the first row / column If the entries in the first line of the input area contains the flag item, the "flag is located in the first line" check box; if the first column of the input area contains the flag item, the sign is located in the first Column check box; if the input area has no flag item, the checkbox will not be selected, Microsoft Excel will generate a suitable data flag in the output table (the first number in each column).
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information. 6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right. 7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
3 Sign is located in the first row / column If the entries in the first line of the input area contains the flag item, the "flag is located in the first line" check box; if the first column of the input area contains the flag item, the sign is located in the first Column check box; if the input area has no flag item, the checkbox will not be selected, Microsoft Excel will generate a suitable data flag in the output table (the first number in each column).
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability). 5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
1 Enter area Enter the cell reference to the data area to be analyzed here. This reference must be composed of two or more adjacent data regions, or column or row.
2 Packet mode If you need to point out the data in the input area, it is arranged by the line or by column.
3 Sign is located in the first row / column If the entries in the first line of the input area contains the flag item, the "flag is located in the first line" check box; if the first column of the input area contains the flag item, the sign is located in the first Column check box; if the input area has no flag item, the checkbox will not be selected, Microsoft Excel will generate a suitable data flag in the output table (the first number in each column).
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook. 6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right. 7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
3 Sign is located in the first row / column If the entries in the first line of the input area contains the flag item, the "flag is located in the first line" check box; if the first column of the input area contains the flag item, the sign is located in the first Column check box; if the input area has no flag item, the checkbox will not be selected, Microsoft Excel will generate a suitable data flag in the output table (the first number in each column).
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right. 7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
2 Packet mode If you need to point out the data in the input area, it is arranged by the line or by column.
3 Sign is located in the first row / column If the entries in the first line of the input area contains the flag item, the "flag is located in the first line" check box; if the first column of the input area contains the flag item, the sign is located in the first Column check box; if the input area has no flag item, the checkbox will not be selected, Microsoft Excel will generate a suitable data flag in the output table (the first number in each column).
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook. 5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
3 Sign is located in the first row / column If the entries in the first line of the input area contains the flag item, the "flag is located in the first line" check box; if the first column of the input area contains the flag item, the sign is located in the first Column check box; if the input area has no flag item, the checkbox will not be selected, Microsoft Excel will generate a suitable data flag in the output table (the first number in each column). 4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right. 7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
1 Enter area Enter the cell reference to the data area to be analyzed here. This reference must be composed of two or more adjacent data regions, or column or row.
2 Packet mode If you need to point out the data in the input area, it is arranged by the line or by column.
3 Sign is located in the first row / column If the entries in the first line of the input area contains the flag item, the "flag is located in the first line" check box; if the first column of the input area contains the flag item, the sign is located in the first Column check box; if the input area has no flag item, the checkbox will not be selected, Microsoft Excel will generate a suitable data flag in the output table (the first number in each column).
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right. 7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
3 Sign is located in the first row / column If the entries in the first line of the input area contains the flag item, the "flag is located in the first line" check box; if the first column of the input area contains the flag item, the sign is located in the first Column check box; if the input area has no flag item, the checkbox will not be selected, Microsoft Excel will generate a suitable data flag in the output table (the first number in each column).
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability). 5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information. 6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
2 Packet mode If you need to point out the data in the input area, it is arranged by the line or by column.
3 Sign is located in the first row / column If the entries in the first line of the input area contains the flag item, the "flag is located in the first line" check box; if the first column of the input area contains the flag item, the sign is located in the first Column check box; if the input area has no flag item, the checkbox will not be selected, Microsoft Excel will generate a suitable data flag in the output table (the first number in each column).
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right. 7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
3 Sign is located in the first row / column If the entries in the first line of the input area contains the flag item, the "flag is located in the first line" check box; if the first column of the input area contains the flag item, the sign is located in the first Column check box; if the input area has no flag item, the checkbox will not be selected, Microsoft Excel will generate a suitable data flag in the output table (the first number in each column).
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right. 7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook. 7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
2 Packet mode If you need to point out the data in the input area, it is arranged by the line or by column.
3 Sign is located in the first row / column If the entries in the first line of the input area contains the flag item, the "flag is located in the first line" check box; if the first column of the input area contains the flag item, the sign is located in the first Column check box; if the input area has no flag item, the checkbox will not be selected, Microsoft Excel will generate a suitable data flag in the output table (the first number in each column).
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information. 6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
3 Sign is located in the first row / column If the entries in the first line of the input area contains the flag item, the "flag is located in the first line" check box; if the first column of the input area contains the flag item, the sign is located in the first Column check box; if the input area has no flag item, the checkbox will not be selected, Microsoft Excel will generate a suitable data flag in the output table (the first number in each column).
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook. 7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook. 3 Sign is located in the first row / column If the entries in the first line of the input area contains the flag item, the "flag is located in the first line" check box; if the first column of the input area contains the flag item, the sign is located in the first Column check box; if the input area has no flag item, the checkbox will not be selected, Microsoft Excel will generate a suitable data flag in the output table (the first number in each column).
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook. 6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
4ALPHA inputs the inspection level of the F stat to critical value here. Alpha is a significant level of the Type I error in the probability of occurrence (discarding the probability).
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right. 7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
5 Output area In this input, the reference to the upper left upper left upper corner cell of the output table. When the output table overrides existing data, or the output table has passed the boundary of the worksheet, Microsoft Excel automatically determines the size of the output area and display information.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
6 New Worksheet Click this option to insert a new worksheet in the current workbook, and start the calculation result by the new worksheet A1 cell. If you need to name a new worksheet, type the name in the edit box on the right.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
7 New Workbook Click this option, you can create a new workbook and paste the calculation results in the new workbook.
3. Application examples
After entering the data in the format shown in Table, the ANOVA dialog box is selected as described above, in the input area or the input or select A1: D11, the group mode is column, the flag is located in the first line, alpha is 0.05, output options For the new worksheet group. The result is shown in the new Sheet, and three.
Table 1 data input
Table 1 data input
After entering the data in the format shown in Table, the ANOVA dialog box is selected as described above, in the input area or the input or select A1: D11, the group mode is column, the flag is located in the first line, alpha is 0.05, output options For the new worksheet group. The result is shown in the new Sheet, and three.
Table 1 data input
Table 1 data input
After entering the data in the format shown in Table, the ANOVA dialog box is selected as described above, in the input area or the input or select A1: D11, the group mode is column, the flag is located in the first line, alpha is 0.05, output options For the new worksheet group. The result is shown in the new Sheet, and three.
Table 1 data input
Table 1 data input
Table 1 data input
CD3CD4CD8CD4CD83420131.5383222151.4673723141.6433026122.1673617131.308321817173371017003625122.0833819151.267
Table 2 statistical description
Table 2 statistical description
Group gauges and average variance CD31034534.57.166667CD410202.57.166667CD41020220.213.51111CD81012812.82.51111CD81012812.82.51111CD81012812.82.51111CD81012812.82.51111CD81012812.82.51111CD81012812.82.62222222220.098403 Stochastic sectoral analysis is similar to single factor variance analysis, but to use pairing numbers as a column To analyze.
three. Linear regression
Linear regression is one of the relationship between one more independent variable (due to variable) and a set of independent variables (independent variables).
Table three variance analysis results
Linear regression is one of the relationship between one more independent variable (due to variable) and a set of independent variables (independent variables).
Table three variance analysis results
three. Linear regression
Linear regression is one of the relationship between one more independent variable (due to variable) and a set of independent variables (independent variables).
Table three variance analysis results
Linear regression is one of the relationship between one more independent variable (due to variable) and a set of independent variables (independent variables).
Table three variance analysis results
three. Linear regression
Linear regression is one of the relationship between one more independent variable (due to variable) and a set of independent variables (independent variables).
Table three variance analysis results
Linear regression is one of the relationship between one more independent variable (due to variable) and a set of independent variables (independent variables).
Table three variance analysis results
Linear regression is one of the relationship between one more independent variable (due to variable) and a set of independent variables (independent variables).
Table three variance analysis results
Difference SSDFMSFP-VALUEF CRIT group 5712.32131904.107325.51063.96E-262.866365.849601 total 5922.90639
1. Function call: Press Tools → Analyze Tools, call up the Analytical Tools menu, light up "regression", press to determine the regression dialog box.
2. Option:
1X, Y value input area: In this respectively, the reference to the argument and the variable data area is respectively, respectively. The area must be composed of single column data, respectively. 2 Sign: If the flag item is included in the first row of the input area, select this check box. 3 confidence: If you need additional confidence information in the summary output table, select this check box, then in the edit box on the right, enter the confidence to use. If it is 95%, it can be omitted. 4 constant is zero: mandatory return line through the origin. 5 Output area: In this input, the reference to the upper left upper corner cell of the output table is input. 6 New Worksheet: Click this option to insert a new worksheet in the current workbook, and start the calculation result by the A1 cell of the new worksheet. If you need to name a new worksheet, type the name in the Edit box. 7 New Workbook: Create a new workbook and paste the calculation results in the new worksheet in the new workbook. 8 Residual: View the residual in the form of residual output table. ⑨ Standard residual: The standard residual is included in the residual output table. Residual map: Draw each own variable and its residual. Line-shaped fitting: Generate a chart for predictive values and observations. Normal probability map: Draw a normal probability map.
1X, Y value input area: In this respectively, the reference to the argument and the variable data area is respectively, respectively. The area must be composed of single column data, respectively. 2 Sign: If the flag item is included in the first row of the input area, select this check box. 3 confidence: If you need additional confidence information in the summary output table, select this check box, then in the edit box on the right, enter the confidence to use. If it is 95%, it can be omitted. 4 constant is zero: mandatory return line through the origin. 5 Output area: In this input, the reference to the upper left upper corner cell of the output table is input. 6 New Worksheet: Click this option to insert a new worksheet in the current workbook, and start the calculation result by the A1 cell of the new worksheet. If you need to name a new worksheet, type the name in the Edit box. 7 New Workbook: Create a new workbook and paste the calculation results in the new worksheet in the new workbook. 8 Residual: View the residual in the form of residual output table. ⑨ Standard residual: The standard residual is included in the residual output table. Residual map: Draw each own variable and its residual. Line-shaped fitting: Generate a chart for predictive values and observations. Normal probability map: Draw a normal probability map. 1X, Y value input area: In this respectively, the reference to the argument and the variable data area is respectively, respectively. The area must be composed of single column data, respectively. 2 Sign: If the flag item is included in the first row of the input area, select this check box. 3 confidence: If you need additional confidence information in the summary output table, select this check box, then in the edit box on the right, enter the confidence to use. If it is 95%, it can be omitted. 4 constant is zero: mandatory return line through the origin. 5 Output area: In this input, the reference to the upper left upper corner cell of the output table is input. 6 New Worksheet: Click this option to insert a new worksheet in the current workbook, and start the calculation result by the A1 cell of the new worksheet. If you need to name a new worksheet, type the name in the Edit box. 7 New Workbook: Create a new workbook and paste the calculation results in the new worksheet in the new workbook. 8 Residual: View the residual in the form of residual output table. ⑨ Standard residual: The standard residual is included in the residual output table. Residual map: Draw each own variable and its residual. Line-shaped fitting: Generate a chart for predictive values and observations. Normal probability map: Draw a normal probability map.
3. Note: In the data analysis result, Intercept is the intercept, the value under Intercept is the regression coefficient of each variable (slope). The residual map is unregistered with 0 as a midline, and it is considered to be independent, and the results are independent, and the result is the linear function due to the variable observation. Points in the normal probability map If approximately in a straight line, the overall self-contained origin is indicated. (Due to limited space, it will be slightly exemplified)
Using Excel can also make a correlation coefficient, a covariance analysis, a description statistics, a smoothing index, and a double-mode-equiating F test, Fourier analysis, histogram, etc. Its basic operation is similar to the above analysis process, as long as the data input format is correct, it is generally possible to obtain accurate results.
