Correlation matrix refresh VBA

[technomau]

Hello All,

I would like to create a way to refresh data based on dates set in Tab "Correlation", C34:C35.
Is there any way to create a VBA to refresh the correlation (done manually though data analysis) based on data change on those cells? Data range for correlation is "RawData AF3: BI".

Thanks!

 

[vletm]

technomau
Have You verified Your expected results?
I left Your original values in Your calculated sheet.

 

[technomau]

what do you mean exactly?

 

[vletm]

technomau
Have You verified Your expected results?:
eg cell value for B3 ... how did You solved that value? 0.805059998394211
Can You give a formula - which gives that value?
I used =CORREL(B3:B266,C3:C266) = 0.93835196

I left Your original values in Your calculated sheet.
Your expected results are still in Correlation Yours-sheet.
My sample results are in Correlation-sheet.
... then You could compare those.

 

[technomau]

I reviewed to reflect what I meant to have:

In Tab "Correlation", I revised to reflect rows showing years for comparison.
On the same tab, I added a drop-down list which I would like the correlation to refer to (cell: C10). I mean, when drop-down changes, correlation will take the corresponding row data. How shall I need to revise the formula, assuming multiple arrays?

Thanks so much for supporting.

 

[vletm]

technomau
Seems You skipped my questions ...
Seems that You changed Your thread, that means per Forum Rules - You should open a new thread for it.
Take care.

 

[technomau]

sorry, I find a workaround but I will open another thread to discuss

 

[vletm]

Thread changed.
This thread is closed now.