è¡å颿°
ãã®åé¡é ç®ã«ã¯ãè¡å颿°ãå«ãŸããŸãã
è¡åãšã¯
è¡åã¯ã衚èšç®ããã¥ã¡ã³ãå ã§é£çµããããå€ãå«ãã»ã«ç¯å²ã§ãã3 è¡ãš 3 åã®ç¯å²ã¯ 3 x 3 è¡åã§ãã
A |
B |
C |
|
1 |
7 |
31 |
33 |
2 |
95 |
17 |
2 |
3 |
5 |
10 |
50 |
æå°ã®è¡å㯠1 x 2 ãŸã㯠2 ã€ã®é£æ¥ã»ã«ãæã€ 2 x 1 è¡åã§ãã
è¡ååŒãšã¯
ã»ã«ç¯å²å ã®åã ã®å€ãèæ ®ãããæ°åŒããè¡ååŒãšåŒã³ãŸããè¡ååŒãšã»ãã®æ°åŒãšã®éãã¯ãåè ã¯äžåºŠã«è€æ°ã®å€ãåŠçããã®ã«å¯ŸããåŸè ã¯äžåºŠã« 1 ã€ã®å€ããåŠçããªãç¹ã§ãã
è¡ååŒã¯ãè€æ°ã®å€ãåŠçã§ããã ãã§ã¯ãªããè€æ°ã®å€ãè¿ãããšãã§ããŸããè¡ååŒã®çµæãè¡åã§ãã
äžèšã®è¡åã§åã ã®ã»ã«ã®å€ã 10 åããå Žåãåã»ã«ãå€ã«æ°åŒãé©çšããå¿ èŠã¯ãããŸããããã®ä»£ããã«äœ¿çšããå¿ èŠãããã®ã¯ã1 ã€ã®è¡ååŒã ãã§ããã¹ãã¬ããã·ãŒãã®å¥ã®éšåã« 3 x 3 ã»ã«ã®ç¯å²ãéžæããæ°åŒ =10*A1:C3 ãå ¥åããããŒã®çµã¿åãã Command Ctrl + Shift + Enter ã§ãã®å ¥åã確å®ããŸããçµæã¯ãã»ã«ç¯å² (A1:C3) ã®åã ã®å€ã«å æ° 10 ãæãããã 3 x 3 ã®è¡åã§ãã
ä¹ç®ã«å ããåç §ç¯å² (è¡å) ã§ã¯ã»ãã®æŒç®åã䜿çšããããšãã§ããŸããLibreOffice Calc ã§ã¯ãå ç® (+)ãæžç® (-)ãä¹ç® (*)ãé€ç® (/)ãææ° (^)ãé£çµ (&)ãããã³æ¯èŒ (=ã<>ã<ã>ã<=ã>=) ãè¡ããŸããæŒç®åã¯ã»ã«ç¯å²å ã®åã ã®å€ã«å¯ŸããŠäœ¿çšã§ããè¡ååŒãå ¥åãããŠããå Žåã¯çµæãè¡åãšããŠè¿ããŸãã
è¡ååŒã®æ¯èŒæŒç®åã¯ãéåžžã®æ°åŒãšåãããã«ãã€ãŸãããŒããŸãã¯ç©ºã®æååãšããŠã空çœã»ã«ãæ±ããŸããããšãã°ãã»ã« A1 ãš A2 ã空çœã®å Žåãè¡ååŒ {=A1:A2=""} ãš {=A1:A2=0} ã¯ãäž¡æ¹ TRUE ãå«ãã»ã«ã® 1 å 2 è¡ã®è¡åãè¿ããŸãã
è¡ååŒããã€äœ¿çšããã
ç°ãªãå€ã䜿çšããŠèšç®ãç¹°ãè¿ãå¿ èŠãããå Žåã¯ãè¡ååŒã䜿çšããŸããè¡ååŒã䜿çšãããšãåŸããèšç®æ¹æ³ãå€ããå Žåã§ããè¡ååŒãæŽæ°ããã ãã§æžã¿ãŸããè¡ååŒã远å ããã«ã¯ãè¡åç¯å²å šäœãéžæããå¿ èŠã«å¿ããŠè¡ååŒã«å€æŽãå ããŸãã
è¡ååŒã¯ãã¡ã¢ãªãŒã倧éã«æ¶è²»ããããã§ã¯ãªãã®ã§ãããã€ãã®å€ãèšç®ãããšãã«å®¹éãç¯çŽããããšãã§ããŸããããã«ãè¡åã¯è€éãªèšç®ãè¡ãå Žåã«äžå¯æ¬ ãšãªãããŒã«ã§ããããŸããããã¯ãè€æ°ã®ã»ã«ç¯å²ãèšç®ã®äžã«å«ããããšãã§ããããã§ããLibreOffice ã¯ã2 ã€ã®è¡åãä¹ç®ãã MMULT 颿°ãã2 ã€ã®è¡åã®ã¹ã«ã©ãŒç©ãèšç®ãã SUMPRODUCT 颿°ãªã©ãããŸããŸãªæ°åŠé¢æ°ãæäŸããŸãã
LibreOffice Calc ã§è¡ååŒã䜿çšãã
ãŸãããã©ã¡ãŒã¿ãŒãªã©ã®åç §ç¯å²ã§è¡ååŒã瀺ããéåžžã®ãæ°åŒãäœæããããšãã§ããŸãããã®çµæã¯ãåç §ç¯å²ãšãæ°åŒãå«ãŸããè¡ãŸãã¯åã®å ±ééšåããè¿ãããŸããå ±ééšåããªãå ŽåããŸãã¯ãå ±ééšåã®ç¯å²ã«è€æ°ã®è¡ãŸãã¯åãå«ãŸããå Žåã¯ã#VALUE! ãšã©ãŒã¡ãã»ãŒãžã衚瀺ãããŸãããã®æŠå¿µã次ã®äŸã§èª¬æããŸãã
è¡ååŒã®äœæ
颿°ãŠã£ã¶ãŒã ã䜿çšããŠè¡ååŒãäœæããå Žåãäœæãããã³ã« è¡å ãã§ãã¯ããã¯ã¹ããªã³ã«ããŠçµæãè¡åã«è¿ãããããã«ããå¿ èŠããããŸãããã§ãã¯ããã¯ã¹ããªã³ã«ããªããšãèšç®ãããè¡åã®å·Šäžã®ã»ã«ã®å€ã®ã¿ãè¿ãããŸãã
ã»ã«ã«çŽæ¥è¡ååŒãå ¥åããå Žåã¯ãEnter ããŒã ãã§ã¯ãªãã(Shift) + (Command)(Ctrl) + (Enter) ã®ããŒã®çµã¿åããã䜿çšããå¿ èŠããããŸãããã®ããŒã®çµã¿åããã䜿çšããå Žåã ããæ°åŒã¯è¡ååŒã«ã¯ãªããŸãã

