Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Use Solver Tool in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • How To Create Frequency Distribution in Excel
  • Everything about Charts in Excel
  • Data Series in Excel

References

  • How to use Excel COLUMN Function
  • How to get last row in text data in Excel
  • How to get relative column numbers in a range in Excel
  • Vlookup Examples in Excel
  • How to use Excel MATCH Function

Data Validations

  • Excel Data validation whole percentage only
  • Excel Data validation don’t exceed total
  • Prevent invalid data entering in specific cells
  • Excel Data validation allow uppercase only
  • Excel Data validation must begin with

Category: Statistical Functions

Excel provides a variety of Statistical Functions that helps in analyzing data within a worksheet

How To Use AGGREGATE function to sum a range with errors in Excel

by

Excel functions such as SUM, COUNT, LARGE and MAX don’t work if a range includes errors. However, you can easily use the AGGREGATE function to fix this. 1. For example, Excel returns an error if you use the SUM function to sum a range with errors. 2. Use the AGGREGATE function to sum a range with errors. Explanation: …

Continue Reading

Example of Count with Or Criteria in Excel

by

How to count data based upon multiple criteria? Counting with Or criteria in Excel can be tricky. This article shows several easy to follow examples. 1. We start simple. For example, we want to count the number of cells that contain Google or Facebook (one column). 2a. However, if we want to count the number of rows that contain Google or Stanford …

Continue Reading

Complete List of Excel Statistical Functions References and Examples

by

Excel provides a variety of statistical functions that might be useful for you know in calculations. Statistical functions perform calculations ranging from basic mean, median & mode to the more complex statistical distribution and probability tests. Here’s a full list of Built-In Statistical Functions in Excel and their Descriptions below: Click each of the function link to …

Continue Reading

Countif function in Excel

by

COUNTIF is one of the statistical functions, it is used to count the number of cells that meet a criterion This chapter covers  many easy to follow COUNTIF examples like Numbers, Text, Booleans, Errors and ‘Or Criteria’. Numbers 1. The COUNTIF function below counts the number of cells that contain the value 20. 2. The following COUNTIF …

Continue Reading

Excel Standard Deviation

by

What is Standard Deviation (STDEV.P, STDEV.S)? This page explains how to calculate the standard deviation based on the entire population using the STDEV.P function in Excel and how to estimate the standard deviation based on a sample using the STDEV.S function in Excel. What is Standard Deviation? Standard deviation is a number that tells you how far numbers are …

Continue Reading

Count Unique Values in Excel

by

This example shows you how to create an array formula that counts unique values. Examples: 1.. To count the number of 5’s, use the following function. We use the COUNTIF function.  2. To count the unique values (don’t be overwhelmed), we add the SUM function, 1/, and replace 5 with A1:A6. 3. Finish by pressing CTRL + SHIFT …

Continue Reading

PERCENTILE and QUARTILE function examples in Excel

by

This example teaches you how to use the PERCENTILE and QUARTILE function in Excel. Below you can find a list of scores (green fill for illustration only). 1. Use the PERCENTILE function shown below to calculate the 30th percentile. Excel returns the value 12.7. This means that 30% (6 out of 20) of the scores are lower or …

Continue Reading

Forecast vs Trend Function in Excel

by

The FORECAST and TREND function give the exact same result. When you add a trendline to an Excel chart, Excel can display the equation in a chart (see below). You can use this equation to calculate future sales. Explanation: Excel uses the method of least squares to find a line that best fits the points. The R-squared value equals 0.9295, which is a …

Continue Reading

How To Use MaxIfs and MinIfs in Excel

by

This function combines the MAX and IF function in order to get the maximum value in a data set of Excel worksheet. To look up the maximum value in a range based on specific criteria, you can use a basic array formula based on the IF function. {=MAX(IF(criteria_range=criteria,value_range))} Use the MAXIFS and MINIFS function in Excel …

Continue Reading

Count if two criteria match in Excel

by

This tutorial shows how to Count if two criteria match in Excel using the example below; Formula =COUNTIFS(range1,critera1,range2,critera2) Explanation If you want to count rows where two (or more) criteria match, you can use a formula based on the COUNTIFS function. In the example shown, we want to count the number of orders with a …

Continue Reading

Average the last 3 numeric values in Excel

by

This tutorial shows how to work  Average the last 3 numeric values in Excel using the example below; Formula {=AVERAGE(LOOKUP(LARGE(IF(ISNUMBER(data),ROW(data)),{1,2,3}),ROW(data), data))} Explanation To average the last 3 numeric values in a range, you can use an array formula based on a combination of functions to feed the last n numeric values into the AVERAGE function. In the example …

Continue Reading

Break ties with helper column and COUNTIF in Excel

by

This tutorial shows how to Break ties with helper column and COUNTIF in Excel using the example below; Formula =A1+(COUNTIF(exp_rng,A1)-1)*adjustment Explanation To break ties, you can use a helper column and the COUNTIF function to adjust values so that they don’t contain duplicates, and therefore won’t result in ties. In the example shown, the formula in D5 …

Continue Reading

Count and Sum Functions in Excel

by

The most used functions in Excel are the functions that count and sum. COUNT function is one of the STATISTICAL functions while SUM function is one of the Math and Trig functions. You can count and sum based on one criteria or multiple criteria. Count To count the number of cells that contain numbers, use the COUNT function. Countif To count cells …

Continue Reading

9 Mathematical Computations Example using Excel Statistical Function

by

In addition to formulas, another way to conduct mathematical computations in Excel is through functions. Statistical functions apply a mathematical process to a group of cells in a worksheet. This chapter gives an overview of some very useful statistical functions like: AVERAGE function, AVERAGEIF function, MEDIAN function, SUMIF function, MIN function, MODE function, STEDV function, LARGE function, SMALL function. Average To calculate the average of a …

Continue Reading

CHISQ.TEST function: Description, Usage, Syntax, Examples and Explanation

by

What is CHISQ.TEST function in Excel? CHISQ.TEST function is one of Statistical functions in Microsoft Excel that returns the test for independence. CHISQ.TEST returns the value from the chi-squared (χ2) distribution for the statistic and the appropriate degrees of freedom. You can use χ2 tests to determine whether hypothesized results are verified by an experiment. …

Continue Reading

AVERAGE function: Description, Usage, Syntax, Examples and Explanation

by

What is AVERAGE function in Excel? MODE.SNGL function is one of Statistical functions in Microsoft Excel that returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers. Syntax of AVERAGE function AVERAGE(number1, [number2], …) The AVERAGE function syntax has the following arguments: Number1    Required. …

Continue Reading

CHISQ.INV.RT function: Description, Usage, Syntax, Examples and Explanation

by

What is CHISQ.INV.RT function in Excel? CHISQ.INV.RT function is one of Statistical functions in Microsoft Excel that returns the inverse of the right-tailed probability of the chi-squared distribution. If probability = CHISQ.DIST.RT(x,…), then CHISQ.INV.RT(probability,…) = x. Use this function to compare observed results with expected ones in order to decide whether your original hypothesis is …

Continue Reading

T.DIST.2T function: Description, Usage, Syntax, Examples and Explanation

by

 What is T.DIST.2T function in Excel? T.DIST.2T function is one of Statistical functions in Microsoft Excel that returns the two-tailed Student’s t-distribution. The Student’s t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution. Syntax of T.DIST.2T function T.DIST.2T(x,deg_freedom) The T.DIST.2T function …

Continue Reading

AVERAGEA function: Description, Usage, Syntax, Examples and Explanation

by

What is AVERAGEA function in Excel? AVERAGEA function is one of Statistical functions in Microsoft Excel that calculates the average (arithmetic mean) of the values in the list of arguments. Syntax of AVERAGEA function AVERAGEA(value1, [value2], …) The AVERAGEA function syntax has the following arguments: Value1, value2, …    Value1 is required, subsequent values are optional. 1 to …

Continue Reading

CHISQ.INV function: Description, Usage, Syntax, Examples and Explanation

by

What is CHISQ.INV function in Excel? CHISQ.INV function is one of Statistical functions in Microsoft Excel that returns the inverse of the left-tailed probability of the chi-squared distribution.The chi-squared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television. Syntax …

Continue Reading

AVERAGEIF function: Description, Usage, Syntax, Examples and Explanation

by

What is AVERAGEIF function in Excel? AVERAGEIF function is one of Statistical functions in Microsoft Excel that returns the average (arithmetic mean) of all the cells in a range that meet a given criteria. Syntax of AVERAGEIF function AVERAGEIF(range, criteria, [average_range]) The AVERAGEIF function syntax has the following arguments: Range    Required. One or more cells to average, …

