Статистика

Use the data statistics in Calc to perform complex data analysis

Доступ к этой команде

From the menu bar:

Choose Data - Statistics.

From the tabbed interface:

Choose Data - Statistics.

On the Data menu of the Data tab, choose Statistics.

From toolbars:

Icon Statistics

Statistics


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.

Дисперсионный анализ (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

Регрессионный анализ

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

Парный t-критерий

Calculates the paired t-Test of two data samples.

F-критерий

Calculates the F-Test of two data samples.

Z-критерий

Calculates the z-Test of two data samples.

Критерий хи-квадрат

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.

Пожалуйста, поддержите нас!