Ber-statistik-ria di Microsoft Excel

October 30th, 2008 | Posted by iip in Spreadsheet tips - (5 Comments)

Siapa bilang Excel hanya bisa membuat tabel dan perhitungan biasa saja? Microsoft Excel bisa melakukan lebih dari itu!

Pada artikel sebelumnya, sudah dijelaskan bagaimana menggunakan Goal Seek. Fungsi ini berguna sekali untuk men-traceback suatu perhitungan (tentu dengan formula yang digunakan) baik yang rumit maupun sederhana –sesuai dengan hasil akhir yang kita inginkan. Gampangnya, formula ini bisa digunakan untuk menjawab pertanyaan:

(more…)

, , , , , , , ,

How to setup statistical analysis tools in Microsoft Excel 2007

October 28th, 2008 | Posted by iip in Spreadsheet tips - (2 Comments)

I’ve been two years using Microsoft excel to complete almost all my office tasks. It’s nice to know how to use statistics analysis tools in this software, instead of using particular statical analysis software. In fact, table-related tasks mostly need calculation, either simple or complex.

If you have to deal with complex task calculations, you may need this simple guideline. There are two facilities to make statistic analysis in Microsoft excel 2007. The first one is Data Analysis which is an additional instruction. How to set up this instruction?

(more…)

, , , , , , , , ,