Issue 78442 - Show formula and r^2 value of regression curve in status bar and quick help
Summary: Show formula and r^2 value of regression curve in status bar and quick help
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL: http://specs.openoffice.org/chart/Cha...
Keywords:
Depends on:
Blocks:
 
Reported: 2007-06-14 10:53 UTC by bjoern.milcke
Modified: 2013-02-24 21:19 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Patch for showing the formula and r squared value of a trend line (3.47 KB, patch)
2007-06-14 10:55 UTC, bjoern.milcke 		no flags Details | Diff
Screen shot of how it would look (16.48 KB, image/png)
2007-06-14 10:56 UTC, bjoern.milcke 		no flags Details
TCS (1.95 KB, text/html)
2007-06-26 12:54 UTC, kla 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description bjoern.milcke 2007-06-14 10:53:10 UTC 
For regression curves the formula and R^2 value (R is the correlation
coefficient of the regression) is currently not visible to the user (see Issue
7998).

To see these parameters it would be nice to show them in the status bar when the
regression curve (aka trend line) is selected. It can also be displayed in the
quick help, when a user moves the mouse over the curve.

For an impression see the attached screen shot that was taken after applying the
attached patch.
Comment 1 bjoern.milcke 2007-06-14 10:55:13 UTC 
Created attachment 45899 [details]
Patch for showing the formula and r squared value of a trend line
Comment 2 bjoern.milcke 2007-06-14 10:56:37 UTC 
Created attachment 45900 [details]
Screen shot of how it would look
Comment 3 bjoern.milcke 2007-06-14 11:01:15 UTC 
-> mmp: What do you think about this enhancement? It helps those people waiting
for Issue 7998, who only want to know the values. It doesn't help for showing
the formula in a print-out, though.

The question is, if we want to separate the formula and R^2 value by comma or
some other separator. It would be nice if we could avoid a localization.

I also had the idea to put the formula and R^2 in different boxes in the status
bar, but there are technical problems with different status bars. Only
alternative would be to have the sections for the formula and R^2 for all
objects, not only regression curves.
Comment 4 vabijou 2007-06-15 06:10:37 UTC 
This would be better than nothing for now.  Please don't implement this INSTEAD 
of a real solution to Issue 7998, but implementing this patch ASAP would 
certainly help.  I would recommend that in the final implementation of Issue 
7998, the method discussed here should still exist whenever the user elects to 
place a regression curve without displaying the function and r^2 value on the 
chart.  In other words, give the users who want the info on the chart their 
option, but those that just want the info without cluttering the chart could 
still use this technique.

Thanks for working on this.
Comment 5 bjoern.milcke 2007-06-20 14:42:47 UTC 
In progress
Comment 6 bjoern.milcke 2007-06-20 22:43:55 UTC 
Fixed in CWS chart06.

See Object naming spec (field URL) for the string
STR_OBJECT_CURVE_WITH_PARAMETERS used for the status bar text and the extended
tip help for regression curves.
Comment 7 bjoern.milcke 2007-06-25 15:32:14 UTC 
Please verify in CWS chart06.
Comment 8 bjoern.milcke 2007-06-25 15:32:50 UTC 
... and now with setting a new owner ...
Comment 9 kla 2007-06-26 12:54:18 UTC 
verified in cws chart06, TCS written.
Comment 10 kla 2007-06-26 12:54:56 UTC 
Created attachment 46250 [details]
TCS
Comment 11 kla 2007-07-11 08:20:59 UTC 
seen ok in the current master -> closed
Comment 12 dudson 2007-08-02 17:50:11 UTC 
Also R value please, it's useful for comparing for educational purposes