Descriptive Statistics in Excel
Descriptive Statistics in Excel
How to Calculate Quintiles in Excel (With Examples)
In statistics, quintiles are numbers that split a dataset into five groups of equal frequency.
The first quintile is the point where 20% of all...
Descriptive Statistics in Excel
How to Find the Slope of a Trendline in Excel
Often you may want to find the slope of a trendline in Excel.
Fortunately this is fairly easy to do and the following step-by-step example...
Descriptive Statistics in Excel
How to Calculate Cronbach’s Alpha in Excel
Chronbach’s Alpha is a way to measure the internal consistency of a questionnaire or survey.
Cronbach’s Alpha ranges between 0 and 1, with higher values...
Descriptive Statistics in Excel
Pearson’s Coefficient of Skewness in Excel (Step-by-Step)
Developed by biostatistician Karl Pearson, Pearson’s coefficient of skewness is a way to measure the skewness in a sample dataset.
There are actually two methods...
Descriptive Statistics in Excel
How to Calculate Intraclass Correlation Coefficient in Excel
An intraclass correlation coefficient (ICC) is used to determine if items (or subjects) can be rated reliably by different raters.
The value of an ICC...
Descriptive Statistics in Excel
How to Calculate Pooled Variance in Excel (Step-by-Step)
In statistics, pooled variance refers to the average of two or more group variances.
We use the word “pooled” to indicate that we’re “pooling” two...
Descriptive Statistics in Excel
How to Apply Bayes’ Theorem in Excel
Bayes’ Theorem states the following for any two events A and B:
P(A|B) = P(A)*P(B|A) / P(B)
where:
P(A|B): The probability of event A, given event B has...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read