diff options
Diffstat (limited to 'source/text/scalc/01/04060107.xhp')
| -rw-r--r-- | source/text/scalc/01/04060107.xhp | 52 |
1 files changed, 26 insertions, 26 deletions
diff --git a/source/text/scalc/01/04060107.xhp b/source/text/scalc/01/04060107.xhp index 51e44773d9..a0d00beda1 100644 --- a/source/text/scalc/01/04060107.xhp +++ b/source/text/scalc/01/04060107.xhp @@ -365,16 +365,16 @@ <paragraph id="hd_id3158446" role="heading" level="2" xml-lang="en-US">MUNIT</paragraph> <paragraph id="par_id3154121" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_EINHEITSMATRIX">Returns the unitary square array of a certain size.</ahelp> The unitary array is a square array where the main diagonal elements equal 1 and all other array elements are equal to 0.</paragraph> -<paragraph id="hd_id3155123" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3156271" role="code" xml-lang="en-US">MUNIT(Dimensions)</paragraph> <paragraph id="par_id3159390" role="paragraph" xml-lang="en-US"><emph>Dimensions</emph> refers to the size of the array unit.</paragraph> <paragraph id="par_idN10C9B" role="note" xml-lang="en-US">You can find a general introduction to Array functions at the top of this page.</paragraph> -<paragraph id="hd_id3156162" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3150949" role="paragraph" xml-lang="en-US">Select a square range within the spreadsheet, for example, from A1 to E5.</paragraph> <paragraph id="par_id3151260" role="paragraph" xml-lang="en-US">Without deselecting the range, select the MUNIT function. Mark the <emph>Array</emph> check box. Enter the desired dimensions for the array unit, in this case <item type="input">5</item>, and click <emph>OK</emph>.</paragraph> -<paragraph id="par_id3150403" role="paragraph" xml-lang="en-US">You can also enter the <item type="input">=Munit(5)</item> formula in the last cell of the selected range (E5), and press <switchinline select="sys"><caseinline select="MAC">Shift+Command+Enter -</caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline>.</paragraph> +<paragraph id="par_id3150403" role="paragraph" xml-lang="en-US">You can also enter the <item type="input">=Munit(5)</item> formula in the last cell of the selected range (E5), and press <switchinline select="sys"><caseinline select="MAC"><item type="keycode">Shift+Command+Enter</item> + </caseinline><defaultinline><item type="keycode">Shift+Ctrl+Enter</item></defaultinline></switchinline>.</paragraph> <paragraph id="par_id3156143" role="paragraph" xml-lang="en-US">You now see a unit array with a range of A1:E5.</paragraph> <paragraph id="par_idN10FA7" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph> </section> @@ -389,13 +389,13 @@ <paragraph id="hd_id3159084" role="heading" level="2" xml-lang="en-US">FREQUENCY</paragraph> <paragraph id="par_id3145777" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_HAEUFIGKEIT">Indicates the frequency distribution in a one-column-array.</ahelp> The function counts the number of values in the Data array that are within the values given by the Classes array.</paragraph> -<paragraph id="hd_id3153347" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3155498" role="code" xml-lang="en-US">FREQUENCY(Data; Classes)</paragraph> <paragraph id="par_id3154352" role="paragraph" xml-lang="en-US"><emph>Data</emph> represents the reference to the values to be counted.</paragraph> <paragraph id="par_id3148402" role="paragraph" xml-lang="en-US"><emph>Classes</emph> represents the array of the limit values.</paragraph> <paragraph id="par_idN10D71" role="note" xml-lang="en-US">You can find a general introduction to Array functions at the top of this page.</paragraph> -<paragraph id="hd_id3148981" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3155904" role="paragraph" xml-lang="en-US">In the following table, column A lists unsorted measurement values. Column B contains the upper limit you entered for the classes into which you want to divide the data in column A. According to the limit entered in B1, the FREQUENCY function returns the number of measured values less than or equal to 5. As the limit in B2 is 10, the FREQUENCY function returns the second result as the number of measured values that are greater than 5 and less than or equal to 10. The text you entered in B6, ">25", is only for reference purposes.<comment>i77461: replace old text: As the limit in B2 is 10, the FREQUENCY function returns the second result as the number of measured values that are greater than 5 or greater than or equal to 10.</comment></paragraph><comment>UFI: replace table by picture</comment> <table id="tbl_id3150680"> @@ -573,7 +573,7 @@ <paragraph id="hd_id3151030" role="heading" level="2" xml-lang="en-US">MDETERM</paragraph> <paragraph id="par_id3154073" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_MDET">Returns the array determinant of an array.</ahelp> This function returns a value in the current cell; it is not necessary to define a range for the results.</paragraph> -<paragraph id="hd_id3156366" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3156380" role="code" xml-lang="en-US">MDETERM(Array)</paragraph> <paragraph id="par_id3150290" role="paragraph" xml-lang="en-US"><emph>Array</emph> represents a square array in which the determinants are defined.</paragraph> <paragraph id="par_idN11635" role="note" xml-lang="en-US">You can find a general introduction to using Array functions on top of this page.</paragraph> @@ -591,12 +591,12 @@ <paragraph id="hd_id3151348" role="heading" level="2" xml-lang="en-US">MINVERSE</paragraph> <paragraph id="par_id3145569" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_MINV">Returns the inverse array.</ahelp></paragraph> -<paragraph id="hd_id3156072" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3156085" role="code" xml-lang="en-US">MINVERSE(Array)</paragraph> <paragraph id="par_id3157849" role="paragraph" xml-lang="en-US"><emph>Array</emph> represents a square array that is to be inverted.</paragraph> <paragraph id="par_idN113EE" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph> -<paragraph id="hd_id3157868" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3149638" role="paragraph" xml-lang="en-US">Select a square range and select MINVERSE. Select the output array, select the <emph>Array</emph> field and click <emph>OK</emph>.</paragraph> </section> @@ -610,13 +610,13 @@ <paragraph id="hd_id3148546" role="heading" level="2" xml-lang="en-US">MMULT</paragraph> <paragraph id="par_id3148518" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_MMULT">Calculates the array product of two arrays.</ahelp> The number of columns for array 1 must match the number of rows for array 2. The square array has an equal number of rows and columns.</paragraph> -<paragraph id="hd_id3146767" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3150798" role="code" xml-lang="en-US">MMULT(Array; Array)</paragraph> <paragraph id="par_id3150812" role="paragraph" xml-lang="en-US"><emph>Array</emph> at first place represents the first array used in the array product.</paragraph> <paragraph id="par_id3152553" role="paragraph" xml-lang="en-US"><emph>Array</emph> at second place represents the second array with the same number of rows.</paragraph> <paragraph id="par_idN114C3" role="note" localize="false" xml-lang="en-US"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph> -<paragraph id="hd_id3152574" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3146826" role="paragraph" xml-lang="en-US">Select a square range. Choose the MMULT function. Select the first <emph>Array</emph>, then select the second <emph>Array</emph>. Using <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. Click <emph>OK</emph>. The output array will appear in the first selected range.</paragraph> </section> @@ -630,12 +630,12 @@ <paragraph id="hd_id3154970" role="heading" level="2" xml-lang="en-US">TRANSPOSE</paragraph> <paragraph id="par_id3155276" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_MTRANS">Transposes the rows and columns of an array.</ahelp></paragraph> -<paragraph id="hd_id3155294" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3153843" role="code" xml-lang="en-US">TRANSPOSE(Array)</paragraph> <paragraph id="par_id3153857" role="paragraph" xml-lang="en-US"><emph>Array</emph> represents the array in the spreadsheet that is to be transposed.</paragraph> <paragraph id="par_idN11035" role="note" xml-lang="en-US">You can find a general introduction to using Array functions on top of this page.</paragraph> -<paragraph id="hd_id3159352" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3159366" role="paragraph" xml-lang="en-US">In the spreadsheet, select the range in which the transposed array can appear. If the original array has n rows and m columns, your selected range must have at least m rows and n columns. Then enter the formula directly, select the original array and press <switchinline select="sys"><caseinline select="MAC">Shift+Command+Enter </caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline>. Or, if you are using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. The transposed array appears in the selected target range and is protected automatically against changes.</paragraph> @@ -766,7 +766,7 @@ <paragraph id="hd_id3109846" role="heading" level="2" xml-lang="en-US">LINEST</paragraph> <paragraph id="par_id3144733" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_RGP">Returns a table of statistics for a straight line that best fits a data set.</ahelp><comment>changed based on https://wiki.documentfoundation.org/Documentation/How_Tos/Calc:_LINEST_function (issue 76142)</comment></paragraph> -<paragraph id="hd_id3152825" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3152839" role="code" xml-lang="en-US">LINEST(data_Y; data_X; linearType; stats)</paragraph> <paragraph id="par_id3152853" role="paragraph" xml-lang="en-US"><emph>data_Y</emph> is a single row or column range specifying the y coordinates in a set of data points.</paragraph> <paragraph id="par_id3154428" role="paragraph" xml-lang="en-US"><emph>data_X</emph> is a corresponding single row or column range specifying the x coordinates. If <emph>data_X</emph> is omitted it defaults to <item type="literal">1, 2, 3, ..., n</item>. If there is more than one set of variables <emph>data_X</emph> may be a range with corresponding multiple rows or columns.</paragraph> @@ -778,7 +778,7 @@ <paragraph id="par_idN11416" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> <paragraph id="par_idN116C6" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph> -<paragraph id="hd_id3154162" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3154176" role="paragraph" xml-lang="en-US">This function returns an array and is handled in the same way as the other array functions. Select a range for the answers and then the function. Select <emph>data_Y</emph>. If you want, you can enter other parameters. Select <emph>Array</emph> and click <emph>OK</emph>.</paragraph> <paragraph id="par_id3155468" role="paragraph" xml-lang="en-US">The results returned by the system (if <emph>stats</emph> = 0), will at least show the slope of the regression line and its intersection with the Y axis. If <emph>stats</emph> does not equal 0, other results are to be displayed.</paragraph> @@ -1048,7 +1048,7 @@ <paragraph id="hd_id3146009" role="heading" level="2" xml-lang="en-US">LOGEST</paragraph> <paragraph id="par_id3146037" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_RKP">This function calculates the adjustment of the entered data as an exponential regression curve (y=b*m^x).</ahelp><comment>UFI: see http://support.microsoft.com/default.aspx?kbid=828528&product=xl2003 for bug #i31051#</comment></paragraph> -<paragraph id="hd_id3146056" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3163123" role="code" xml-lang="en-US">LOGEST(DataY; DataX; FunctionType; Stats)</paragraph> <paragraph id="par_id3163137" role="paragraph" xml-lang="en-US"><emph>DataY</emph> represents the Y Data array.</paragraph> <paragraph id="par_id3163155" role="paragraph" xml-lang="en-US"><emph>DataX</emph> (optional) represents the X Data array.</paragraph> @@ -1057,7 +1057,7 @@ <paragraph id="par_idN118F7" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> <paragraph id="par_idN11BC3" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph> -<paragraph id="hd_id3163216" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3163230" role="paragraph" xml-lang="en-US">See LINEST. However, no square sum will be returned.</paragraph> </section> @@ -1074,12 +1074,12 @@ <paragraph id="hd_id3163286" role="heading" level="2" xml-lang="en-US">SUMPRODUCT</paragraph> <paragraph id="par_id3163314" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMMENPRODUKT">Multiplies corresponding elements in the given arrays, and returns the sum of those products.</ahelp></paragraph> -<paragraph id="hd_id3163334" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3163347" role="code" xml-lang="en-US">SUMPRODUCT(Array1; Array2...Array30)</paragraph> <paragraph id="par_id3163362" role="paragraph" xml-lang="en-US"><emph>Array1, Array2...Array30</emph> represent arrays whose corresponding elements are to be multiplied.</paragraph> <paragraph id="par_idN11B19" role="paragraph" xml-lang="en-US">At least one array must be part of the argument list. If only one array is given, all array elements are summed.</paragraph> -<paragraph id="par_idN11B1C" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <table id="tbl_id6215704"> <tablerow> @@ -1168,7 +1168,7 @@ <paragraph id="hd_id3144842" role="heading" level="2" xml-lang="en-US">SUMX2MY2</paragraph> <paragraph id="par_id3144871" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMMEX2MY2">Returns the sum of the difference of squares of corresponding values in two arrays.</ahelp></paragraph> -<paragraph id="hd_id3144889" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3144903" role="code" xml-lang="en-US">SUMX2MY2(ArrayX; ArrayY)</paragraph> <paragraph id="par_id3144916" role="paragraph" xml-lang="en-US"><emph>ArrayX</emph> represents the first array whose elements are to be squared and added.</paragraph> <paragraph id="par_id3144936" role="paragraph" xml-lang="en-US"><emph>ArrayY</emph> represents the second array whose elements are to be squared and subtracted.</paragraph> @@ -1185,7 +1185,7 @@ <paragraph id="hd_id3145026" role="heading" level="2" xml-lang="en-US">SUMX2PY2</paragraph> <paragraph id="par_id3145055" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMMEX2PY2">Returns the sum of the sum of squares of corresponding values in two arrays.</ahelp></paragraph> -<paragraph id="hd_id3163390" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3163404" role="code" xml-lang="en-US">SUMX2PY2(ArrayX; ArrayY)</paragraph> <paragraph id="par_id3163417" role="paragraph" xml-lang="en-US"><emph>ArrayX</emph> represents the first array whose elements are to be squared and added.</paragraph> <paragraph id="par_id3163437" role="paragraph" xml-lang="en-US"><emph>ArrayY</emph> represents the second array, whose elements are to be squared and added.</paragraph> @@ -1202,7 +1202,7 @@ <paragraph id="hd_id3163527" role="heading" level="2" xml-lang="en-US">SUMXMY2</paragraph> <paragraph id="par_id3163556" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMMEXMY2">Adds the squares of the variance between corresponding values in two arrays.</ahelp></paragraph> -<paragraph id="hd_id3163574" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3163588" role="code" xml-lang="en-US">SUMXMY2(ArrayX; ArrayY)</paragraph> <paragraph id="par_id3163601" role="paragraph" xml-lang="en-US"><emph>ArrayX</emph> represents the first array whose elements are to be subtracted and squared.</paragraph> <paragraph id="par_id3163621" role="paragraph" xml-lang="en-US"><emph>ArrayY</emph> represents the second array, whose elements are to be subtracted and squared.</paragraph> @@ -1219,7 +1219,7 @@ <paragraph id="hd_id3166062" role="heading" level="2" xml-lang="en-US">TREND</paragraph> <paragraph id="par_id3166091" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_TREND">Returns values along a linear trend.</ahelp></paragraph> -<paragraph id="hd_id3166109" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3166122" role="code" xml-lang="en-US">TREND(DataY; DataX; NewDataX; LinearType)</paragraph> <paragraph id="par_id3166137" role="paragraph" xml-lang="en-US"><emph>DataY</emph> represents the Y Data array.</paragraph> <paragraph id="par_id3166156" role="paragraph" xml-lang="en-US"><emph>DataX</emph> (optional) represents the X Data array.</paragraph> @@ -1228,7 +1228,7 @@ <paragraph id="par_idN11D2F" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> <paragraph id="par_idN12019" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph> -<paragraph id="hd_id3166231" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3166245" role="paragraph" xml-lang="en-US">Select a spreadsheet range in which the trend data will appear. Select the function. Enter the output data or select it with the mouse. Mark the <emph>Array</emph> field. click <emph>OK</emph>. The trend data calculated from the output data is displayed.</paragraph> </section> @@ -1243,7 +1243,7 @@ <paragraph id="hd_id3166317" role="heading" level="2" xml-lang="en-US">GROWTH</paragraph> <paragraph id="par_id3166346" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_VARIATION">Calculates the points of an exponential trend in an array.</ahelp></paragraph> -<paragraph id="hd_id3166364" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3166377" role="code" xml-lang="en-US">GROWTH(DataY; DataX; NewDataX; FunctionType)</paragraph> <paragraph id="par_id3166392" role="paragraph" xml-lang="en-US"><emph>DataY</emph> represents the Y Data array.</paragraph> <paragraph id="par_id3166411" role="paragraph" xml-lang="en-US"><emph>DataX</emph> (optional) represents the X Data array.</paragraph> @@ -1252,7 +1252,7 @@ <paragraph id="par_idN11DFD" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/00/00000004.xhp#optional"/></paragraph> <paragraph id="par_idN12113" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/00/00000004.xhp#moreontop"/></paragraph> -<paragraph id="hd_id3173839" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3173852" role="paragraph" xml-lang="en-US">This function returns an array and is handled in the same way as the other array functions. Select a range where you want the answers to appear and select the function. Select DataY. Enter any other parameters, mark <emph>Array</emph> and click <emph>OK</emph>.</paragraph> </section> </sort> |