The CHISQ.DIST function returns the cumulative distribution function for a chi-square distribution, which represents the probability that a chi-square distributed random variable falls within a specified range. Syntax: CHISQ.DIST(x, degrees_freedom, cumulative). The CHISQ.INV function returns the inverse of the cumulative distribution function for a chi-square distribution, providing the critical value for a specified probability. Syntax: CHISQ.INV(probability, degrees_freedom).
The HYPGEOM.DIST function returns the probability of a given number of successes in a population, based on a hypergeometric distribution. Syntax: HYPGEOM.DIST(sample_s, number_sample, population_s, number_population, cumulative). The NEGBINOM.DIST function returns the probability of a specified number of failures before a specified number of successes, based on a negative binomial distribution. Syntax: NEGBINOM.DIST(number_f, number_s, probability_s, cumulative).
The EXPON.DIST function returns the probability density function for an exponential distribution, which represents the probability of an event occurring at a certain time. Syntax: EXPON.DIST(x, lambda, cumulative).
The WEIBULL.DIST function returns the value of the Weibull distribution for a given input value, alpha, and beta. Syntax: WEIBULL.DIST(x, alpha, beta, cumulative).
The GAMMA.DIST function returns the value of the gamma distribution for a given input value, alpha, and beta. Syntax: GAMMA.DIST(x, alpha, beta, cumulative). The GAMMA.INV function returns the inverse of the gamma cumulative distribution, providing the critical value for a specified probability. Syntax: GAMMA.INV(probability, alpha, beta).
The BETA.DIST function returns the beta cumulative distribution function, which represents the probability of a value falling between a specified range. Syntax: BETA.DIST(x, alpha, beta, cumulative, A, B). The BETA.INV function returns the inverse of the beta cumulative distribution function for a specified probability and beta distribution. Syntax: BETA.INV(probability, alpha, beta, A, B).
The PERMUT function returns the number of permutations for a given number of objects that can be selected from the total objects. Syntax: PERMUT(number, number_chosen). The COMBIN function returns the number of combinations for a given number of objects that can be selected from the total objects. Syntax: COMBIN(number, number_chosen).
The FACT function returns the factorial of a number, which is the product of all positive integers up to that number. Syntax: FACT(number). The FACTDOUBLE function returns the double factorial of a number, which is the product of every other integer up to the specified number. Syntax: FACTDOUBLE(number).
The MULTINOMIAL function returns the ratio of the factorial of a sum of values to the product of factorials of those values. Syntax: MULTINOMIAL(number1, [number2], ...). The SERIESSUM function returns the sum of a power series based on the formula. Syntax: SERIESSUM(x, n, m, a).
The DELTA function tests whether two values are equal. It returns 1 if the values are equal and 0 otherwise. Syntax: DELTA(number1, [number2]). The GESTEP function returns 1 if a number is greater than or equal to a step value, and 0 otherwise. Syntax: GESTEP(number, [step]).
The ERF function returns the error function integrated between two limits, which is used in probability, statistics, and partial differential equations. Syntax: ERF(lower_limit, [upper_limit]). The ERFC function returns the complementary error function integrated between a limit and infinity. Syntax: ERFC(x).
The BESSELJ function returns the Bessel function, which is often used in solving differential equations. Syntax: BESSELJ(x, n). The BESSELK function returns the modified Bessel function, which is also used in solving differential equations. Syntax: BESSELK(x, n).
The IMAGINARY function returns the imaginary coefficient of a complex number in x + yi or x + yj text format . Syntax: IMAGINARY(inumber). The IMREAL function returns the real coefficient of a complex number in x + yi or x + yj text format. Syntax: IMREAL(inumber).
The COMPLEX function converts real and imaginary coefficients into a complex number. Syntax: COMPLEX(real_num, i_num, [suffix]). The IMCONJUGATE function returns the complex conjugate of a complex number. Syntax: IMCONJUGATE(inumber).
The MDETERM function returns the matrix determinant of an array. Syntax: MDETERM(array). The MINVERSE function returns the inverse of a matrix stored in an array. Syntax: MINVERSE(array).
The MMULT function returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. Syntax: MMULT(array1, array2).
The SUMX2MY2 function returns the sum of the differences of squares of corresponding values in two arrays. Syntax: SUMX2MY2(array_x, array_y). The SUMX2PY2 function returns the sum of the sums of squares of corresponding values in two arrays. Syntax: SUMX2PY2(array_x, array_y).
The SUMXMY2 function returns the sum of the squares of differences of corresponding values in two arrays. Syntax: SUMXMY2(array_x, array_y).
The COVARIANCE.P function returns the population covariance, the average of the products of deviations for each data point pair in two sets of numbers. Syntax: COVARIANCE.P(array1, array2). The COVARIANCE.S function returns the sample covariance, the average of the products of deviations for each data point pair in two sets of numbers. Syntax: COVARIANCE.S(array1, array2).
The CORREL function returns the correlation coefficient between two data sets. Syntax: CORREL(array1, array2).
The PEARSON function returns the Pearson product-moment correlation coefficient, a measure of the linear correlation between two sets of data. Syntax: PEARSON(array1, array2).
The RSQ function returns the square of the Pearson product-moment correlation coefficient, a measure of how well the predicted values for the trend line correspond to the actual data. Syntax: RSQ(known_y's, known_x's).
The STEYX function returns the standard error of the predicted y-value for each x in the regression. Syntax: STEYX(known_y's, known_x's).
The SLOPE function returns the slope of the linear regression line through data points in known_y's and known_x's. Syntax: SLOPE(known_y's, known_x's). The INTERCEPT function returns the y-axis intercept of the linear regression line through data points in known_y's and known_x's. Syntax: INTERCEPT(known_y's, known_x's).
The T.TEST function returns the probability associated with a Student's t-test. Syntax: T.TEST(array1, array2, tails, type). The T.INV.2T function returns the two-tailed inverse of the Student's t-distribution. Syntax: T.INV.2T(probability, degrees_freedom).
The F.TEST function returns the result of an F-test, the probability that the variances in array1 and array2 are not significantly different. Syntax: F.TEST(array1, array2). The Z.TEST function returns the one-tailed probability-value of a z-test. Syntax: Z.TEST(array, x, [sigma]).
The CHISQ.TEST function returns the test for independence, which is the probability that the observed data values would deviate at least as much as observed if the variables are independent. Syntax: CHISQ.TEST(actual_range, expected_range). The CHISQ.INV.RT function returns the inverse of the right-tailed probability of the chi-square distribution. Syntax: CHISQ.INV.RT(probability, degrees_freedom).
The LOGNORM.DIST function returns the lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev. Syntax: LOGNORM.DIST(x, mean, standard_dev, cumulative). The LOGNORM.INV function returns the inverse of the lognormal cumulative distribution function. Syntax: LOGNORM.INV(probability, mean, standard_dev).
The GEOMEAN function returns the geometric mean of an array or range of positive data. Syntax: GEOMEAN(number1, [number2], ...). The HARMEAN function returns the harmonic mean of a data set. Syntax: HARMEAN(number1, [number2], ...).
The CONCATENATE function joins two or more text strings into one string. Syntax: CONCATENATE(text1, [text2], ...). The TEXT function converts a value to text in a specified number format. Syntax: TEXT(value, format_text). Together, they can be used to format and concatenate strings, e.g., CONCATENATE(TEXT (A1, "0.00"), " - ", TEXT(B1, "$0.00")).
The NETWORKDAYS function returns the number of whole workdays between two dates, excluding weekends and optionally specified holidays. Syntax: NETWORKDAYS(start_date, end_date, [holidays]).
The DATEDIF function calculates the difference between two dates in years, months, or days. Syntax: DATEDIF(start_date, end_date, unit). The EDATE function returns the serial number of the date that is the indicated number of months before or after the start date. Syntax: EDATE(start_date, months). Together, they can be used to calculate date differences and adjust dates by months.
The YEAR function returns the year of a date as a 4-digit number. Syntax: YEAR(serial_number). The MONTH function returns the month of a date as a number from 1 (January) to 12 (December). Syntax: MONTH(serial_number). The DAY function returns the day of a date as a number from 1 to 31. Syntax: DAY(serial_number).
The HOUR function returns the hour of a time value as a number from 0 to 23. Syntax: HOUR(serial_number). The MINUTE function returns the minute of a time value as a number from 0 to 59. Syntax: MINUTE(serial_number). The SECOND function returns the second of a time value as a number from 0 to 59. Syntax: SECOND(serial_number).
The TEXT function converts a value to text in a specified number format. It is often used to format dates and times as text strings in a desired format. Syntax: TEXT(value, format_text).
The WEEKDAY function returns the day of the week corresponding to a date. Syntax: WEEKDAY(serial_number, [return_type]). The WEEKNUM function returns the week number of a specific date. Syntax: WEEKNUM(serial_number, [return_type]).
The WORKDAY function returns the serial number of the date before or after a specified number of workdays, excluding weekends and holidays. Syntax: WORKDAY(start_date, days, [holidays]). The WORKDAY.INTL function is similar but allows specifying which days are considered weekends. Syntax: WORKDAY.INTL(start_date, days, [weekend], [holidays]).
A dynamic date range can be created using the OFFSET and COUNTA functions. For example, OFFSET(start_date, 0, 0, COUNTA(date_range), 1) creates a dynamic range that adjusts as dates are added or removed. This range can be used in charts, formulas, and data validation.
The EOMONTH function returns the serial number for the last day of the month that is the indicated number of months before or after the start date. Syntax: EOMONTH(start_date, months).
The EDATE function returns the serial number of the date that is the indicated number of months before or after the start date. Syntax: EDATE(start_date, months).
The DATEVALUE function converts a date in the form of text to a serial number that Excel recognizes as a date. Syntax: DATEVALUE(date_text). The TIMEVALUE function converts a time in the form of text to a serial number that Excel recognizes as a time. Syntax: TIMEVALUE(time_text).
The DOLLAR function converts a number to text using currency format, with the number of decimals rounded to the specified place. Syntax: DOLLAR(number, [decimals]). The EUROCONVERT function converts a number to euros, or from euros to a participating currency, using the fixed conversion rates. Syntax: EUROCONVERT(number, source_currency, target_currency, full_precision, triangulation_precision).
The DECIMAL function converts a text representation of a number in a given base into a decimal number. Syntax: DECIMAL(text, radix). The BASE function converts a number into a text representation with the given base. Syntax: BASE(number, radix, [min_length]).
The ROMAN function converts an Arabic numeral to a Roman numeral, as text. Syntax: ROMAN(number, [form]). The ARABIC function converts a Roman numeral, as text, to an Arabic numeral. Syntax: ARABIC(text).
The CEILING.MATH function rounds a number up to the nearest integer or to the nearest multiple of significance. Syntax: CEILING.MATH(number, [significance], [mode]). The FLOOR.MATH function rounds a number down to the nearest integer or to the nearest multiple of significance. Syntax: FLOOR.MATH(number, [significance], [mode]).
The ROUNDUP function rounds a number up, away from zero. Syntax: ROUNDUP(number, num_digits). The ROUNDDOWN function rounds a number down, towards zero. Syntax: ROUNDDOWN(number, num_digits). When applied to negative numbers, ROUNDUP will move the value away from zero (e.g., -1.5 becomes -2), and ROUNDDOWN will move the value towards zero (e.g., -1.5 becomes -1).
The TRUNC function trunc ates a number to an integer by removing the fractional part of the number. Syntax: TRUNC(number, [num_digits]). The INT function rounds a number down to the nearest integer. Syntax: INT(number). Used together, TRUNC and INT can help control how a number is converted to an integer, especially with negative numbers.
The SQRT function returns the square root of a number. Syntax: SQRT(number). The SQRTPI function returns the square root of (number * pi). Syntax: SQRTPI(number).
The EXP function returns e raised to the power of a given number. Syntax: EXP(number). The LN function returns the natural logarithm of a number. Syntax: LN(number).
The LOG function returns the logarithm of a number to a specified base. Syntax: LOG(number, [base]). The LOG10 function returns the base-10 logarithm of a number. Syntax: LOG10(number).
No comments:
Post a Comment