Sigma Squared
Lexington, KY, USA
614-973-9100
Follow on:
Linkedin-in Twitter Youtube

Blog

CLEAN

  • May 31, 2023
Definition: CLEAN is a function that removes all non-printable characters from a string. Syntax: =CLEAN(text) Situation: This formula is suitable when you need to remove non-printable characters, such...
Read More

CHOOSE

  • May 31, 2023
Definition: CHOOSE is a function that returns a value from a list of values based on a specified index. Syntax: =CHOOSE(index_num, value1, [value2], ...) Situation: This formula is...
Read More

CHITEST

  • May 31, 2023
Definition: CHITEST is a function that tests the independence of two sets of data. Syntax: =CHITEST(actual_range, expected_range) Situation: This formula is suitable when you need to test whether...
Read More

CHIINV

  • May 31, 2023
Definition: CHIINV is a function that returns the inverse of the one-tailed probability of the chi-squared distribution. Syntax: =CHIINV(probability, degrees_freedom) Situation: This formula is suitable when you need...
Read More

CHIDIST

  • May 31, 2023
Definition: CHIDIST is a function that returns the one-tailed probability of the chi-squared distribution. Syntax: =CHIDIST(x, degrees_freedom) Situation: This formula is suitable when you need to find the...
Read More

CHAR

  • May 31, 2023
Definition: CHAR is a function that returns the character specified by a number. Syntax: =CHAR(number) Situation: This formula is suitable when you need to convert a number to...
Read More

CELL

  • May 31, 2023
Definition: CELL is a function that returns information about a cell, such as its format, contents, or location. Syntax: =CELL(info_type, [reference]) Situation: This formula is suitable when you...
Read More

CEILING

  • May 31, 2023
Definition: CEILING is a function that rounds a number up to the nearest multiple of a specified value. Syntax: =CEILING(number, [significance]) Situation: This formula is suitable when you...
Read More

BINOMDIST

  • May 31, 2023
Definition: BINOMDIST is a function that returns the individual term binomial distribution probability. Syntax: =BINOMDIST(number_s, trials, probability_s, [cumulative]) Situation: This formula is suitable when you need to find...
Read More

BIN2OCT

  • May 31, 2023
Definition: BIN2OCT is a function that converts a binary number to octal. Syntax: =BIN2OCT(number, [places]) Situation: This formula is suitable when you need to convert a binary number...
Read More