[et_pb_section fb_built=“1″ admin_label=“section“ _builder_version=“4.16.0″ background_color=“#FFFFFF“ custom_padding=“0px|||||“ top_divider_color=“#F0F0F1″ bottom_divider_style=“mountains2″ bottom_divider_color=“#F0F0F1″ link_option_url=“https:\/\/www.flickr.com\/photos\/152824664@N07\/30212411048\/, mikemcmarketing“ global_colors_info=“{}“ theme_builder_area=“post_content“][\/et_pb_section][et_pb_section fb_built=“1″ _builder_version=“4.16.0″ _module_preset=“default“ background_color=“#F0F0F1″ custom_padding=“0px||6px|||“ top_divider_style=“mountains2″ top_divider_color=“#F0F0F1″ bottom_divider_style=“mountains2″ bottom_divider_color=“#F0F0F1″ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_row _builder_version=“4.16.0″ _module_preset=“default“ min_height=“95px“ custom_padding=“||7px|||“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“4_4″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n
Du m\u00f6chtest f\u00fcr ein Seminar oder deine Abschlussarbeit erhobene Daten aus einer Excel-Tabelle auswerten und daf\u00fcr die Hilfe von ChatGPT benutzen. Was kann ChatGPT tun, um dich bei der Eingabe von Codes zu unterst\u00fctzen? ChatGPT kann Beispielcodes f\u00fcr R-Studio erzeugen und die Anwendungsschritte erkl\u00e4ren. Wir haben die Codes zum Einlesen einer Excel-Tabelle, Median und der Standardabweichung in R-Studio \u00fcberpr\u00fcft.<\/p>\n
[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=“1″ _builder_version=“4.16.0″ _module_preset=“default“ custom_margin=“||-3px|||“ top_divider_style=“mountains2″ top_divider_color=“#F0F0F1″ bottom_divider_style=“mountains2″ bottom_divider_color=“#F0F0F1″ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_row column_structure=“1_2,1_2″ _builder_version=“4.16.0″ _module_preset=“default“ custom_padding=“||27px|||“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16.0″ _module_preset=“default“ header_text_color=“#000000″ header_3_text_color=“#D50C2F“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n
F\u00fcr Anf\u00e4nger sind besonders die Codes zum Dateneinlesen wichtig. Im ersten Schritt wird dargestellt, wie der Prompt zum Einlesen von Daten aus einer Excel-Tabelle formuliert werden kann.<\/p>\n
<\/p>\n
[\/et_pb_text][\/et_pb_column][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_image src=“https:\/\/blog.hwr-berlin.de\/elerner\/wp-content\/uploads_elerner\/2023\/12\/1-Prompting.png“ title_text=“1 Prompting“ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=“1_2,1_2″ _builder_version=“4.16.0″ _module_preset=“default“ custom_padding=“||27px|||“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16.0″ _module_preset=“default“ header_text_color=“#000000″ header_3_text_color=“#D50C2F“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n
Die Antwort von ChatGPT auf diesen Prompt ist rechts dargestellt. Auf den ersten Blick sehen die Codes vom Paketladen bis zum Darstellen der Daten plausibel aus. ChatGPT gibt noch folgende n\u00fctzliche Anmerkungen:<\/p>\n
„Stelle sicher, dass du den Pfad zur Excel-Datei durch den tats\u00e4chlichen Pfad zu deiner Datei ersetzt. Beachte auch, dass der Dateipfad in R doppelt (\\) oder einfach (\/) geschrieben werden kann, abh\u00e4ngig von deinem Betriebssystem.“<\/em><\/p>\n <\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_image src=“https:\/\/blog.hwr-berlin.de\/elerner\/wp-content\/uploads_elerner\/2023\/12\/2-Outpur-ChatGPT.png“ title_text=“2 Outpur ChatGPT“ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=“1_2,1_2″ _builder_version=“4.16.0″ _module_preset=“default“ custom_padding=“||27px|||“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16.0″ _module_preset=“default“ header_text_color=“#000000″ header_3_text_color=“#D50C2F“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n Nun geben wir den Code als Gegenprobe in R-Studio ein und lassen uns das Ergebnis anzeigen. <\/p>\n <\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_image src=“https:\/\/blog.hwr-berlin.de\/elerner\/wp-content\/uploads_elerner\/2023\/12\/3-Output-R.png“ title_text=“3 Output R“ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=“1_2,1_2″ _builder_version=“4.16.0″ _module_preset=“default“ custom_padding=“||27px|||“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16.0″ _module_preset=“default“ header_text_color=“#000000″ header_3_text_color=“#D50C2F“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n Unter „Packages“ wird das Paket als geladen angezeigt.<\/p>\n <\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_image src=“https:\/\/blog.hwr-berlin.de\/elerner\/wp-content\/uploads_elerner\/2023\/12\/4-R-Paket.png“ title_text=“4 R Paket“ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=“1_2,1_2″ _builder_version=“4.16.0″ _module_preset=“default“ custom_padding=“||27px|||“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16.0″ _module_preset=“default“ header_text_color=“#000000″ header_3_text_color=“#D50C2F“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n Nun wollen wir den Median f\u00fcr die Daten aus der Excel-Tabelle berechnen. Im rechten Feld wurde der Prompt wie folgt formuliert. Zus\u00e4tzlich wurde sp\u00e4ter ChatGPT noch nach dem Code f\u00fcr die Standardabweichung gefragt und gepr\u00fcft.<\/p>\n <\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_image src=“https:\/\/blog.hwr-berlin.de\/elerner\/wp-content\/uploads_elerner\/2023\/12\/5-Mean.png“ title_text=“5 Mean“ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=“1_2,1_2″ _builder_version=“4.16.0″ _module_preset=“default“ custom_padding=“||27px|||“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16.0″ _module_preset=“default“ header_text_color=“#000000″ header_3_text_color=“#D50C2F“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n ChatGPT erzeugte folgenden Code f\u00fcr den Median (mean).<\/p>\n <\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_image src=“https:\/\/blog.hwr-berlin.de\/elerner\/wp-content\/uploads_elerner\/2023\/12\/6-Mean-R.png“ title_text=“6 Mean R“ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=“1_2,1_2″ _builder_version=“4.16.0″ _module_preset=“default“ custom_padding=“||27px|||“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16.0″ _module_preset=“default“ header_text_color=“#000000″ header_3_text_color=“#D50C2F“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n Die Gegenprobe in R-Studio hat funktioniert. Der Code f\u00fcr den Median und die Standardabweichung wurde ohne Fehlermeldung ausgef\u00fchrt und zeigt das Ergebnis an.\u00a0 <\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_image src=“https:\/\/blog.hwr-berlin.de\/elerner\/wp-content\/uploads_elerner\/2023\/12\/7-MeanSD-R.png“ title_text=“7 Mean+SD R“ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=“1_2,1_2″ _builder_version=“4.16.0″ _module_preset=“default“ custom_padding=“||27px|||“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16.0″ _module_preset=“default“ header_text_color=“#000000″ header_3_text_color=“#D50C2F“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n Anschlie\u00dfend \u00fcberpr\u00fcfen wir noch, wie gut ChatGPT die R-Studio-Outputs interpretieren kann.<\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_image src=“https:\/\/blog.hwr-berlin.de\/elerner\/wp-content\/uploads_elerner\/2023\/12\/8-Prompt-Interpretation.png“ title_text=“8 Prompt Interpretation“ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=“1_2,1_2″ _builder_version=“4.16.0″ _module_preset=“default“ custom_padding=“||27px|||“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16.0″ _module_preset=“default“ header_text_color=“#000000″ header_3_text_color=“#D50C2F“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n Die Ergebnisse werden von ChatGPT interpretiert und eingeordnet.<\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_image src=“https:\/\/blog.hwr-berlin.de\/elerner\/wp-content\/uploads_elerner\/2023\/12\/9-ChatGPT-Interpr.png“ title_text=“9 ChatGPT Interpr“ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=“1_2,1_2″ _builder_version=“4.16.0″ _module_preset=“default“ custom_padding=“||27px|||“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16.0″ _module_preset=“default“ header_text_color=“#000000″ header_3_text_color=“#D50C2F“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n Zum Schluss zeigt uns ChatGPT noch die passende Zusammenfassung der Ergebnisse an.<\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=“1_2″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_image src=“https:\/\/blog.hwr-berlin.de\/elerner\/wp-content\/uploads_elerner\/2023\/12\/10-Zusammfassung.png“ title_text=“10 Zusammfassung“ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=“1″ _builder_version=“4.16.0″ _module_preset=“default“ custom_margin=“||-3px|||“ top_divider_style=“mountains2″ top_divider_color=“#F0F0F1″ bottom_divider_style=“mountains2″ bottom_divider_color=“#F0F0F1″ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_row _builder_version=“4.16.0″ _module_preset=“default“ custom_padding=“||27px|||“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“4_4″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16.0″ _module_preset=“default“ header_text_color=“#000000″ header_3_text_color=“#D50C2F“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n Insgesamt bietet ChatGPT f\u00fcr das Coden in R-Studio eine gute M\u00f6glichkeit, um Hilfestellungen zu bekommen. Diese KI-Anwendung bietet Vorteile, die insbesondere f\u00fcr Studierende im Bereich der statistischen Datenanalyse von gro\u00dfem Nutzen sein k\u00f6nnen. Dennoch ist wie immer Vorsicht geboten und ein kritischer Blick auf die Ergebnisse.<\/p>\n \u00a0[Es handelt sich um einen studentischen Gastbeitrag.]<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=“1″ _builder_version=“4.16.0″ _module_preset=“default“ custom_margin=“||-3px|||“ top_divider_style=“mountains2″ top_divider_color=“#F0F0F1″ bottom_divider_style=“mountains2″ bottom_divider_color=“#F0F0F1″ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_row _builder_version=“4.16.0″ _module_preset=“default“ custom_padding=“||27px|||“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“4_4″ _builder_version=“4.16.0″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16.0″ _module_preset=“default“ header_text_color=“#000000″ header_3_text_color=“#D50C2F“ hover_enabled=“0″ global_colors_info=“{}“ theme_builder_area=“post_content“ sticky_enabled=“0″]<\/p>\n <\/p>\n <\/p>\n <\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Du m\u00f6chtest ChatGPT zur Hilfe nehmen, um deine Daten im Programm R auszuwerten? Das geht und wir haben uns angeschaut, ob die vorgeschlagenen Codes von ChatGPT auch funktionieren und verst\u00e4ndlich sind. <\/p>\n","protected":false},"author":167,"featured_media":38551,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","inline_featured_image":false,"footnotes":""},"categories":[2676,2666,2863,2672,12,13],"tags":[966,711,2941],"class_list":["post-41032","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-elz","category-lehre_studium","category-padll","category-schulungen","category-veranstaltungen","category-werkzeuge","tag-e-learning-zentrum","tag-studentischer-blogartikel","tag-veranstaltungen"],"_links":{"self":[{"href":"https:\/\/blog.hwr-berlin.de\/elerner\/wp-json\/wp\/v2\/posts\/41032","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.hwr-berlin.de\/elerner\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.hwr-berlin.de\/elerner\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.hwr-berlin.de\/elerner\/wp-json\/wp\/v2\/users\/167"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.hwr-berlin.de\/elerner\/wp-json\/wp\/v2\/comments?post=41032"}],"version-history":[{"count":22,"href":"https:\/\/blog.hwr-berlin.de\/elerner\/wp-json\/wp\/v2\/posts\/41032\/revisions"}],"predecessor-version":[{"id":41130,"href":"https:\/\/blog.hwr-berlin.de\/elerner\/wp-json\/wp\/v2\/posts\/41032\/revisions\/41130"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.hwr-berlin.de\/elerner\/wp-json\/wp\/v2\/media\/38551"}],"wp:attachment":[{"href":"https:\/\/blog.hwr-berlin.de\/elerner\/wp-json\/wp\/v2\/media?parent=41032"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.hwr-berlin.de\/elerner\/wp-json\/wp\/v2\/categories?post=41032"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.hwr-berlin.de\/elerner\/wp-json\/wp\/v2\/tags?post=41032"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}