{"id":2080,"date":"2023-07-23T19:07:47","date_gmt":"2023-07-23T19:07:47","guid":{"rendered":"https:\/\/statorials.org\/de\/manhattan-distance-excel\/"},"modified":"2023-07-23T19:07:47","modified_gmt":"2023-07-23T19:07:47","slug":"manhattan-distance-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/de\/manhattan-distance-excel\/","title":{"rendered":"So berechnen sie die manhattan-entfernung in excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Der <strong>Manhattan-Abstand<\/strong> zwischen zwei Vektoren <em>A<\/em> und <em>B<\/em> wird wie folgt berechnet:<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u03a3|A <sub>i<\/sub> \u2013 B <sub>i<\/sub> |<\/span><\/p>\n<p> <span style=\"color: #000000;\">wobei <em>i<\/em> das i- <sup>te<\/sup> Element jedes Vektors ist.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dieser Abstand wird zur Messung der Un\u00e4hnlichkeit zwischen zwei Vektoren verwendet und wird h\u00e4ufig in vielen <a href=\"https:\/\/statorials.org\/de\/die-statistik-erklart-konzepte-auf-einfache-und-direkte-weise.-wir-erleichtern-das-erlernen-von-statistiken\/\" target=\"_blank\" rel=\"noopener noreferrer\">Algorithmen f\u00fcr maschinelles Lernen<\/a> verwendet.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Das folgende Beispiel zeigt, wie der Manhattan-Abstand zwischen zwei Vektoren in Excel berechnet wird.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Beispiel: Manhattan-Entfernung in Excel berechnen<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Angenommen, wir haben die folgenden zwei Vektoren A und B in Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19377 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/manhattanexcel1.png\" alt=\"\" width=\"563\" height=\"474\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Um den Manhattan-Abstand zwischen diesen beiden Vektoren zu berechnen, m\u00fcssen wir zun\u00e4chst die Funktion <strong>ABS()<\/strong> verwenden, um die absolute Differenz zwischen jedem entsprechenden Element in den Vektoren zu berechnen:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19378 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/manhattanexcel2.png\" alt=\"\" width=\"494\" height=\"467\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Als n\u00e4chstes m\u00fcssen wir die Funktion <strong>SUM()<\/strong> verwenden, um jede der absoluten Differenzen zu addieren:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19379 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/manhattanexcel3.png\" alt=\"\" width=\"485\" height=\"467\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Der Manhattan-Abstand zwischen den beiden Vektoren betr\u00e4gt <strong>51<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Zus\u00e4tzliche Ressourcen<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Die folgenden Tutorials erkl\u00e4ren, wie Sie andere Entfernungen in Excel berechnen:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/de\/euklidischer-abstand-excel\/\" target=\"_blank\" rel=\"noopener\">So berechnen Sie den euklidischen Abstand in Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/de\/hamming-distanz-in-excel\/\" target=\"_blank\" rel=\"noopener\">So berechnen Sie die Hamming-Distanz in Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Der Manhattan-Abstand zwischen zwei Vektoren A und B wird wie folgt berechnet: \u03a3|A i \u2013 B i | wobei i das i- te Element jedes Vektors ist. Dieser Abstand wird zur Messung der Un\u00e4hnlichkeit zwischen zwei Vektoren verwendet und wird h\u00e4ufig in vielen Algorithmen f\u00fcr maschinelles Lernen verwendet. Das folgende Beispiel zeigt, wie der Manhattan-Abstand [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>So berechnen Sie die Manhattan-Distanz in Excel \u2013 Statistik<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial wird anhand von Beispielen erl\u00e4utert, wie Sie den Manhattan-Abstand zwischen zwei Vektoren in Excel berechnen.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/de\/manhattan-distance-excel\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"So berechnen Sie die Manhattan-Distanz in Excel \u2013 Statistik\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial wird anhand von Beispielen erl\u00e4utert, wie Sie den Manhattan-Abstand zwischen zwei Vektoren in Excel berechnen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/de\/manhattan-distance-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T19:07:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/manhattanexcel1.png\" \/>\n<meta name=\"author\" content=\"Dr. Benjamin Anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr. Benjamin Anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/de\/manhattan-distance-excel\/\",\"url\":\"https:\/\/statorials.org\/de\/manhattan-distance-excel\/\",\"name\":\"So berechnen Sie die Manhattan-Distanz in Excel \u2013 Statistik\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/de\/#website\"},\"datePublished\":\"2023-07-23T19:07:47+00:00\",\"dateModified\":\"2023-07-23T19:07:47+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/de\/#\/schema\/person\/ec75c4d6365f2708f8a0ad3a42121aa0\"},\"description\":\"In diesem Tutorial wird anhand von Beispielen erl\u00e4utert, wie Sie den Manhattan-Abstand zwischen zwei Vektoren in Excel berechnen.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/de\/manhattan-distance-excel\/#breadcrumb\"},\"inLanguage\":\"de-DE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/de\/manhattan-distance-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/de\/manhattan-distance-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Heim\",\"item\":\"https:\/\/statorials.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"So berechnen sie die manhattan-entfernung in excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/de\/#website\",\"url\":\"https:\/\/statorials.org\/de\/\",\"name\":\"Statorials\",\"description\":\"Ihr Leitfaden f\u00fcr statistische Kompetenz !\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/de\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de-DE\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/de\/#\/schema\/person\/ec75c4d6365f2708f8a0ad3a42121aa0\",\"name\":\"Dr. Benjamin Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de-DE\",\"@id\":\"https:\/\/statorials.org\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/de\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/de\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr. Benjamin Anderson\"},\"description\":\"Hallo, ich bin Benjamin, ein pensionierter Statistikprofessor, der sich zum engagierten Statorials-Lehrer entwickelt hat. Mit umfassender Erfahrung und Fachwissen auf dem Gebiet der Statistik bin ich bestrebt, mein Wissen zu teilen, um Studenten durch Statorials zu bef\u00e4higen. Mehr wissen\",\"sameAs\":[\"https:\/\/statorials.org\/de\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"So berechnen Sie die Manhattan-Distanz in Excel \u2013 Statistik","description":"In diesem Tutorial wird anhand von Beispielen erl\u00e4utert, wie Sie den Manhattan-Abstand zwischen zwei Vektoren in Excel berechnen.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/de\/manhattan-distance-excel\/","og_locale":"de_DE","og_type":"article","og_title":"So berechnen Sie die Manhattan-Distanz in Excel \u2013 Statistik","og_description":"In diesem Tutorial wird anhand von Beispielen erl\u00e4utert, wie Sie den Manhattan-Abstand zwischen zwei Vektoren in Excel berechnen.","og_url":"https:\/\/statorials.org\/de\/manhattan-distance-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-23T19:07:47+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/manhattanexcel1.png"}],"author":"Dr. Benjamin Anderson","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"Dr. Benjamin Anderson","Gesch\u00e4tzte Lesezeit":"1 Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/de\/manhattan-distance-excel\/","url":"https:\/\/statorials.org\/de\/manhattan-distance-excel\/","name":"So berechnen Sie die Manhattan-Distanz in Excel \u2013 Statistik","isPartOf":{"@id":"https:\/\/statorials.org\/de\/#website"},"datePublished":"2023-07-23T19:07:47+00:00","dateModified":"2023-07-23T19:07:47+00:00","author":{"@id":"https:\/\/statorials.org\/de\/#\/schema\/person\/ec75c4d6365f2708f8a0ad3a42121aa0"},"description":"In diesem Tutorial wird anhand von Beispielen erl\u00e4utert, wie Sie den Manhattan-Abstand zwischen zwei Vektoren in Excel berechnen.","breadcrumb":{"@id":"https:\/\/statorials.org\/de\/manhattan-distance-excel\/#breadcrumb"},"inLanguage":"de-DE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/de\/manhattan-distance-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/de\/manhattan-distance-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Heim","item":"https:\/\/statorials.org\/de\/"},{"@type":"ListItem","position":2,"name":"So berechnen sie die manhattan-entfernung in excel"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/de\/#website","url":"https:\/\/statorials.org\/de\/","name":"Statorials","description":"Ihr Leitfaden f\u00fcr statistische Kompetenz !","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/de\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de-DE"},{"@type":"Person","@id":"https:\/\/statorials.org\/de\/#\/schema\/person\/ec75c4d6365f2708f8a0ad3a42121aa0","name":"Dr. Benjamin Anderson","image":{"@type":"ImageObject","inLanguage":"de-DE","@id":"https:\/\/statorials.org\/de\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/de\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/de\/wp-content\/uploads\/2023\/11\/Benjamin-Anderson-96x96.jpg","caption":"Dr. Benjamin Anderson"},"description":"Hallo, ich bin Benjamin, ein pensionierter Statistikprofessor, der sich zum engagierten Statorials-Lehrer entwickelt hat. Mit umfassender Erfahrung und Fachwissen auf dem Gebiet der Statistik bin ich bestrebt, mein Wissen zu teilen, um Studenten durch Statorials zu bef\u00e4higen. Mehr wissen","sameAs":["https:\/\/statorials.org\/de"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/de\/wp-json\/wp\/v2\/posts\/2080"}],"collection":[{"href":"https:\/\/statorials.org\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/de\/wp-json\/wp\/v2\/comments?post=2080"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/de\/wp-json\/wp\/v2\/posts\/2080\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/de\/wp-json\/wp\/v2\/media?parent=2080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/de\/wp-json\/wp\/v2\/categories?post=2080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/de\/wp-json\/wp\/v2\/tags?post=2080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}