How to make correlation tables with stars for significance?

[rempsyc]

How to make correlation tables with stars for significance?

[OlivierKlein-coder]

Thanks very much. I have tried to remove the colors manually but it is based on a large sets of rules and when removing the rules, the stars and the decimals disappear as well. However, apaTables seems to be doing what I need!

[rempsyc]

Would the cormatrix_excel() function suit your needs? It exports with stars to Excel. Or do you need to export to Word for publication?

[OlivierKlein-coder]

Yes! That's great. But, strangely, it does not include the column and rownames of my data.frame. Also, is there an option to get rid of the colors?

[rempsyc]

Depending on your goals, there are a couple of options. What are you trying to achieve?

There is no option currently to get rid of the colour with rempsyc::cormatrix_excel, but you can remove it manually in Excel, if desired. You can alternatively use the packages correlation (exports to console) or apaTables (exports to Word). Or you can try to do it with rempsyc::nice_table (exports to Word/html) by following this guide: https://www.marsja.se/report-correlation-in-apa-style-using-r-text-tables/ (also see my comments here https://twitter.com/MarsjaSe/status/1655460976764805120)