Data analysis tools package contains various tools for statistical data analysis, random number generation and data sampling. To use these tools select the ``Data Analysis...'' entry in the ``Tools'' menu. This gives you a list of tools to choose from. Select one of the tools from the list and press the OK button. The tools are described below.
All the tools have the same output options. The results can be printed out into a new sheet, into a new workbook, or into the same sheet within a given output range. To select the output method just select one of the radio buttons bellow the ``Output options:'' label. Note that if the output is pasted into a range that is too small, some of the results will not fit in it. Also not that the old data in the output range is lost.
Use this tool to make a single factor analysis of the variances of given variables. The variables are specified by the ``Input Range:'' entry. The given range can be groupped either by columns or by rows. ``Alpha:'' entry specifies the level of significance which is by default 95%.
If you have labels, for example the names of the variables, in the first row of the given range, you should check the ``Labels'' button on. This leaves the first row (or the first column if the data is groupped by rows) of the input range out of the analysis. In addition, the names of the variables are pasted nicely into the output table.
The tool calculates the source of variation between groups, within groups, and the total source of variation. The values of these are given in the ''SS'' column. The degrees of freedom of are given in the ''df'' column. In ''MS'' column the sources of variation are divided by the degrees of freedom. The results of these divisions are used in calculating the F value in the ''F'' column. The F value is the division of MS in ''Between columns'' and ''MS'' in ''Within columns''. You can compare this value with the ''F critical'' value in the last column. The F critical value is the largest value of F that is statistically significant using the given significance level (''Alpha''). Bellow the ''P-value'' is the result of the F-test.
In addition, the tool calculates the count, sum, average, and the variance of all the variables.
The correlation tool calculates correlation coefficients of given variables. Use this tool to calculate any number of correlation coefficients at the same time. The variables for which the correlations are calulated are specified by the ``Input Range:'' entry. The given range can be groupped either by columns or by rows.
For example, you want to calculate the correlation between two variables, one in a column A and the other