Search results

@Hui I don't think we can put sub-scripts or super-scripts here. I have been doing some reading. Is R2 the same as R-squared? Is it called the Coefficient of Determination? My value, with my data, is only .089 and I read that it ranges up to 100% or 1.0. So, I am interpreting my...

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?

Do the se1 and se2 show the likely strength of the causal correlation of the x1 and x2 variables to the y-value?

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?

@Hui Thank you. Your diagnosis was correct. It worked.

Before entering my question here, I had done some reading and I had already tried that LINEST function. But when I Ctrl-Shift-Enter it, I am not getting the table you show. I only get one number, -.0523 in my case. What am I missing?

How do I perform a multiple linear regression? My X1 variable is in column fields E6:E20, X2 variable values are in F6:F20, and my Y values are in fields G6:G20. I would like to find the Y intercept B and the slopes M1 and M2, as well as other regression statistics.

Let's say cell C6 contains 08:18 AM and cell D6 contains 11:00 AM. How do I calculate and fill a field E6 with the value of 162 minutes in between these two times? All times will be withing the same day.