範例：QR 矩陣因式分解

• 為避免在執行布林比較時發生邏輯不符的情況，請啟用「計算選項」下拉式清單中的「近似等式」。

• 此範例使用複數矩陣作為輸入，但此函數也接受實數矩陣作為輸入。

預設函數 QR(M1) 等同於 QR(M,1).

<region id="ID0E1HZMB" actualWidth="167.83666666666665" actualHeight="81.4" top="1209.6000000000001" left="38.400000000000006" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="16" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">M1</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">P1</id> </apply> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>	<region id="ID0ENIZMB" actualWidth="165.74" actualHeight="81.4" top="1209.6000000000001" left="211.20000000000005" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="18" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Q1</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">R1</id> </apply> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EEJZMB" actualWidth="153.23666666666668" actualHeight="25.6" top="1286.4" left="38.400000000000006" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="20" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <apply xml:lang="zh_TW"> <equal xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">M1</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">P1</id> </apply> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Q1</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">R1</id> </apply> </apply> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
此關係在邏輯上為真。

<region id="ID0EVMZMB" actualWidth="220.22000000000003" actualHeight="25.6" top="1401.6000000000001" left="38.400000000000006" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50">
 <math resultRef="22" xml:lang="zh_TW">
 <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50">
 <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW">M2</id>
 <apply xml:lang="zh_TW">
 <id labels="FUNCTION" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">submatrix</id>
 <sequence xml:lang="zh_TW">
 <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">M1</id>
 <real xml:lang="zh_TW">0</real>
 <real xml:lang="zh_TW">1</real>
 <real xml:lang="zh_TW">0</real>
 <real xml:lang="zh_TW">2</real>
 </sequence>
 </apply>
 </define>
 <resultFormat xml:lang="zh_TW">
 <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" />
 </resultFormat>
 </math>
</region>

<region id="ID0EMQZMB" actualWidth="69.890000000000015" actualHeight="36.800000000000004" top="1516.8000000000002" left="38.400000000000006" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="26" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW">P2</id> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">m2</id> <real xml:lang="zh_TW">0</real> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>	<region id="ID0E6QZMB" actualWidth="71.38666666666667" actualHeight="36.800000000000004" top="1516.8000000000002" left="134.40000000000003" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="28" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW">Q2</id> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">m2</id> <real xml:lang="zh_TW">1</real> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>	<region id="ID0ESRZMB" actualWidth="70.816666666666677" actualHeight="36.800000000000004" top="1516.8000000000002" left="230.40000000000003" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="30" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW">R2</id> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">m2</id> <real xml:lang="zh_TW">2</real> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EJSZMB" actualWidth="153.23666666666668" actualHeight="25.6" top="1555.2000000000003" left="38.400000000000006" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="32" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <apply xml:lang="zh_TW"> <equal xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">M2</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">P2</id> </apply> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Q2</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">R2</id> </apply> </apply> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
此關係在邏輯上為真。

<region id="ID0EPVZMB" actualWidth="220.22000000000003" actualHeight="25.6" top="1670.4000000000003" left="38.400000000000006" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50">
 <math resultRef="34" xml:lang="zh_TW">
 <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50">
 <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW">M3</id>
 <apply xml:lang="zh_TW">
 <id labels="FUNCTION" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">submatrix</id>
 <sequence xml:lang="zh_TW">
 <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">M1</id>
 <real xml:lang="zh_TW">0</real>
 <real xml:lang="zh_TW">2</real>
 <real xml:lang="zh_TW">0</real>
 <real xml:lang="zh_TW">2</real>
 </sequence>
 </apply>
 </define>
 <resultFormat xml:lang="zh_TW">
 <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" />
 </resultFormat>
 </math>
</region>

<region id="ID0EGZZMB" actualWidth="69.890000000000015" actualHeight="36.800000000000004" top="1785.6000000000004" left="38.400000000000006" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="38" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW">P3</id> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">m3</id> <real xml:lang="zh_TW">0</real> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>	<region id="ID0EZZZMB" actualWidth="71.38666666666667" actualHeight="36.800000000000004" top="1785.6000000000004" left="134.40000000000003" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="40" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW">Q3</id> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">m3</id> <real xml:lang="zh_TW">1</real> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>	<region id="ID0EM1ZMB" actualWidth="70.816666666666677" actualHeight="36.800000000000004" top="1785.6000000000004" left="230.40000000000003" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="42" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW">R3</id> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">m3</id> <real xml:lang="zh_TW">2</real> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0ED2ZMB" actualWidth="153.23666666666668" actualHeight="25.6" top="1824.0000000000002" left="38.400000000000006" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="44" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <apply xml:lang="zh_TW"> <equal xml:lang="zh_TW" /> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">M3</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">P3</id> </apply> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Q3</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">R3</id> </apply> </apply> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
此關係在邏輯上為真。

<region id="ID0EPC1MB" actualWidth="140.69333333333333" actualHeight="81.4" top="2380.8" left="38.400000000000006" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="52" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">M1</id> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>	<region id="ID0ECD1MB" actualWidth="170.95" actualHeight="81.4" top="2380.8" left="211.20000000000005" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="54" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Q10</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">R10</id> </apply> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EZD1MB" actualWidth="142.05333333333334" actualHeight="25.6" top="2457.6000000000004" left="38.400000000000006" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="56" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <apply xml:lang="zh_TW"> <equal xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">M1</id> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Q10</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">R10</id> </apply> </apply> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
此關係在邏輯上為真。

<region id="ID0EMJ1MB" actualWidth="87.346666666666664" actualHeight="36.800000000000004" top="2649.6000000000004" left="38.400000000000006" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="60" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW">Q20</id> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">m20</id> <real xml:lang="zh_TW">0</real> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>	<region id="ID0E6J1MB" actualWidth="86.776666666666671" actualHeight="36.800000000000004" top="2649.6000000000004" left="134.40000000000003" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="62" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW">R20</id> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">m20</id> <real xml:lang="zh_TW">1</real> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0EWK1MB" actualWidth="142.05333333333334" actualHeight="25.6" top="2688.0000000000005" left="38.400000000000006" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="64" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <apply xml:lang="zh_TW"> <equal xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">M2</id> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Q20</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">R20</id> </apply> </apply> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
此關係在邏輯上為真。

<region id="ID0EIQ1MB" actualWidth="87.346666666666664" actualHeight="36.800000000000004" top="2880.0000000000005" left="38.400000000000006" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="68" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW">Q30</id> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">m30</id> <real xml:lang="zh_TW">0</real> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>	<region id="ID0E2Q1MB" actualWidth="86.776666666666671" actualHeight="36.800000000000004" top="2880.0000000000005" left="134.40000000000003" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="70" xml:lang="zh_TW"> <define xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW">R30</id> <apply xml:lang="zh_TW"> <indexer xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">m30</id> <real xml:lang="zh_TW">1</real> </apply> </define> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
<region id="ID0ESR1MB" actualWidth="142.05333333333334" actualHeight="25.6" top="2918.4000000000005" left="38.400000000000006" xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="72" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <apply xml:lang="zh_TW"> <equal xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">M3</id> <apply xml:lang="zh_TW"> <mult xml:lang="zh_TW" /> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">Q30</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">R30</id> </apply> </apply> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> <resultFormat xml:lang="zh_TW"> <matrix size="12,12" offset="0,0" show-indices="false" expand-nested-arrays="false" xml:lang="zh_TW" /> </resultFormat> </math> </region>
此關係在邏輯上為真。