How to add asterisks to a correlation table to show the significance in excel

How to calculate the correlation from the p value.

In this video I show you how to calculate the r critical value to find out how big the correlation needs to be to be significant at p ＜ 0.05 and p ＜ 0.01. Then how to add conditional formatting to change the number formatting to add asterisks after the significant correlations in the correlation table.

r critical value =T.INV(1-alpha/2,n-2)/SQRT(T.INV(1-alpha/2,n-2)^2+n-2)

Pearson Correlation - r Critical and p Value of r in Excel blog.excelmasterseries.com/2014/05/pearson-corr…

How to Create a Correlation Table in APA Style Using Excel 2016 (Windows and Mac)
youtube.com/watch?v=lRTxQhx1d-g
--------------------------------------------------------------------------------
#excel #exceltutorials #exceltips

SUBSCRIBE: goo.gl/c46YPs

Microsoft Office 365, 2016, Office Insider, Version 1906
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- How to calculate Spearman's correlation in excel with missing values youtu.be/PEm4eQkdqw0
- Quickly make a correlation table in excel - 6 different methods youtu.be/o-BEVG6LlMY
- How to delete cells diagonally in excel youtu.be/USIQuYDmc20
- This video is part of a playlist: Correlations in excel youtube.com/playlist?list=PLVe64sIb7fSaHYe5C68D…