{"id":4770,"date":"2024-10-17T09:09:51","date_gmt":"2024-10-17T09:09:51","guid":{"rendered":"https:\/\/howtogeek.blog\/ko\/?p=4770"},"modified":"2024-10-17T09:09:51","modified_gmt":"2024-10-17T09:09:51","slug":"a-comprehensive-guide-on-using-the-trend-function-in-excel","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/ko\/a-comprehensive-guide-on-using-the-trend-function-in-excel\/","title":{"rendered":"Excel\uc5d0\uc11c TREND \ud568\uc218 \uc0ac\uc6a9\uc5d0 \ub300\ud55c \ud3ec\uad04\uc801\uc778 \uac00\uc774\ub4dc"},"content":{"rendered":"<p>Excel\uc758 TREND \ud568\uc218\ub294 \uc0ac\uc6a9\uc790\uac00 \ucd5c\uc18c \uc81c\uacf1 \ud1b5\uacc4 \ubc29\ubc95\uc744 \ud1b5\ud574 \ucc28\ud2b8\uc5d0 \ud45c\uc2dc\ub41c \ub370\uc774\ud130\uc5d0 \uac00\uc7a5 \uc801\ud569\ud55c \uc120\uc744 \uacc4\uc0b0\ud560 \uc218 \uc788\ub294 \uac15\ub825\ud55c \ub3c4\uad6c\uc785\ub2c8\ub2e4. \uc774 \ud568\uc218\uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 \uae30\ubcf8 \ubc29\uc815\uc2dd\uc740 <code>y = mx + b<\/code>, \uc5ec\uae30\uc11c <strong>y\ub294<\/strong> \uc885\uc18d \ubcc0\uc218\ub97c \ub098\ud0c0\ub0b4\uace0, <strong>m<\/strong> \uc740 \uc120\uc758 \uae30\uc6b8\uae30, <strong>x\ub294<\/strong> \ub3c5\ub9bd \ubcc0\uc218\ub97c \ub098\ud0c0\ub0b4\uace0, <strong>b\ub294<\/strong> \ucd94\uc138\uc120\uc774 y\ucd95\uacfc \uad50\ucc28\ud558\ub294 \uc9c0\uc810\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/p>\n<h2 id=\"using-the-trend-function\">TREND \ud568\uc218 \ud65c\uc6a9\ud558\uae30<\/h2>\n<p>TREND \ud568\uc218\ub294 \ub2e4\uc591\ud55c \uc2dc\ub098\ub9ac\uc624\uc5d0\uc11c \ub9e4\uc6b0 \uadc0\uc911\ud560 \uc218 \uc788\ub294\ub370, \uc608\ub97c \ub4e4\uc5b4 \ud2b9\uc815 \uae30\uac04 \ub3d9\uc548\uc758 \uc218\uc775\uc744 \ubd84\uc11d\ud558\uc5ec \ucd94\uc138\ub97c \ud30c\uc545\ud558\ub294 \uacbd\uc6b0\uc785\ub2c8\ub2e4.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"538\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-303-1.webp\" title=\"\" width=\"957\"\/><\/figure>\n<ul>\n<li>\uc704\uc5d0 \uc124\uba85\ub41c \uc608\uc5d0\uc11c \uc140 C2\uc5d0 \ub2e4\uc74c \uacf5\uc2dd\uc744 \uc785\ub825\ud569\ub2c8\ub2e4. <code>=TREND(B2:B14,A2:A14)<\/code>\uc774 \uacbd\uc6b0 &#8216;B2:B14&#8217;\ub294 \uc54c\ub824\uc9c4 y \uac12\uc744 \ub098\ud0c0\ub0b4\uace0 &#8216;A2:A14&#8217;\ub294 \uc54c\ub824\uc9c4 x \uac12\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"430\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-304-1.webp\" title=\"\" width=\"764\"\/><\/figure>\n<ul>\n<li>Enter \ud0a4\ub97c \ub204\ub974\uba74 \ucd94\uc138\uac00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\uc5d0 \ubc30\uc5f4\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"521\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-305-1.webp\" title=\"\" width=\"927\"\/><\/figure>\n<ul>\n<li>\ucd94\uc138\uac00 \ud655\ub9bd\ub418\uba74 <code>=TREND(B2:B14,A2:A14,A15:A18)<\/code>\uc140 C15\uc5d0 \uc785\ub825\ud558\uc5ec \ubbf8\ub798 \uae30\uac04\uc758 \ub370\uc774\ud130\ub97c \uc608\uce21\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc11c &#8216;A2:A14&#8217;\ub294 \uc5ec\uc804\ud788 \uc54c\ub824\uc9c4 x \uac12\uc744 \ucc38\uc870\ud558\ub294 \ubc18\uba74 &#8216;B2:B14&#8217;\ub294 \uc54c\ub824\uc9c4 y \uac12\uc744 \ucc38\uc870\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"461\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-306-1.webp\" title=\"\" width=\"820\"\/><\/figure>\n<ul>\n<li>Enter \ud0a4\ub97c \ub20c\ub7ec \ubbf8\ub798 \uae30\uac04\uc5d0 \ub300\ud55c \uc608\uc0c1 \uac12\uc744 \uc5bb\uc73c\uc138\uc694.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"452\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-307-1.webp\" title=\"\" width=\"804\"\/><\/figure>\n<h2 id=\"trend-function-in-charts\">\ucc28\ud2b8\uc5d0 TREND \ud568\uc218 \ud1b5\ud569<\/h2>\n<p>TREND \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ub3c4\ucd9c\ud55c \ud6c4\uc5d0\ub294 \ucc28\ud2b8 \ud615\uc2dd\uc73c\ub85c \uc2dc\uac01\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li>\uba38\ub9ac\uae00\uc744 \ud3ec\ud568\ud558\uc5ec \uc6cc\ud06c\uc2dc\ud2b8\uc5d0\uc11c \ubaa8\ub4e0 \uad00\ub828 \ub370\uc774\ud130\ub97c \uac15\uc870 \ud45c\uc2dc\ud55c \ub2e4\uc74c, \uc704\ucabd\uc5d0 \uc788\ub294 &#8216;\uc0bd\uc785&#8217; \ud0ed\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"498\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-308-1.webp\" title=\"\" width=\"885\"\/><\/figure>\n<ul>\n<li>\ub2e4\uc74c\uc73c\ub85c, \ucc28\ud2b8 \uc635\uc158\uc5d0\uc11c &#8216;2D \ud074\ub7ec\uc2a4\ud130\ud615 \ub9c9\ub300\ud615 \ucc28\ud2b8&#8217;\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4. Excel \ubc84\uc804\uc5d0 \ub530\ub77c \ubaa8\uc591\uc774 \uc57d\uac04 \ub2e4\ub97c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"509\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-310-1.webp\" title=\"\" width=\"905\"\/><\/figure>\n<ul>\n<li>\ucc28\ud2b8\uac00 \uc0dd\uc131\ub418\uba74 \uc218\uc775 \ub370\uc774\ud130(\ub3c5\ub9bd \ubcc0\uc218)\uc640 \ucd94\uc138\uc120\uc744 \ubaa8\ub450 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ucd94\uc138\uc120\uc744 \uadf8\ub798\ud53d \uc120\uc73c\ub85c \ud45c\ud604\ud558\ub824\uba74 \ucc28\ud2b8\ub97c \ub9c8\uc6b0\uc2a4 \uc624\ub978\ucabd \ubc84\ud2bc\uc73c\ub85c \ud074\ub9ad\ud558\uace0 &#8216;\ucc28\ud2b8 \uc720\ud615 \ubcc0\uacbd&#8217;\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"477\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-311-1.webp\" title=\"\" width=\"848\"\/><\/figure>\n<ul>\n<li>\uc0ac\uc6a9 \uac00\ub2a5\ud55c \uc635\uc158\uc5d0\uc11c &#8216;\ucf64\ubcf4&#8217;\ub97c \uc120\ud0dd\ud558\uace0 \ucd94\uc138\uc120\uc774 &#8216;\uc120&#8217;\uc73c\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778\ud558\uc138\uc694.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"480\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-313-1.webp\" title=\"\" width=\"853\"\/><\/figure>\n<ul>\n<li>&#8216;\ud655\uc778&#8217;\uc744 \ud074\ub9ad\ud558\uc5ec \uc5c5\ub370\uc774\ud2b8\ub41c \ucc28\ud2b8\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \ubaa8\uc11c\ub9ac\uc5d0 \uc788\ub294 &#8216;+&#8217; \uc544\uc774\ucf58\uc744 \ud074\ub9ad\ud558\uc5ec \ubc94\ub840\ub97c \uc81c\uac70\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"531\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-314-1.webp\" title=\"\" width=\"944\"\/><\/figure>\n<p>\ub370\uc774\ud130 \uc138\ud2b8\uc5d0\uc11c \ucd94\uc138\ub97c \uc2dc\uac01\ud654\ud55c \ud6c4 \uae30\uc6b8\uae30\ub97c \uacc4\uc0b0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h3 id=\"things-to-know\">\uae30\uc5b5\ud574\uc57c \ud560 \uc911\uc694\ud55c \uc810<\/h3>\n<ul>\n<li>TREND \ud568\uc218\ub294 FORECAST \ud568\uc218\uc640 \ube44\uc2b7\ud55c \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \ud558\uc9c0\ub9cc TREND \ud568\uc218\ub294 \uacfc\uac70 \ub370\uc774\ud130\uc5d0 \ucd08\uc810\uc744 \ub450\ub294 \ubc18\uba74, FORECAST\ub294 \uc2dc\ub9ac\uc988\uc758 \ubbf8\ub798 \uac12\uc744 \uc608\uce21\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n<li>\ubbf8\ub798 \uc608\uce21\uc744 \uc124\uba85\ud558\uace0 \uc2f6\uc9c0 \uc54a\ub2e4\uba74 TREND \ud568\uc218\ub97c \ud65c\uc6a9\ud558\uc9c0 \uc54a\uace0 Excel\uc5d0\uc11c \ucc28\ud2b8\uc5d0 \uc9c1\uc811 \ucd94\uc138\uc120\uc744 \ucd94\uac00\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li>&#8216;\uc0bd\uc785&#8217; \ud0ed\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc2a4\ud30c\ud06c\ub77c\uc778\uc740 \ub370\uc774\ud130 \ub0b4\uc758 \ucd94\uc138\ub97c \uc2dc\uac01\ud654\ud558\ub294 \ub610 \ub2e4\ub978 \ubc29\ubc95\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/li>\n<li>\ubc30\uc5f4 \ucd9c\ub825\uc744 \uc0dd\uc131\ud558\ub294 \uc218\uc2dd\uc73c\ub85c \uc791\uc5c5\ud560 \ub54c\ub294 .\uc744 \uc0ac\uc6a9\ud558\uc5ec \ubc30\uc5f4 \uc218\uc2dd\uc73c\ub85c \uc785\ub825\ud574\uc57c \ud569\ub2c8\ub2e4 <code>Ctrl + Shift + Enter<\/code>. \ubc18\ub300\ub85c Microsoft 365\uc758 \uc5c5\ub370\uc774\ud2b8\ub41c \ubc84\uc804\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 Enter\ub97c \ub204\ub974\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p><a class=\"xiaomi\" href=\"https:\/\/allthings.how\/how-to-use-the-trend-function-in-excel\/\" rel=\"noopener nofollow\" target=\"_blank\">\uc6d0\ucc9c<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel\uc758 TREND \ud568\uc218\ub294 \uc0ac\uc6a9\uc790\uac00 \ucd5c\uc18c \uc81c\uacf1 \ud1b5\uacc4 \ubc29\ubc95\uc744 \ud1b5\ud574 \ucc28\ud2b8\uc5d0 \ud45c\uc2dc\ub41c \ub370\uc774\ud130\uc5d0 \uac00\uc7a5 \uc801\ud569\ud55c \uc120\uc744 \uacc4\uc0b0\ud560 \uc218 \uc788\ub294 \uac15\ub825\ud55c \ub3c4\uad6c\uc785\ub2c8\ub2e4. \uc774 \ud568\uc218\uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 \uae30\ubcf8 \ubc29\uc815\uc2dd\uc740 y = mx + b, \uc5ec\uae30\uc11c y\ub294 \uc885\uc18d \ubcc0\uc218\ub97c \ub098\ud0c0\ub0b4\uace0, m \uc740 \uc120\uc758 \uae30\uc6b8\uae30, x\ub294 \ub3c5\ub9bd \ubcc0\uc218\ub97c \ub098\ud0c0\ub0b4\uace0, b\ub294 \ucd94\uc138\uc120\uc774 y\ucd95\uacfc \uad50\ucc28\ud558\ub294 \uc9c0\uc810\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. TREND \ud568\uc218 \ud65c\uc6a9\ud558\uae30 TREND \ud568\uc218\ub294 \ub2e4\uc591\ud55c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[63,130,286],"class_list":["post-4770","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-apps","tag-microsoft","tag-microsoft-excel"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/4770","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/comments?post=4770"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/4770\/revisions"}],"predecessor-version":[{"id":4771,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/posts\/4770\/revisions\/4771"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/media?parent=4770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/categories?post=4770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/ko\/wp-json\/wp\/v2\/tags?post=4770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}