Statistical Summary

The descriptive statistics functionality automates the statistical basis analysis of a time series and performs a variety of statistical tests to better understand the underlying distribution of a data sample.


To use this functionality, select the corresponding icon on the toolbar (or the menu item).

Click on the Summary Statistics icon in the NumXL tab.

Point to the data sample on your worksheet, select the different test and summary statistics and designate a location on your sheet to print the results to.

Dialog box of the Summary Statistics Wizard.

The descriptive statistics wizard performs a series of data validation checks. For instance, it ensures that a significance level is a positive number smaller than one.


Upon completion, the function outputs the selected statistical summaries and their corresponding tests as formulas (instead of raw numbers) in the designated location of your worksheet

Output table displaying the Summary Statistics results.

Tutorial Video


Please sign in to leave a comment.

Was this article helpful?
1 out of 1 found this helpful