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

Data Analysis

  • Everything about Charts in Excel
  • How to calculate average last N values in a table in Excel
  • Error Bars in Excel
  • Managing Conditional Formatting Rules in Excel
  • Data Series in Excel

References

  • Count rows with at least n matching values
  • Count unique text values with criteria
  • How to use Excel LOOKUP Function
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • How to get last row in mixed data with blanks in Excel

Data Validations

  • Prevent invalid data entering in specific cells
  • Excel Data validation require unique number
  • Excel Data validation whole percentage only
  • Excel Data validation allow weekday only
  • Excel Data validation must contain specific text

Category: Statistical Functions

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

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

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

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

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

by

What is CORREL function in Excel? CORREL function is one of Statistical functions in Microsoft Excel that returns the correlation coefficient of the Array1 and Array2 cell ranges. Use the correlation coefficient to determine the relationship between two properties. For example, you can examine the relationship between a location’s average temperature and the use of …

Continue Reading

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

by

What is COUNTIF function in Excel? COUNTIF function is one of Statistical functions in Microsoft Excel used to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.In its simplest form, COUNTIF says: =COUNTIF(Where do you want to look?, What …

Continue Reading

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

by

What is LOGNORM.INV function in Excel? LOGNORM.INV function is one of Statistical functions in Microsoft Excel that returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. If p = LOGNORM.DIST(x,…) then LOGNORM.INV(p,…) = x. Use the lognormal distribution to analyze logarithmically transformed data. …

Continue Reading

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

by

What is MINIFS function in Excel? The MINIFS function is one of Statistical functions in Microsoft Excel that returns the minimum value among cells specified by a given set of conditions or criteria. Note: This feature is available on Windows or Mac if you have Office 2019, or if you have an Office 365 subscription. If you …

Continue Reading

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

by

What is STEYX function in Excel? STEYX function is one of Statistical functions in Microsoft Excel that returns the standard error of the predicted y-value for each x in the regression. The standard error is a measure of the amount of error in the prediction of y for an individual x. Syntax of STEYX function STEYX(known_y’s, known_x’s) …

Continue Reading

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

by

What is TREND function in Excel? TREND function in Excel is a Statistical Function that computes the linear trend line based on the given linear set of data. TREND in Excel calculates the predictive values of Y for given array values of X and uses the least square method based on the given two data …

Continue Reading

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

by

What is CONFIDENCE.T function in Excel? CONFIDENCE.T function is one of Statistical functions in Microsoft Excel that returns the confidence interval for a population mean, using a Student’s t distribution. Syntax of CONFIDENCE.T function CONFIDENCE.T(alpha,standard_dev,size) The CONFIDENCE.T function syntax has the following arguments: Alpha     Required. The significance level used to compute the confidence level. The confidence …

Continue Reading

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

by

What is COUNTBLANK function in Excel? COUNTBLANK function is one of Statistical functions in Microsoft Excel used to count the number of empty cells in a range of cells. Syntax of COUNTBLANK function COUNTBLANK(range) The COUNTBLANK function syntax has the following arguments: Range    Required. The range from which you want to count the blank cells. COUNTBLANK formula explanation Cells with formulas that return …

Continue Reading

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

by

What is LOGNORM.DIST function in Excel? LOGNORM.DIST function is one of Statistical functions in Microsoft Excel that returns the lognormal distribution of x, where ln(x) is normally distributed with parameters Mean and Standard_dev. Use this function to analyze data that has been logarithmically transformed. Syntax of LOGNORM.DIST function LOGNORM.DIST(x,mean,standard_dev,cumulative) The LOGNORM.DIST function syntax has the following …

Continue Reading

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

by

What is MINA function in Excel? MINA function is one of Statistical functions in Microsoft Excel that returns the smallest value in the list of arguments. Syntax of MINA function MINA(value1, [value2], …) The MINA function syntax has the following arguments: Value1, value2, …    Value1 is required, subsequent values are optional. 1 to 255 values for which …

Continue Reading

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

by

What is STDEVPA function in Excel? STDEVPA function is one of Statistical functions in Microsoft Excel that calculates standard deviation based on the entire population given as arguments, including text and logical values. The standard deviation is a measure of how widely values are dispersed from the average value (the mean). Syntax of STDEVPA function STDEVPA(value1, [value2], …) …

Continue Reading

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

by

What is T.TEST function in Excel? T.TEST function is one of Statistical functions in Microsoft Excel that returns the probability associated with a Student’s t-Test. Use T.TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean. Syntax of T.TEST function T.TEST(array1,array2,tails,type) The T.TEST function syntax has …

Continue Reading

CONFIDENCE.NORM function: Description, Usage, Syntax, Examples and Explanation

by

What is CONFIDENCE.NORM function in Excel? CONFIDENCE.NORM function is one of Statistical functions in Microsoft Excel that returns the confidence interval for a population mean, using a normal distribution. The confidence interval is a range of values. Your sample mean, x, is at the center of this range and the range is x ± CONFIDENCE.NORM. …

Continue Reading

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

by

What is FORECAST function in Excel? FORECAST function is one of Statistical functions in Microsoft Excel that calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. The known values are existing x-values and y-values, and the new value is predicted by using linear regression. …

Continue Reading

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

by

What is LOGEST function in Excel? LOGEST function is one of Statistical functions in Microsoft Excel that r In regression analysis, calculates an exponential curve that fits your data and returns an array of values that describes the curve. Because this function returns an array of values, it must be entered as an array formula.The …

Continue Reading

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

by

 What is MIN function in Excel? MIN function is one of Statistical functions in Microsoft Excel that returns the smallest number in a set of values. Syntax of MIN function MIN(number1, [number2], …) The MIN function syntax has the following arguments: Number1, number2, …    Number1 is optional, subsequent numbers are optional. 1 to 255 numbers for which …

Continue Reading

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

by

What is STDEVA function in Excel? STDEVA function is one of Statistical functions in Microsoft Excel that estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean). Syntax of STDEVA function STDEVA(value1, [value2], …) The STDEVA function syntax has the following arguments: Value1, …

