This is a step by step guide on how to make a histogram in Excel using Data Analysis ToolPak.
Charts and graphs help you to summarize your data visually. If you publish a report with some values only, the policymakers will stumble on it to get the insight from your report. So Reports or Excel Dashboards are made of huge charts and graphs and other data visualization tools.
Pendidikan anak dini usia merupakan upaya pemberian layanan pendidikan kepada anak usia 0-6 tahun melalui Penitipan Anak yaitu intervensi bagi anak usia 3 bulan sampai memasuki pendidikan dasar pada lembaga penitipan anak (w ahana kesejahteraan anak yang berfungsi sebagai pengganti krluarga untuk jangka waktu. Desain penelitian ini Deskriptif. Subjek penelitian 63 keluarga yang memiliki anak GPPH dengan rentang usia 8-12 tahun yang bersekolah di 5 buah SLB tipe C Kota Bandung. Pengambilan sampel menggunakan teknik total sampling dengan kuesioner inventory yaitu kuesioner kualitas hidup anak (PedsQL). Analisa data menggunakan deskriptif analitik.
In this post, I will talk about a special type of Excel chart. It is histogram chart or you can call it a frequency distribution chart. There are a good number of ways to make a histogram chart. In this blog post, I have shown total 7 ways to make a frequency distribution table. In most of the ways, I have used Excel functions, in one method, I have used Pivot Table. You will also get my FreqGen Excel template to make frequency distribution tables automatically.
But in this blog post, I am going to show you how to make a histogram in Excel in the easiest way: using the Analysis ToolPak Excel add-in.
Table of Contents
How to Make a Histogram in Excel
To build a histogram in Excel, I have used these data.
There are total 40 values in this list. And the values range from 3.24 to 96.76. So, I am going to make the bins with bin size 10. So my first bin will be 0 to 10, I input the upper value of the bin, 10, in cell B2. While creating histogram chart, Data Analysis TookPak needs only the upper value of the bin. Th next bin is greater than 10 and less than or equal to 20, so I input value 20 in cell B3. Now I select these two cells and drag down up to cell B11. That places the 10 upper values of the bins.
Bins are created
Now let’s show you how to use the Data Analysis ToolPak to make a histogram using this data. In the Data tab, and in the Analysis group of commands, you will get a command named Data Analysis. If you don’t see the command there, then the ToolPak is not activated.
Installing Analysis ToolPak
Let me show you how to add Data Analysis Toolpak. Click on the File tab, then Options, and click on the Add-ins tab on the left side of the Excel Options dialog box. On the right side and under the list of Active Application Add-ins, you will not find the Analysis ToolPak. You will find it under the Inactive Application Add-ins.
Let’s activate the add-in. [Above image] under Manage drop-down, Excel Add-ins is already selected. Click on the Go… button on the right. Add-ins dialog box appears. Analysis ToolPak check boxis not selected. Just select the checkbox. And click OK.
Now you find the Data Analysis command will be showing under the Analysis group of commands in the Data tab.
Creating Histogram Using Analysis ToolPak
Click on the Data Analysis command in the data tab. Data Analysis dialog box appears. You will find several Data Analysis tools in the window. I select histogram and click OK. Or I can double click on the histogram option. Histogram dialog box appears.
In the Input range, I select these values from cell A2 to A41. In the bin range, I select values in the cells B2 to B11. There are Output options here. You can see your output in three ways:
I want to see my output in a new worksheet. New Worksheet Ply is selected, it is OK. I want to see the result in a chart also, so I select this Chart Output option. Now I click OK.
Histogram Options
You see a new worksheet is created. In the worksheet, you get the Bin, the frequency distribution table and you get the histogram chart on the right side of the worksheet.
Let’s analyze the above chart a little bit. Between 0 and 10, we get 3 values, between 10 and 20, we get 6 values, between 20 and 30 we get 4 values and so on. It is clear from the chart that the data does not show any pattern.
Histogram chart is an important concept in data analysis. When you will learn how to create Bell Curve in Excel, this technique will be useful to you.
Histogram chart can show great insights from your sales and other business related data.
This is a sample lecture of my course: Data Analysis in Excel with Statistics: Get Meanings of Data where you will learn Data Analysis with 52 case studies, problems, and their solutions!
Read More:Abstrak
PENGARUH BIMBINGAN TENTANG RISIKO CIDERA TERHADAP PERILAKU PENCEGAHAN CIDERA DI SEKOLAH DASAR BIBIS KECAMATAN KASIHAN BANTUL YOGYAKARTAEffects of Guidance On The Risk of Injury To The Behaviour of Injury Prevention In Elementary School District Bibis Pity Bantul YogyakartaTitih HuriahProgram Studi Ilmu Keperawatan Fakultas Kedokteran Universitas Muhammadiyah YogyakartaJl. Lingkar Barat Taman Tirto Kasihan Bantul Yogyakarta 55182e-mail: [email protected] cidera terbesar pada anak usia sekolah di negara sedang berkembang seperti di Indonesia adalah kecelakaan di jalan raya. Hasil survei oleh WHO pada 8 Provinsi di Indonesia tahun 2003 didapatkan angka cidera pada anak usia sekolah sebesar 28,27%. Hasil ini berimplikasi terhadap tingginya angka kematian pada anak usia sekolah di Indonesia. Penelitian ini bertujuan untuk mengetahui pengaruh bimbingan tentang resiko cidera terhadap perilaku pencegahan cidera di SD Bibis Kasihan Bantul Yogyakarta. Metode penelitian menggunakan kuasi eksperimental dengan rancangan one group pre test post test design. Subyek penelitian adalah pelajar SD Bibis yang pernah mengalami cidera berjumlah 50 sampel, 25 orang kelompok kontrol dan 25 orang kelompok perlakuan. Instrumen yang digunakan yaitu kuesioner dan cek list observasi. Uji statistik menggunakan SPSS dengan tingkat kemaknaan p < 0,05. Hasil analisis data menggunakan uji z test, perilaku pencegahan cidera anak usia sekolah pada kelompok perlakuan terlihat adanya peningkatan prosentase dari hasil pre test dan post test, yaitu 36% perilaku pencegahan cidera yang baik pada pelajar SD Bibis, dengan nilai p = 0,003 yang berarti terdapat perbedaan perilaku pencegahan cidera antara sebelum dan setelah diberikan perlakuan. Pada kelompok kontrol terjadi peningkatan 8% perilaku pencegahan cidera yang baik pada pelajar SD Bibis, dengan nilai p = 0,157 yang berarti tidak terdapat perbedaan perilaku pencegahan cidera antara nilai pre test dan post test pada kelompok kontrol. Hasil penelitian menunjukkan bahwa bimbingan tentang resiko cidera berpengaruh terhadap perilaku pencegahan cidera anak usia sekolah (p = 0,000). Sehingga perlu dilakukan kerja sama dengan berbagai intansi terkait (dinas kesehatan, dinas pendidikan dan dinas perhubungan) untuk implementasi kebijakan pencegahan cidera pada anak usia sekolah.Kata kunci: guidance, cidera, perilaku, anak usia sekolahABSTRACTThe largest cause of injuries in school age children in developing countries such as Indonesia is an accident on the highway. The results of the WHO survey conducted in 8 Provinces in Indonesia in 2003 found the number injured at school age children for 28,27%. These results may have implications for the high mortality in school age children in Indonesia. This study aims to determine the effect of giving guidance about the risk of injury prevention behavior in elementary Bibis Kasihan Bantul Yogyakarta. Research method used is quasy experimental design one group pre test post test design. Research subjects were elementary school students who have experienced Bibis injuries with totaling 50 samples, 25 of the control group and intervention group of 25 peoples. Ways of collecting data using questionnaires and observation check list. Statistical tests using SPSS with value level is p < 0,05. The results of this study data analysis using z test testing, injury prevention behaviors of school age children in the intervention group looks to an increase in the percentage of the pre test and post test, where an increase of 36% injury prevention behavior is good at Bibis Elementary School students, with the value p = 0,003, which means there is a difference between injury prevention behavior before and after a given intervention. In the control group an increase of 8% of injury prevention behaviors in both Bibis Elementary School students, with a value of p = 0,157, which means there is no difference in behavior between the value of injury prevention pre test and post test in the control group. The results showed that the guidance about the risk of injury affects behavior in primary injury prevention school age children's (p = 0,000). So must cooperation with various related institutions (public health, education services and transportation services) to policy implementation order to realize the existence of injury prevention curricula in school age children.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |