Excel and Statistics(23), Correlation

Excel and Statistics, everybody should know.  : Contents

Correlation

 

Let’s open ‘example1.xlsx’ to do ‘Correlation’. ‘Correlation’ selects columns of numbers and compares each pair. In this case, select all three columns.

 

The result shows the correlation coefficient(or Pearson correlation coefficient), after a total of three columns, which means 3 pairs.

 

Plus Alpha

 

 If you visit http://tinyurl.com/matrix-scatterplot3, upload ‘example1.csv’, and open the ‘result’ tabŒ, it shows the same result as in Excel. At the same time, you can select the correlation coefficients of Spearman and Kendall in addition to Pearson, which shows the p valuesŽ.

The ‘plot’ tab shows data with correlation coefficients and various other plots.

 

 

 

Excel and Statistics, everybody should know.  : Contents

=================================================

• R statisics portal https://tinyurl.com/stat-portal

• R data visualization book 1  https://tinyurl.com/R-plot-I (chart)

• R data visualization book 2
  

https://tinyurl.com/R-plot-II-2  simple variables
https://tinyurl.com/R-plot-II-3-4   many variables / map
https://tinyurl.com/R-plot-II-5-6   time related / statistics related
https://tinyurl.com/R-plot-II-7-8   others / reactive chart 

• R data visualization book 3    https://tinyurl.com/R-data-Vis3 
  

• R data visualization book 4   R 데이터 시각화 4권
  

• Meata Analysis book 1  https://tinyurl.com/MetaA-portal
• Meata Analysis book 2  https://tinyurl.com/MetaA-portal(2)

 

• Preciction Model and Machine Learning   https://tinyurl.com/Machine-Learning-EZ
• Sample Size Calculations   https://tinyurl.com/MY-sample-size 
• Sample data  https://tinyurl.com/data4edu 

• easier R than SPSS with Rcmdr : Contents