Descriptive Statistics

Calculate basic descriptive statistics, plot empirical distribution and/or conduct powerful significance tests using your data in Excel with a few clicks.

Descriptive statistics in NumXL

A Descriptive statistics is the discipline of quantitatively describing the main features of your dataset to learn about the population that the data are believed to represent. Descriptive statistics may be presented as either quantitative, i.e. summary statistics, or visual, i.e. simple-to-understand graphs. These summaries may form the basis of the initial description of data as part of a more extensive statistical analysis, or they are all that are necessary for your investigation.

NumXL comes with scores of functions to compute various summary statistics and to estimate empirical distribution functions, including Histogram, EDF and KDE. Furthermore, NumXL includes a wide range of statistical tests to verify the significance of the computed summary statistics.

Summary Statistics

Summary Statistics

Summarize your sample data to communicate key information (e.g. location, dispersion, distribution, etc.) of your data.

Empirical Distribution

Empirical Distribution

Estimate the frequency and cumulative distribution functions using your sample data.

Dispersion Measures

Dispersion Measures

Explore the variability (scatter or spread) of the values in your sample data.

Correlation

Correlation

Measures the strength (and the significance) of the relationship between two data sets.

Correlogram

Correlogram

Automate the statistical analysis of the serial correlation, model order identification, and exploring patterns in the your time series data.

Statistical significance

Statistical significance

Conduct statistical test of hypothesis to draw inferences (e.g. Normality, Stationary, Cointegration, etc.) about population from our sample data.