Continue Reading

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

by

What is T.INV.2T function in Excel? T.INV.2T function is one of Statistical functions in Microsoft Excel that returns the two-tailed inverse of the Student’s t-distribution. Syntax of T.INV.2T function T.INV.2T(probability,deg_freedom) The T.INV.2T 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

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

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

by

What is FISHERINV function in Excel? FISHERINV function is one of Statistical functions in Microsoft Excel that returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then FISHERINV(y) = x. Syntax of FISHERINV function FISHERINV(y) The FISHERINV function syntax has the following …

Continue Reading

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

by

What is LINEST function in Excel? The LINEST function calculates the statistics for a line by using the “least squares” method to calculate a straight line that best fits your data, and then returns an array that describes the line. You can also combine LINEST with other functions to calculate the statistics for other types of models that are …

Continue Reading

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

by

What is MAXIFS function in Excel? The MAXIFS function is one of Statistical functions in Microsoft Excel that returns the maximum value among cells specified by a given set of conditions or criteria. Note: This feature is available on Windows or Mac if you have Office 2019, or if you have an Office 365 subscription. If you …

Continue Reading

STDEV.S function: Description, Usage, Syntax, Examples and Explanation

by

What is STDEV.S function in Excel? STDEV.S function is one of Statistical functions in Microsoft Excel that estimates standard deviation based on a sample (ignores logical values and text in the sample).The standard deviation is a measure of how widely values are dispersed from the average value (the mean). Syntax of STDEV.S function STDEV.S(number1,[number2],…) The STDEV.S function syntax has …

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

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

by

What is FISHER function in Excel? FISHER function is one of Statistical functions in Microsoft Excel that returns the Fisher transformation at x. This transformation produces a function that is normally distributed rather than skewed. Use this function to perform hypothesis testing on the correlation coefficient. Syntax of FISHER function FISHER(x) The FISHER function syntax has …

Continue Reading

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

by

What is LARGE function in Excel? LARGE function is one of Statistical functions in Microsoft Excel that returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score. Syntax …

Continue Reading

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

by

What is MAXA function in Excel? MAXA function is one of Statistical functions in Microsoft Excel that returns the largest value in a list of arguments. MAXA is similar to MINA. Syntax of MAXA function MAXA(value1,[value2],…) The MAXA function syntax has the following arguments: Value1: The first number argument for which you want to find the …

Continue Reading

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

by

What is STANDARDIZE function in Excel? STANDARDIZE function is one of Statistical functions in Microsoft Excel that returns a normalized value from a distribution characterized by mean and standard_dev. Syntax of STANDARDIZE function STANDARDIZE(x, mean, standard_dev) The STANDARDIZE function syntax has the following arguments: X: The value you want to normalize. Mean: The arithmetic mean of the distribution. …

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

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

by

What is F.TEST function in Excel? F.TEST function is one of Statistical functions in Microsoft Excel that returns the result of an F-test, the two-tailed probability that the variances in array1 and array2 are not significantly different. Use this function to determine whether two samples have different variances. For example, given test scores from public …

Continue Reading

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

by

What is KURT function in Excel? KURT function is one of Statistical functions in Microsoft Excel that returns the kurtosis of a data set. Kurtosis characterizes the relative peakedness or flatness of a distribution compared with the normal distribution. Positive kurtosis indicates a relatively peaked distribution. Negative kurtosis indicates a relatively flat distribution. Syntax of KURT …

Continue Reading

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

by

What is MEDIAN function in Excel? MEDIAN function is one of Statistical functions in Microsoft Excel that returns the median of the given numbers. The median is the number in the middle of a set of numbers. Syntax of MEDIAN function MEDIAN(number1, [number2], …) The MEDIAN function syntax has the following arguments: Number1, number2, …    Number1 is …

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

  • Extract multiple matches into separate rows in Excel
  • How to use Excel OR Function
  • How to use Excel TRUE Function
  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • Not Equal To ‘<>‘ operator in Excel

Date Time

  • How to calculate nth day of year in Excel
  • How to get Weekdays, Working days between Two Dates in Excel
  • How to join date and text together in Excel
  • NETWORKDAYS.INTL function: Description, Usage, Syntax, Examples and Explanation
  • Convert date to Julian format in Excel

Grouping

  • Calculate conditional mode with criteria in Excel
  • If cell contains one of many things in Excel
  • Group numbers with VLOOKUP in Excel
  • Categorize text with keywords in Excel
  • Map text to numbers in Excel

General

  • Customize Ribbon In Excel
  • How to calculate percent of goal in Excel
  • How to calculate percentage discount in Excel
  • How to increase by percentage in Excel
  • Transpose: Switch ‘Rows to Columns’ or ‘Columns to Rows’ in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning