Bug 70673

Summary: EDITING: More regression functions
Product: LibreOffice Reporter: fldrivers
Component: ChartAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: enhancement    
Priority: lowest CC: jmadero.dev
Version: 4.1.2.3 release   
Hardware: All   
OS: All   
Whiteboard: BSA
i915 platform: i915 features:
Attachments: Test file as described

Description fldrivers 2013-10-20 14:23:33 UTC
Created attachment 87879 [details]
Test file as described

Problem description: Add (now they are only linear, logarithm, exponential and power functions) and correct regression functions.

Steps to reproduce:
1. Have rising power function in testing file and only negative the sign to correct function from NaN to better.

Expected behavior: As data with oposite sign

Add polynomial function https://en.wikipedia.org/wiki/Polynomial and
Operating System: Windows 7
Version: 4.1.2.3 release
Comment 1 Tomaz Vajngerl 2013-10-21 21:00:29 UTC
Polynomial regression will be available in 4.2
As for power function I tried in excel and gnumeric and both also couldn't handle series 2 power function.
Comment 2 Owen Genat 2013-11-23 10:46:51 UTC
This is an enhancement request. Severity set to enhancement. Platform set to All/All. Further details in relation to comment #1 include https://wiki.documentfoundation.org/ReleaseNotes/4.2#Chart which indicates that bug 35712 is implementing polynomial regression.

In order for this enhancement request to be confirmed, please edit the summary to be clear about the specific regression model required (preferably one per bug) and provide links in a comment indicating the model. It is not clear from the description what a "rising power function" is i.e., is a specific function indicated here, or a family of functions? Do any of the links in the right-hand sidebar of https://en.wikipedia.org/wiki/Regression_analysis list the required function / model?

Thanks.
Comment 3 fldrivers 2013-11-26 19:27:01 UTC
For adding regression funcions is sufficient polynomial regression which will be available in 4.2.

But for function in attached file I'm expecting regression with power function (https://en.wikipedia.org/wiki/Power_function or https://cs.wikipedia.org/wiki/Mocninná_funkce), where exponent is -0.92 and constant is -213.1. Data in column A is time (which cannot be negative), column B is measured value (discharging capacitor current in amperes), column C is measured value converted to pA and column D is column C with opposite sign. Expected expression is -213.1 x ^ -0,92 from cx^r . Its not big problem because I can think negative constant c. But solution can be helpful.

Thanks
Comment 4 Joel Madero 2013-12-22 17:15:46 UTC
Thank you for reporting this enhancement request! I can confirm that this is a valid enhancement request on:
Version: 4.3.0.0.alpha0+Build ID: daa57a101a20e0b37db7090796ad002b8d192b9b
Date:   Sun Dec 15 23:07:57 2013 +0100 
Platform: Ubuntu Linux 13.10 x64
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 
As I've been able to confirm the enhancement request I am marking as:

New (confirmed)
Enhancement
Lowest - not going to be incredibly useful for the vast majority of our users but a valid request none the less


+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 
LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link:
https://wiki.documentfoundation.org/QA/BugTriage

There are also other ways to get involved including with marketing, UX, documentation, and of course developing -  http://www.libreoffice.org/get-help/mailing-lists/. 

Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.