LibreOffice Calc ã§ã¯ãè¡ååŒã¯äžãã£ãã«å²ãŸããŠè¡šç€ºãããŸããäžãã£ããæå ¥åããŠãè¡ååŒã¯äœæã§ããŸããã

çµæè¡åã®ã»ã«ã¯ã倿Žãããªãããèªåçã«ä¿è·ãããŸãããã ããè¡åã®ã»ã«ç¯å²å šäœãéžæãããšãè¡ååŒãç·šéãŸãã¯ã³ããŒã§ããŸãã
æ°åŒã§ã€ã³ã©ã€ã³è¡å宿°ã䜿çšãã
Calc ã¯æ°åŒã§ã®ã€ã³ã©ã€ã³è¡å宿°ããµããŒãããŠããŸãã ã€ã³ã©ã€ã³è¡åã¯ãäžæ¬åŒ§ã{ãããã³ã}ãã§å²ãŸããŠããŸãã èŠçŽ ã¯ãæ°å (è² ã®æ°ãå«ã)ãè«ç宿° (TRUEãFALSE)ãæååã®ããããã«ã§ããŸãã 宿°ä»¥å€ã®åŒã¯èš±å¯ãããŸããã è¡å㯠1 è¡ä»¥äžã®è¡ã1 å以äžã®åã§å ¥åã§ããŸãã ãã¹ãŠã®è¡ã¯åäžæ°ã®èŠçŽ ã§æ§æãããå¿ èŠãããããã¹ãŠã®åã¯åäžæ°ã®èŠçŽ ã§æ§æãããå¿ èŠããããŸãã
The column separator (separating elements in one row) and the row separator are language and locale dependent. But in this help content, the ';' semicolon and '|' pipe symbol are used to indicate the column and row separators, respectively. For example, in the English locale, the ',' comma is used as the column separator, while the ';' semicolon is used as the row separator.

