Function Type: Compatibility Description: Returns the one-tailed probability of the chi-squared distribution. In Excel 2007, this is a Statistical function. Function Structure: =CHIDIST(x, deg_freedom). Argument Breakdown: x – The value at which the chi-square distribution is to be evaluated (must be ≥ 0). deg_freedom – The number of degrees of freedom (must be an integer between 1Continue reading “CHIDIST”
Tag Archives: Excel
BINOMDIST
Function Type: Compatibility Description: Returns the individual term binomial distribution probability. In Excel 2007, this is a Statistical function. Function Structure: =BINOMDIST(number_s, trials, probability_s, cumulative) Argument Breakdown: number_s – The number of successes. trials – The number of independent trials. probability_s – The probability success on each trial. cumulative – TRUE = cumulative distribution function,Continue reading “BINOMDIST”
VAR
Estimates variance based on a sample.
SUMIFS function
SUMIFS function adds the cell values based on specified criteria.
INDEX function
Function Type: Lookup and Reference Description: INDEX function returns the value of a given location in a table range or array. This function is commonly used with MATCH function which give us the location of the lookup_value. Function Structure: =INDEX(array, row_number, [column_number]) Argument Breakdown: array – This is the group of cells where your excelContinue reading “INDEX function”
Shortcut Keys in Excel
Keys for moving and scrolling in a worksheet or workbook Arrow keys: Move one cell up, down, left, or right CTRL+arrow: key Move to the edge of the current data region HOME: Move to the beginning of the row CTRL+HOME: Move to the beginning of the worksheet CTRL+END: Move to the last cell on theContinue reading “Shortcut Keys in Excel”
IF function
Function Type: Logical Description: IF is one of the most popular functions in Excel. It checks if the condition is met then it returns a value. It is used to return one value if the logic is true and another value if false. Function Structure: =IF(logical_test, [value_if_true], [value_if_false]) Argument Breakdown: logical_test – This is whereContinue reading “IF function”
Excel Cell
In Microsoft Excel, a cell is a rectangular box that occurs at the intersection of a vertical column and a horizontal row in a worksheet. Thus, it is defined by a combination of column and row e.g., A1 A cell stores 1 data at a time. These data can be a formula, text value, numericContinue reading “Excel Cell”
VLOOKUP
Function Type: Lookup and Reference Description: VLOOKUP is one of the most popular functions in Excel. It is used to lookup a data and retrieve the corresponding data from a specific column. You may either lookup for the exact or approximate match. The “V” in Vlookup means Vertical. Function Structure: =VLOOKUP(lookup_value, table_array, column_index_number, [range_lookup]) ArgumentContinue reading “VLOOKUP”