PHPOffice / PhpSpreadsheet

     *

     * @return array of float

     */

    public static function GROWTH($yValues, $xValues = [], $newValues = [], $const = true)

    {

        $yValues = Functions::flattenArray($yValues);

        $xValues = Functions::flattenArray($xValues);

        $newValues = Functions::flattenArray($newValues);

        $const = (is_null($const)) ? true : (bool) Functions::flattenSingleValue($const);

        $bestFitExponential = \PhpOffice\PhpSpreadsheet\Shared\trend\trend::calculate(\PhpOffice\PhpSpreadsheet\Shared\trend\trend::TREND_EXPONENTIAL, $yValues, $xValues, $const);

        if (empty($newValues)) {

            $newValues = $bestFitExponential->getXValues();

        }

        $returnArray = [];

        foreach ($newValues as $xValue) {

            $returnArray[0][] = $bestFitExponential->getValueOfYForX($xValue);

        }

        return $returnArray;

    }

    /**

     * HARMEAN.

     *

     * @return array of float

     */

    public static function TREND($yValues, $xValues = [], $newValues = [], $const = true)

    {

        $yValues = Functions::flattenArray($yValues);

        $xValues = Functions::flattenArray($xValues);

        $newValues = Functions::flattenArray($newValues);

        $const = (is_null($const)) ? true : (bool) Functions::flattenSingleValue($const);

        $bestFitLinear = \PhpOffice\PhpSpreadsheet\Shared\trend\trend::calculate(\PhpOffice\PhpSpreadsheet\Shared\trend\trend::TREND_LINEAR, $yValues, $xValues, $const);

        if (empty($newValues)) {

            $newValues = $bestFitLinear->getXValues();

        }

        $returnArray = [];

        foreach ($newValues as $xValue) {

            $returnArray[0][] = $bestFitLinear->getValueOfYForX($xValue);

        }

        return $returnArray;

    }

    /**

     * TRIMMEAN.