update translations for 5.3.0 beta2

and force-fix errors using pocheck

Change-Id: I50100798b84da2969535c4f558dd60463b30108e

1 files changed, 299 insertions, 107 deletions

diff --git a/source/fi/helpcontent2/source/text/schart/01.po b/source/fi/helpcontent2/source/text/schart/01.po
index b0665957c3b..43a7265ec20 100644
--- a/source/fi/helpcontent2/source/text/schart/01.po
+++ b/source/fi/helpcontent2/source/text/schart/01.po
@@ -3,18 +3,18 @@ msgid ""
 msgstr ""
 "Project-Id-Version: \n"
 "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2016-03-09 20:48+0100\n"
-"PO-Revision-Date: 2015-12-11 12:22+0000\n"
-"Last-Translator: system user <>\n"
+"POT-Creation-Date: 2016-11-09 14:10+0100\n"
+"PO-Revision-Date: 2016-07-06 01:53+0000\n"
+"Last-Translator: Anonymous Pootle User\n"
 "Language-Team: Finnish <discuss@fi.libreoffice.org>\n"
 "Language: fi\n"
 "MIME-Version: 1.0\n"
 "Content-Type: text/plain; charset=UTF-8\n"
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
-"X-Generator: Pootle 2.7\n"
+"X-Generator: LibreOffice\n"
 "X-Accelerator-Marker: ~\n"
-"X-POOTLE-MTIME: 1449836568.000000\n"
+"X-POOTLE-MTIME: 1467770014.000000\n"
 
 #: 03010000.xhp
 msgctxt ""
@@ -1268,8 +1268,8 @@ msgctxt ""
 "04050100.xhp\n"
 "bm_id1744743\n"
 "help.text"
-msgid "<bookmark_value>calculating;regression curves</bookmark_value>      <bookmark_value>regression curves in charts</bookmark_value>      <bookmark_value>trend lines in charts</bookmark_value>      <bookmark_value>mean value lines in charts</bookmark_value>"
-msgstr "<bookmark_value>laskeminen;regressiokäyrät</bookmark_value><bookmark_value>regressiokäyrät kaavioissa</bookmark_value><bookmark_value>trendiviivat kaavioissa</bookmark_value><bookmark_value>keskiarvoviivat kaavioissa</bookmark_value>"
+msgid "<bookmark_value>calculating;regression curves</bookmark_value>  <bookmark_value>regression curves in charts</bookmark_value>  <bookmark_value>trend lines in charts</bookmark_value>  <bookmark_value>mean value lines in charts</bookmark_value>"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
@@ -1284,8 +1284,8 @@ msgctxt ""
 "04050100.xhp\n"
 "par_id7272255\n"
 "help.text"
-msgid "<variable id=\"trendlinestext\"><ahelp hid=\".\">Trend lines can be added to all 2D chart types except for Pie and Stock charts.</ahelp></variable>"
-msgstr "<variable id=\"trendlinestext\"><ahelp hid=\".\">Regressiokäyrät, jotka tunnetaan myös trendiviivoina, voidaan lisätä 2D-kaaviotyyppeihin, paitsi piirakka- ja pörssikaavioihin.</ahelp></variable>"
+msgid "<variable id=\"trendlinestext\"> <ahelp hid=\".\">Trend lines can be added to all 2D chart types except for Pie and Stock charts.</ahelp> </variable>"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
@@ -1322,6 +1322,78 @@ msgstr "<ahelp hid=\".\" visibility=\"hidden\">Piirretään potenssitrendiviiva
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
+"par_id180820161052123210\n"
+"help.text"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">A polynomial trend line is shown with a given degree.</ahelp>"
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id180820161102568315\n"
+"help.text"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Degree of polynomial trend line.</ahelp>"
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id180820161105546053\n"
+"help.text"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">A moving average trend line is shown with a given period.</ahelp>"
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id180820161107537745\n"
+"help.text"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Number of points to calculate average of moving average trend line.</ahelp>"
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id180820161112599880\n"
+"help.text"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Name of trend line in legend.</ahelp>"
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id180820161117252261\n"
+"help.text"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Trend line is extrapolated for higher x-values.</ahelp>"
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id18082016111837138\n"
+"help.text"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Trend line is extrapolated for lower x-values.</ahelp>"
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id180820161124272765\n"
+"help.text"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">For linear, polynomial and exponential trend lines, intercept value is forced to a given value.</ahelp>"
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id180820161126064822\n"
+"help.text"
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Value of intercept if it is forced.</ahelp>"
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
 "par_id8962370\n"
 "help.text"
 msgid "<ahelp hid=\".\" visibility=\"hidden\">Shows the trend line equation next to the trend line.</ahelp>"
