This way you can avoid using highly correlated (or colinear) independent variables, which can give you trouble.Įxcel provides two built-in functions that allow you to compute the Pearson product-moment correlation coefficients between variables. ![]() ![]() This is a typical example where it's prudent to assess the correlation between independent variables before conducting the regression analysis. The example I discuss in that recipe involves six independent variables. In Recipe 8.4, I show you how to perform linear regression where the dependent variable depends on more than one independent variable. ![]() ![]() Use Excel's built-in functions CORREL or PEARSON, or use the Correlation tool available in the Analysis ToolPak. You're working with a multivariable problem and want to compute the correlation coefficient between variables.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |