Introduction
Correlation analysis is one of the world's greatest statistical forms of analysis. Using Excel, correlation analysis can be pretty easy to do, as you might know. This page is different from my other two pages on correlation matrices: page one ... page two
Of course, there is more to correlation analysis than just =CORREL(known_ys, known_xs) and my new article walks you through six different correlation techniques while using real data and it finishes with the creation of a correlation matrix and how it can be used in regression analysis.
Bonus for Blog Members
Because you are a member of my community by being here, the link to the articles also includes BOTH Excel files and that means you get the data for the final example that includes the correlation matrix analysis.
The article and the Excel files are free to download from here https://drive.google.com/drive/folders/12S_QiqPb8stuBNf0zv6nG_3l3e-HzZpm?usp=sharing
Duncan Williamson
19th April 2024
No comments:
Post a Comment