@@ -1338,58 +1410,58 @@ msgstr "<ahelp hid=\".\" visibility=\"hidden\">Esitetään selitysaste trendivii
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id8398998\n"
+"par_id180820161133305870\n"
 "help.text"
-msgid "If you insert a trend line to a chart type that uses categories, like <emph>Line </emph>or <emph>Column, </emph>then the numbers 1, 2, 3, <emph>…</emph> are used as x-values to calculate the trend line."
-msgstr "Jos käytetään trendiviivoja kaaviotyyppeihin, joissa käytetään luokittelua, kuten <emph>Viiva </emph>tai <emph>pylväs, </emph> lukuja 1, 2, 3, <emph>…</emph> käytetään x:n arvoina trendiviivaa laskettaessa."
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Name of X variable in trend line equation.</ahelp>"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id5676747\n"
+"par_id180820161134155865\n"
 "help.text"
-msgid "To insert trend lines for all data series, double-click the chart to enter edit mode. Choose <item type=\"menuitem\">Insert - Trend Lines</item>, then select the type of trend line from None, Linear, Logarithmic, Exponential, or Power trend line."
-msgstr "Lisättäessä trendiviivat kaikille arvosarjoille kaksoisnapsautetaan kaaviota muokkaustilaan siirtymiseksi. Valitaan ensin <item type=\"menuitem\">Lisää - Trendiviivat</item> ja valitaan sitten trendiviivan tyyppi: ei mitään, lineaarinen, logaritminen, eksponentiaalinen tai potenssiregressio."
+msgid "<ahelp hid=\".\" visibility=\"hidden\">Name of Y variable in trend line equation.</ahelp>"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id4349192\n"
+"par_id8398998\n"
 "help.text"
-msgid "To insert a trend line for a single data series, select the data series in the chart, right-click to open the context menu, and choose <item type=\"menuitem\">Insert - Trend Line</item>."
-msgstr "Lisättäessä trendiviiva yhdelle arvosarjalle, valitaan sarja kaaviosta, napsautetaan kakkospainikkeella kohdevalikko auki ja valitaan <item type=\"menuitem\">Lisää -Trendiviiva</item>."
+msgid "If you insert a trend line to a chart type that uses categories, like <emph>Line</emph> or <emph>Column</emph>, then the numbers 1, 2, 3, <emph>…</emph> are used as x-values to calculate the trend line. For such charts the XY chart type might be more suitable."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id9337443\n"
+"par_id4349192\n"
 "help.text"
-msgid "To delete a single trend line or mean value line, click the line, then press the Del key."
-msgstr "Yksittäinen trendi- tai keskiarvoviiva poistetaan napsauttamalla viivaa ja painamalla sitten Del-näppäintä."
+msgid "To insert a trend line for a data series, select the data series in the chart. Choose <item type=\"menuitem\">Insert - Trend Lines</item>, or right-click to open the context menu, and choose <item type=\"menuitem\">Insert - Trend Line</item>."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id4529251\n"
+"par_id180820161539033867\n"
 "help.text"
-msgid "To delete all trend lines, choose <item type=\"menuitem\">Insert - Trend Lines</item>, then select <emph>None</emph>."
-msgstr "Kaikki trendiviivat poistetaan valitsemalla ensin <item type=\"menuitem\">Lisää - Trendiviivat</item> ja sitten <emph>Ei mitään</emph>."
+msgid "Mean Value Lines are special trend lines that show the mean value. Use <item type=\"menuitem\">Insert - Mean Value Lines</item> to insert mean value lines for data series."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id296334\n"
+"par_id9337443\n"
 "help.text"
-msgid "A trend line is shown in the legend automatically."
-msgstr "Trendiviivan selite näkyy oletuksena."
+msgid "To delete a trend line or mean value line, click the line, then press the Del key."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id4072084\n"
+"par_id296334\n"
 "help.text"
