xref: /AOO41X/main/chart2/source/tools/LinearRegressionCurveCalculator.cxx (revision cdf0e10c4e3984b49a9502b011690b615761d4a3)
1*cdf0e10cSrcweir /*************************************************************************
2*cdf0e10cSrcweir  *
3*cdf0e10cSrcweir  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
4*cdf0e10cSrcweir  *
5*cdf0e10cSrcweir  * Copyright 2000, 2010 Oracle and/or its affiliates.
6*cdf0e10cSrcweir  *
7*cdf0e10cSrcweir  * OpenOffice.org - a multi-platform office productivity suite
8*cdf0e10cSrcweir  *
9*cdf0e10cSrcweir  * This file is part of OpenOffice.org.
10*cdf0e10cSrcweir  *
11*cdf0e10cSrcweir  * OpenOffice.org is free software: you can redistribute it and/or modify
12*cdf0e10cSrcweir  * it under the terms of the GNU Lesser General Public License version 3
13*cdf0e10cSrcweir  * only, as published by the Free Software Foundation.
14*cdf0e10cSrcweir  *
15*cdf0e10cSrcweir  * OpenOffice.org is distributed in the hope that it will be useful,
16*cdf0e10cSrcweir  * but WITHOUT ANY WARRANTY; without even the implied warranty of
17*cdf0e10cSrcweir  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18*cdf0e10cSrcweir  * GNU Lesser General Public License version 3 for more details
19*cdf0e10cSrcweir  * (a copy is included in the LICENSE file that accompanied this code).
20*cdf0e10cSrcweir  *
21*cdf0e10cSrcweir  * You should have received a copy of the GNU Lesser General Public License
22*cdf0e10cSrcweir  * version 3 along with OpenOffice.org.  If not, see
23*cdf0e10cSrcweir  * <http://www.openoffice.org/license.html>
24*cdf0e10cSrcweir  * for a copy of the LGPLv3 License.
25*cdf0e10cSrcweir  *
26*cdf0e10cSrcweir  ************************************************************************/
27*cdf0e10cSrcweir 
28*cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove
29*cdf0e10cSrcweir #include "precompiled_chart2.hxx"
30*cdf0e10cSrcweir #include "LinearRegressionCurveCalculator.hxx"
31*cdf0e10cSrcweir #include "macros.hxx"
32*cdf0e10cSrcweir #include "RegressionCalculationHelper.hxx"
33*cdf0e10cSrcweir 
34*cdf0e10cSrcweir #include <rtl/math.hxx>
35*cdf0e10cSrcweir #include <rtl/ustrbuf.hxx>
36*cdf0e10cSrcweir 
37*cdf0e10cSrcweir using namespace ::com::sun::star;
38*cdf0e10cSrcweir 
39*cdf0e10cSrcweir using ::rtl::OUString;
40*cdf0e10cSrcweir using ::rtl::OUStringBuffer;
41*cdf0e10cSrcweir 
42*cdf0e10cSrcweir namespace chart
43*cdf0e10cSrcweir {
44*cdf0e10cSrcweir 
45*cdf0e10cSrcweir LinearRegressionCurveCalculator::LinearRegressionCurveCalculator() :
46*cdf0e10cSrcweir         m_fSlope( 0.0 ),
47*cdf0e10cSrcweir         m_fIntercept( 0.0 )
48*cdf0e10cSrcweir {
49*cdf0e10cSrcweir     ::rtl::math::setNan( & m_fSlope );
50*cdf0e10cSrcweir     ::rtl::math::setNan( & m_fIntercept );
51*cdf0e10cSrcweir }
52*cdf0e10cSrcweir 
53*cdf0e10cSrcweir LinearRegressionCurveCalculator::~LinearRegressionCurveCalculator()
54*cdf0e10cSrcweir {}
55*cdf0e10cSrcweir 
56*cdf0e10cSrcweir // ____ XRegressionCurveCalculator ____
57*cdf0e10cSrcweir void SAL_CALL LinearRegressionCurveCalculator::recalculateRegression(
58*cdf0e10cSrcweir     const uno::Sequence< double >& aXValues,
59*cdf0e10cSrcweir     const uno::Sequence< double >& aYValues )
60*cdf0e10cSrcweir     throw (uno::RuntimeException)
61*cdf0e10cSrcweir {
62*cdf0e10cSrcweir     RegressionCalculationHelper::tDoubleVectorPair aValues(
63*cdf0e10cSrcweir         RegressionCalculationHelper::cleanup(
64*cdf0e10cSrcweir             aXValues, aYValues,
65*cdf0e10cSrcweir             RegressionCalculationHelper::isValid()));
66*cdf0e10cSrcweir 
67*cdf0e10cSrcweir     const size_t nMax = aValues.first.size();
68*cdf0e10cSrcweir     if( nMax == 0 )
69*cdf0e10cSrcweir     {
70*cdf0e10cSrcweir         ::rtl::math::setNan( & m_fSlope );
71*cdf0e10cSrcweir         ::rtl::math::setNan( & m_fIntercept );
72*cdf0e10cSrcweir         ::rtl::math::setNan( & m_fCorrelationCoeffitient );
73*cdf0e10cSrcweir         return;
74*cdf0e10cSrcweir     }
75*cdf0e10cSrcweir 
76*cdf0e10cSrcweir     const double fN = static_cast< double >( nMax );
77*cdf0e10cSrcweir     double fSumX = 0.0, fSumY = 0.0, fSumXSq = 0.0, fSumYSq = 0.0, fSumXY = 0.0;
78*cdf0e10cSrcweir     for( size_t i = 0; i < nMax; ++i )
79*cdf0e10cSrcweir     {
80*cdf0e10cSrcweir         fSumX   += aValues.first[i];
81*cdf0e10cSrcweir         fSumY   += aValues.second[i];
82*cdf0e10cSrcweir         fSumXSq += aValues.first[i]  * aValues.first[i];
83*cdf0e10cSrcweir         fSumYSq += aValues.second[i] * aValues.second[i];
84*cdf0e10cSrcweir         fSumXY  += aValues.first[i]  * aValues.second[i];
85*cdf0e10cSrcweir     }
86*cdf0e10cSrcweir 
87*cdf0e10cSrcweir     m_fSlope = (fN * fSumXY - fSumX * fSumY) / ( fN * fSumXSq - fSumX * fSumX );
88*cdf0e10cSrcweir     m_fIntercept = (fSumY - m_fSlope * fSumX) / fN;
89*cdf0e10cSrcweir 
90*cdf0e10cSrcweir     m_fCorrelationCoeffitient = ( fN * fSumXY - fSumX * fSumY ) /
91*cdf0e10cSrcweir         sqrt( ( fN * fSumXSq - fSumX * fSumX ) *
92*cdf0e10cSrcweir               ( fN * fSumYSq - fSumY * fSumY ) );
93*cdf0e10cSrcweir }
94*cdf0e10cSrcweir 
95*cdf0e10cSrcweir double SAL_CALL LinearRegressionCurveCalculator::getCurveValue( double x )
96*cdf0e10cSrcweir     throw (lang::IllegalArgumentException,
97*cdf0e10cSrcweir            uno::RuntimeException)
98*cdf0e10cSrcweir {
99*cdf0e10cSrcweir     double fResult;
100*cdf0e10cSrcweir     ::rtl::math::setNan( & fResult );
101*cdf0e10cSrcweir 
102*cdf0e10cSrcweir     if( ! ( ::rtl::math::isNan( m_fSlope ) ||
103*cdf0e10cSrcweir             ::rtl::math::isNan( m_fIntercept )))
104*cdf0e10cSrcweir     {
105*cdf0e10cSrcweir         fResult = m_fSlope * x + m_fIntercept;
106*cdf0e10cSrcweir     }
107*cdf0e10cSrcweir 
108*cdf0e10cSrcweir     return fResult;
109*cdf0e10cSrcweir }
110*cdf0e10cSrcweir 
111*cdf0e10cSrcweir uno::Sequence< geometry::RealPoint2D > SAL_CALL LinearRegressionCurveCalculator::getCurveValues(
112*cdf0e10cSrcweir     double min, double max, ::sal_Int32 nPointCount,
113*cdf0e10cSrcweir     const uno::Reference< chart2::XScaling >& xScalingX,
114*cdf0e10cSrcweir     const uno::Reference< chart2::XScaling >& xScalingY,
115*cdf0e10cSrcweir     ::sal_Bool bMaySkipPointsInCalculation )
116*cdf0e10cSrcweir     throw (lang::IllegalArgumentException,
117*cdf0e10cSrcweir            uno::RuntimeException)
118*cdf0e10cSrcweir {
119*cdf0e10cSrcweir     if( bMaySkipPointsInCalculation &&
120*cdf0e10cSrcweir         isLinearScaling( xScalingX ) &&
121*cdf0e10cSrcweir         isLinearScaling( xScalingY ))
122*cdf0e10cSrcweir     {
123*cdf0e10cSrcweir         // optimize result
124*cdf0e10cSrcweir         uno::Sequence< geometry::RealPoint2D > aResult( 2 );
125*cdf0e10cSrcweir         aResult[0].X = min;
126*cdf0e10cSrcweir         aResult[0].Y = this->getCurveValue( min );
127*cdf0e10cSrcweir         aResult[1].X = max;
128*cdf0e10cSrcweir         aResult[1].Y = this->getCurveValue( max );
129*cdf0e10cSrcweir 
130*cdf0e10cSrcweir         return aResult;
131*cdf0e10cSrcweir     }
132*cdf0e10cSrcweir     return RegressionCurveCalculator::getCurveValues( min, max, nPointCount, xScalingX, xScalingY, bMaySkipPointsInCalculation );
133*cdf0e10cSrcweir }
134*cdf0e10cSrcweir 
135*cdf0e10cSrcweir OUString LinearRegressionCurveCalculator::ImplGetRepresentation(
136*cdf0e10cSrcweir     const uno::Reference< util::XNumberFormatter >& xNumFormatter,
137*cdf0e10cSrcweir     ::sal_Int32 nNumberFormatKey ) const
138*cdf0e10cSrcweir {
139*cdf0e10cSrcweir     OUStringBuffer aBuf( C2U( "f(x) = " ));
140*cdf0e10cSrcweir 
141*cdf0e10cSrcweir     bool bHaveSlope = false;
142*cdf0e10cSrcweir 
143*cdf0e10cSrcweir     if( m_fSlope != 0.0 )
144*cdf0e10cSrcweir     {
145*cdf0e10cSrcweir         if( ::rtl::math::approxEqual( fabs( m_fSlope ), 1.0 ))
146*cdf0e10cSrcweir         {
147*cdf0e10cSrcweir             if( m_fSlope < 0 )
148*cdf0e10cSrcweir                 aBuf.append( UC_MINUS_SIGN );
149*cdf0e10cSrcweir         }
150*cdf0e10cSrcweir         else
151*cdf0e10cSrcweir             aBuf.append( getFormattedString( xNumFormatter, nNumberFormatKey, m_fSlope ));
152*cdf0e10cSrcweir         aBuf.append( sal_Unicode( 'x' ));
153*cdf0e10cSrcweir         bHaveSlope = true;
154*cdf0e10cSrcweir     }
155*cdf0e10cSrcweir 
156*cdf0e10cSrcweir     if( bHaveSlope )
157*cdf0e10cSrcweir     {
158*cdf0e10cSrcweir         if( m_fIntercept < 0.0 )
159*cdf0e10cSrcweir         {
160*cdf0e10cSrcweir             aBuf.append( UC_SPACE );
161*cdf0e10cSrcweir             aBuf.append( UC_MINUS_SIGN );
162*cdf0e10cSrcweir             aBuf.append( UC_SPACE );
163*cdf0e10cSrcweir             aBuf.append( getFormattedString( xNumFormatter, nNumberFormatKey, fabs( m_fIntercept )));
164*cdf0e10cSrcweir         }
165*cdf0e10cSrcweir         else if( m_fIntercept > 0.0 )
166*cdf0e10cSrcweir         {
167*cdf0e10cSrcweir             aBuf.appendAscii( RTL_CONSTASCII_STRINGPARAM( " + " ));
168*cdf0e10cSrcweir             aBuf.append( getFormattedString( xNumFormatter, nNumberFormatKey, m_fIntercept ));
169*cdf0e10cSrcweir         }
170*cdf0e10cSrcweir     }
171*cdf0e10cSrcweir     else
172*cdf0e10cSrcweir     {
173*cdf0e10cSrcweir         aBuf.append( getFormattedString( xNumFormatter, nNumberFormatKey, m_fIntercept ));
174*cdf0e10cSrcweir     }
175*cdf0e10cSrcweir 
176*cdf0e10cSrcweir     return aBuf.makeStringAndClear();
177*cdf0e10cSrcweir }
178*cdf0e10cSrcweir 
179*cdf0e10cSrcweir } //  namespace chart
180