Data Analysis sering digunakan bagi kita yang melakukan pengolahan data menggunakan Office Excel. Namun secara default Add-ins Data Analysis tidak muncul pada ribbon. Namun bisa kita munculkan sendiri dengan cara yang mudah dan tidak membutuhkan waktu yang lama. Analysis Tools yang ada pada Office Excel memiliki beberapa fungsi diantaranya : Anova: Single Factor, Anova: Two-Factor
With Replication, Anova: Two-Factor Without Replication, Correlation, Covariance, Descriptive Statistics, Exponential Smoothing, F-Test Two-Sample for Variances, Fourier Analysis, Histogram, Moving Average, Random Number Generation, Rank and Percentile, Regression, Sampling, t-Test: Paired Two Sample for Means, t-Test: Two-Sample Assuming Equal Variances, t-Test: Two-Sample Assuming Enequal Variances, z-Test: Two Sample for Means. Banyak sekali fungsi yang ditawarkan, namun
biasanya saya menggunakannya untuk random data (Random Number Generation). Kebetulan saya menggunakan Microsoft Office 2013, sebenarnya tidak ada perbedaan yang besar dengan versi sebelumnya, hanya beberapa interface yang berubah, termasuk perbaikan pada performa. Berikut langkah-langkahnya : 1. Klik File, terletak pada pojok kiri atas.  2. Kemudian klik Options. 3. Setelah muncul Excel Options seperti gambar dibawah, Klik Add-Ins. 4. Pada Manage pilih Excel Add-ins, Klik Go… 5. Akan muncul Jendela Add-Ins, centang Analysis ToolPak dan Analysis ToolPak-VBA dan Klik Ok. 6. Setelah menunggu beberapa saat akan muncul Data Analysis di sebelah kanan Outline. Selamat Mencoba window['__wavt'] = 'AOuZoY40S-xtbPwyBbpsQW-qFMZVuUC5SQ:1664774635974';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d4480054309899695002','//www.sobat-tutorial.com/2021/11/cara-memunculkan-data-analysis-di-excel.html','4480054309899695002'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '4480054309899695002', 'title': 'Sobat-Tutorial', 'url': 'https://www.sobat-tutorial.com/2021/11/cara-memunculkan-data-analysis-di-excel.html', 'canonicalUrl': 'https://www.sobat-tutorial.com/2021/11/cara-memunculkan-data-analysis-di-excel.html', 'homepageUrl': 'https://www.sobat-tutorial.com/', 'searchUrl': 'https://www.sobat-tutorial.com/search', 'canonicalHomepageUrl': 'https://www.sobat-tutorial.com/', 'blogspotFaviconUrl': 'https://www.sobat-tutorial.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'UA-195699183-1', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Sobat-Tutorial - Atom\x22 href\x3d\x22https://www.sobat-tutorial.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Sobat-Tutorial - RSS\x22 href\x3d\x22https://www.sobat-tutorial.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Sobat-Tutorial - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/4480054309899695002/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Sobat-Tutorial - Atom\x22 href\x3d\x22https://www.sobat-tutorial.com/feeds/4597550760508379455/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-3012863392330552', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/e8b4eb3f3f22b957', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'Twitter', 'key': 'twitter', 'shareMessage': 'Share to Twitter', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'item', 'postId': '4597550760508379455', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/a/AVvXsEghWnOj5Eb1QgzP6OQws3x5yR9_44Hsq5anTPZ_QARGDpGoxvp7H4JGjxGvMwwRNvxXf55LIb5bHDJB63B7NxAlYzHVhHMf4wTO9MwPtMZgvdOmHOs-kzsuuaQWPlH1PUnBvvk9AlNLlpWfztJt05WA5buXAh-HiF_8Ayf9JhlX1FutkTounv31PATn\x3ds72-w320-c-h252', 'postImageUrl': 'https://blogger.googleusercontent.com/img/a/AVvXsEghWnOj5Eb1QgzP6OQws3x5yR9_44Hsq5anTPZ_QARGDpGoxvp7H4JGjxGvMwwRNvxXf55LIb5bHDJB63B7NxAlYzHVhHMf4wTO9MwPtMZgvdOmHOs-kzsuuaQWPlH1PUnBvvk9AlNLlpWfztJt05WA5buXAh-HiF_8Ayf9JhlX1FutkTounv31PATn\x3dw320-h252', 'pageName': 'Cara Memunculkan Data Analysis di Excel', 'pageTitle': 'Sobat-Tutorial: Cara Memunculkan Data Analysis di Excel', 'metaDescription': 'Untuk memunculkan Data Analysis di excel , Anda dapat membuka jendela excel options kemudian memilih menu Add-Ins.'}}, {'name': 'features', 'data': {'sharing_get_link_dialog': 'true', 'sharing_native': 'false'}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Cara Memunculkan Data Analysis di Excel', 'description': 'Untuk memunculkan Data Analysis di excel , Anda dapat membuka jendela excel options kemudian memilih menu Add-Ins.', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEghWnOj5Eb1QgzP6OQws3x5yR9_44Hsq5anTPZ_QARGDpGoxvp7H4JGjxGvMwwRNvxXf55LIb5bHDJB63B7NxAlYzHVhHMf4wTO9MwPtMZgvdOmHOs-kzsuuaQWPlH1PUnBvvk9AlNLlpWfztJt05WA5buXAh-HiF_8Ayf9JhlX1FutkTounv31PATn\x3dw320-h252', 'url': 'https://www.sobat-tutorial.com/2021/11/cara-memunculkan-data-analysis-di-excel.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 4597550760508379455}}, {'name': 'widgets', 'data': [{'title': 'Kode Pengaturan Template', 'type': 'HTML', 'sectionId': 'template-settings', 'id': 'HTML711'}, {'title': 'Custom CSS', 'type': 'HTML', 'sectionId': 'custom-css', 'id': 'HTML712'}, {'title': 'Sobat-Tutorial (Header)', 'type': 'Header', 'sectionId': 'header', 'id': 'Header1'}, {'title': 'Kode Menu Navigasi', 'type': 'HTML', 'sectionId': 'navmenu', 'id': 'HTML642'}, {'title': 'Widget HTML #1', 'type': 'HTML', 'sectionId': 'bellow-header-widget', 'id': 'HTML619'}, {'title': 'Widget HTML #2 (homepage)', 'type': 'HTML', 'sectionId': 'bellow-header-widget2', 'id': 'HTML616'}, {'title': 'Widget HTML #3 (homepage)', 'type': 'HTML', 'sectionId': 'above-post-widget', 'id': 'HTML421'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'main', 'id': 'Blog1', 'posts': [{'id': '4597550760508379455', 'title': 'Cara Memunculkan Data Analysis di Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEghWnOj5Eb1QgzP6OQws3x5yR9_44Hsq5anTPZ_QARGDpGoxvp7H4JGjxGvMwwRNvxXf55LIb5bHDJB63B7NxAlYzHVhHMf4wTO9MwPtMZgvdOmHOs-kzsuuaQWPlH1PUnBvvk9AlNLlpWfztJt05WA5buXAh-HiF_8Ayf9JhlX1FutkTounv31PATn\x3dw320-h252', 'showInlineAds': false}], 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'author', 'label': 'Oleh'}, {'name': 'timestamp', 'label': 'pada tanggal'}, {'name': 'comments', 'label': 'Comments'}, {'name': 'icons', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': 'Tags'}]}], 'allBylineItems': [{'name': 'author', 'label': 'Oleh'}, {'name': 'timestamp', 'label': 'pada tanggal'}, {'name': 'comments', 'label': 'Comments'}, {'name': 'icons', 'label': ''}, {'name': 'labels', 'label': 'Tags'}]}, {'title': 'Iklan Atas Artikel', 'type': 'HTML', 'sectionId': 'iklan-atas', 'id': 'HTML996'}, {'title': 'Iklan Tengah Artikel 1', 'type': 'HTML', 'sectionId': 'iklan-tengah2', 'id': 'HTML997'}, {'title': 'Iklan Tengah Artikel 2', 'type': 'HTML', 'sectionId': 'iklan-tengah2', 'id': 'HTML998'}, {'title': 'Iklan Bawah Artikel', 'type': 'HTML', 'sectionId': 'iklan-bawah', 'id': 'HTML999'}, {'title': 'Iklan Matched Content', 'type': 'HTML', 'sectionId': 'matched-content', 'id': 'HTML939'}, {'title': 'Iklan In-Feed (homepage)', 'type': 'HTML', 'sectionId': 'iklan-infeed', 'id': 'HTML952'}, {'title': '', 'type': 'HTML', 'sectionId': 'sidebar-sticky', 'id': 'HTML1'}, {'title': 'Kode Icon Media Sosial', 'type': 'HTML', 'sectionId': 'footer-widget-container', 'id': 'HTML637'}, {'title': 'Menu Halaman Statis', 'type': 'PageList', 'sectionId': 'footer-navmenu', 'id': 'PageList1'}, {'title': 'Teks Footer', 'type': 'HTML', 'sectionId': 'footer-container', 'id': 'HTML781'}, {'title': 'Custom JavaScript Footer', 'type': 'HTML', 'sectionId': 'custom-javascript-footer', 'id': 'HTML782'}]}]); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML711', 'template-settings', document.getElementById('HTML711'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML712', 'custom-css', document.getElementById('HTML712'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'header', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML642', 'navmenu', document.getElementById('HTML642'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML619', 'bellow-header-widget', document.getElementById('HTML619'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML616', 'bellow-header-widget2', document.getElementById('HTML616'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML421', 'above-post-widget', document.getElementById('HTML421'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'main', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2965620613-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/3523451998-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML996', 'iklan-atas', document.getElementById('HTML996'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML997', 'iklan-tengah2', document.getElementById('HTML997'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML998', 'iklan-tengah2', document.getElementById('HTML998'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML999', 'iklan-bawah', document.getElementById('HTML999'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML939', 'matched-content', document.getElementById('HTML939'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML952', 'iklan-infeed', document.getElementById('HTML952'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'sidebar-sticky', document.getElementById('HTML1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML637', 'footer-widget-container', document.getElementById('HTML637'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'footer-navmenu', document.getElementById('PageList1'), {'title': 'Menu Halaman Statis', 'links': [{'isCurrentPage': false, 'href': 'http://www.sobat-tutorial.com/', 'title': 'Home'}, {'isCurrentPage': false, 'href': 'https://www.sobat-tutorial.com/p/about.html', 'id': '3965008305155860960', 'title': 'About'}, {'isCurrentPage': false, 'href': 'https://www.sobat-tutorial.com/p/contact-from.html', 'id': '7329249319797838445', 'title': 'Contact From'}, {'isCurrentPage': false, 'href': 'https://www.sobat-tutorial.com/p/kebijakan-privasi.html', 'id': '1165300369733531422', 'title': 'Kebijakan Privasi'}, {'isCurrentPage': false, 'href': 'https://www.sobat-tutorial.com/p/disclamer.html', 'id': '210741168472217755', 'title': 'Disclaimer'}], 'mobile': false}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML781', 'footer-container', document.getElementById('HTML781'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML782', 'custom-javascript-footer', document.getElementById('HTML782'), {}, 'displayModeFull')); Bagaimana cara memunculkan data Analysis di Excel?Memuat Analysis ToolPak di Excel. Klik tab File, klik Opsi, lalu klik kategori Add-In. Jika menggunakan Excel 2007, klik Tombol Microsoft Office , lalu klik Opsi Excel.. Di kotak Kelola, klik Add-in Excel, lalu klik Jalankan. ... . Di kotak Add-In, centang kotak Analysis ToolPak, lalu klik OK.. Bagaimana cara mengaktifkan data Analysis?Memuat dan mengaktifkan Analysis ToolPak
Klik tab File, klik Opsi, lalu klik kategori Add-In. Di kotak Kelola, klik Add-in Excel, lalu klik Jalankan. Jika Anda menggunakan Excel untuk Mac, dalam menu file, masuk ke Add-in > Excel Tools. Di kotak Add-In, centang kotak Analysis ToolPak, lalu klik OK.
Apa itu analisis ToolPak?Analysis toolpak excel adalah add-ins di excel yang dapat kita gunakan untuk melakukan analisis data dan berbagai perhitungan penting lainnya. Add-ins ini secara default tidak diaktifkan di excel dan kita harus mengaktifkannya secara manual dari tab file di bagian option.
Dimana add ins di Excel 2007?Untuk menggunakan fungsi dari otomatisasi Add-in di Excel 2007 dan yang lebih baru, ikuti langkah-langkah berikut:. Klik Tombol Microsoft Office, lalu klik Opsi Excel.. Klik Add-in.. Di bawah Kelola, klik Excel Add in, dan kemudian klik Lanjutkan.. Di kotak dialog Add-in , klik Otomatisasi.. |
Cara mengaktifkan data analisis di excel
Pos Terkait
Copyright © 2024 adaberapa Inc.
