Home Â» Statistical Point Â» Excel Â» Descriptive Statistics in Excel
Category:

# Descriptive Statistics in Excel

• ## How to Sum by Quarter in Excel (Step-by-Step Example)

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

• ## How to Find Y-Intercept of a Graph in Excel

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

• ## Excel: How to Use MIN Function and Exclude Zero

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

• ## 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…

• ## 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…

• ## 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…

• ## 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…

• ## 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…

• ## 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…

• ## 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…