Anova and Correlation
There are different types of tools available in the Analysis Toolpak. While the computer will generally use the information that you provide to automatically pick the best macro-function for your data analysis, it will be helpful to you to know about the available tools. This article will give you an overview of Anova, Covariance, Descriptive Statistics and Exponential Smoothing. Future articles will give an overview of the remaining tools.
This tool is generally used for variance analysis. The Anova tool is broken down into three parts: Single Factor, Two-factor with Replication and Two-Factor without Replication.
The Single Factor is a simple statistical analysis of two or more samples. You can test an underlying probability distribution hypothesis against its alternative. If you simply need to test two samples, you can also use the TTEST function.
The Two-factor with Replication function is used for two-dimensional analysis. For example, if you want to test the bloom rate of a flower, you may give it different brands of fertilizer and keep them at different temperatures. For the six different possible combinations, you can keep track of how the flowers are doing.
The Two-factor without Replication can also be used for two-dimensional analysis, but you are only observing one single factor for each pair combination.
The Correlation uses the Correl and Pearson worksheet functions. These functions correlate the coefficient of two variables as measurements on taking measurements on a set of subjects. It’s best to use the Correlation analysis tool when each subject has more than two variables. When these calculations are outputted, you will get your output table plus a correlation matrix which will the value of the Correl in relation to each pair of variables.