ELSA LORENA ELIZABETH TITO RAMOS
Last answered:

10 Mar 2023

 Posted on:

20 May 2022
0

Excel formula for calculating correlation coefficient

in Statistics / Correlation

The excel formula for calculating the correlation coefficient assume the sample as population. Is there any other excel formula to calculate the same but considering  sample?

2 answers ( 0 marked as helpful)
Dylan Lopez
Posted on:

08 Dec 2022
0

=CORREL(array1,array2)

Ahmed Fares Sayed
Posted on:

10 Mar 2023
0

Population correlation coefficient = Sample correlation coefficient =CORREL( )


Submit an answer

related questions

Timur Abdukarimov
1
6
Why the way of calculating STD error and STD error of difference is different?
Nunno Nugroho
0
6
Resolved: Different result with Excel formula
Sulthan ,
1
6
Resolved: Using Excel built-in CONFIDENCE() function to find the intervals
Nunno Nugroho
0
6
Resolved: Excel formula to find number in the Z-table
Amel Yahou
0
6
Problem Excel version for displaying charts
Alessandro Imbrìaco
0
4
Resolved: I have Openoffice and not Excel
Callum Shaw
3
4
Difference between excel skew and calculated skew
Valerie Spitaels
1
4
Resolved: Calculating Variance