Select an area of 5 rows x 5 columns
Type =LINEST(G6:G20,E6:F20,TRUE,TRUE) and press Ctrl+Shift+Enter
The solution will be like
View attachment 52831
Then read the section on Multiple Variable linear regression at:
https://chandoo.org/wp/trendlines-and-forecasting-in-excel-part-2/
Okay, I have the two slopes m1 and m2 and the intercept b. Among the other values in the 5 X 5 grid, are there indicators of the "causal-strength" (maybe called coefficient of correlation?) that will show me if the x1 or x2 variable is strongly correlated with or determining the resulting y-value?Select an area of 5 rows x 5 columns
Type =LINEST(G6:G20,E6:F20,TRUE,TRUE) and press Ctrl+Shift+Enter
The solution will be like
View attachment 52831
Then read the section on Multiple Variable linear regression at:
https://chandoo.org/wp/trendlines-and-forecasting-in-excel-part-2/
Do the se1 and se2 show the likely strength of the causal correlation of the x1 and x2 variables to the y-value?The coefficients go from Mn, Mn-1, Mn-2, , , M2, M1, Intercept
from Excel Help
View attachment 52835
Thanks again Hui. What is the range of R2? Is it -1 to +1? What would be considered "high"?
And is there an R1 for X1 variable and an R2 for X2 variable?