A correlation coefficient of -1 indicates a perfect negative correlation. You can use the CORREL function or the data statistics to find the correlation coefficient between two variables.Ī correlation coefficient of +1 indicates a perfect positive correlation.

The correlation coefficient (a value between -1 and +1) refers to how strongly two variables are related to each other. Rows per sample: Defines how many rows a sample has.Īn example and results are shown in Figure 3. Type: Selects if the analysis is for a single factor or for two-factor ANOVA.Īlpha: This is the level of significance of the test. Grouped by: Selects whether the input data has a columns or rows layout.

Results to: This refers to the top left cell of the range where the results are displayed. Input range: This refers to the range of the data to analyse. To perform ANOVA, choose Data > Statistics > Analysis of Variance (ANOVA). It is a collection of statistical models and their associated estimation procedures (such as the ‘variation’ among and between groups) used to analyse the differences among the group means in a sample. Once done, click ‘OK’ and you can see the desired output (Figure 1).įigure 6: Sample data set, exponential smoothing options and resultsĪNOVA is the acronym for Analysis Of Variance. Next, you have to specify the sampling method. This convention is followed for other methods also. In ‘Results’ too, you have to specify the column name and row ID (e.g., $E$1 means column E and Row 1). In the input range, you have to specify the source of the data by selecting the columns. Result: This refers to the top left cell of the range where the results are displayed. Input: This refers to the range of the data to analyse. The sampling can be random or periodical. Sampling allows you to pick data from a source table/row and to fill a target table/row. To perform sampling, choose Data -> Statistics ->Sampling. Period: This is the number of lines to skip periodically when sampling. Periodic: This method picks lines at a pace defined by Period. Sample size: This is the number of lines sampled from the source table. Random: Picks exact sample size lines of the source table randomly. Figure 2: Sample data, options of descriptive statistics and results

Libre calculator