Descriptive Statistics in Excel
Descriptive Statistics in Excel
How to Calculate the Median by Group in Excel
The following step-by-step example shows how to calculate the median value by group in Excel.
Related: How to Calculate the Average by Group in Excel
Step...
Descriptive Statistics in Excel
Excel: How to Use XLOOKUP to Return All Matches
By default, the XLOOKUP function in Excel looks up some value in a range and returns a corresponding value only for the first match.
However,...
Descriptive Statistics in Excel
Excel: How to Use XLOOKUP with Multiple Criteria
You can use the following XLOOKUP formula in Excel to look up cells that meet multiple criteria:
=XLOOKUP(F2&G2&H2,A2:A13&B2:B13&C2:C13,D2:D13)
This particular formula will look for the cell...
Descriptive Statistics in Excel
How to Calculate Tenure in Excel (With Example)
You can use one of the following formulas to calculate employee tenure in Excel:
Formula 1: Calculate Tenure in Years and Months (e.g. 14 years,...
Descriptive Statistics in Excel
How to Calculate Year Over Year Growth in Excel
You can use the following formula to calculate year over year (YoY) growth for some company:
YoY Growth = (Current Period Revenue / Previous Period...
Descriptive Statistics in Excel
How to Calculate Percent Complete in Excel
Often you may want to calculate the completion percentage of a project in Excel.
This tutorial provides two examples of how to calculate completion percentage...
Descriptive Statistics in Excel
Excel: How to Use Wildcard in FILTER Function
You can use the following syntax to use wildcard characters within a FILTER function in Excel:
=FILTER(A2:B12, ISNUMBER(SEARCH("some_string", A2:A12)), "None")
This particular formula will filter the...
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