This made calculating p value for my Pearson extremely easy, only probablem is i don't know what are we doing in that formula. I received an extremely good value like below 0.001 only with 6 samples, which are indeed correlating. I really need to know what we did in that cell by pasting your formula in the description to be sure it's correct. Would be really appreciated if you can explain. Thanks a lot!
I found that formula years ago. I don't know exactly how it works. I have never tried to dissect it to figure out exactly what it is doing. I have compared the values to multiple stats programs with good results though.
@@VivoPhys Thanks. Too bad with conditional formatting I could put more condition and at the change of the value of the source cell you change the one in the target cell
This made calculating p value for my Pearson extremely easy, only probablem is i don't know what are we doing in that formula. I received an extremely good value like below 0.001 only with 6 samples, which are indeed correlating. I really need to know what we did in that cell by pasting your formula in the description to be sure it's correct. Would be really appreciated if you can explain. Thanks a lot!
I found that formula years ago. I don't know exactly how it works. I have never tried to dissect it to figure out exactly what it is doing. I have compared the values to multiple stats programs with good results though.
@@VivoPhys by good do you mean exact or similar results?
Same to at least a few decimal places. Each program does slightly different equations though.
@@VivoPhys good enough for me! thank you very much.
Hi Evan, great video. I need a condition formatting about text from a cell and write a text to destination cell. Thanks
It doesn't sound like conditional formatting. Instead, it sounds like an "=if()" formula. Best of luck.
@@VivoPhys Thanks. Too bad with conditional formatting I could put more condition and at the change of the value of the source cell you change the one in the target cell
How to conditional formatting based on another cell color?
That's a good question. Off the top of my head I am not sure. Sorry. Hopefully someone else will respond.
@@VivoPhys no problem
Btw thanks for your prompt reply