![]() ![]() How was this done in older releases of methods continue to work in newer releases of though the RiskCorrel( ) function is simpler to use. See Excel Reports a Correlation Different from What I Specified for more about this. When you specify your desired correlation for two inputs, as opposed to computing the actual correlation in a simulation, applies Spearman correlation of those inputs. The cell will show #VALUE initially, replaced with the coefficient when you run a simulation. To find the simulated Spearman (rank-order) correlation, use: To find the simulated Pearson correlation, enter this function in a worksheet cell: In 5.5 and newer, the RiskCorrel( ) function can compute the correlation for you, either the Pearson correlation or the Spearman (rank-order) correlation. I want to find the simulated correlation coefficient between two cells in my simulation. Correlation Coefficient of Output Distributions Techniques and Tips Simulation: Numerical Results →Ĭorrelation Coefficient of Output DistributionsĦ.13. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |