Descriptive Statistics in Excel
Descriptive Statistics in Excel
How to Calculate Weighted Standard Deviation in Excel
The weighted standard deviation is a useful way to measure the dispersion of values in a dataset when some values in the dataset have...
Descriptive Statistics in Excel
How to Winsorize Data in Excel
To winsorize data means to set extreme outliers equal to a specified percentile of the data.
For example, a 90% winsorization sets all observations greater than the...
Descriptive Statistics in Excel
How to Calculate Probability in Excel (With Examples)
Probability describes the likelihood that some event occurs.
We can calculate probabilities in Excel by using the PROB function, which uses the following syntax:
PROB(x_range, prob_range,...
Descriptive Statistics in Excel
How to Calculate Deciles in Excel (With Examples)
In statistics, deciles are numbers that split a dataset into ten groups of equal frequency.
The first decile is the point where 10% of all...
Descriptive Statistics in Excel
How to Calculate Cumulative 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 Euclidean Distance in Excel
The Euclidean distance between two vectors, A and B, is calculated as:
Euclidean distance = √Σ(Ai-Bi)2
where:
Σ is a Greek symbol that means “sum”
Ai is the...
Descriptive Statistics in Excel
How to Calculate Hamming Distance in Excel
The Hamming distance between two vectors is simply the sum of corresponding elements that differ between the vectors.
For example, suppose we have the following...
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