-msgid "<ahelp hid=\".\">Mean Value Lines are special trend lines that show the mean value. Use <item type=\"menuitem\">Insert - Mean Value Lines</item> to insert mean value lines for data series.</ahelp>"
-msgstr "<ahelp hid=\".\">Keskiarvoviivat ovat erityisiä vaakasuoria trendiviivoja, jotka esittävät arvosarjan keskiarvoa. Käyttämällä valintaa <item type=\"menuitem\">Lisää - Keskiarvoviivat</item> arvosarjoille lisätään oma viivansa.</ahelp>"
+msgid "A trend line is shown in the legend automatically. Its name can be defined in options of the trend line."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
@@ -1402,50 +1474,178 @@ msgstr "Trendiviiva saa aluksi arvosarjansa värin. Viivan ominaisuuksia voi vai
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id846888\n"
+"hd_id180820161534333508\n"
 "help.text"
-msgid "<ahelp hid=\".\">To show the trend line equation, select the trend line in the chart, right-click to open the context menu, and choose <emph>Insert Trend Line Equation</emph>.</ahelp>"
-msgstr "<ahelp hid=\".\">Trendiviivan yhtälön esittäminen tapahtuu niin, että valitaan viiva kaaviosta, avataan kohdevalikko napsauttamalla kakkospainikkeella ja valitaan <emph>Lisää trendiviivan yhtälö</emph>.</ahelp>"
+msgid "Trend Line Equation and Coefficient of Determination"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
 "par_id8962065\n"
 "help.text"
-msgid "When the chart is in edit mode, %PRODUCTNAME gives you the equation of the trend line and the coefficient of determination R². Click on the trend line to see the information in the status bar."
-msgstr "Kaavion muokkaustilassa %PRODUCTNAME antaa trendiviivan yhtälön ja selitysasteen eli korrelaatiokertoimen neliön R². Napsauttamalla trendiviivaa tiedot näkyvät tilarivillä."
+msgid "When the chart is in edit mode, %PRODUCTNAME gives you the equation of the trend line and the coefficient of determination R<sup>2</sup>, even if they are not shown: click on the trend line to see the information in the status bar."
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id846888\n"
+"help.text"
+msgid "<ahelp hid=\".\">To show the trend line equation, select the trend line in the chart, right-click to open the context menu, and choose <item type=\"menuitem\">Insert Trend Line Equation</item>.</ahelp>"
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id8962066\n"
+"help.text"
+msgid "To change format of values (use less significant digits or scientific notation), select the equation in the chart, right-click to open the context menu, and choose <item type=\"menuitem\">Format Trend Line Equation - Numbers</item>."
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id180820161627109994\n"
+"help.text"
+msgid "Default equation uses <item type=\"literal\">x</item> for abscissa variable, and <item type=\"literal\">f(x)</item> for ordinate variable. To change these names, select the trend line, choose <item type=\"menuitem\">Format - Format Selection – Type</item> and enter names in <item type=\"literal\">X Variable Name</item> and <item type=\"literal\">Y Variable Name</item> edit boxes."
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id18082016163702791\n"
+"help.text"
+msgid "To show the coefficient of determination R<sup>2</sup>, select the equation in the chart, right-click to open the context menu, and choose <item type=\"menuitem\">Insert R<sup>2</sup></item>."
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id180820161637028632\n"
+"help.text"
+msgid "If intercept is forced, coefficient of determination R<sup>2</sup> is not calculated in the same way as with free intercept. R<sup>2</sup> values can not be compared with forced or free intercept."
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"hd_id180820161534333509\n"
+"help.text"
+msgid "Trend Lines Curve Types"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id1328470\n"
+"par_id18082016153820777\n"
 "help.text"
-msgid "For a category chart (for example a line chart), the trend line information is calculated using numbers 1, 2, 3, … as x-values. This is also true if your data series uses other numbers as names for the x-values. For such charts the XY chart type might be more suitable."
-msgstr "Luokkakaaviolle (esimerkiksi viivakaavio) regressio lasketaan käyttäen numeroita 1, 2, 3, … x:n arvoina. Sama pätee, jos numerot ovat niminä x-arvoille. Tässä tapauksessa aineistolle voisi sopia XY-kaaviotyyppi paremmin."
+msgid "Following regression types are available:"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id8092593\n"
+"par_id180820161604098009\n"
 "help.text"
