The PEARSON function in Excel calculates the Pearson correlation coefficient between two sets of values.
It measures the strength and direction of the linear relationship between variables.
Formula dasar PEARSON
=PEARSON(array1, array2)Hasil/Output penggunaan rumus PEARSON
Hasilnya berupa angka yakni: Pearson correlation coefficient
Penjelasan dari contoh rumus PEARSON
- The PEARSON function takes two arrays of values and calculates the Pearson correlation coefficient between them.
- It ranges from -1 to 1, where -1 indicates a perfect negative correlation, 1 indicates a perfect positive correlation, and 0 indicates no correlation.
Kesimpulan
PEARSON is useful for analyzing the relationship between two sets of data in statistical analysis.
PEARSON
The PEARSON function in Excel calculates the Pearson correlation coefficient between two sets of values.
ahliexcel.com - Statistik