Correlation Graph - Your input will be highly appreciated

[Myami_Wazir]

I have attached the datasheet, want to run a correlation test on it. I do understand the use of correlation functions for two variables on a continuous scale, however, I want to check the correlation for the variables present in the file on a single graph; someone may have done it previously or understand it, your guidance will be highly appreciated. The data is easy to understand, still, if someone finds difficulty, I can explain it. I also checked old posts but did not find any relevant thread, so posting it here. Thanks.

P.S. Correlation: Cloudiness VS. Rain

[MrShorty]

How much of this is an Excel question and how much is a broader statistics question? We are pretty good at programming known algorithms into Excel, but we are not always knowledgeable in statistics to help you choose a statistical procedure.

I want to check the correlation for the variables present in the file on a single graph

As a guess, this sounds to me like you want some kind of scatter chart/graph. If you are unfamiliar with creating scatter charts in Excel, this help file should be useful: https://support.microsoft.com/en-us/...rs=en-us&ad=us

[Myami_Wazir]

Thanks for the reply; yes, exactly I want to run a scatter plot for the data; sure, I will read the link you have sent me. Actually, it needs coding skills. The data involves the correlation between three columns vs. three columns, and we could not do it through a simple correlation option in Excel; I thought someone with VBA skills might try it.

[MrShorty]

Actually, it needs coding skills. ... I thought someone with VBA skills might try it.

It may require VBA (though I'm a little biased against using VBA unless really necessary). Whatever programming language you choose to use, we will still need you to help us understand the statistics side of the question (equations, algorithms, etc.) before we can help you program this into either spreadsheet or VBA.

If your question is really more about the statistical principles than the Excel/VBA programming steps, then you might start here: https://www.real-statistics.com/corr...e-correlation/ This is a website dedicated to doing statistics in Excel, and he seems to be quite good at explaining the statistical theories and principles, while providing examples in Excel, and also provides an add-in with additional statistical functions and tools beyond what is native to Excel. I don't know what programming language he used -- it may have been VBA or he may have a different language he prefers. I notice that this particular page about multiple correlations does not mention VBA, so VBA may not be needed (except in the UDFs he provides).

As I said before, if you will help us understand the statistical calculations and tests you need to run, we should be able to help you program those into the spreadsheet.

[Myami_Wazir]

Thanks a lot.