-msgid "To show the equation and the coefficient of determination, select the trend line and choose <item type=\"menuitem\">Format - Format Selection - Equation</item>."
-msgstr "Yhtälön ja selitysasteen saa näkyviin, kun valitsee regressiokäyrän ja sitten valitsee <item type=\"menuitem\">Muotoilu - Muotoile valinta - Yhtälö</item>."
+msgid "<emph>Linear</emph> trend line: regression through equation <item type=\"literal\">y=a∙x+b</item>. Intercept <item type=\"literal\">b</item> can be forced."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id7971434\n"
+"par_id180820161612524298\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Enable Show equation to see the equation of the trend line.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Näytä yhtälö -merkein saadaan regressiokäyrän yhtälö näkyviin.</ahelp>"
+msgid "<emph>Polynomial</emph> trend line: regression through equation <item type=\"literal\">y=Σ(a<sub>i</sub>∙x<sup>i</sup>)</item>. Intercept <item type=\"literal\">a<sub>0</sub></item> can be forced. Degree of polynomial must be given (at least 2)."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id558793\n"
+"par_id180820161612525364\n"
 "help.text"
-msgid "<ahelp hid=\".\" visibility=\"hidden\">Enable Show Coefficient of Determination to see the determination coefficient of the trend line.</ahelp>"
-msgstr "<ahelp hid=\".\" visibility=\"hidden\">Näytä korrelaatiokerroin -valinnalla saadaan näkyviin regressiokäyrän selitysaste.</ahelp>"
+msgid "<emph>Logarithmic</emph> trend line: regression through equation <item type=\"literal\">y=a∙ln(x)+b</item>."
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id180820161612526680\n"
+"help.text"
+msgid "<emph>Exponential</emph> trend line: regression through equation <item type=\"literal\">y=b∙exp(a∙x)</item>.This equation is equivalent to <item type=\"literal\">y=b∙m<sup>x</sup></item> with <item type=\"literal\">m=exp(a)</item>. Intercept <item type=\"literal\">b</item> can be forced."
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id180820161612527230\n"
+"help.text"
+msgid "<emph>Power</emph> trend line: regression through equation <item type=\"literal\">y=b∙x<sup>a</sup></item>."
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id180820161617342768\n"
+"help.text"
+msgid "<emph>Moving average</emph> trend line: simple moving average is calculated with the <emph>n</emph> previous y-values, <emph>n</emph> being the period. No equation is available for this trend line."
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"hd_id9204077\n"
+"help.text"
+msgid "Constraints"
+msgstr "Rajoitukset"
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id7393719\n"
+"help.text"
+msgid "The calculation of the trend line considers only data pairs with the following values:"
+msgstr "Trendiviivan laskuissa huomioidaan arvopareja vain seuraavilla arvoilla:"
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id7212744\n"
+"help.text"
+msgid "Logarithmic trend line: only positive x-values are considered."
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id1664479\n"
+"help.text"
+msgid "Exponential trend line: only positive y-values are considered, except if all y-values are negative: regression will then follow equation <item type=\"literal\">y=-b∙exp(a∙x)</item>."
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id8734702\n"
+"help.text"
+msgid "Power trend line: only positive x-values are considered; only positive y-values are considered, except if all y-values are negative: regression will then follow equation<item type=\"literal\"> y=-b∙x<sup>a</sup></item>."
+msgstr ""
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"par_id181279\n"
+"help.text"
+msgid "You should transform your data accordingly; it is best to work on a copy of the original data and transform the copied data."
+msgstr "Aineisto pitää muuntaa vastaavasti. Paras tapa on ottaa kopio alkuperäisestä aineistosta ja muuntaa kopioitua aineistoa."
+
+#: 04050100.xhp
+msgctxt ""
+"04050100.xhp\n"
+"hd_id180820161528021520\n"
+"help.text"
+msgid "Calculate Parameters in Calc"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
@@ -1500,32 +1700,32 @@ msgctxt ""
 "04050100.xhp\n"
 "par_id9244361\n"
 "help.text"
-msgid "r² = RSQ(Data_Y;Data_X)"
-msgstr "r² = RSQ(tiedot_Y;tiedot_X)"
+msgid "r<sup>2</sup> = RSQ(Data_Y;Data_X)"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
 "par_id2083498\n"
 "help.text"