You can view and change the row and column separator in LibreOffice - PreferencesTools - Options - Calc - Formula - Separators.
è¡åãå ¥ãåã«ããããšã¯ã§ããŸããã
äŸ:
={1;2;3}
ããã¯ã1 ã€ã®è¡ã® 3 ã€ã®æ°å 1ã2ã3 ã§æ§æãããè¡åã§ãã
ãã®è¡å宿°ãå ¥åããã«ã¯ã1 ã€ã®è¡äžã® 3 ã€ã®ã»ã«ãéžæããäžæ¬åŒ§ãšã»ãã³ãã³ã䜿ã£ãŠãæ¬¡ã®æ°åŒãã¿ã€ãããŸãã ={1;2;3}ãããŠãCommandCtrl+Shift+Enter ãæŒããŸãã
={1;2;3|4;5;6}
ããã¯ã2 ã€ã®è¡ããããããããã®è¡ã« 3 ã€ã®å€ã®ããè¡åã§ãã
={0;1;2|FALSE;TRUE;"two"}
ããã¯ãçµã¿åããããããŒã¿è¡åã§ãã
=SIN({1;2;3})
ããã¯ãè¡ååŒãšããŠå ¥åããããã®ã§ãããåŒæ° 1ã2ã3 ã§ 3 ã€ã® SIN èšç®ã®çµæãæäŸããŸãã
è¡ååŒã®ç·šé
-
è¡å颿°ãå«ãã»ã«ç¯å²ãè¡åãéžæããŸããè¡åå šäœãéžæããã«ã¯ãè¡åç¯å²å ã®ã»ã«ã«ã«ãŒãœã«ã眮ããCommandCtrl+/ïŒãã³ããŒã§/ãå²ãåœãŠãããããŒïŒãæŒããŸãã
-
F2 ããŒãæŒãããæ°åŒå ¥åããã¯ã¹ã«ã«ãŒãœã«ãç§»åããŸããã©ã¡ããã®ã¢ã¯ã·ã§ã³ã«ãããæ°åŒãç·šéããŸãã
-
倿Žãçµäºãããã(Command)(Ctrl) + (Shift) + (Enter) ããŒãæŒããŸãã

è¡åã®åå¥éšåãèšå®ã§ããŸããããšãã°ããã©ã³ãè²ã倿Žã§ããŸããã»ã«ç¯å²ãéžæããåžæã®å±æ§ã倿ŽããŸãã
è¡ååŒã®ã³ããŒ
-
è¡ååŒãå«ãã»ã«ç¯å²ãŸãã¯è¡åãéžæããŸãã
-
F2 ããŒãæŒãããæ°åŒå ¥åããã¯ã¹ã«ã«ãŒãœã«ãç§»åããŸãã
-
æ°åŒå ¥åããã¯ã¹ã«æ°åŒãã³ããŒããã«ã¯ã(Command)(Ctrl) + (C) ããŒãæŒããŸãã
-
è¡ååŒãæ¿å ¥ããã»ã«ç¯å²ãéžæããF2 ããŒãæŒãããæ°åŒå ¥åããã¯ã¹ã«ã«ãŒãœã«ãç§»åããŸãã
-
(Command)(Ctrl) + (V) ããŒæŒããŠéžæç¯å²å ã«æ°åŒã貌ãä»ãã(Command)(Ctrl) + (Shift) + (Enter) ããŒãæŒããŠç¢ºå®ããŸãããããšãéžæç¯å²å ã«è¡ååŒãå ¥åãããŸãã
è¡åç¯å²ã®èª¿æŽ
åºåè¡åãç·šéããå Žåã¯ã次ãè¡ããŸãã
-
è¡ååŒãå«ãã»ã«ç¯å²ãŸãã¯è¡åãéžæããŸãã
-
éžæããã»ã«ã®å³äžã«ãããŠã¹ã§æ¡å€§çž®å°ããããã®å°ããªã¢ã€ã³ã³ããããŸãã

è¡åç¯å²ã調æŽããå Žåãè¡ååŒã¯èªåçã«èª¿æŽãããŸããããã®å Žåã¯ãçµæã衚瀺ãããç¯å²ã倿ŽããŠããã ãã§ãã
By holding down the CommandCtrl key, you can create a copy of the array formula in the given range.
æ¡ä»¶ä»ãè¡åèšç®
æ¡ä»¶ä»ãè¡åèšç®ã§ã¯ãIF() ãŸã㯠CHOOSE() 颿°ãå«ãè¡ååŒã䜿çšããŸããæ°åŒã«ãããæ¡ä»¶ä»ãåŒæ°ãšã¯ãç¯å²åç §ãŸãã¯è¡åã®çµæã§ãã
次ã®äŸã§ã¯ã{=IF(A1:A3>0;"yes";"no")} åŒã® >0 æ€å®ã A1:A3 ã®ç¯å²ã®åã»ã«ã«é©çšãããçµæã察å¿ããã»ã«ã«ã³ããŒãããŸãã
A |
B (æ°åŒ) |
B (çµæ) |
|
1 |
1 |
{=IF(A1:A3>0;"yes";"no")} |
Yes |
2 |
0 |
{=IF(A1:A3>0;"yes";"no")} |
No |
3 |
1 |
{=IF(A1:A3>0;"yes";"no")} |
Yes |
CORRELãCOVARãFORECASTãFTESTãINTERCEPTãMDETERMãMINVERSEãMMULTãMODEãPEARSONãPROBãRSQãSLOPEãSTEYXãSUMPRODUCTãSUMX2MY2ãSUMX2PY2ãSUMXMY2ãããã³ TTEST 颿°ã¯ã匷å¶çãªè¡ååŠçãè¡ããŸãããããã®é¢æ°ã®ãããããåŒã³åºããšãã«ãç¯å²åç §ãåŒæ°ãšããŠäœ¿çšãããšã颿°ã¯è¡ååŒã®ããã«ãªããŸãã匷å¶çãªè¡ååŠçã®äŸã次ã®è¡šã«ç€ºããŸãã
A |
B (æ°åŒ) |
B (çµæ) |
C (匷å¶çãªè¡ååŒ) |
C (çµæ) |
|
1 |
1 |
=A1:A2+1 |
2 |
=SUMPRODUCT(A1:A2+1) |
5 |
2 |
2 |
=A1:A2+1 |
3 |
=SUMPRODUCT(A1:A2+1) |
5 |
3 |
=A1:A2+1 |
#VALUE! |
=SUMPRODUCT(A1:A2+1) |
5 |
FREQUENCY
1 åã§æ§æãããè¡åã®åºŠæ°ååžã瀺ããŸããã¯ã©ã¹è¡åã®å€ã®ç¯å²ã«ããããŒã¿è¡åã®å€ã®æ°ãæ°ããŸãã
æ§æ
FREQUENCY(ããŒã¿; ã¯ã©ã¹)
ããŒã¿ ãšã¯ãæ°ãã察象ãšãªãå€ã®åç §ã§ãã
ã¯ã©ã¹ ãšã¯ãéçå€ã®è¡åã§ãã

ãã®ããŒãžã®äžçªäžãããè¡å颿°ã«é¢ããäžè¬æ å ±ãæ¢ããŸãã
äŸ
次ã®è¡šã§ã¯ãå A ã«ã¯äžŠã¹æ¿ããããŠããªã枬å®å€ããªã¹ããããŠããŸããå B ã«ã¯å A ã®ããŒã¿ãåå²ããã¯ã©ã¹ã®äžéå€ãå«ãŸããŸããB1 ã«å ¥åãããéçå€ã«åºã¥ããFREQUENCY 颿°ã¯ 5 以äžã®æž¬å®å€ã®æ°ãè¿ããŸããB2 ã®éçå€ã 10 ã§ããã°ãFREQUENCY 颿°ã¯ 2 ã€ãã®çµæãšã㊠5 ãã倧ãã 10 以äžã®æž¬å®å€ãè¿ããŸããB6 ã«å ¥åããããã¹ãã>25ãã¯ãåç §çšãšããŠã®ã¿äœ¿çšãããŸãã
A |
B |
C |
|
1 |
12 |
5 |
1 |
2 |
8 |
10 |
3 |
3 |
24 |
15 |
2 |
4 |
11 |
20 |
3 |
5 |
5 |
25 |
1 |
6 |
20 |
>25 |
1 |
7 |
16 |
||
8 |
9 |
||
9 |
7 |
||
10 |
16 |
||
11 |
33 |
ã¯ã©ã¹ã®äžéå€ããã倧ããå€ã®é »åºŠãå ¥åãããåç¬ã®ã»ã«ç¯å²ãéžæããŸããã¯ã©ã¹ã®äžéå€ããã 1 ãã£ãŒã«ãå€ãéžæããªããã°ãªããŸãããããã§ã¯ãC1:C6 ãéžæããŸãã颿°ãŠã£ã¶ãŒã ã§ FREQUENCY 颿°ãåŒã³åºããŸããããŒã¿ ã®æž¬å®ç¯å²ã (A1:A11) ã§éžæããæ¬¡ã«ã¯ã©ã¹éç (B1:B6) ãå ¥åãã ã¯ã©ã¹ ã®åãéžã³ãŸããè¡å ãã§ãã¯ããã¯ã¹ããªã³ã«ããOK ãã¯ãªãã¯ããŸããæåã«éžæãããç¯å² C1:C6 ã«é »åºŠã衚瀺ãããŸãã
More explanations on top of this page.
GROWTH
è¡åå ã®ææ°ãã¬ã³ãã®ãã€ã³ããèšç®ããŸãã
æ§æ
GROWTH(ããŒã¿ Y; ããŒã¿ X; æ°ããããŒã¿ X; 颿°ã¿ã€ã)
ããŒã¿ Y ã¯ãY ããŒã¿è¡åã衚ããŸãã
ããŒã¿ X (ãªãã·ã§ã³) ã¯ãX ããŒã¿è¡åã衚ããŸãã
æ°ããããŒã¿ X (ãªãã·ã§ã³) ã¯ãå€ãåèšç®ãã X ããŒã¿ã®è¡åã衚ããŸãã
颿°ã¿ã€ã (ãªãã·ã§ã³)ã颿°ã¿ã€ã = 0 ã®å Žåã¯ãy = m^x ãšãã圢åŒã®é¢æ°ãèšç®ãããŸãããã®ä»ã®å Žåã¯ãy = b*m^x ãšãã颿°ãèšç®ãããŸãã
In the LibreOffice Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.
More explanations on top of this page.
äŸ
ãã®é¢æ°ã¯è¡åãè¿ããã»ãã®è¡å颿°ãšåãããã«åŠçãããŸããåçã衚瀺ããç¯å²ãšé¢æ°ãéžæããŸããããŒã¿ Y ãéžæããŸããäœããã®ã»ãã®ãã©ã¡ãŒã¿ãŒãå ¥åãããè¡åã ãããŒã¯ããŠããOKã ãã¯ãªãã¯ããŸãã
LINEST
ããŒã¿ã°ã«ãŒãã«ãã£ãšãé©åããçŽç·ã®çµ±èšå€ã®ããŒãã« (衚) ãè¿ããŸãã
æ§æ
LINEST(ããŒã¿ Y; ããŒã¿ X; ç·åœ¢ã¿ã€ã; çµ±èš)
data_Y ã¯ããŒã¿ãã€ã³ãã°ã«ãŒãã®äžã§ Y 座æšã瀺ã 1 è¡ãŸãã¯åã®ç¯å²ã§ãã
data_X ã¯ã察å¿ãã 1 ã€ã®è¡ããŸãã¯ãX 座æšçŸ€ãèšè¿°ããã«ã©ã ç¯å²ã§ãããããdata_x ãçç¥ãããå Žåãããã©ã«ã㯠1, 2, 3, ..., n ã«ãªããŸãã1 ã€ä»¥äžã®å€æ°ã®ã»ãããããå Žåãdata_Xã¯å¯Ÿå¿ããè€æ°ã®è¡ãŸãã¯åã®ç¯å²ã«ãªããããããŸããã
LINEST ã¯ãç·åœ¢ååž° (æå°äºä¹æ³) ã䜿ã£ãŠããã£ãšãããŒã¿ã«é©åããçŽç· y = a + bx ãèŠã€ããŸãã1 ã€ä»¥äžã®å€æ°ãããå Žåããã®çŽç·ã¯ y = a + b1x1 + b2x2 ... + bnxn ãšãã圢åŒã®ãã®ã«ãªããŸãã
If linearType is FALSE the straight line found is forced to pass through the origin (the constant a is zero; y = bx). If omitted, linearType defaults to TRUE (the line is not forced through the origin).
If stats is omitted or FALSE only the top line of the statistics table is returned. If TRUE the entire table is returned.
LINEST ã¯ä»¥äžã®ããã«çµ±èšããŒãã« (è¡å) ãè¿ããŸãããŸããè¡ååŒãšããŠå ¥åãããªããã°ãªããŸãã (ã€ãŸããåãªã Return ã§ã¯ãªã CommandCtrl+Shift+Return ã䜿çšããŸã)ã
In the LibreOffice Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.
More explanations on top of this page.
äŸ
ãã®é¢æ°ã¯è¡åãè¿ããã»ãã®è¡å颿°ãšåãããã«åŠçãããŸããåçç¯å²ãšé¢æ°ãéžæããŸããããŒã¿ Y ãéžæããŸããå¿ èŠãªå Žåã¯ãã»ãã®ãã©ã¡ãŒã¿ãŒãå ¥åããŸãããè¡åã ãéžæãããOKã ãã¯ãªãã¯ããŸãã
(çµ±èšã 0 ã®å Žåã«) ã·ã¹ãã ã«ãã£ãŠè¿ãããçµæã¯ãå°ãªããšãååž°çŽç·ãšååž°çŽç·ãš Y 軞ã®äº€å·®ã瀺ããŸããçµ±èšã 0 ã§ãªãå Žåã¯ãã»ãã®çµæã衚瀺ãããŸãã
ãã®ä»ã® LINEST ã®çµæã¯ä»¥äžã®ãšããã§ãã
以äžã®äŸãæ€èšŒããŸãã
A |
B |
C |
D |
E |
F |
G |
|
1 |
x1 |
x2 |
y |
æ®åäŸ¡é¡ |
|||
2 |
4 |
7 |
100 |
4,17 |
-3,48 |
82,33 |
|
3 |
5 |
9 |
105 |
5,46 |
10,96 |
9,35 |
|
4 |
6 |
11 |
104 |
0,87 |
5,06 |
#NA |
|
5 |
7 |
12 |
108 |
13,21 |
4 |
#NA |
|
6 |
8 |
15 |
111 |
675,45 |
102,26 |
#NA |
|
7 |
9 |
17 |
120 |
||||
8 |
10 |
19 |
133 |
å A ã«ã¯ããã€ãã® X1 å€ããå B ã«ã¯ããã€ãã® X2 å€ãããããŠå C ã«ã¯ Y å€ãå«ãŸããŠããŸãããããã®å€ã¯ã衚èšç®ããã¥ã¡ã³ãã«ãã§ã«å ¥åãããŠããŸããããã§ã衚èšç®ããã¥ã¡ã³ãã« E2:G6 ãèšå®ããã颿°ãŠã£ã¶ãŒã ããªã³ã«ãªã£ãŠããŸããLINEST 颿°ãå®è¡ããã«ã¯ã颿°ãŠã£ã¶ãŒã ã® è¡å ãã§ãã¯ããã¯ã¹ããªã³ã«ããå¿ èŠããããŸããæ¬¡ã«ã衚èšç®ããã¥ã¡ã³ãã§ä»¥äžã®å€ãéžæããŸã (ãŸãã¯ãå€ãããŒããŒãããå ¥åããŸã)ã
ããŒã¿ Y 㯠C2:C8 ã§ãã
ããŒã¿ X 㯠A2:B8 ã§ãã
ç·åœ¢ã¿ã€ã ãš çµ±èšæ å ± ã®äž¡æ¹ã« 1 ãèšå®ãããŸãã
OK ãã¯ãªãã¯ãããšãLibreOffice Calc ã¯äžã®äŸã« LINEST å€ãå ¥åããŸãã
æ°åŒ ããŒã®æ°åŒã¯ãLINEST è¡å {=LINEST(C2:C8;A2:B8;1;1)} ã®åã»ã«ã«å¯Ÿå¿ããŸãã
ããã¯èšç®çµæã§ãã LINEST å€ã§ã:
E2 ãš* F2:x1 ãš x2 ã®å€ã«å¯Ÿããååž°çŽç· y=b+m*x ã®åŸã mãå€ã¯éæ¹åã«æå®ãããŸããã€ãŸããx2 ã®åŸã㯠E2ãx1 ã®åŸã㯠F2 ã«æå®ãããŸãã
G2: y 軞ãšã®äº€å·® b
E3 ããã³ F3: åŸãå€ã®æšæºèª€å·®
G3: åçã®æšæºèª€å·®
E4: RSQ
F4: Y å€ã®ååž°ã®æšæºèª€å·®
E5: å·®ç°åæããåŸããã F å€
F5: å·®ç°åæããåŸãããèªç±åºŠ
E6: ç·åœ¢å¹³åããå°ãããY ã®äºæž¬å€ã®å¹³æ¹åå·®ã®å
F6: äžå®ã® Y å€ããå°ãããY ã®äºæž¬å€ã®å¹³æ¹åå·®ã®å
More explanations on top of this page.
LOGEST
ãã®é¢æ°ã¯ãå ¥åããã調æŽãããããŒã¿ãææ°ååž°æ²ç© (y=b*m^x) ãšããŠèšç®ããŸãã
æ§æ
LOGEST(ããŒã¿ Y; ããŒã¿ X; 颿°ã¿ã€ã; çµ±èš)
ããŒã¿ Y ã¯ãY ããŒã¿è¡åã衚ããŸãã
ããŒã¿ X (ãªãã·ã§ã³) ã¯ãX ããŒã¿è¡åã衚ããŸãã
颿°ã¿ã€ã (ãªãã·ã§ã³)ã颿°ã¿ã€ã = 0 ã®å Žåã¯ãy = m^x ãšãã圢åŒã®é¢æ°ãèšç®ãããŸãããã®ä»ã®å Žåã¯ãy = b*m^x ãšãã颿°ãèšç®ãããŸãã
çµ±èšå€ (ãªãã·ã§ã³)ãçµ±èšå€=0 ã§ããã°ãååž°ä¿æ°ã®ã¿ãèšç®ãããŸãã
In the LibreOffice Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.
More explanations on top of this page.
äŸ
LINEST ãåç §ããŠãã ããããã ããå¹³æ¹åã¯è¿ãããŸããã
MDETERM
è¡åã®è¡ååŒãè¿ããŸãããã®é¢æ°ã¯ãçŸåšã®ã»ã«ã®å€ãè¿ããŸããçµæãè¿ãããã«ç¯å²ãæå®ããå¿ èŠã¯ãããŸããã
æ§æ
MDETERM(è¡å)
è¡å ãšã¯ãè¡ååŒãæå®ãããå¹³æ¹è¡åã§ãã

You can find a general introduction to using Array functions on top of this page.
More explanations on top of this page.
MINVERSE
éè¡åãè¿ããŸãã
æ§æ
MINVERSE(è¡å)
è¡å ãšã¯ãé転ãããå¹³æ¹è¡åã§ãã
More explanations on top of this page.
äŸ
ç¯å²ãéžæããŠãããMINVERSE ãéžæããŸããæ¬¡ã«ãåºåè¡åãéžæããè¡å ãã£ãŒã«ããéžãã§ãã OK ãã¯ãªãã¯ããŸãã
MMULT
2 ã€ã®è¡åã®è¡åç©ãèšç®ããŸããè¡å 1 ã®åæ°ã¯ãè¡å 2 ã®è¡æ°ãšäžèŽããªããã°ãªããŸãããå¹³æ¹è¡åã¯ãåæ°ã®è¡ãšåãæã¡ãŸãã
æ§æ
MMULT(è¡å; è¡å)
æåã®äœçœ®ã«ãã è¡å ã¯ãè¡åç©ã§äœ¿çšãããæåã®è¡åã§ãã
2 ã€ãã® è¡å ãšã¯ãè¡æ°ãåãã® 2 ã€ãã®è¡åã§ãã
äŸ
ç¯å²ãéžæããŸããMMULT 颿°ãéžã³ãŸããæåã® è¡å ãéžæããæ¬¡ã« 2 ã€ãã® è¡å ãéžæããŸãã颿°ãŠã£ã¶ãŒã ã䜿çšããè¡å ãã§ãã¯ããã¯ã¹ããªã³ã«ããOK ãã¯ãªãã¯ããŸããåºåè¡åããæåã«éžæãããç¯å²ã«è¡šç€ºãããŸãã
MUNIT
äžå®ãµã€ãºã®åäœå¹³æ¹è¡åãè¿ããŸããåäœè¡åãšã¯ãäž»èŠå¯Ÿè§èŠçŽ ã 1ããã®ä»ã®è¡åèŠçŽ ã 0 ã«ãªãå¹³æ¹è¡åã§ãã
æ§æ
MUNIT(寞æ³)
å¯žæ³ ãšã¯ãè¡åã®åäœã®ãµã€ãºã§ãã

ãã®ããŒãžã®äžçªäžãããè¡å颿°ã«é¢ããäžè¬æ å ±ãæ¢ããŸãã
äŸ
A1 ïœ E5 ãªã©ã衚èšç®ããã¥ã¡ã³ãå ã§ç¯å²ãéžæããŸãã
ç¯å²ã®éžæãè§£é€ããã«ãMUNIT 颿°ãéžæããŸãããè¡åã ãã§ãã¯ããã¯ã¹ãããŒã¯ããŸãã䜿çšããè¡ååäœã®æ¬¡æ°ãå ¥åããŸãããã®å Žåã¯ã5 ãå ¥åããŸãããOKã ãã¯ãªãã¯ããŸãã
éžæããç¯å² (E5) ã®æåŸã®ã»ã«ã«æ°åŒ =Munit(5) ãå ¥åããShift + Command + EnterShift + Ctrl + Enter ãæŒãããšãã§ããŸãã
ç¯å²ã A1:E5 ã®åäœè¡åã瀺ãããŸãã
More explanations on top of this page.
SUMPRODUCT
æå®ã®è¡åå ã«ãããŠäžèŽããèŠçŽ ãä¹ç®ãããããã®ç©ã®åãè¿ããŸãã
æ§æ
SUMPRODUCT(è¡å 1; è¡å 2...è¡å 30)
è¡å 1ãè¡å 2...è¡å 30 ã¯ã察å¿ããèŠçŽ ãä¹ç®ãããè¡åã衚ããŸãã
å°ãªããšã 1 ã€ã®è¡åãåŒæ°ãªã¹ãã®äžéšã§ãªããã°ãªããŸãããè¡åã 1 ã€ããäžããããŠããªãå Žåããã¹ãŠã®è¡åèŠçŽ ãåèšãããŸãã
äŸ
A |
B |
C |
D |
|
1 |
2 |
3 |
4 |
5 |
2 |
6 |
7 |
8 |
9 |
3 |
10 |
11 |
12 |
13 |
=SUMPRODUCT(A1:B3;C1:D3) ã¯ã397 ãè¿ããŸãã
èšç®: A1*C1 + B1*D1 + A2*C2 + B2*D2 + A3*C3 + B3*D3
SUMPRODUCT ã䜿çšãããšã2 ã€ã®ç¯å²ã®ã¹ã«ã©ãŒç©ãèšç®ã§ããŸãã

SUMPRODUCT ã¯åäžã®å€ãè¿ãã®ã§ã颿°ãè¡ååŒãšããŠå ¥åããå¿ èŠã¯ãããŸããã
More explanations on top of this page.
SUMX2MY2
2 ã€ã®è¡åã«ãããŠäžèŽããå€ã®å¹³æ¹å·®ã®åãè¿ããŸãã
æ§æ
SUMX2MY2(è¡å X; è¡å Y)
è¡å X ã¯ãèŠçŽ ãå¹³æ¹ãããŠå ç®ãããæåã®è¡åã衚ããŸãã
è¡å Y ã¯ãèŠçŽ ãå¹³æ¹ãããŠæžç®ããã 2 çªç®ã®è¡åã衚ããŸãã
More explanations on top of this page.
SUMX2PY2
2 ã€ã®è¡åã«ãããŠäžèŽããå€ã®å¹³æ¹åã®åãè¿ããŸãã
æ§æ
SUMX2PY2(è¡å X; è¡å Y)
è¡å X ã¯ãèŠçŽ ãå¹³æ¹ãããŠå ç®ãããæåã®è¡åã衚ããŸãã
è¡å Y ã¯ãèŠçŽ ãå¹³æ¹ãããŠå ç®ããã 2 çªç®ã®è¡åã衚ããŸãã
More explanations on top of this page.
SUMXMY2
2 ã€ã®è¡åã§äžèŽããå€ã®åå·®ã®å¹³æ¹ãå ç®ããŸãã
æ§æ
SUMXMY2(è¡å X; è¡å Y)
è¡å X ã¯ãèŠçŽ ãæžç®ãããŠå¹³æ¹ãããæåã®è¡åã衚ããŸãã
è¡å Y ã¯ãèŠçŽ ãæžç®ãããŠå¹³æ¹ããã 2 çªç®ã®è¡åã衚ããŸãã
More explanations on top of this page.
TRANSPOSE
è¡åã®è¡ãšåãå ¥ãæ¿ããŸãã
æ§æ
TRANSPOSE(è¡å)
è¡å ãšã¯ã衚èšç®ããã¥ã¡ã³ãã®è¡åã®äžã§è¡ãšåãå ¥ãæ¿ãããã®ãæããŸãã

ãã®ããŒãžã®äžçªäžãããè¡å颿°ã®äœ¿çšã«é¢ããäžè¬æ å ±ãæ¢ããŸãã
äŸ
衚èšç®ããã¥ã¡ã³ãã§ãè¡ãšåãå ¥ãæ¿ããè¡åã衚瀺ããç¯å²ãéžæããŸããå ã®è¡åã n è¡ãš m åã§æ§æãããŠããå Žåã¯ãéžæãããç¯å²ã«ã¯å°ãªããšã m è¡ãš n åãªããã°ãªããŸãããæ¬¡ã«ãæ°åŒãçŽæ¥å ¥åããŠããå ã®è¡åãéžæãã(Shift) + (Command) + (Enter)(Shift) + (Ctrl) + (Enter) ããŒãæŒããŸãã颿°ãŠã£ã¶ãŒã ã䜿çšããå Žåã¯ãè¡å ãã§ãã¯ããã¯ã¹ããªã³ã«ããŸããè¡ãšåãå ¥ãæ¿ããè¡åãéžæããç¯å²ã«è¡šç€ºããã倿Žãããªãããèªåçã«ä¿è·ãããŸãã
A |
B |
C |
D |
|
1 |
2 |
3 |
4 |
5 |
2 |
6 |
7 |
8 |
9 |
The above table is 2 rows, 4 columns. In order to transpose it, you must select 4 rows, 2 columns. Assuming you want to transpose the above table to the range A7:B10 (4 rows, 2 columns) you must select the entire range and then enter the following:
TRANSPOSE(A1:D2)
Then make sure to enter it as matrix formula with Shift+Command+EnterShift+Ctrl+Enter. The result will be as follows:
A |
B |
|
7 |
2 |
6 |
8 |
3 |
7 |
9 |
4 |
8 |
10 |
5 |
9 |
TREND
ç·åœ¢ãã¬ã³ãäžã®å€ãè¿ããŸãã
æ§æ
TREND(ããŒã¿ Y; ããŒã¿ X; æ°ããããŒã¿ X; ç·åœ¢ã¿ã€ã)
ããŒã¿ Y ã¯ãY ããŒã¿è¡åã衚ããŸãã
ããŒã¿ X (ãªãã·ã§ã³) ã¯ãX ããŒã¿è¡åã衚ããŸãã
æ°ããããŒã¿ X (ãªãã·ã§ã³) ã¯ãå€ã®åèšç®ã«äœ¿çšããã X ããŒã¿ã®è¡åã衚ããŸãã
ç·åœ¢ã¿ã€ã (ãªãã·ã§ã³)ãç·åœ¢ã¿ã€ã = 0 ã«ãããšãç·ã¯ãŒãç¹ãéãããã«èšç®ãããŸãããã®ä»ã®å Žåã¯ããªãã»ããç·ãèšç®ãããŸããæšæºå€ã¯ ç·åœ¢ã¿ã€ã <> 0ã§ãã
In the LibreOffice Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.
More explanations on top of this page.
äŸ
ãã¬ã³ãããŒã¿ã衚瀺ãã衚èšç®ããã¥ã¡ã³ãå ã®ç¯å²ãéžæããŸãããŸãã颿°ãéžæããŸããåºåããŒã¿ãå ¥åããããåºåããŒã¿ãããŠã¹ã§éžæããŸããè¡å ãã£ãŒã«ããããŒã¯ããOK ãã¯ãªãã¯ããŸãããããšãåºåããŒã¿ããèšç®ããããã¬ã³ãããŒã¿ã瀺ãããŸãã