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 "ExponentialRegressionCurveCalculator.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 ExponentialRegressionCurveCalculator::ExponentialRegressionCurveCalculator() :
46*cdf0e10cSrcweir         m_fLogSlope( 0.0 ),
47*cdf0e10cSrcweir         m_fLogIntercept( 0.0 )
48*cdf0e10cSrcweir {
49*cdf0e10cSrcweir     ::rtl::math::setNan( & m_fLogSlope );
50*cdf0e10cSrcweir     ::rtl::math::setNan( & m_fLogIntercept );
51*cdf0e10cSrcweir }
52*cdf0e10cSrcweir 
53*cdf0e10cSrcweir ExponentialRegressionCurveCalculator::~ExponentialRegressionCurveCalculator()
54*cdf0e10cSrcweir {}
55*cdf0e10cSrcweir 
56*cdf0e10cSrcweir // ____ XRegressionCurveCalculator ____
57*cdf0e10cSrcweir void SAL_CALL ExponentialRegressionCurveCalculator::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::isValidAndYPositive()));
66*cdf0e10cSrcweir 
67*cdf0e10cSrcweir     const size_t nMax = aValues.first.size();
68*cdf0e10cSrcweir     if( nMax == 0 )
69*cdf0e10cSrcweir     {
70*cdf0e10cSrcweir         ::rtl::math::setNan( & m_fLogSlope );
71*cdf0e10cSrcweir         ::rtl::math::setNan( & m_fLogIntercept );
72*cdf0e10cSrcweir         ::rtl::math::setNan( & m_fCorrelationCoeffitient );// actual it is coefficient of determination
73*cdf0e10cSrcweir         return;
74*cdf0e10cSrcweir     }
75*cdf0e10cSrcweir 
76*cdf0e10cSrcweir     double fAverageX = 0.0, fAverageY = 0.0;
77*cdf0e10cSrcweir     size_t i = 0;
78*cdf0e10cSrcweir     for( i = 0; i < nMax; ++i )
79*cdf0e10cSrcweir     {
80*cdf0e10cSrcweir         fAverageX += aValues.first[i];
81*cdf0e10cSrcweir         fAverageY += log( aValues.second[i] );
82*cdf0e10cSrcweir     }
83*cdf0e10cSrcweir 
84*cdf0e10cSrcweir     const double fN = static_cast< double >( nMax );
85*cdf0e10cSrcweir     fAverageX /= fN;
86*cdf0e10cSrcweir     fAverageY /= fN;
87*cdf0e10cSrcweir 
88*cdf0e10cSrcweir     double fQx = 0.0, fQy = 0.0, fQxy = 0.0;
89*cdf0e10cSrcweir     for( i = 0; i < nMax; ++i )
90*cdf0e10cSrcweir     {
91*cdf0e10cSrcweir         double fDeltaX = aValues.first[i] - fAverageX;
92*cdf0e10cSrcweir         double fDeltaY = log( aValues.second[i] ) - fAverageY;
93*cdf0e10cSrcweir 
94*cdf0e10cSrcweir         fQx  += fDeltaX * fDeltaX;
95*cdf0e10cSrcweir         fQy  += fDeltaY * fDeltaY;
96*cdf0e10cSrcweir         fQxy += fDeltaX * fDeltaY;
97*cdf0e10cSrcweir     }
98*cdf0e10cSrcweir 
99*cdf0e10cSrcweir     m_fLogSlope = fQxy / fQx;
100*cdf0e10cSrcweir     m_fLogIntercept = fAverageY - m_fLogSlope * fAverageX;
101*cdf0e10cSrcweir     m_fCorrelationCoeffitient = fQxy / sqrt( fQx * fQy );
102*cdf0e10cSrcweir 
103*cdf0e10cSrcweir }
104*cdf0e10cSrcweir 
105*cdf0e10cSrcweir double SAL_CALL ExponentialRegressionCurveCalculator::getCurveValue( double x )
106*cdf0e10cSrcweir     throw (lang::IllegalArgumentException,
107*cdf0e10cSrcweir            uno::RuntimeException)
108*cdf0e10cSrcweir {
109*cdf0e10cSrcweir     double fResult;
110*cdf0e10cSrcweir     ::rtl::math::setNan( & fResult );
111*cdf0e10cSrcweir 
112*cdf0e10cSrcweir     if( ! ( ::rtl::math::isNan( m_fLogSlope ) ||
113*cdf0e10cSrcweir             ::rtl::math::isNan( m_fLogIntercept )))
114*cdf0e10cSrcweir     {
115*cdf0e10cSrcweir         fResult = exp(m_fLogIntercept + x * m_fLogSlope);
116*cdf0e10cSrcweir     }
117*cdf0e10cSrcweir 
118*cdf0e10cSrcweir     return fResult;
119*cdf0e10cSrcweir }
120*cdf0e10cSrcweir 
121*cdf0e10cSrcweir uno::Sequence< geometry::RealPoint2D > SAL_CALL ExponentialRegressionCurveCalculator::getCurveValues(
122*cdf0e10cSrcweir     double min, double max, ::sal_Int32 nPointCount,
123*cdf0e10cSrcweir     const uno::Reference< chart2::XScaling >& xScalingX,
124*cdf0e10cSrcweir     const uno::Reference< chart2::XScaling >& xScalingY,
125*cdf0e10cSrcweir     ::sal_Bool bMaySkipPointsInCalculation )
126*cdf0e10cSrcweir     throw (lang::IllegalArgumentException,
127*cdf0e10cSrcweir            uno::RuntimeException)
128*cdf0e10cSrcweir {
129*cdf0e10cSrcweir     if( bMaySkipPointsInCalculation &&
130*cdf0e10cSrcweir         isLinearScaling( xScalingX ) &&
131*cdf0e10cSrcweir         isLogarithmicScaling( xScalingY ))
132*cdf0e10cSrcweir     {
133*cdf0e10cSrcweir         // optimize result
134*cdf0e10cSrcweir         uno::Sequence< geometry::RealPoint2D > aResult( 2 );
135*cdf0e10cSrcweir         aResult[0].X = min;
136*cdf0e10cSrcweir         aResult[0].Y = this->getCurveValue( min );
137*cdf0e10cSrcweir         aResult[1].X = max;
138*cdf0e10cSrcweir         aResult[1].Y = this->getCurveValue( max );
139*cdf0e10cSrcweir 
140*cdf0e10cSrcweir         return aResult;
141*cdf0e10cSrcweir     }
142*cdf0e10cSrcweir 
143*cdf0e10cSrcweir     return RegressionCurveCalculator::getCurveValues( min, max, nPointCount, xScalingX, xScalingY, bMaySkipPointsInCalculation );
144*cdf0e10cSrcweir }
145*cdf0e10cSrcweir 
146*cdf0e10cSrcweir 
147*cdf0e10cSrcweir OUString ExponentialRegressionCurveCalculator::ImplGetRepresentation(
148*cdf0e10cSrcweir     const uno::Reference< util::XNumberFormatter >& xNumFormatter,
149*cdf0e10cSrcweir     ::sal_Int32 nNumberFormatKey ) const
150*cdf0e10cSrcweir {
151*cdf0e10cSrcweir     double fIntercept = exp(m_fLogIntercept);
152*cdf0e10cSrcweir     double fSlope = exp(m_fLogSlope);
153*cdf0e10cSrcweir     bool bHasSlope = !rtl::math::approxEqual( fSlope, 1.0 );
154*cdf0e10cSrcweir     bool bHasIntercept = !rtl::math::approxEqual( fIntercept, 1.0 );
155*cdf0e10cSrcweir 
156*cdf0e10cSrcweir     OUStringBuffer aBuf( C2U( "f(x) = " ));
157*cdf0e10cSrcweir 
158*cdf0e10cSrcweir     if ( fIntercept == 0.0)
159*cdf0e10cSrcweir     {
160*cdf0e10cSrcweir         // underflow, a true zero is impossible
161*cdf0e10cSrcweir         aBuf.append( C2U( "exp( " ));
162*cdf0e10cSrcweir         aBuf.append( getFormattedString( xNumFormatter, nNumberFormatKey, m_fLogIntercept) );
163*cdf0e10cSrcweir         aBuf.append( (m_fLogSlope < 0.0) ? C2U( " - " ) : C2U( " + " ));
164*cdf0e10cSrcweir         aBuf.append( getFormattedString( xNumFormatter, nNumberFormatKey, fabs(m_fLogSlope)) );
165*cdf0e10cSrcweir         aBuf.append( C2U( " x )" ));
166*cdf0e10cSrcweir     }
167*cdf0e10cSrcweir     else
168*cdf0e10cSrcweir     {
169*cdf0e10cSrcweir         if (bHasIntercept)
170*cdf0e10cSrcweir         {
171*cdf0e10cSrcweir             aBuf.append( getFormattedString( xNumFormatter, nNumberFormatKey, fIntercept) );
172*cdf0e10cSrcweir             aBuf.append( C2U( " exp( " ));
173*cdf0e10cSrcweir             aBuf.append( getFormattedString( xNumFormatter, nNumberFormatKey, m_fLogSlope) );
174*cdf0e10cSrcweir             aBuf.append( C2U( " x )" ));
175*cdf0e10cSrcweir         }
176*cdf0e10cSrcweir         else
177*cdf0e10cSrcweir         {
178*cdf0e10cSrcweir             // show logarithmic output, if intercept and slope both are near one
179*cdf0e10cSrcweir             // otherwise drop output of intercept, which is 1 here
180*cdf0e10cSrcweir             aBuf.append( C2U( " exp( " ));
181*cdf0e10cSrcweir             if (!bHasSlope)
182*cdf0e10cSrcweir             {
183*cdf0e10cSrcweir                 aBuf.append( getFormattedString( xNumFormatter, nNumberFormatKey, m_fLogIntercept) );
184*cdf0e10cSrcweir                 aBuf.append( (m_fLogSlope < 0.0) ? C2U( " - " ) : C2U( " + " ));
185*cdf0e10cSrcweir                 aBuf.append( getFormattedString( xNumFormatter, nNumberFormatKey, fabs(m_fLogSlope)) );
186*cdf0e10cSrcweir             }
187*cdf0e10cSrcweir             else
188*cdf0e10cSrcweir             {
189*cdf0e10cSrcweir                 aBuf.append( getFormattedString( xNumFormatter, nNumberFormatKey, m_fLogSlope) );
190*cdf0e10cSrcweir             }
191*cdf0e10cSrcweir             aBuf.append( C2U( " x )" ));
192*cdf0e10cSrcweir         }
193*cdf0e10cSrcweir     }
194*cdf0e10cSrcweir 
195*cdf0e10cSrcweir     return aBuf.makeStringAndClear();
196*cdf0e10cSrcweir }
197*cdf0e10cSrcweir 
198*cdf0e10cSrcweir } //  namespace chart
199