Anda tertarik dengan Statistika?

Blog Winner Statisik adalah Blog mengenai informasi seputar statistika.

Mari kita berbagi informasi mengenai statistika...

Apabila Anda perlu bantuan, hubungi: (021)96927448

Selasa, 22 Desember 2009

Statistik dengan Excel

Melakukan analisis Statistika dengan menggunakan MS Excel sangatlah mudah. Berikut saya jelaskan langkah-langkah melakukan analisis statistik dengan menggunakan MS Excel.

1. Buka Aplikasi Ms Excel Anda misalnya Ms Excel 2003 atau Ms Excel 2007

2. Ms Excel 2003: Klik Tools - Add-Ins
    Ms Excel 2007: Klik Office Button (pojok kiri atas) 
    lalu klik Excel Option - add-Ins

3. Pilih Analysis ToolPak

4. Kemudian akan tersedia menu Data Analysis

    Ms Office 2003 terletak di Tools - Data Analysis
    Ms Office 2007 terletak di menu ribbon "Data" - "Data Analysis"

5. Klik Data Analysis dan kemudian pilih analisis statistik apa yang akan Anda gunakan

untuk selanjutnya, Anda tinggal melakukan langkah no. 5 saja.

Selamat mencoba!!!

19 komentar:

  1. untuk regresi linear berganda dg ms.excel 2007 gmn?

  2. The Butler Report ( is a world news summary website site which, in addition to headline news,
    publishes US and worldwide events not covered by mainstream
    media. He tells the tale of a young boy, a tot, who was riding
    a toy car near the railroad crossing. The reliable reviews on business
    and forecast about products and services.

    My web site - Latest Daily News

  3. Hi there, I want to subscribe for this web site to get most up-to-date updates,
    so where can i do it please assist.

    Feel free to visit my webpage :: fitness tips women

  4. Many websites are involved in the funny picture concept and they include the cat playing with the plaything or with the trainer.

    If you have wandered around the internet to any extent you have probably encountered funny pictures.
    So, to overcome this situation and to remain in a positive
    mood laughter therapy is the best solution which can
    be done by various ways by watching funny movies, by downlaoding some funny pictures or by doing chit
    chatting of funny text with your dear freinds.

    my web page funny pictures and sayings to send in emails

  5. With the New Year quickly approaching, many people are setting
    their sights towards total physical fitness. Don't jump cold, warm up first until you break a light sweat. To keep one motivated it is important to alternate the activities after one to two weeks.

    My homepage fitness tips abs

  6. Based on my own experiences I am going to make five recommendations that I wish someone had made to me to
    help take the fear out of fitness. You have to find a way to take the tips you learn and make maximum use
    of them. ' Being physically active can promote good mental health and help you to manage stress, anxiety and depression.

    Here is my site - fitness tips abs

  7. Its such as you read my mind! You appear to understand a lot approximately this, like
    you wrote the e-book in it or something. I think that you simply could do with a few p.
    c. to power the message house a little bit, however instead of that, this is great blog.
    An excellent read. I'll certainly be back.

    My homepage Biotechnology

  8. And as we all know, too much stress can be harmful to health.
    It's almost always easy to make a joke about the way a cat ends up lying down or sitting. therefore no worries and suspend with a correct approach of chat and fun together with your loved ones.

    Here is my web blog ... funny pictures and cartoons

  9. Far too many children become the victims
    of abuse, neglect, or abandonment and then sadly, often they become wards of the court who will eventually determine their fate.
    " Earlier today some cruise ship struck land in Alaska. I want to mention a part of the Prime Law (Twelve Visions Party) which is part of Neothink.

    Feel free to surf to my web-site: Latest Daily News

  10. One can find plenty of funny pictures and videos by a single click on any search engine like Yahoo or Google.

    That is why we have dedicated this page to help you renew your spirit and
    perhaps have a few laughs too. And if you are not ready for it, then believe it, your boredom will stay.

    Here is my site - funny pictures and quotes for facebook

  11. These fitness tips in above some basic ideas for keeping
    fit and healthy body. My grandma can really feel vindicated at such a
    claim,she's been saying this all my life. This can be achieved by adding more weight, increasing the number of repetitions, or by adding on additional sets.

    my web blog: Suggested Site

  12. Нi there tο eѵery body, it's my first visit of this weblog; this weblog includes remarkable and really fine data designed for visitors.

    Feel free to surf to my webpage :: raspberry diet

  13. Hi there! This is my fігst comment here so I just wanted to
    give a quick shоut out and tell you I genuinely enjoу reаding your
    posts. Can yοu recommend any other blogs/wеbsites/forums that go оver the sаme topicѕ?
    Τhanks a ton!

    my ωeb-site

  14. Hi there! Thiѕ is mу first commеnt here so I just wаnted to give а quick shout out аnd
    tell you I genuinely enjoy readіng your postѕ. Can
    you rеcommend аny othеr blоgs/websіtes/forumѕ that
    go over the sаme toρicѕ? Thanks a ton!

    Herе is my ωebsitе ...

  15. Very good post! We агe linking to thiѕ great ρoѕt on οuг ωеbѕіte.
    Кеeρ up the great wrіting.

    Feel fгee to visіt my homepаgе: vistaprint coupon

  16. Nice respοnd in гetuгn оf this quеstion wіth genuіne arguments аnd tellіng
    everything on the topiс of that.

    Taκe a lоok at my ωeblog ... raspberry ketone 100 mg vitamins

  17. Hello, I read your blogs daily. Your story-telling style is witty, keep doing what you're doing!

    Feel free to surf to my site ... ripped muscle x price (

  18. permisi pak, saya pernah menulis tentang fungsi autocorrelation untuk penentuan pola data time series apakah musiman, tren, atau stationer, di artikel berikut: yang ingin saya tanyakan, apakah ada teknik lain untuk mencari pola data time series selain fungsi autocorrelation ya pak? terima kasih


Apa komentar Anda terhadap tulisan saya?

Anda Perlu Bantuan Analisis Data Statistik?

Hubungi kami melalui:

  - Telp. (021)96927448

  - email.

Analisis Data:

  - Skripsi (S1): Rp 500.000

  - Tesis (S2): Rp 1.000.000

  - Disertasi (S3): Rp 2.500.000

Kursus Private Statistika

2 jam per pertemuan:

  - S1: Rp 150.000 per pertemuan

  - S2: Rp 300.000 per pertemuan

  - S3: Rp 500.000 per pertemuan 

Konsultasi Rp 100.000 per jam


1. Analisis Deskriptif
     Meringkas Data, statistika 5 serangkai, Ukuran pemusatan,
      ukuran  keragaman data, dll
2. Charting, grafik
     Pembuatan chart dan grafik apapun sesuai keinginan Anda
3. Tabulasi
     Pembuatan berbagai macam tabel sesuai keinginan Anda
4. Uji Signifikan
     Melakukan uji hipotesis terhadap berbagai permasalahan
     Uji satu sampel, uji dua sempel, uji dua atau lebih sampel
5. Korelasi
     Metode untuk mengetahui hubungan antar dua variabel,  
     satu variabel dengan lebih dari satu veriabel, dan juga 
     banyak variabel dengan banyak variabel. 
6. Regresi   
     Metode untuk membuat suatu modelhubungan antara 
     satu variabel terikat (dependent variable) dengan satu atau      lebih variabel bebas (independent variable)
7. Multivariate Regression
    Metode untuk membuat model hubungan antara banyak
    variabel terikat (dependent variable) dan banyak variabel bebas  
    (independent variable)
8. Logit-Probit
    Mirip dengan regresi namun dapat digunakan untuk variabel kategorik
    (ordinal dan nominal), termasuk non parametrik   
9. Experimental Design     
10. Non-Parametrik Analysis 
11. AKU (Analisis Komponen Utama) /Principal Component
12. Analisis Faktor 

13. Cluster Analysis

14. Analisis Diskriminan

15. Multidimensional Scaling 
16. Biplot 
17. Analisis Korespondency 
18. Time Series Anlysis 
19. Path Analysis 
20. SEM (Seqential Equation Modeling)
22. AMMI
23. Bootstrap