Rumus Fungsi Statistik Menggunakan
Spreadsheet :
Nama Fungsi
|
Bentuk Umum Fungsi
|
Keterangan
|
Fungsi AVERAGE
|
=AVERAGE(number1;number2)
|
Menghitung Nilai Rata-Rata
Argumen
|
Fungsi STDEV
|
=STDEV(number1;number2)
|
Menghitung Nilai Standar
Deviasi atau simpangan baku
|
Fungsi MAX
|
=MAX(number1;number2)
|
Mencari Nilai maksimum data
argumen
|
Fungsi MIN
|
=MIN(number1;number2)
|
Mencari nilai minimum data
argumen
|
Contoh :
A
|
B
|
C
|
|
No
|
Angka
|
Rumus
|
Hasil
|
1
|
5
|
=AVERAGE(A1;A2)
|
7,5
|
2
|
10
|
=STDEV(A1;A2)
|
3,54
|
3
|
15
|
=MAX(A1;A2)
|
10
|
4
|
20
|
=MIN(A1;A2)
|
5
|
0 komentar:
Posting Komentar