Descriptive Statistics in Excel
Descriptive Statistics in Excel
How to Calculate Fleiss’ Kappa in Excel
Fleiss’ Kappa is a way to measure the degree of agreement between three or more raters when the raters are assigning categorical ratings to a...
Descriptive Statistics in Excel
How to Easily Find Outliers in Excel
An outlier is an observation that lies abnormally far away from other values in a dataset. Outliers can be problematic because they can effect the results...
Descriptive Statistics in Excel
How to Calculate Relative Frequency in Excel
A frequency table is a table that displays information about frequencies. Frequencies simply tell us how many times a certain event has occurred.
For example, the following...
Descriptive Statistics in Excel
How to Calculate Class Width in Excel
In a frequency distribution, class width refers to the difference between the upper and lower boundaries of any class or category.
For example, the following frequency distribution...
Descriptive Statistics in Excel
How to Calculate the Midrange in Excel
The midrange of a dataset is calculated as:
Midrange = (largest value + smallest value) / 2
This value is simply the average of the largest and smallest...
Descriptive Statistics in Excel
How to Normalize Data in Excel
To “normalize” a set of data values means to scale the values such that the mean of all of the values is 0 and the...
Descriptive Statistics in Excel
How to Calculate Spearman Rank Correlation in Excel
In statistics, correlation refers to the strength and direction of a relationship between two variables. The value of a correlation coefficient can range from -1 to...
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