Terima kasih telah mengirimkan pertanyaan Anda! Salah satu anggota tim kami akan segera menghubungi Anda.
Terima kasih telah mengirimkan pemesanan Anda! Salah satu anggota tim kami akan segera menghubungi Anda.
Kerangka Materi
Menggabungkan Data dalam Excel
- Fungsi Statistik
- Ringkasan
- Subtotal
- Tabel Pivot
Analisis Hubungan Data
- Distribusi Normal
- Penggolongan Statistics
- Korelasi Linear
- Analisis Regresi
- Kovarians
Menganalisis Data dalam Waktu
- Trend/Garis Regresi
- Penyaringan Rata-rata Bergerak, Linier, Logaritmik, Polinomial, Daya, Eksponensial
- Analisis Fluktuasi Musiman
Membandingkan Populasi
- Interval Kepercayaan untuk Rata-rata
- Uji Hipotesis Mengenai Rata-rata Populasi
- Perbedaan antara Rata-rata Dua Populasi
- ANOVA: Analisis Varians
- Goodness-of-Fit Test untuk Variabel Acak Diskrit
- Uji Independensi: Tabel Kontingensi
- Uji Hipotesis Mengenai Varians Dua Populasi
Forecasting
- Eksplorasi
Persyaratan
Peserta seharusnya familiar dengan dasar-dasar dari Excel dan Statistics.
14 Jam
Testimoni (3)
1. Clear theoretical explanation of concepts and alternatives to problem solving. 2. Practical examples where concepts are, and can be applied. 3. I learnt skills that I can use in my job, which will make some of my work easier 4. It will definitely bring some innovation into some of the reports I prepare for different Committees.
Sindiso Ndlovu - Export Credit insurance corporation
Kursus - Excel For Statistical Data Analysis
Steve was willing to answer every questions and worked diligently to address any individual concerns or technical issues as they arose in the class. He also did a great job of presenting the technical details in a way that made it less intimidating to even the least tech savvy people in the room. Personally, learning about some useful shortcuts in Excel that I didn't know about will certainly improve my overall workflow when using Excel in the future! I am so appreciative of those little details that I was exposed to during the two-day training.
Alan Gonzalez - Queens College, CUNY
Kursus - Excel For Statistical Data Analysis
The fact he had dif excel and data sheets with exercises for us to do.
