This technique expands on the tests for two means, such as the t-test. Performs two-factor anova that does not include more than one sampling per group. Correlation Measures the relationship between two data sets that are scaled to be independent of the unit of measurement. The population correlation calculation returns the covariance of two data sets divided by the product of their standard deviations. Covariance Returns the average of the product of deviations of data points from their respective means.
Covariance is a measure of the relationship between two ranges of data.
Covariance is sensitive to the unit of measure for X and Y. Two pairs of similarly related ranges of data yield different covariance values if the magnitude of the data points varies. Descriptive Statistics Generates a report of univariate statistics for data in the input range. This procedure provides information about the central tendency and variability of your data. The statistics in this table are a common starting point for further analysis and can indicate which tests are appropriate to explore next. Exponential Smoothing Predicts a value based on the forecast for the prior period, adjusted for the error in that prior forecast.