### Data Summary and Presentations

**Summary.xlsx.**

The more typical descriptive statistical measures: number of data, arithmetic mean, mode, variance, standard error, skewness, kurtosis, quartiles, maximum and minimum are computed.

**Frequency-Table.xlsx**

The same descriptive measures as in Summary.xlsx are computed, but for variables classified in a frequency table.

**Bar-Pie.xlsx**

An easy way to plot a bar and a pie charts.

**Histogram.xlsx**

Setting an anchor point (a bit lower than the minimum of the sample) and an interval width (the template helps the user computing the integer part of \(\sqrt{n} \)

(being n the number of data), that can be used to fix the number of intervals and, therefore, the binwidth.

**Boxplot.xlsx**

Up to four boxplots for different variables can be created.

**Regression-Line.xlsx**

The regression line of Y over X is computed, along with the coefficient R².

**Two-Way-Table.xlsx**

When we have a bidimensional variable in a two-way table format, some different measures are calculated (arithmetic means, variances, covariance and linear correlation), and also the two regression lines (Y over X, and X over Y).

**Contingency-Table.xlsx**

For a two-way table, considering that the different values correspond to qualitative variables, some associate measures are calculated:

-chi-square χ²,

-Yule’s \(Q\) for \(2\times 2\) tables,

-the contingency coefficient \( C=\sqrt{\frac{\chi ^{2}}{\chi ^{2}+N}}\) where χ² is derived from Pearson’s chi-squared test, and\(N\) is the grand total of observations

-the Cramer’s \(V\), given by

\(V= \sqrt{\frac{\chi ^{2}}{N(k-1)}}\), with \(k\) being the number of rows or the number of columns.

### Random variables

**Discr-RV-Moment.xlsx**

For a discrete random variable (described by their values and probabilities), the expectation, variance, standard deviation, Pearson’s coefficient of variation, and the coefficient of skewness and kurtosis are computed.

**Binomial-Dist.xlsx**

Computes the probability’s law and distribution function, the expectation and standard deviation of the binomial random variable. A bar chart with the probability function is also shown.

**Poisson-Dist.xlsx**

The same information as in the previous template is presented here, but for the Poisson distribution.

**Negative-Binomial-Dist.xlsx**

Similar template to the previous for the case of the negative binomial distribution.

**Hypergeometric-Dist.xlsx**

Similar template to the previous considering the hypergeometric distribution.

**Exponential-Dist.xlsx**

Considering a exponential distribution, the expectation and variance are computed, and the corresponding density function is drawn. The user can compute probabilities between two values (or probabilities greater or lower than a particular point) and quantiles.

**Normal-Dist.xlsx**

The same information as in the previous template is presented here, but for a Gaussian random variable.

**T-Dist.xlsx**

Similar template to the previous one, but for the case of a t-student distribution.

**Chi-Dist.xlsx**

This template works as the previous one in the case of χ² distribution.

**F-Dist.xlsx**

The same information is displayed here, but considering a F-distribution.

**Distr-Tables.xlsx**

It gathers all the considered discrete and continuous random variables in the same spreadsheet, allowing to compute probabilities in points (values of the corresponding densitiy for continuous variables), areas between points or quantiles.

**Inter-Gauss.xlsx,**

**Inter-Area-Gauss.xlsx**

The user can explore the Gaussian curve in an interactive fashion. In the first case, the graph contains interactive buttons that allows the comparison of a normal density with different values for the mean and/or the variance with the standard N(0,1) variable. In the second case, the user can learn about the symmetry of the normal density function, by moving the buttons and computing areas under the curve.

### Confidence Intervals

**CI-Mean-Variance.xlsx**

For one sample, we can compute the confidence interval for the mean (considering the variance known or unknown) and for the variance (considering the mean known or unknown). In both cases, we can write directly the data in the first column, as well as computing the intervals from summary values (sample size and sample mean, or sample variance).

**CI-Mean-Diff.xlsx**

Confidence intervals for the difference between two means, and for the ratio of variances of two normal variables.

**CI-Proportions.xlsx**

Confidence intervals for a sample proportion, or the difference between two sample proportions.

### Hypothesis testing

**Mean-Test.xlsx**

(Unilateral or bilateral) test about the mean of a normal random variable (where the variance can be known or unknown).

**Variance-Test.xlsx**

Test about the populational variance (or the standard deviation) of a normal random variable (with the mean known or unknown).

**Mean-Diff-Test.xlsx**

Test about mean differences between two means, and for the ratio of variances of two normal variables.

**One-Propor-Test.xlsx**

Test about a proportion.

**Two-Propor-Test.xlsx**

Test about the difference between two proportions.