diff options
Diffstat (limited to 'source/ca-valencia/helpcontent2/source/text/schart/01.po')
| -rw-r--r-- | source/ca-valencia/helpcontent2/source/text/schart/01.po | 406 |
1 files changed, 299 insertions, 107 deletions
diff --git a/source/ca-valencia/helpcontent2/source/text/schart/01.po b/source/ca-valencia/helpcontent2/source/text/schart/01.po index 99c38efe107..4274d65b8cc 100644 --- a/source/ca-valencia/helpcontent2/source/text/schart/01.po +++ b/source/ca-valencia/helpcontent2/source/text/schart/01.po @@ -3,19 +3,19 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE 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:13+0000\n" -"Last-Translator: system user <>\n" +"POT-Creation-Date: 2016-11-09 14:10+0100\n" +"PO-Revision-Date: 2016-03-09 23:37+0000\n" +"Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" "Language: ca-valencia\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-Accelerator-Marker: ~\n" +"X-Generator: LibreOffice\n" "X-Language: ca-XV\n" -"X-POOTLE-MTIME: 1449835991.000000\n" +"X-POOTLE-MTIME: 1457566640.000000\n" #: 03010000.xhp msgctxt "" @@ -1270,8 +1270,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>càlcul;corbes de regressió</bookmark_value><bookmark_value>corbes de regressió en diagrames</bookmark_value><bookmark_value>línies de tendència en diagrames</bookmark_value><bookmark_value>línies de valor mitjà en diagrames</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 "" @@ -1286,8 +1286,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=\".\">Podeu afegir línies de tendència a tots els tipus de diagrama 2D, excepte als diagrames de sectors i als diagrames de borsa.</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 "" @@ -1324,6 +1324,78 @@ msgstr "<ahelp hid=\".\" visibility=\"hidden\">Es mostra una línia de tendènci #: 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>" @@ -1340,58 +1412,58 @@ msgstr "<ahelp hid=\".\" visibility=\"hidden\">Mostra el coeficient de determina #: 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 "Si inseriu una línia de tendència en un tipus de diagrama que utilitze categories, com ara <emph>Línia </emph> o <emph>Columna</emph>, els nombres 1, 2, 3, <emph>...</emph> s'utilitzaran com a valors X per calcular la línia de tendència." +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 "Per inserir línies de tendència per a totes les sèries de dades, feu doble clic al diagrama per entrar al mode d'edició. Trieu <item type=\"menuitem\">Insereix - Línies de tendència</item> i seleccioneu un tipus de línia de tendència entre Cap, Lineal, Logarítmica, Exponencial o Potencial." +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 "Per inserir una línia de tendència per a una sola sèrie de dades, seleccioneu la sèrie de dades del diagrama, feu clic amb el botó dret del ratolí per obrir-ne el menú contextual i seleccioneu <item type=\"menuitem\">Insereix - Línia de tendència</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 "Per suprimir una línia de tendència simple o una línia de valor mitjà, feu clic a la línia i premeu la tecla Supr." +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 "Per suprimir totes les línies de tendència, trieu <item type=\"menuitem\">Insereix - Línies de tendència</item> i a continuació seleccioneu <emph>Cap</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 "Es mostra una línia de tendència a la llegenda de manera automàtica." +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=\".\">Les línies de valor mitjà són línies de tendència especials que mostren el valor mitjà. Utilitzeu <item type=\"menuitem\">Insereix - Línies de valor mitjà</item> per inserir línies de valor mitjà per a totes les sèries de dades.</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 "" @@ -1404,50 +1476,178 @@ msgstr "La línia de tendència és del mateix color que la sèrie de dades corr #: 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=\".\">Per mostrar l'equació de la línia de tendència, seleccioneu la línia de tendència en el diagrama, feu clic amb el botó dret del ratolí per obrir el menú contextual i trieu <emph>Insereix l'equació de la línia de tendència</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 "Quan el diagrama està en mode d'edició, el %PRODUCTNAME vos proporciona l'equació de la línia de tendència i el coeficient de determinació R². Feu clic a la línia de tendència per visualitzar la informació a la barra d'estat." +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 "Per a un diagrama de categories (per exemple, un diagrama de línies) la informació de la línia de tendència es calcula mitjançant nombres 1, 2, 3... com a valors X. Este fet també es produeix si les sèries de dades utilitzen altres nombres com a noms per als valors X. Per a esta mena de diagrames poden ser més adequats els diagrames de tipus XY." +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 "Per mostrar l'equació i el coeficient de determinació, seleccioneu la línia de tendència i trieu <item type=\"menuitem\">Format - Formata la selecció - Equació</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\">Activeu Mostra l'equació per visualitzar l'equació de la línia de tendència.</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\">Activeu Mostra el coeficient de determinació per visualitzar el coeficient de determinació de la línia de tendència.</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 "Restriccions" + +#: 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 "El càlcul de la línia de tendència només té en compte els parells de dades que disposin dels valors següents:" + +#: 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 "És recomanable que transformeu les dades d'acord amb estes indicacions; el millor és treballar amb una còpia de les dades originals i transformar estes dades copiades." + +#: 04050100.xhp +msgctxt "" +"04050100.xhp\n" +"hd_id180820161528021520\n" +"help.text" +msgid "Calculate Parameters in Calc" +msgstr "" #: 04050100.xhp msgctxt "" @@ -1502,32 +1702,32 @@ msgctxt "" "04050100.xhp\n" "par_id9244361\n" "help.text" -msgid "r² = RSQ(Data_Y;Data_X)" -msgstr "r² = RQUAD(Dades_Y;Dades_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 "A més de m, b i r², la funció de matriu <emph>ESTLIN</emph> proporciona estadístiques addicionals per a una anàlisi de la regressió." +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 "Equació de regressió logarítmica" +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 "La <emph>regressió logarítmica</emph> segueix l'equació <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 "" @@ -1550,8 +1750,8 @@ msgctxt "" "04050100.xhp\n" "par_id5649281\n" "help.text" -msgid "r² = RSQ(Data_Y;LN(Data_X))" -msgstr "r² = RQUAD(Dades_Y;LN(Dades_X))" +msgid "r<sup>2</sup> = RSQ(Data_Y;LN(Data_X))" +msgstr "" #: 04050100.xhp msgctxt "" @@ -1622,16 +1822,16 @@ msgctxt "" "04050100.xhp\n" "par_id5437177\n" "help.text" -msgid "r² = RSQ(LN(Data_Y);Data_X)" -msgstr "r² = RQUAD(LN(Dades_Y);Dades_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 "A més de m, b i r² la funció de matriu ESTLOG proporciona estadístiques addicionals per a l'anàlisi de la regressió." +msgid "Besides m, b and r<sup>2</sup> the array function LOGEST provides additional statistics for a regression analysis." +msgstr "" #: 04050100.xhp msgctxt "" @@ -1670,112 +1870,104 @@ msgctxt "" "04050100.xhp\n" "par_id2357249\n" "help.text" -msgid "r² = RSQ(LN(Data_Y);LN(Data_X))" -msgstr "r² = RQUAD(LN(Dades_Y);LN(Dades_X))" - -#: 04050100.xhp -msgctxt "" -"04050100.xhp\n" -"hd_id9204077\n" -"help.text" -msgid "Constraints" -msgstr "Restriccions" +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 "El càlcul de la línia de tendència només té en compte els parells de dades que disposin dels valors següents:" +msgid "The polynomial regression equation" +msgstr "Equació de regressió polinòmica" #: 04050100.xhp msgctxt "" "04050100.xhp\n" -"par_id7212744\n" +"par_id8918729\n" "help.text" -msgid "logarithm regression: only positive x-values are considered," -msgstr "regressió logarítmica: només té en compte valors X positius," +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 "regressió exponencial: només es tenen en compte els valors Y positius," +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 "regressió potencial: només es tenen en compte els valors X positius i els valors Y positius." +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 "És recomanable que transformeu les dades d'acord amb estes indicacions; el millor és treballar amb una còpia de les dades originals i transformar estes dades copiades." +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 "La primera fila del resultat d'ESTLIN conté els coeficients de la regressió polinòmica, en què el coeficient de xⁿ es troba a la posició de més a l'esquerra." #: 04050100.xhp msgctxt "" "04050100.xhp\n" -"hd_id7907040\n" +"par_id8202154\n" "help.text" -msgid "The polynomial regression equation" -msgstr "Equació de regressió polinòmica" +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 "No és possible afegir una corba de <emph>regressió polinòmica</emph> de manera automàtica, sinó que heu de calcular esta corba de manera manual." +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 "Creeu una taula amb les columnes x, x², x³, … , xⁿ, y fins al grau n desitjat." +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 "Utilitzeu la fórmula <item type=\"literal\">=ESTLIN(Dades_Y,Dades_X)</item> amb l'interval complet x a xⁿ (sense encapçalaments) com a Dades_X." +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 "La primera fila del resultat d'ESTLIN conté els coeficients de la regressió polinòmica, en què el coeficient de xⁿ es troba a la posició de més a l'esquerra." +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 "El primer element de la tercera línia del resultat d'ESTLIN és el valor de r². Vegeu la funció <link href=\"text/scalc/01/04060107.xhp#Section8\">ESTLIN</link> per conèixer-ne més detalls i altres paràmetres." +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\">Pestanya Barres d'error a les Y</link>" +msgid "<link href=\"text/scalc/01/04060181.xhp#rsq\">RSQ</link> function" +msgstr "" #: 04060000.xhp msgctxt "" |