public static function PHPExcel_Calculation_MathTrig::COMBIN in Loft Data Grids 6.2

Same name and namespace in other branches

1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php \PHPExcel_Calculation_MathTrig::COMBIN()

* COMBIN * * Returns the number of combinations for a given number of items. Use COMBIN to * determine the total possible number of groups for a given number of items. * * Excel Function: * COMBIN(numObjs,numInSet) * * @access public * @category Mathematical and Trigonometric Functions *

Parameters

int $numObjs Number of different objects: * @param int $numInSet Number of objects in each combination * @return int Number of combinations

3 calls to PHPExcel_Calculation_MathTrig::COMBIN()

PHPExcel_Calculation_Statistical::BINOMDIST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php

* BINOMDIST * * Returns the individual term binomial distribution probability. Use BINOMDIST in problems with * a fixed number of tests or trials, when the outcomes of any trial are only success or failure, * when trials are independent, and…

PHPExcel_Calculation_Statistical::HYPGEOMDIST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php

* HYPGEOMDIST * * Returns the hypergeometric distribution. HYPGEOMDIST returns the probability of a given number of * sample successes, given the sample size, population successes, and population size. * *

PHPExcel_Calculation_Statistical::NEGBINOMDIST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php

* NEGBINOMDIST * * Returns the negative binomial distribution. NEGBINOMDIST returns the probability that * there will be number_f failures before the number_s-th success, when the constant * probability of a success is probability_s. This…

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php, line 176

Class

PHPExcel_Calculation_MathTrig

PHPExcel_Calculation_MathTrig

Code

public static function COMBIN($numObjs, $numInSet) {
  $numObjs = PHPExcel_Calculation_Functions::flattenSingleValue($numObjs);
  $numInSet = PHPExcel_Calculation_Functions::flattenSingleValue($numInSet);
  if (is_numeric($numObjs) && is_numeric($numInSet)) {
    if ($numObjs < $numInSet) {
      return PHPExcel_Calculation_Functions::NaN();
    }
    elseif ($numInSet < 0) {
      return PHPExcel_Calculation_Functions::NaN();
    }
    return round(self::FACT($numObjs) / self::FACT($numObjs - $numInSet)) / self::FACT($numInSet);
  }
  return PHPExcel_Calculation_Functions::VALUE();
}