Continue Reading

CHISQ.DIST.RT function: Description, Usage, Syntax, Examples and Explanation

by

What is CHISQ.DIST.RT function in Excel? CHISQ.DIST.RT function is one of Statistical functions in Microsoft Excel that returns the right-tailed probability of the chi-squared distribution. The χ2 distribution is associated with a χ2 test. Use the χ2 test to compare observed and expected values. For example, a genetic experiment might hypothesize that the next generation …

Continue Reading

SLOPE function: Description, Usage, Syntax, Examples and Explanation

by

What is SLOPE function in Excel? SLOPE function is one of Statistical functions in Microsoft Excel that returns the slope of the linear regression line through data points in known_y’s and known_x’s. The slope is the vertical distance divided by the horizontal distance between any two points on the line, which is the rate of change …

Continue Reading

AVERAGEIFS function: Description, Usage, Syntax, Examples and Explanation

by

What is AVERAGEIFS function in Excel? AVERAGEIFS function is one of Statistical functions in Microsoft Excel that returns the average (arithmetic mean) of all cells that meet multiple criteria. Syntax of AVERAGEIFS function AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …) The AVERAGEIFS function syntax has the following arguments: Average_range    Required. One or more cells to average, including numbers …

Continue Reading

CHISQ.DIST function: Description, Usage, Syntax, Examples and Explanation

by

What is CHISQ.DIST function in Excel? CHISQ.DIST function is one of Statistical functions in Microsoft Excel that returns the chi-squared distribution. The chi-squared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television. Syntax of CHISQ.DIST function CHISQ.DIST(x,deg_freedom,cumulative) The CHISQ.DIST function …

Continue Reading

SKEW.P function: Description, Usage, Syntax, Examples and Explanation

by

What is SKEW.P function in Excel? SKEW.P function is one of Statistical functions in Microsoft Excel that returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean. Syntax of SKEW.P function SKEW.P(number 1, [number 2],…) The SKEW.P function syntax has the following arguments. Number 1, number …

Continue Reading

BETA.DIST function: Description, Usage, Syntax, Examples and Explanation

by

What is BETA.DIST function in Excel? BETA.DIST function is one of Statistical functions in Microsoft Excel that returns the beta distribution. The beta distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television. Syntax of BETA.DIST function BETA.DIST(x,alpha,beta,cumulative,[A],[B]) The BETA.DIST function …

Continue Reading

BETA.INV function: Description, Usage, Syntax, Examples and Explanation

by

What is BETA.INV function in Excel? BETA.INV function is one of Statistical functions in Microsoft Excel that returns the inverse of the beta cumulative probability density function (BETA.DIST). If probability = BETA.DIST(x,…TRUE), then BETA.INV(probability,…) = x. The beta distribution can be used in project planning to model probable completion times given an expected completion time …

Continue Reading

SKEW function: Description, Usage, Syntax, Examples and Explanation

by

What is SKEW function in Excel? SKEW function is one of Statistical functions in Microsoft Excel that returns the skewness of a distribution. Skewness characterizes the degree of asymmetry of a distribution around its mean. Positive skewness indicates a distribution with an asymmetric tail extending toward more positive values. Negative skewness indicates a distribution with an asymmetric …

Continue Reading

BINOM.DIST function: Description, Usage, Syntax, Examples and Explanation

by

What is BINOM.DIST function in Excel? BINOM.DIST function is one of Statistical functions in Microsoft Excel that returns the individual term binomial distribution probability. Use BINOM.DIST in problems with a fixed number of tests or trials, when the outcomes of any trial are only success or failure, when trials are independent, and when the probability …

Continue Reading

RANK.EQ function: Description, Usage, Syntax, Examples and Explanation

by

 What is RANK.EQ function in Excel? RANK.EQ function  is one of Statistical functions in Microsoft Excel that  returns the rank of a number in a list of numbers. Its size is relative to other values in the list; if more than one value has the same rank, the top rank of that set of values is …

Continue Reading

BINOM.DIST.RANGE function: Description, Usage, Syntax, Examples and Explanation

by

