lihat lampiran, ada contoh sederhana tapi jelas mengenai penggunaan *fungsi frequency*
di situs ini (Peter Nonely): http://www.xlfdic.com/ ada workbook yg dapat didonlot (1.2 MB) gratis berisi penjelasan BANYAK (150 an) worksheet function; dipraktekkan langsung di tiap sheet lihat juga: http://www.functionx.com/excel/ http://www.techonthenet.com/excel/index.php dan masih banyak lagi... Jangan lupa di Area Files di milis kita http://tech.groups.yahoo.com/group/belajar-excel/files/ juga tersedia penjelasan SEMUA FUNGSI basic - all_excel_function.pdf<http://f1.grp.yahoofs.com/v1/EPTpTZXRv-0NZXu-Q-4HV7lqd2vafMBpRfD5qwi0qDufXFw7qjps4vCoylm3N6_JqxdUuFX4c1xLGwP6Liv0vA/basic%20-%20all_excel_function.pdf> - Function List Selain juga tentu saja di TOMBOL F1 di Excel anda On Sat, Jun 4, 2011 at 3:29 PM, Angga Gurmilang Sedar <[email protected]>wrote: > Aduhh, disentil Mbak Siti, > > Demi memuaskan rasa penasaran saya akan Fungsi FREQUENCY, maka saya buat > trit ini, > > Oke gini rekan-rekan, berawal dari jawaban Mr. Kid yang menyertakan fungsi > Frequency. Saya jadi bertanya-tanya, karena nih fungsi jujur banget saya > baru tahu malah **padahal kalok dilihat di function categories, nih > Frequency masuk dalam kategori Statistical** > > Nah, dari rekan-rekan Be-Excel disini adakah yang bisa memberikan contoh > penerapan atau penggunaan Fungsi Frequency ini ?? karena saya lihat dari > formula Mas Kid sebelumnya, bisa dipadukan dengan dengan countif untuk > mencari Unique Value dari sebuah record data. Mungkin bisa diterapkan di > kasus yang lain. Ayooo Be-Excel ;) > > > > Nb : Menurut info dari Mbak Siti > > *FREQUENCY* > > *Calculates how often values occur within a range of values, and then > returns a vertical array of numbers. For example, use FREQUENCY to count the > number of test scores that fall within ranges of scores. Because FREQUENCY > returns an array, it must be entered as an array formula.* > > * * > > *Syntax* > > *FREQUENCY(data_array,bins_array)* > > * * > > *Data_array* > > *is an array of or reference to a set of values for which you want to > count frequencies. If data_array contains no values, FREQUENCY returns an > array of zeros.* > > * * > > *Bins_array* > > *is an array of or reference to intervals into which you want to group the > values in data_array. If bins_array contains no values, FREQUENCY returns > the number of elements in data_array.* > > * * > > *Remarks* > > * * > > *FREQUENCY is entered as an array formula** after you select a range of > adjacent cells into which you want the returned distribution to appear. * > > *The number of elements in the returned array is one more than the number > of elements in bins_array. The extra element in the returned array returns > the count of any values above the highest interval. For example, when > counting three ranges of values (intervals) that are entered into three > cells, be sure to enter FREQUENCY into four cells for the results. The extra > cell returns the number of values in data_array that are greater than the > third interval value. * > > *FREQUENCY ignores blank cells and text. * > > *Formulas that return arrays must be entered as array* > > > > -Gilang Sedar- >
fungsi Frequency.xls
Description: MS-Excel spreadsheet
