Statistical,Excel and Data science

  Nested IF Function : The  nested IF  function allows you to perform tests with multiple conditions and return different values based on the results of those tests. It is called “nested” because one IF function is embedded inside another IF function. Syntax of a generic nested IF formula: =IF(condition1, result1, IF(condition2, result2, IF(condition3, result3, result4) ) ) Each subsequent IF function is embedded into the  value_if_false  argument of the previous function. SWITCH Function : The  SWITCH  function is a more compact alternative to nested IF statements. It compares an expression against a list of values and returns the result according to the first matching value. Syntax of the SWITCH function: =SWITCH(expression, value1, result1, [default or value2, result2], ... [default or valueN, resultN]) It has four arguments: expression : The value to compare against the list of values. valueN : A value com...

  VLOOKUP (Vertical Lookup) : Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Example: =VLOOKUP(A2, B2:D10, 2, FALSE) Searches for a value in the leftmost column of a table and returns a value in the same row from a specified column. HLOOKUP (Horizontal Lookup) : Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]) Example: =HLOOKUP(B2, A1:D10, 3, FALSE) Searches for a value in the top row of a table and returns a value in the same column from a specified row. LOOKUP : Syntax: =LOOKUP(lookup_value, lookup_vector, [result_vector]) Example: =LOOKUP(A2, B2:B10, C2:C10) Finds the closest (approximate) match in the lookup_vector and returns the corresponding value from the result_vector. INDEX and MATCH (Dynamic Lookup) : Syntax: =INDEX(return_range, MATCH(lookup_value, lookup_range, 0)) Example: =INDEX(C2:C10, MATCH(A2, B2:B10, 0)) Combines INDEX and MATCH functions for more flexibility in lookup operations. XLOOKUP (Modern Lookup Functi...

  Mean (Average) : Syntax: =AVERAGE(range) Example: =AVERAGE(A1:A10) Calculates the mean (average) of a range of values. Median : Syntax: =MEDIAN(range) Example: =MEDIAN(A1:A10) Finds the median (middle value) of a range of values. Mode : Syntax: =MODE.SNGL(range) Example: =MODE.SNGL(A1:A10) Identifies the most frequently occurring value in a range. Standard Deviation : Syntax: =STDEV.P(range) or =STDEV.S(range) Example: =STDEV.P(A1:A10) or =STDEV.S(A1:A10) Calculates the standard deviation for a population ( STDEV.P ) or a sample ( STDEV.S ). Variance : Syntax: =VAR.P(range) or =VAR.S(range) Example: =VAR.P(A1:A10) or =VAR.S(A1:A10) Computes the variance for a population ( VAR.P ) or a sample ( VAR.S ). Correlation Coefficient : Syntax: =CORREL(range1, range2) Example: =CORREL(A1:A10, B1:B10) Calculates the correlation coefficient between two sets of values. Regression Analysis (Slope) : Syntax: =SLOPE(known_y's, known_x's) Example: =SLOPE(B1:B10, A1:A10) Computes the slop...