函數
>
向量與矩陣
>
其他陣列函數
>
範例：等級與排序向量
範例：等級與排序向量
1.
定義向量。
<region id="ID0EKVINB" top="153.60000000000002" left="57.600000000000009" xml:lang="zh_TW" height="81.4" width="69.81" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="12" 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">V</id> <matrix rows="4" cols="1" xml:lang="zh_TW"> <real xml:lang="zh_TW">-2</real> <real xml:lang="zh_TW">3</real> <real xml:lang="zh_TW">-1</real> <real xml:lang="zh_TW">1</real> </matrix> </define> </math> </region>
2.
使用
Rank
函數取得向量之每個元素的排序位置。
<region id="ID0EVXINB" top="288.00000000000006" left="38.400000000000006" xml:lang="zh_TW" height="81.4" width="117.15333333333336" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="14" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <apply xml:lang="zh_TW"> <id labels="FUNCTION" xml:space="preserve" xml:lang="zh_TW">Rank</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">V</id> </apply> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> </math> </region>
3.
使用
order
函數取得排序向量元素所使用的索引。
<region id="ID0EA1INB" top="441.60000000000008" left="38.400000000000006" xml:lang="zh_TW" height="81.4" width="117.00666666666669" 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"> <id labels="FUNCTION" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">order</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">V</id> </apply> <unitOverride xml:lang="zh_TW"> <placeholder xml:lang="zh_TW" /> </unitOverride> </eval> </math> </region>
4.
修改向量使其包含兩個相同的元素，然後呼叫
Rank
與
order
。
<region id="ID0E62INB" top="556.80000000000007" left="38.400000000000006" xml:lang="zh_TW" height="81.4" width="69.81" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="18" 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">V</id> <matrix rows="4" cols="1" xml:lang="zh_TW"> <real xml:lang="zh_TW">-2</real> <real xml:lang="zh_TW">3</real> <real xml:lang="zh_TW">-1</real> <real xml:lang="zh_TW">3</real> </matrix> </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="ID0ER3INB" top="633.60000000000014" left="38.400000000000006" xml:lang="zh_TW" height="81.4" width="129.50333333333336" 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"> <id labels="FUNCTION" xml:space="preserve" xml:lang="zh_TW">Rank</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">V</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="ID0ED4INB" top="633.60000000000014" left="288.00000000000006" xml:lang="zh_TW" height="81.4" width="117.00666666666669" xmlns="http://schemas.mathsoft.com/worksheet50"> <math resultRef="22" xml:lang="zh_TW"> <eval xml:lang="zh_TW" xmlns="http://schemas.mathsoft.com/math50"> <apply xml:lang="zh_TW"> <id labels="FUNCTION" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">order</id> <id labels="VARIABLE" xml:space="preserve" xml:lang="zh_TW" label-is-contextual="true">V</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>
針對相同的元素，
Rank
會傳回在排序後出現值的索引平均值。
order
函數會根據其在向量的原始順序產生序數索引。
複製運算式
