Operations in Excel
Excel
How to Perform Stratified Sampling in Excel (Step-by-Step)
In statistics, we often take samples from a population and use the data from the sample to draw conclusions about the population as a...
Excel
How to Perform Systematic Sampling in Excel (Step-by-Step)
Researchers often take samples from a population and use the data from the sample to draw conclusions about the population as a whole.
One commonly...
Excel
How to Find the Antilog of Values in Excel
The antilog of a number is the inverse of the log of a number.
So, if you calculate the log of a number you can...
Excel
How to Sort by Multiple Columns in Excel
Often you may want to sort by multiple columns in Excel. Fortunately this is easy to do using the Custom Sort option.
This tutorial provides...
Excel
How to Calculate the Difference Between Two Dates in Excel
We can use the DATEDIF() function to calculate the difference between two dates in Excel.
This function uses the following syntax:
=DATEDIF(Start_Date, End_Date, Metric)
where:
Start_Date: The start date
End_Date:...
Excel
How to Interpolate Missing Values in Excel
Often you may have one or more missing values in a series in Excel that you’d like to fill in.
The simplest way to fill...
Excel
Linear Interpolation in Excel: Step-by-Step Example
Interpolation is the process of estimating an unknown value of a function between two known values.
Given two known values (x1, y1) and (x2, y2),...
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