Descriptive Statistics in Excel

Often you may want to sum the values of some dataset in Excel based on quarter. For example, suppose we have the…

The y-intercept of a graph represents the point where a line crosses the y-axis when x is equal to zero. To find…

You can use the following basic syntax to use the MIN function in Excel to find the minimum value in a range…

The following step-by-step example shows how to calculate the median value by group in Excel. Related: How to Calculate the Average by…

By default, the XLOOKUP function in Excel looks up some value in a range and returns a corresponding value only for the…

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…

You can use one of the following formulas to calculate employee tenure in Excel: Formula 1: Calculate Tenure in Years and Months…

You can use the following formula to calculate year over year (YoY) growth for some company: YoY Growth = (Current Period Revenue…

Often you may want to calculate the completion percentage of a project in Excel. This tutorial provides two examples of how to…

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…