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.

Descriptive Statistics

Fill a table in the spreadsheet with the main statistical properties of the data set.

Analysis of Variance (ANOVA)

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.

Exponential Smoothing

Results in a smoothed data series

Moving Average

Calculates the moving average of a time series

Regression Analysis

Performs linear, logarithmic, or power regression analysis of a data set comprising one dependent variable and multiple independent variables.

Paired t-test

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.

Chi-square test

Calculates the Chi-square test of a data sample.

Fourier Analysis

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.

Please support us!