/* * ==================================================================== * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. * ==================================================================== */ package org.apache.poi.ss.formula.functions; import org.apache.poi.ss.formula.eval.ValueEval; import org.apache.poi.ss.formula.functions.LinearRegressionFunction.FUNCTION; /** * Implementation of Excel function SLOPE()

* * Calculates the SLOPE of the linear regression line using org.apache.commons.math3.stat.regression.SimpleRegression * SLOPE(arrayX, arrayY)

* * * @author Johan Karlsteen * @see org.apache.commons.math3.stat.regression.SimpleRegression */ public final class Slope extends Fixed2ArgFunction { private final LinearRegressionFunction func; public Slope() { func = new LinearRegressionFunction(FUNCTION.SLOPE); } public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) { return func.evaluate(srcRowIndex, srcColumnIndex, arg0, arg1); } }