¿¹Á¦ ÆÄÀÏ ³»·Á¹Þ±â
ȸ±ÍºÐ¼®À» µ¹¸®¸é ÇÊÈ÷ °áÁ¤°è¼ö¸¦ È®ÀÎÇØ¾ß Çϴµ¥, ¿¢¼¿¿¡¼´Â Å©°Ô µÎ °¡Áö ¹æ½ÄÀ¸·Î °áÁ¤°è¼ö¸¦
±¸ÇÒ ¼ö ÀÖ´Ù. ¸·°ÇÑ 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))
ºÐ»êÇü Â÷Æ®¿¡¼ Ãß¼¼¼±À¸·Îµµ °áÁ¤°è¼ö¸¦ ±¸ÇÒ ¼ö ÀÖ´Ù. ±×·¯³ª Ãß¼¼¼±À¸·Î ±¸ÇÑ °áÁ¤°è¼ö´Â Á¤È®µµ°¡ ¶³¾îÁø´Ù´Â ´ÜÁ¡ÀÌ ÀÖ´Ù.

¡¡
|