New Excel functions for analysis and data processing
Effective functions with advanced capabilities in the field of data computation and analysis.New and advanced features
PEARSON function for calculating the Pearson correlation coefficient in Excel.Examples of solving problems for calculating the distribution and the criteria of agreement according to Pearson. How and where to use the PEARSON function?
MAX and MAXA functions in Excel for analyzing maximum values.Examples of using the functions of MAX and MAXA in the analysis of maximum values in the ranges of data of different types: numerical, logical, textual, under several conditions.
Examples of working with text function REPLACE in Excel.Examples of using the function REPLACE with different tasks for working with text in table cells. How to change a few characters in a text string?
Functions HOUR, MINUTE and SECOND to work with time in Excel.Examples of using functions for calculations and computing work with time. How to use the function HOUR, MINUTE and SECOND to convert a number to a time data type format?
MEDIAN function in Excel for performing statistical analysis.Examples of the operation of the MEDIAN function in statistical analysis. Formulas with combinations of MEDIAN, AVERAGE, and MODE functions for performing statistical analyzes.
How to use LINEST function in Excel for multiple linear regression.Illustrative step-by-step examples of using LINEST for outputting output statistical information. Analysis and calculation of relationships or dependencies in multiple regression.
Examples of using the SHEET and SHEETS functions in Excel formulas.Examples of formulas for working with workbook worksheets using the SHEET and SHEETS functions. How to find the sheet name by formula?
Function SHEETS and formulas for working with other sheets in Excel.Examples of formula calculations in references to other sheets of the workbook. How to use the SHEETS function and count the total number of sheets?
How to calculate natural LOG in Excel for exponential growth.Examples of LN, LOG, and LOG10 functions for mathematical calculations when calculating the natural logarithm of a number. Investment and deposit calculator for calculating compound interest with capitalization.
Example MATCH function for finding occurring values in Excel.Examples of how the MATCH function works to find the exact and nearest larger or smaller value in a range of cells. How to compare for the coincidence of values of two tables?