-msgid "Besides m, b and r² the array function <emph>LINEST</emph> provides additional statistics for a regression analysis."
-msgstr "Matriisi- tai taulukkofunktio <emph>LINEST</emph> laskee arvojen m, b ja r² lisäksi muitakin regressioanalyysin tunnuslukuja."
+msgid "Besides m, b and r<sup>2</sup> the array function <emph>LINEST</emph> provides additional statistics for a regression analysis."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
 "hd_id2538834\n"
 "help.text"
-msgid "The logarithm regression equation"
-msgstr "Logaritminen regressioyhtälö"
+msgid "The logarithmic regression equation"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
 "par_id394299\n"
 "help.text"
-msgid "The <emph>logarithm regression</emph> follows the equation <item type=\"literal\">y=a*ln(x)+b</item>."
-msgstr "<emph>Logaritminen regressio</emph> noudattaa yhtälöä <item type=\"literal\">y=a*ln(x)+b</item>."
+msgid "The <emph>logarithmic regression</emph> follows the equation <item type=\"literal\">y=a*ln(x)+b</item>."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
@@ -1548,8 +1748,8 @@ msgctxt ""
 "04050100.xhp\n"
 "par_id5649281\n"
 "help.text"
-msgid "r² = RSQ(Data_Y;LN(Data_X))"
-msgstr "r² = RSQ(tiedot_Y;LN(tiedot_X))"
+msgid "r<sup>2</sup> = RSQ(Data_Y;LN(Data_X))"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
@@ -1620,16 +1820,16 @@ msgctxt ""
 "04050100.xhp\n"
 "par_id5437177\n"
 "help.text"
-msgid "r² = RSQ(LN(Data_Y);Data_X)"
-msgstr "r² = RSQ(LN(tiedot_Y);tiedot_X)"
+msgid "r<sup>2</sup> = RSQ(LN(Data_Y);Data_X)"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
 "par_id6946317\n"
 "help.text"
-msgid "Besides m, b and r² the array function LOGEST provides additional statistics for a regression analysis."
-msgstr "Matriisi- tai taulukkofunktio LOGEST laskee arvojen m, b ja r² lisäksi muitakin regressioanalyysin tunnuslukuja."
+msgid "Besides m, b and r<sup>2</sup> the array function LOGEST provides additional statistics for a regression analysis."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
@@ -1668,112 +1868,104 @@ msgctxt ""
 "04050100.xhp\n"
 "par_id2357249\n"
 "help.text"
-msgid "r² = RSQ(LN(Data_Y);LN(Data_X))"
-msgstr "r² = RSQ(LN(tiedot_Y);LN(tiedot_X))"
-
-#: 04050100.xhp
-msgctxt ""
-"04050100.xhp\n"
-"hd_id9204077\n"
-"help.text"
-msgid "Constraints"
-msgstr "Rajoitukset"
+msgid "r<sup>2</sup> = RSQ(LN(Data_Y);LN(Data_X))"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id7393719\n"
+"hd_id7907040\n"
 "help.text"
-msgid "The calculation of the trend line considers only data pairs with the following values:"
-msgstr "Trendiviivan laskuissa huomioidaan arvopareja vain seuraavilla arvoilla:"
+msgid "The polynomial regression equation"
+msgstr "Polynomiregression yhtälö"
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id7212744\n"
+"par_id8918729\n"
 "help.text"
-msgid "logarithm regression: only positive x-values are considered,"
-msgstr "logaritminen regressio: vain positiiviset x:n arvot huomioidaan,"
+msgid "For <emph>polynomial regression</emph> curves a transformation to a linear model takes place."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id1664479\n"
+"par_id33875\n"
 "help.text"
-msgid "exponential regression: only positive y-values are considered,"
-msgstr "eksponentiaalinen regressio: vain positiiviset y:n arvot huomioidaan,"
+msgid "Create a table with the columns x, x<sup>2</sup>, x<sup>3</sup>, … , x<sup>n</sup>, y up to the desired degree n."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id8734702\n"
+"par_id8720053\n"
 "help.text"
-msgid "power regression: only positive x-values and positive y-values are considered."
-msgstr "potenssiregressio: vain positiiviset x:n arvot ja positiiviset y:n arvot huomioidaan."
+msgid "Use the formula <item type=\"literal\">=LINEST(Data_Y,Data_X)</item> with the complete range x to x<sup>n</sup> (without headings) as Data_X."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id181279\n"
+"par_id5068514\n"
 "help.text"
-msgid "You should transform your data accordingly; it is best to work on a copy of the original data and transform the copied data."
-msgstr "Aineisto pitää muuntaa vastaavasti. Paras tapa on ottaa kopio alkuperäisestä aineistosta ja muuntaa kopioitua aineistoa."
+msgid "The first row of the LINEST output contains the coefficients of the regression polynomial, with the coefficient of xⁿ at the leftmost position."
+msgstr "Ensimmäinen rivi LINEST-tuloksessa esittää regressiopolynomin kertoimet alenevin potenssein, niin että xⁿ:n on ensimmäisenä vasemmalla."
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"hd_id7907040\n"
+"par_id8202154\n"
 "help.text"
-msgid "The polynomial regression equation"
-msgstr "Polynomiregression yhtälö"
+msgid "The first element of the third row of the LINEST output is the value of r<sup>2</sup>. See the <link href=\"text/scalc/01/04060107.xhp#Section8\">LINEST</link> function for details on proper use and an explanation of the other output parameters."
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id8918729\n"
+"par_id4562211\n"
 "help.text"
-msgid "A <emph>polynomial regression</emph> curve cannot be added automatically. You must calculate this curve manually."
-msgstr "Ohjelma ei lisää <emph>Polynomiregression</emph> kuvaajaa omatoimisesti. Käyttäjän pitää huolehtia kuvaajan laskemisesta."
+msgid "<link href=\"text/schart/01/04050000.xhp\">X/Y Error Bars</link>"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id33875\n"
+"par_id4562212\n"
 "help.text"
-msgid "Create a table with the columns x, x², x³, … , xⁿ, y up to the desired degree n."
-msgstr "Luodaan taulukko, jossa on sarakkeet x, x², x³, … , xⁿ, y haluttuun astelukuun n asti."
+msgid "<link href=\"text/scalc/01/04060107.xhp#Section8\">LINEST</link> function"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id8720053\n"
+"par_id4562216\n"
 "help.text"
-msgid "Use the formula <item type=\"literal\">=LINEST(Data_Y,Data_X)</item> with the complete range x to xⁿ (without headings) as Data_X."
-msgstr "Käytetään lauseketta <item type=\"literal\">=LINEST(tiedot_Y,tiedot_X)</item> koko alueen x:stä xⁿ:ään (ei otsikoita) toimiessa tiedot_X:nä."
+msgid "<link href=\"text/scalc/01/04060107.xhp#Section7\">LOGEST</link> function"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id5068514\n"
+"par_id4562213\n"
 "help.text"
-msgid "The first row of the LINEST output contains the coefficients of the regression polynomial, with the coefficient of xⁿ at the leftmost position."
-msgstr "Ensimmäinen rivi LINEST-tuloksessa esittää regressiopolynomin kertoimet alenevin potenssein, niin että xⁿ:n on ensimmäisenä vasemmalla."
+msgid "<link href=\"text/scalc/01/04060185.xhp#slope\">SLOPE</link> function"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id8202154\n"
+"par_id4562214\n"
 "help.text"
-msgid "The first element of the third row of the LINEST output is the value of r². See the <link href=\"text/scalc/01/04060107.xhp#Section8\">LINEST</link> function for details on proper use and an explanation of the other output parameters."
-msgstr "Kolmannen rivin ensimmäinen alkio LINEST-funktion tulomatriisissa on r²-arvo. Katso <link href=\"text/scalc/01/04060107.xhp#Section8\">LINEST</link>-funktion yksityiskohdat oikeaa käyttöä ja muiden tulosparametrien selitystä varten."
+msgid "<link href=\"text/scalc/01/04060181.xhp#intercept\">INTERCEPT</link> function"
+msgstr ""
 
 #: 04050100.xhp
 msgctxt ""
 "04050100.xhp\n"
-"par_id4562211\n"
+"par_id4562215\n"
 "help.text"
-msgid "<link href=\"text/schart/01/04050000.xhp\">Y Error Bars tab page</link>"
-msgstr "<link href=\"text/schart/01/04050000.xhp\">Y-virhepalkin välilehti</link>"
+msgid "<link href=\"text/scalc/01/04060181.xhp#rsq\">RSQ</link> function"
+msgstr ""
 
 #: 04060000.xhp
 msgctxt ""