diff options
Diffstat (limited to 'source/text/scalc/01/04060107.xhp')
| -rw-r--r-- | source/text/scalc/01/04060107.xhp | 76 |
1 files changed, 38 insertions, 38 deletions
diff --git a/source/text/scalc/01/04060107.xhp b/source/text/scalc/01/04060107.xhp index 1b450e689d..542a818ce0 100644 --- a/source/text/scalc/01/04060107.xhp +++ b/source/text/scalc/01/04060107.xhp @@ -362,8 +362,8 @@ <paragraph role="paragraph" id="par_id3151260" xml-lang="en-US" l10n="U" oldref="19">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 role="paragraph" id="par_id3150403" xml-lang="en-US" l10n="U" oldref="20">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 role="paragraph" id="par_id3156143" xml-lang="en-US" l10n="U" oldref="21">You now see a unit array with a range of A1:E5.</paragraph> -<paragraph role="paragraph" id="par_idN10FA7" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#moreontop"/> +<paragraph role="paragraph" id="par_idN10FA7" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#moreontop"/> </paragraph> </section> <section id="Section13"> @@ -570,8 +570,8 @@ </table> <paragraph role="paragraph" id="par_id3150312" xml-lang="en-US" l10n="CHG" oldref="29">Select a single column range in which to enter the frequency according to the class limits. You must select one field more than the class ceiling. In this example, select the range C1:C6. Call up the FREQUENCY function in the <emph>Function Wizard</emph>. Select the <emph>Data</emph> range in (A1:A11), and then the <emph>Classes</emph> range in which you entered the class limits (B1:B6). Select the <emph>Array</emph> check box and click <emph>OK</emph>. You will see the frequency count in the range C1:C6.</paragraph> -<paragraph role="paragraph" id="par_idN11269" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#moreontop"/> +<paragraph role="paragraph" id="par_idN11269" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#moreontop"/> </paragraph> </section> <section id="Section12"> @@ -586,8 +586,8 @@ <paragraph role="paragraph" id="par_id3150290" xml-lang="en-US" l10n="U" oldref="35"> <emph>Array</emph> represents a square array in which the determinants are defined.</paragraph> <paragraph role="note" id="par_idN11035" xml-lang="en-US" l10n="NEW">You can find a general introduction to using Array functions on top of this page.</paragraph> -<paragraph role="paragraph" id="par_idN11333" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#moreontop"/> +<paragraph role="paragraph" id="par_idN11333" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#moreontop"/> </paragraph> </section> <section id="Section11"> @@ -601,8 +601,8 @@ <paragraph role="code" id="par_id3156085" xml-lang="en-US" l10n="U" oldref="42">MINVERSE(Array)</paragraph> <paragraph role="paragraph" id="par_id3157849" xml-lang="en-US" l10n="U" oldref="43"> <emph>Array</emph> represents a square array that is to be inverted.</paragraph> -<paragraph role="paragraph" id="par_idN113EE" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#moreontop"/> +<paragraph role="paragraph" id="par_idN113EE" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#moreontop"/> </paragraph> <paragraph role="heading" id="hd_id3157868" xml-lang="en-US" level="3" l10n="U" oldref="44">Example</paragraph> <paragraph role="paragraph" id="par_id3149638" xml-lang="en-US" l10n="U" oldref="45">Select a square range and select MINVERSE. Select the output array, select the <emph>Array</emph> field and click <emph>OK</emph>.</paragraph> @@ -619,8 +619,8 @@ <emph>Array</emph> at first place represents the first array used in the array product.</paragraph> <paragraph role="paragraph" id="par_id3152553" xml-lang="en-US" l10n="U" oldref="52"> <emph>Array</emph> at second place represents the second array with the same number of rows.</paragraph> -<paragraph role="note" id="par_idN114C3" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#moreontop"/> +<paragraph role="note" id="par_idN114C3" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#moreontop"/> </paragraph> <paragraph role="heading" id="hd_id3152574" xml-lang="en-US" level="3" l10n="U" oldref="53">Example</paragraph> <paragraph role="paragraph" id="par_id3146826" xml-lang="en-US" l10n="U" oldref="54">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> @@ -635,8 +635,8 @@ <paragraph role="code" id="par_id3153843" xml-lang="en-US" l10n="U" oldref="59">TRANSPOSE(Array)</paragraph> <paragraph role="paragraph" id="par_id3153857" xml-lang="en-US" l10n="U" oldref="60"> <emph>Array</emph> represents the array in the spreadsheet that is to be transposed.</paragraph> -<paragraph role="paragraph" id="par_idN115A5" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#moreontop"/> +<paragraph role="paragraph" id="par_idN115A5" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#moreontop"/> </paragraph> <paragraph role="heading" id="hd_id3159352" xml-lang="en-US" level="3" l10n="U" oldref="61">Example</paragraph> <paragraph role="paragraph" id="par_id3159366" xml-lang="en-US" l10n="U" oldref="62">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> @@ -657,11 +657,11 @@ <paragraph role="paragraph" id="par_id3154448" xml-lang="en-US" l10n="U" oldref="70"> if<emph>linearType</emph> is FALSE the straight line found is forced to pass through the origin (the constant a is zero; y = bx). If omitted, <emph>linearType</emph> defaults to TRUE (the line is not forced through the origin).</paragraph> <paragraph role="paragraph" id="par_id3154142" xml-lang="en-US" l10n="U" oldref="71">if<emph>stats</emph> is omitted or FALSE only the top line of the statistics table is returned. If TRUE the entire table is returned.</paragraph> <paragraph role="paragraph" id="par_id0811200804502261" xml-lang="en-US" l10n="NEW">LINEST returns a table (array) of statistics as below and must be entered as an array formula (for example by using <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Return rather than just Return).</paragraph> -<paragraph role="paragraph" id="par_idN11416" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#optional"/> +<paragraph role="paragraph" id="par_idN11416" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#optional"/> </paragraph> -<paragraph role="paragraph" id="par_idN116C6" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#moreontop"/> +<paragraph role="paragraph" id="par_idN116C6" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#moreontop"/> </paragraph> <paragraph role="heading" id="hd_id3154162" xml-lang="en-US" level="3" l10n="U" oldref="72">Example</paragraph> <paragraph role="paragraph" id="par_id3154176" xml-lang="en-US" l10n="U" oldref="73">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> @@ -1014,8 +1014,8 @@ <paragraph role="paragraph" id="par_id3145915" xml-lang="en-US" l10n="U" oldref="146">F5: The degrees of freedom from the variance analysis.</paragraph> <paragraph role="paragraph" id="par_id3145937" xml-lang="en-US" l10n="U" oldref="147">E6: The sum of the squared deviation of the estimated Y values from their linear mean.</paragraph> <paragraph role="paragraph" id="par_id3145952" xml-lang="en-US" l10n="U" oldref="148">F6: The sum of the squared deviation of the estimated Y value from the given Y values.</paragraph> -<paragraph role="paragraph" id="par_idN11B04" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#moreontop"/> +<paragraph role="paragraph" id="par_idN11B04" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#moreontop"/> </paragraph> </section> <section id="Section7"> @@ -1035,11 +1035,11 @@ for bug #i31051#</comment></paragraph> <emph>FunctionType</emph> (optional). If Function_Type = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated.</paragraph> <paragraph role="paragraph" id="par_id3163196" xml-lang="en-US" l10n="U" oldref="157"> <emph>Stats</emph> (optional). If Stats=0, only the regression coefficient is calculated.</paragraph> -<paragraph role="paragraph" id="par_idN118F7" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#optional"/> +<paragraph role="paragraph" id="par_idN118F7" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#optional"/> </paragraph> -<paragraph role="paragraph" id="par_idN11BC3" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#moreontop"/> +<paragraph role="paragraph" id="par_idN11BC3" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#moreontop"/> </paragraph> <paragraph role="heading" id="hd_id3163216" xml-lang="en-US" level="3" l10n="U" oldref="158">Example</paragraph> <paragraph role="paragraph" id="par_id3163230" xml-lang="en-US" l10n="CHG" oldref="159">See LINEST. However, no square sum will be returned.</paragraph> @@ -1158,8 +1158,8 @@ for bug #i31051#</comment></paragraph> <paragraph role="paragraph" id="par_idN11BA4" xml-lang="en-US" l10n="NEW">Calculation: A1*C1 + B1*D1 + A2*C2 + B2*D2 + A3*C3 + B3*D3</paragraph> <paragraph role="paragraph" id="par_idN11BA7" xml-lang="en-US" l10n="NEW">You can use SUMPRODUCT to calculate the scalar product of two vectors.</paragraph> <paragraph role="note" id="par_idN11BBC" xml-lang="en-US" l10n="NEW">SUMPRODUCT returns a single number, it is not necessary to enter the function as an array function.</paragraph> -<paragraph role="paragraph" id="par_idN11C91" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#moreontop"/> +<paragraph role="paragraph" id="par_idN11C91" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#moreontop"/> </paragraph> </section> <section id="Section5"> @@ -1174,8 +1174,8 @@ for bug #i31051#</comment></paragraph> <emph>ArrayX</emph> represents the first array whose elements are to be squared and added.</paragraph> <paragraph role="paragraph" id="par_id3144936" xml-lang="en-US" l10n="U" oldref="174"> <emph>ArrayY</emph> represents the second array whose elements are to be squared and subtracted.</paragraph> -<paragraph role="paragraph" id="par_idN11D6B" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#moreontop"/> +<paragraph role="paragraph" id="par_idN11D6B" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#moreontop"/> </paragraph> </section> <section id="Section4"> @@ -1190,8 +1190,8 @@ for bug #i31051#</comment></paragraph> <emph>ArrayX</emph> represents the first array whose elements are to be squared and added.</paragraph> <paragraph role="paragraph" id="par_id3163437" xml-lang="en-US" l10n="U" oldref="183"> <emph>ArrayY</emph> represents the second array, whose elements are to be squared and added.</paragraph> -<paragraph role="paragraph" id="par_idN11E45" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#moreontop"/> +<paragraph role="paragraph" id="par_idN11E45" xml-lang="en-US" l10n="NEW" localize="false"> + <embedvar href="text/scalc/00/00000004.xhp#moreontop"/> </paragraph> </section> <section id="Section3"> @@ -1206,8 +1206,8 @@ for bug #i31051#</comment></paragraph> <emph>ArrayX</emph> represents the first array whose elements are to be subtracted and squared.</paragraph> <paragraph role="paragraph" id="par_id3163621" xml-lang="en-US" l10n="U" oldref="192"> <emph>ArrayY</emph> represents the second array, whose elements are to be subtracted and squared.</paragraph> -<paragraph role="paragraph" id="par_idN11F1F" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#moreontop"/> +<paragraph role="paragraph" id="par_idN11F1F" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#moreontop"/> </paragraph> </section> <section id="Section2"> @@ -1226,11 +1226,11 @@ for bug #i31051#</comment></paragraph> <emph>NewDataX</emph> (optional) represents the array of the X data, which are used for recalculating values.</paragraph> <paragraph role="paragraph" id="par_id3166196" xml-lang="en-US" l10n="U" oldref="203"> <emph>LinearType</emph>(Optional). If LinearType = 0, then lines will be calculated through the zero point. Otherwise, offset lines will also be calculated. The default is LinearType <> 0.</paragraph> -<paragraph role="paragraph" id="par_idN11D2F" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#optional"/> +<paragraph role="paragraph" id="par_idN11D2F" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#optional"/> </paragraph> -<paragraph role="paragraph" id="par_idN12019" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#moreontop"/> +<paragraph role="paragraph" id="par_idN12019" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#moreontop"/> </paragraph> <paragraph role="heading" id="hd_id3166231" xml-lang="en-US" level="3" l10n="U" oldref="204">Example</paragraph> <paragraph role="paragraph" id="par_id3166245" xml-lang="en-US" l10n="U" oldref="205">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> @@ -1252,11 +1252,11 @@ for bug #i31051#</comment></paragraph> <emph>NewDataX</emph> (optional) represents the X data array, in which the values are recalculated.</paragraph> <paragraph role="paragraph" id="par_id3173817" xml-lang="en-US" l10n="U" oldref="214"> <emph>FunctionType</emph>(optional). If FunctionType = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated.</paragraph> -<paragraph role="paragraph" id="par_idN11DFD" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#optional"/> +<paragraph role="paragraph" id="par_idN11DFD" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#optional"/> </paragraph> -<paragraph role="paragraph" id="par_idN12113" xml-lang="en-US" l10n="NEW"> -<embedvar href="text/scalc/00/00000004.xhp#moreontop"/> +<paragraph role="paragraph" id="par_idN12113" xml-lang="en-US" l10n="NEW" localize="false" > + <embedvar href="text/scalc/00/00000004.xhp#moreontop"/> </paragraph> <paragraph role="heading" id="hd_id3173839" xml-lang="en-US" level="3" l10n="U" oldref="215">Example</paragraph> <paragraph role="paragraph" id="par_id3173852" xml-lang="en-US" l10n="U" oldref="216">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> |