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
0 kommentar(er)
