Use the data statistics in Calc to perform complex data analysis
To work on a complex statistical or engineering analysis, you can save steps and time by using Calc Data Statistics. You provide the data and parameters for each analysis, and the set of tools uses the appropriate statistical or engineering functions to calculate and display the results in an output table.
Create a table with data sampled from another table.
Fill a table in the spreadsheet with the main statistical properties of the data set.
Produces the analysis of variance (ANOVA) of a given data set
Calculates the correlation of two sets of numeric data.
Calculates the covariance of two sets of numeric data.
Results in a smoothed data series
Calculates the moving average of a time series
Performs linear, logarithmic, or power regression analysis of a data set comprising one dependent variable and multiple independent variables.
Calculates the paired t-Test of two data samples.
Calculates the F-Test of two data samples.
Calculates the z-Test of two data samples.
Calculates the Chi-square test of a data sample.
Produces the Fourier analysis of a data set by computing the Discrete Fourier Transform (DFT) of an input array of complex numbers using a couple of Fast Fourier Transform (FFT) algorithms.