What is BINOM.DIST.RANGE function in Excel? BINOM.DIST.RANGE function is one of Statistical functions in Microsoft Excel that returns the probability of a trial result using a binomial distribution. Syntax of BINOM.DIST.RANGE function BINOM.DIST.RANGE(trials,probability_s,number_s,[number_s2]) The BINOM.DIST.RANGE function syntax has the following arguments. Trials    Required. The number of independent trials. Must be greater than or equal to 0. …

Continue Reading

RANK.AVG function: Description, Usage, Syntax, Examples and Explanation

by

 What is RANK.AVG function in Excel? RANK.AVG function is one of Statistical functions in Microsoft Excel that returns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the average rank is returned. Syntax of RANK.AVG function RANK.AVG(number,ref,[order]) The …

Continue Reading

BINOM.INV function: Description, Usage, Syntax, Examples and Explanation

by

What is BINOM.INV function in Excel? BINOM.INV function is one of Statistical functions in Microsoft Excel that returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. Syntax of BINOM.INV function BINOM.INV(trials,probability_s,alpha) The BINOM.INV function syntax has the following arguments: Trials     Required. The number of Bernoulli trials. …

Continue Reading

QUARTILE.INC function: Description, Usage, Syntax, Examples and Explanation

by

What is QUARTILE.INC function in Excel? QUARTILE.INC function is one of Statistical functions in Microsoft Excel that returns the quartile of a data set, based on percentile values from 0..1, inclusive. Quartiles often are used in sales and survey data to divide populations into groups. For example, you can use QUARTILE.INC to find the top 25 percent …

Continue Reading

AVEDEV function: Description, Usage, Syntax, Examples and Explanation

by

What is AVEDEV function in Excel? AVEDEV function is one of Statistical functions in Microsoft Excel that returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set. Syntax of AVEDEV function AVEDEV(number1, [number2], …) The AVEDEV function syntax has the following arguments: …

Continue Reading

T.INV function: Description, Usage, Syntax, Examples and Explanation

by

What is T.INV function in Excel? T.INV function is one of Statistical functions in Microsoft Excel that returns the left-tailed inverse of the Student’s t-distribution. Syntax of T.INV function T.INV(probability,deg_freedom) The T.INV function syntax has the following arguments: Probability: The probability associated with the Student’s t-distribution. Deg_freedom:  The number of degrees of freedom with which to characterize the …

Continue Reading

QUARTILE.EXC function: Description, Usage, Syntax, Examples and Explanation

by

What is QUARTILE.EXC function in Excel? QUARTILE.EXC function is one of Statistical functions in Microsoft Excel that returns the quartile of the data set, based on percentile values from 0..1, exclusive. Syntax of QUARTILE.EXC function QUARTILE.EXC(array, quart) The QUARTILE.EXC function syntax has the following arguments: Array: The array or cell range of numeric values for which you want …

Continue Reading

COUNT function: Description, Usage, Syntax, Examples and Explanation

by

What is COUNT function in Excel? COUNT function is one of Statistical functions in Microsoft Excel that  is used counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of …

Continue Reading

TRIMMEAN function: Description, Usage, Syntax, Examples and Explanation

by

 What is TRIMMEAN function in Excel? TRIMMEAN function is one of Statistical functions in Microsoft Excel that returns the mean of the interior of a data set. TRIMMEAN calculates the mean taken by excluding a percentage of data points from the top and bottom tails of a data set. You can use this function when you wish …

Continue Reading

Posts navigation

  • 1
  • 2
  • 3
  • 4
  • Next

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function example in Excel
  • IF with boolean logic in Excel
  • Extract multiple matches into separate rows in Excel
  • Return blank if in Excel

Date Time

  • Display the current date in Excel
  • Get days, hours, and minutes between dates in Excel
  • Get days, months, and years between dates in Excel
  • Get days between dates ignoring years in Excel
  • NETWORKDAYS function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • If cell contains one of many things in Excel
  • Group arbitrary text values in Excel
  • Map inputs to arbitrary values in Excel
  • Group numbers with VLOOKUP in Excel
  • Group times into 3 hour buckets in Excel

General

  • How to fill cell ranges with random number from fixed set of options in Excel
  • Share Excel data with Word documents
  • Check if multiple cells have same value in Excel
  • How to Delete Cells, Row and Rows in Excel
  • Spell Check in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning