HOME > »ç¿ëÀÚ Á¦°ø ÀÚ·á > Åë°è·Î ¼¼»óº¸±â

'¹«Áö°³Å¸°í'´ÔÀÇ Åë°è°­ÁÂ

Åë°è·Î ¼¼»óº¸±â | ¼Õ½±°Ô °áÁ¤°è¼ö ±¸Çϱâ

- Author : ¹«Áö°³Å¸°í

- Released : 2017-08-08

- Read : 869 ȸ


¿¹Á¦ ÆÄÀÏ ³»·Á¹Þ±â


ȸ±ÍºÐ¼®À» µ¹¸®¸é ÇÊÈ÷ °áÁ¤°è¼ö¸¦ È®ÀÎÇØ¾ß Çϴµ¥, ¿¢¼¿¿¡¼­´Â Å©°Ô µÎ °¡Áö ¹æ½ÄÀ¸·Î °áÁ¤°è¼ö¸¦ ±¸ÇÒ ¼ö ÀÖ´Ù. ¸·°­ÇÑ LinEst ÇÔ¼ö¿Í ´Ü¼øÈ¸±ÍºÐ¼®¿ë RSQ ÇÔ¼ö.

¾Æ·¡ ÀÚ·á¿¡ ´ëÇØ ¸î °¡Áö ¸ðÇüÀ» °¡Á¤ÇØ ÃßÁ¤Ä¡¸¦ ±¸ÇØ º¸¾Ò´Ù.
¡¡



Trend ÇÔ¼ö¸¦ Ȱ¿ëÇÏ¸é ¾Æ·¡¿Í °°Àº ¹æ½ÄÀ¸·Î ¼Õ½±°Ô ÃßÁ¤Ä¡¸¦ ±¸ÇÒ ¼ö ÀÖ´Ù.

E3 ¼¿ (Y=X©ø+X©÷+X):
=TREND($A$3:$A$9,$B$3:$B$9^{3,2,1},$B3^{3,2,1})

±×·³ °áÁ¤°è¼ö´Â?



LinEst ÇÔ¼ö¸¦ ÀÌ¿ëÇØ ±¸ÇÏ´Â ¹æ¹ýÀº ¿©·¯ Â÷·Ê ¼Ò°³Çß´Ù.

E13 ¼¿ (Y=X©ø+X©÷+X):
=INDEX(LINEST($A$3:$A$9,$B$3:$B$9^{3,2,1},TRUE,TRUE),3,1)

±×¸®°í RSQ ÇÔ¼ö´Â ´Ü¼øÈ¸±Í¸ðÇü¿¡¼­ °£ÆíÈ÷ ¾²´Â ÇÔ¼öÀ̳ª Áßȸ±Í¸ðÇü¿¡¼­´Â ¾Õ¼­ ±¸ÇÑ ÃßÁ¤Ä¡¸¦ °¡Áö°í °áÁ¤°è¼ö¸¦ ±¸ÇÑ´Ù. ¹°·Ð °á°ú´Â ¾Õ¼­ ±¸ÇÑ °á°ú¿Í °°´Ù.

E14 ¼¿ (Y=X©ø+X©÷+X):
=RSQ($A$3:$A$9,E$3:E$9)

´Ü, Á¶°ÇÀÌ ÀÖ´Ù. À§ÀÇ ¹æ¹ýÀº °¡¹ý¸ðÇü¿¡ »ç¿ëÇÏ´Â ¹æ½ÄÀ̰í, ½Â¹ý¸ðÇü¿¡¼­´Â º¯¼ö º¯È¯À» ÇØÁà¾ß ÇÑ´Ù. ´ëÇ¥Àû ½Â¹ý¸ðÇüÀÎ Áö¼ö ȸ±Í¸ðÇüÀ» °¡Á¤ÇØ ±¸Çϸé,



ÃßÁ¤Ä¡´Â º¯¼ö º¯È¯ ÈÄ Trend³ª Growth ÇÔ¼ö·Î ±¸ÇÑ´Ù.

H3 ¼¿ (Trend):
=EXP(TREND(LN($A$3:$A$9),$B$3:$B$9,$B3))

I3 ¼¿ (Growth):
=GROWTH($A$3:$A$9,$B$3:$B$9,$B3)

±×¸®°í °áÁ¤°è¼ö´Â º¯¼ö º¯È¯ ÈÄ LinEst³ª LogEst ÇÔ¼ö·Î ±¸ÇÑ´Ù.

H13 ¼¿ (LinEst):
=INDEX(LINEST(LN($A$3:$A$9),$B$3:$B$9,TRUE,TRUE),3,1)

I13 ¼¿ (LogEst):
=INDEX(LOGEST($A$3:$A$9,$B$3:$B$9,TRUE,TRUE),3,1)

½Â¹ý¸ðÇü¿¡¼­ RSQ ÇÔ¼ö¸¦ ÀÌ¿ëÇØ °áÁ¤°è¼ö¸¦ ±¸ÇÒ ¶§¿¡´Â Á¾¼Óº¯¼ö»Ó¸¸ ¾Æ´Ï¶ó ÃßÁ¤Ä¡¿¡µµ º¯¼ö º¯È¯ÀÌ ÇÊ¿äÇÏ´Ù.

H14 ¼¿:
=RSQ(LN($A$3:$A$9),LN(H$3:H$9))

ºÐ»êÇü Â÷Æ®¿¡¼­ Ãß¼¼¼±À¸·Îµµ °áÁ¤°è¼ö¸¦ ±¸ÇÒ ¼ö ÀÖ´Ù. ±×·¯³ª Ãß¼¼¼±À¸·Î ±¸ÇÑ °áÁ¤°è¼ö´Â Á¤È®µµ°¡ ¶³¾îÁø´Ù´Â ´ÜÁ¡ÀÌ ÀÖ´Ù.


¡¡


Previous

Next

ÀÌ ÆäÀÌÁöÀÇ ÀúÀÛ±ÇÀº ÄÁÅÙÃ÷ Á¦°øÀÚ¿¡°Ô ÀÖ½À´Ï´Ù.

º» °­ÁÂÀÇ ³»¿ëÀº ÇÊÀÚ °³ÀÎÀÇ °ßÇØÀ̸ç, ¾ÆÀÌ¿¢¼¿·¯ ´åÄÄÀÇ °ø½Ä Àǰ߰ú ÀÏÄ¡ÇÏÁö ¾ÊÀ» ¼öµµ ÀÖ½À´Ï´Ù.