A binomial distribution summarizes the number of successes in a fixed number of independent and identical trials. You can calculate binomial probability using ...

Probability is the likelihood that a particular event will occur. It is expressed as a number between 0 and 1. You can calculate probability using a built-in ...

The bell curve represents a normal distribution that is symmetrical about the mean. You can use a function to calculate the normal distribution value and then ...

A lognormal distribution represents the distribution of a random variable whose logarithm is normally distributed. You can create a log normal distribution in ...

A test for normal distribution compares various statistics of the data to determine if the data follows a normal distribution. You can perform several test for ...

A contingency table or crosstabs shows the frequency distribution of two categorical variables. You can use Excel features and functions to easily make a ...

A 95% confidence interval means – 95% of the standard normal distribution lies between an interval bounded by two Z scores. To calculate Z score 95% confidence ...

The Fisher test evaluates any significant association between two categorical variables. We can perform the Fisher test in Excel using the HYPGEOM.DIST ...

A frequency distribution shows the frequency or number of observations within different intervals. You can use Excel functions, features, and add-ins to make a ...

The Z score indicates how many standard deviations a data point is located from the mean value of the dataset. You can use an Excel function or a simple ...