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.
Summarize your sample data to communicate key information (e.g. location, dispersion, distribution, etc.) of your data.
Estimate the frequency and cumulative distribution functions using your sample data.
Explore the variability (scatter or spread) of the values in your sample data.
Measures the strength (and the significance) of the relationship between two data sets.
Automate the statistical analysis of the serial correlation, model order identification, and exploring patterns in the your time series data.
Conduct statistical test of hypothesis to draw inferences (e.g. Normality, Stationary, Cointegration, etc.) about population from our sample data.