Difference between revisions of "Chart2/TrendLines"
From Apache OpenOffice Wiki
< Chart2
Tonygalmiche (Talk | contribs) (→Trend line for X) |
B michaelsen (Talk | contribs) |
||
(6 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
− | |||
− | |||
== Add polynomial regression type == | == Add polynomial regression type == | ||
− | [[Image: | + | [[Image:Chart2_TrendLines01.png]] |
* Different types of regression lines are already offered: linear regression, exponential regression. But a polynomial regression curve is still missing. A macro on this site offers a workaround (french only): | * Different types of regression lines are already offered: linear regression, exponential regression. But a polynomial regression curve is still missing. A macro on this site offers a workaround (french only): | ||
* http://oooconv.free.fr/fitoo/fitoo_fr.html | * http://oooconv.free.fr/fitoo/fitoo_fr.html | ||
Line 12: | Line 7: | ||
== Allow more than one regression line for one series == | == Allow more than one regression line for one series == | ||
− | [[Image: | + | [[Image:Chart2_TrendLines02.png]] |
* covered in http://www.openoffice.org/issues/show_bug.cgi?id=64813 | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=64813 | ||
== Extrapolating of trend lines == | == Extrapolating of trend lines == | ||
− | [[Image: | + | [[Image:Chart2_TrendLines03.png]] |
* Trend lines should also allow extrapolating. If data ranges from 1 to 5 but that x axes range from -2 to 10, then the trend line should display from -2 to +10. | * Trend lines should also allow extrapolating. If data ranges from 1 to 5 but that x axes range from -2 to 10, then the trend line should display from -2 to +10. | ||
* In Excel, the setting is called forward forecast and backward forecast. | * In Excel, the setting is called forward forecast and backward forecast. | ||
Line 24: | Line 19: | ||
== Mean value for X and center of gravity == | == Mean value for X and center of gravity == | ||
− | [[Image: | + | [[Image:Chart2_TrendLines04.png]] |
* Get the mean value not only for Y but also for X. A special symbol could mark the intersection point (the center of gravity). | * Get the mean value not only for Y but also for X. A special symbol could mark the intersection point (the center of gravity). | ||
* covered in http://www.openoffice.org/issues/show_bug.cgi?id=64816 | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=64816 | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
== Error bar for X == | == Error bar for X == | ||
− | |||
* Error bar for X added to the existent Y one | * Error bar for X added to the existent Y one | ||
− | * covered in http://www.openoffice.org/issues/show_bug.cgi?id= | + | * covered in http://www.openoffice.org/issues/show_bug.cgi?id=42946 |
− | + | [[Category:Chart2]] | |
− | + | ||
− | + | ||
− | [[ | + | |
− | + | ||
− | + |
Latest revision as of 09:23, 25 November 2009
Contents
Add polynomial regression type
- Different types of regression lines are already offered: linear regression, exponential regression. But a polynomial regression curve is still missing. A macro on this site offers a workaround (french only):
- http://oooconv.free.fr/fitoo/fitoo_fr.html
- covered in http://www.openoffice.org/issues/show_bug.cgi?id=20819
Allow more than one regression line for one series
Extrapolating of trend lines
- Trend lines should also allow extrapolating. If data ranges from 1 to 5 but that x axes range from -2 to 10, then the trend line should display from -2 to +10.
- In Excel, the setting is called forward forecast and backward forecast.
- covered in http://www.openoffice.org/issues/show_bug.cgi?id=5085
Mean value for X and center of gravity
- Get the mean value not only for Y but also for X. A special symbol could mark the intersection point (the center of gravity).
- covered in http://www.openoffice.org/issues/show_bug.cgi?id=64816
Error bar for X
- Error bar for X added to the existent Y one
- covered in http://www.openoffice.org/issues/show_bug.cgi?id=42946