Original link:tecdat.cn/?p=16745

Original source:Tuo End number according to the tribe public number

 

Excel provides many data analysis tools, can be accessed through the analysis of the data analysis > |.

If you do not see this option, you may need to install the Excel analysis kit first. This is by selecting the Office button options > > Excel the Excel add-in or starting from the Excel version of Excel file in help | > options > load, and then click the “go to” button at the bottom of the window. Next, select the Analysis Tool Library option in the dialog box that appears, and then click ok. You will then be able to access data analysis tools.

Choose data > | data analysis, will figure 1 dialog.

Figure 1 – Data analysis dialog box

You can now select any of the following options that are useful for statistical analysis:

  • Analysis of variance: univariate
  • Analysis of variance: Two factors with repeatability
  • Analysis of variance: two factors without duplication
  • The correlation
  • covariance
  • Descriptive statistics
  • Exponential smoothing
  • F test: Two samples of variance
  • histogram
  • Random number generation
  • Rankings and percentiles
  • Return to the
  • The sampling
  • T-test: Two samples are paired
  • T test: Two samples with equal variance
  • T test: Two samples assuming unequal variances
  • Z test: Two samples of the mean

Each of these options represents a data analysis tool that will be described on this site. Now assume, as an example, that you choose Anova: Single Factor. The dialog shown in Figure 2 will now display.

Figure 2 – AnOVA dialog box: Single factor options

The input range includes those in which the data elements to be analyzed are stored in Excel scope. For example, suppose this data consists of a 4×8 array representing four processing approaches, as shown in Figure 3.

Figure 3 – Sample input range

In this case, insert the range B2: E9 into the Enter Range field (in the Dialog box in Figure 2), and then select the Columns radio button. If you assign a name to the range B2: E9 (for example, Study1), you can put that name in the Input Range field instead of B2: E9.

Alternatively, you can insert B1: E9 in the Input Range field, and then select the Label in First Row check box in the dialog box to indicate that you have included column headings in the data range. Note that the participant number (in column A) is not used.

If you list processed data in rows instead of columns, you can select the Row radio button, as well as the Labels in Column 1 check box.

The alpha value (in the zero-sum substitution tests described) is set to 0.05 by default, although it can optionally be changed to 0.01 or some other value.

You can now select the New Working Surface radio button from the Output option (and leave the data fields blank). In this case, a new worksheet is created (in the TAB that precedes the current worksheet) and the ANOVA report is placed on this worksheet, starting with cell A1. You can then copy the results to the current worksheet (or wherever else you like).

Alternatively, you can select the Output Range or New Workbook radio button to place the report in a particular output range or new workbook of your choice.

Most welcome insight

1.R language multiple Logistic Logistic regression application case

2. Panel smooth transfer regression (PSTR) analysis case implementation

3. Partial least squares regression (PLSR) and principal component regression (PCR) in MATLAB

4.R language Poisson regression model analysis cases

5. Hosmer-lemeshow goodness of fit test in R language regression

6. Implementation of LASSO regression, Ridge regression and Elastic Net model in R language

7. Realize Logistic Logistic regression in R language

8. Python predicts stock prices using linear regression

9. How to calculate IDI and NRI indices for R language in survival analysis and Cox regression