In case of any change, you will have to repeat the above steps again to generate a new table of correlation coefficients. Note that the resulting table is static, and would not update in case any of the data points in your table change. You can also choose to get your results in a new worksheet or a new workbookĪs soon as you do this, Excel would calculate the correlation coefficient for all the series and give you a table as shown below: I’m going to go with cell G1 on the same worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |