Tabel distribusi frekuensi atau tabel frekuensi adalah penyajian data yang tersusun berdasarkan kelas-kelas atau kelompok data yang terbentuk. Tabel distribusi frekuensi tersebut akan memberikan informasi tentang gambaran sederhana dari sekumpulan data. Berikut adalah contoh sederhana tabel distribusi frekuensi:
Jika data masih berukuran kecil misal puluhan, maka pembuatan tabel distribusi frekuensi dapat diselesaikan dengan cara manual atau tanpa alat bantu. Tetapi ketika menemui data dengan ukuran yang sangat besar misal ratusan, ribuan maupun jutaan, maka pembuatan tabel distribusi frekuensi akan sangat membutuhkan ketelitian serta waktu yang sangat panjang. Oleh karena itu dibutuhkan alat bantu yang dapat membantu penyusunan tabel distribusi frekuensi. Salah satu alat bantu yang dapat digunakan dalam penyusunan tabel distribusi frekuensi adalah Ms. Excel.


Perhitungan yang dibutuhkan :

Beberapa perhitungan yang dibutuhkan dalam penyusunan tabel distribusi frekuensi adalah sebagai berikut:

- Menentukan jangkauan (range)
Jangkauan (R) = data terbesar (Max) – data terkecil (Min)

- Menentukan banyak kelas dengan rumus sturgess
K = 1 + 3,322 log (n)Keterangan:K = banyak kelasn  = banyak data

- Menentukan panjang kelas interval (P)
P=(Jangkauan (R))/(Banyak Kelas (K))

- Menentukan batas bawah kelas pertama. Diambil dari data terkecil (Min).
- Melengkapai interval masing-masing kelas.
- Menggunakan rumus =FREQUENCY( ) untuk membentuk tabel distribusi frekuensi.

Contoh :
Berdasarkan hasil pengamatan terhadap perolehan nilai suatu kelas yang terdiri dari 80 siswa, diperoleh hasil sebagai berikut:
Berdasarkan hasil tersebut, susun;ah sebuah tabel distribusi frekuensi menggunakan Ms. Excel. Data pada contoh ini dapat didownload melalui link berikut:
Contoh Data Tabel Distribusi Frekuensi (Deskriptif)
atau mengunjungi menu Contoh Data pada website ini kemudian pilih
Contoh Data Tabel Distribusi Frekuensi (Deskriptif)


Tahapan Penyusunan Tabel Distribusi Frekuensi

Tahap 1.
Menentukan Nilai Min, Max serta Range (Max-Min).


Tahap 2.
Menghitung Banyak Kelas (K) dan Panjang Kelas (P).


Tahap 3.
Menyusun tabel distribusi frekuensi dan menentukan batas interval berdasarkan hasil Tahap 2.

Tahap 4.

Sorot/Block kolom Frekuensi (N2) kemudian gunakan rumus =FREQUENCY( )
Kemudian isi data_array dengan data awal atau dalam kasus ini adalah cell A1:H10. Untuk bins_array diisi dengan batas atas interval atau dalam kasus ini adalah cell M2:M9.


Kemudian tekan dan tahan tombol CTRL + SHIFT + ENTER bersamaan. Kemudian akan muncul hasil sebagai berikut:
Lengkapi tabel dengan menghitung banyak data menggunakan rumus =SUM( ). Lengkapi dengan menghitung persentase frekuensinya.
Hasil akhir yang diperoleh adalah sebagai berikut:
Dalam penyajian data, deskripsi dari data itu sendiri akan lebih mudah lagi jika dibentuk dalam sebuah grafik sebagai berikut:




Demikian tadi tutorial dalam Membuat Tabel Distribusi Frekuensi dengan Ms. Excel. Jika terdapat pertanyaan, saran maupun kritik dapat mengunjungi kolom komentar.

35 Comments

  1. Replies
    1. Bantu jawab ya.
      Nilai 80 didapat dari banyaknya data. Disitu dijelaskan bahwa banyaknya siswa ada 80.

      Delete
  2. Bagaimana cara menentukan sebuah tabel distribusi frekuensi data dalam ratusan ribu rupiah??

    ReplyDelete
    Replies
    1. bisa dengan cara seperti disini, namun diperhatikan nilai "P" (panjang interval)

      Delete
  3. This comment has been removed by the author.

    ReplyDelete
  4. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.

    Big Data Hadoop Training In Chennai | Big Data Hadoop Training In anna nagar | Big Data Hadoop Training In omr | Big Data Hadoop Training In porur | Big Data Hadoop Training In tambaram | Big Data Hadoop Training In velachery

    ReplyDelete
  5. ITU NILAI P = B15/8
    NILAI 8 DAPAT DARI MANA??? JUMLAH BARIS??? KALO JUMLAH BARISNYA MISAL 1 BERARTI B15/1???

    ReplyDelete
  6. Great day! I might have sworn I've visited this site before however in the wake of perusing a considerable lot of the posts I understood it's unfamiliar to me. In any case, I'm unquestionably cheerful I found it and I'll be bookmarking it and returning frequently!
    Net banking

    ReplyDelete
  7. This is an excellent tip especially to those new to the blogosphere. Short however exact data… Thank you for sharing this one. An unquestionable requirement read post!
    earthcycle

    ReplyDelete
  8. wonderful article contains lot of valuable information. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
    AWS certification course in Chennai

    ReplyDelete
  9. I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page. madhur matka

    ReplyDelete


  10. Very wonderful informative article. I appreciated looking at your article. Very wonderful reveal. I would like to twit this on my followers. Many thanks!

    bulletintech
    how tall is dababy
    henry sedgwick v
    justdubs
    citra emulator apk
    frank rocky fiegel
    how to program rca universal remote
    taylor olsen
    natalie 90 day fiance


    ReplyDelete

  11. Your Site is very nice, and it's very helping us this post is unique and interesting, thank you for sharing this awesome information. and visit our blog site also sattaking

    Satta king
    Satta king chart
    Satta king gali
    Satta king Faridabad
    Satta king Desawar
    satta king Gaziabad
    Satta king online
    satta king fast

    Satta King Results

    ReplyDelete
  12. I'm extremely inspired along with your writing skills as neatly as with the format in your blog. Is that a paid subject or did you customize it yourself? Anyway stay up the excellent quality writing, it's rare to look at a great blog like this one today.. Bathroom Mirror

    ReplyDelete
  13. Unbelievable. Your website has a lot of good information about science and society. It also gives me a lot of knowledge to apply in my work.

    poke radar for pokemon go apk for android download

    zanti apk for android download

    ReplyDelete
  14. Excellent goods from you, man. I have understood your stuff previous to and you are simply extremely fantastic. I actually like what you’ve obtained right here, really like what you are saying and the way in which by which you are saying it. You are making it enjoyable and you still care to stay sensible. I can’t wait to read much more from you. This is really a wonderful site. Electronics and Communication Engineering Scope

    ReplyDelete
  15. Thanks for sharing, this was an incredibly wonderful article.!....keep sharing such nice post...

    Planning a spiritual tour in North India and looking for the best hotel in the Chardham Yatra route. If yes, then go with Shikhar Nature Resort, the only accommodation that offers a rustic as well as lavish holiday experience to travelers...read more..Shikhar Nature Resort, Uttarkashi

    Chardham Yatra by Helicopter
    Dodital Trek
    Chardham Yatra
    Char Dham Yatra Deluxe Package

    ReplyDelete
  16. The artistic style of sharing information had kept me bound throughout the blog. I would like to
    thank the writer for sharing such amazing and informative content with us and will share it with
    my friends and family members. I also request the writer to keep sharing such interesting content
    with us. I am sharing some links on adventure activities on my website. If you are interested in
    adventure then you can have a look at it.
    Paragliding in Bir Billing
    Camping and Paragliding in Bir Billing
    Sky Cycling in Bir Billing
    Paragliding and camping in Bir Billing
    Bunjee
    Jumping in Bir Billing

    ReplyDelete
  17. This comment has been removed by the author.

    ReplyDelete
  18. Such a helpful article, this was incredibly wonderful!....I enjoyed reading all your posts....
    keep sharing such a nice post...

    Plan a trip with our well-crafted wildlife tour packages in India and get best offers on wildlife holiday packages.
    ...know more..Wildlife Holiday Tour Packages India

    ReplyDelete
  19. This comment has been removed by the author.

    ReplyDelete
  20. The artistic style of sharing information had kept me bound throughout the blog. I would like to thank the writer for sharing such amazing and informative content with us and will share it with my friends and family members. I also request the writer to keep sharing such interesting content with us. I am sharing some links on adventure activities on my website. If you are interested in adventure then you can have a look at it.
    Paragliding in Bir Billing
    Friendship peak trek
    Rajgundha Trek
    Ali Bedni Bugyal Trek

    ReplyDelete
  21. Thanks for sharing this wonderful information. Your information is very helpful for me.
    Nda Coaching in Lucknow
    Mba College in Lucknow

    ReplyDelete
  22. your article so amazing and informative. Your writing skill is also very well. Your article is really addictive. Keep posting. keep sharing the knowledge. I love to read your articles.
    english stories english short stories with moral value What is the factorial of 100

    ReplyDelete
  23. Your information is very very helpful for me and good Blog
    Kalyan Matka
    kalyan matka result

    ReplyDelete

Post a Comment