Excel-Templates

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.

Some examples of Templates in a web:

Distribution-Tables

Contingency Table

Confidence intervals for the mean and the variance

Hypothesis testing about the mean of a normal random variable.